« back to all changes in this revision
Viewing changes to tests/r/concurrent_innodb.result
- browse files at revision 784
- compare with another revision
- compare with revision 815.1.1
- download diff
- download tarball
- view history from revision 784
- Committer: Brian Aker
- Date: 2009-01-10 22:27:38 UTC
- mfrom: (779.1.8 devel)
- Revision ID: brian@tangent.org-20090110222738-zx4zzq9lsa3othvn
Merge for Monty
- files added:
- m4/acx_pthread.m4
- plugin/logging_syslog
- files removed:
- m4/check_cpu.m4
- files renamed:
- tests/suite/broken/r/concurrent_innodb.result => tests/r/concurrent_innodb.result
- tests/suite/broken/t/concurrent_innodb-master.opt => tests/t/concurrent_innodb-master.opt
- tests/suite/broken/t/concurrent_innodb.test => tests/t/concurrent_innodb.test
- files modified:
- client/Makefile.am
added
removed
tests/r/concurrent_innodb.result
1
SET SESSION STORAGE_ENGINE = InnoDB;
2
drop table if exists t1;
3
create table t1(eta int(11) not null, tipo int(11), c varchar(255));
4
SET SESSION STORAGE_ENGINE = InnoDB;
5
insert into t1 values (7,7, "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa");
6
insert into t1 values (8,8, "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb");
7
insert into t1 values (10,1,"ccccccccccccccccccccccccccccccccccccccccccc");
8
insert into t1 values (20,2,"ddddddddddddddddddddddddddddddddddddddddddd");
9
insert into t1 values (30,1,"eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee");
10
insert into t1 values (40,2,"fffffffffffffffffffffffffffffffffffffffffff");
11
insert into t1 values (50,1,"ggggggggggggggggggggggggggggggggggggggggggg");
12
insert into t1 values (60,2,"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh");
13
insert into t1 values (70,1,"iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii");
14
insert into t1 values (80,22,"jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj");
15
insert into t1 values (90,11,"kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");
16
select get_lock("hello",1);
17
get_lock("hello",1)
18
1
19
begin;
20
update t1 set eta=1+get_lock("hello",1)*0 where tipo=11;
21
begin;
22
update t1 set eta=2 where tipo=22;
23
select release_lock("hello");
24
release_lock("hello")
25
1
26
select * from t1;
27
eta tipo c
28
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
29
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
30
10 1 ccccccccccccccccccccccccccccccccccccccccccc
31
20 2 ddddddddddddddddddddddddddddddddddddddddddd
32
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
33
40 2 fffffffffffffffffffffffffffffffffffffffffff
34
50 1 ggggggggggggggggggggggggggggggggggggggggggg
35
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
36
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
37
2 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
38
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
39
select * from t1;
40
eta tipo c
41
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
42
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
43
10 1 ccccccccccccccccccccccccccccccccccccccccccc
44
20 2 ddddddddddddddddddddddddddddddddddddddddddd
45
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
46
40 2 fffffffffffffffffffffffffffffffffffffffffff
47
50 1 ggggggggggggggggggggggggggggggggggggggggggg
48
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
49
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
50
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
51
1 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
52
commit;
53
select * from t1;
54
eta tipo c
55
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
56
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
57
10 1 ccccccccccccccccccccccccccccccccccccccccccc
58
20 2 ddddddddddddddddddddddddddddddddddddddddddd
59
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
60
40 2 fffffffffffffffffffffffffffffffffffffffffff
61
50 1 ggggggggggggggggggggggggggggggggggggggggggg
62
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
63
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
64
2 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
65
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
66
commit;
67
select * from t1;
68
eta tipo c
69
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
70
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
71
10 1 ccccccccccccccccccccccccccccccccccccccccccc
72
20 2 ddddddddddddddddddddddddddddddddddddddddddd
73
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
74
40 2 fffffffffffffffffffffffffffffffffffffffffff
75
50 1 ggggggggggggggggggggggggggggggggggggggggggg
76
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
77
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
78
2 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
79
1 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
80
select * from t1;
81
eta tipo c
82
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
83
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
84
10 1 ccccccccccccccccccccccccccccccccccccccccccc
85
20 2 ddddddddddddddddddddddddddddddddddddddddddd
86
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
87
40 2 fffffffffffffffffffffffffffffffffffffffffff
88
50 1 ggggggggggggggggggggggggggggggggggggggggggg
89
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
90
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
91
2 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
92
1 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
93
select * from t1;
94
eta tipo c
95
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
96
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
97
10 1 ccccccccccccccccccccccccccccccccccccccccccc
98
20 2 ddddddddddddddddddddddddddddddddddddddddddd
99
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
100
40 2 fffffffffffffffffffffffffffffffffffffffffff
101
50 1 ggggggggggggggggggggggggggggggggggggggggggg
102
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
103
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
104
2 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
105
1 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
106
drop table t1;
107
create table t1(eta int(11) not null, tipo int(11), c varchar(255));
108
insert into t1 values (7,7, "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa");
109
insert into t1 values (8,8, "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb");
110
insert into t1 values (10,1,"ccccccccccccccccccccccccccccccccccccccccccc");
111
insert into t1 values (20,2,"ddddddddddddddddddddddddddddddddddddddddddd");
112
insert into t1 values (30,1,"eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee");
113
insert into t1 values (40,2,"fffffffffffffffffffffffffffffffffffffffffff");
114
insert into t1 values (50,1,"ggggggggggggggggggggggggggggggggggggggggggg");
115
insert into t1 values (60,2,"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh");
116
insert into t1 values (70,1,"iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii");
117
insert into t1 values (80,22,"jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj");
118
insert into t1 values (90,11,"kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");
119
select get_lock("hello",10);
120
get_lock("hello",10)
121
0
122
begin;
123
update t1 set eta=1+get_lock("hello",10)*0 where tipo=1;
124
begin;
125
update t1 set tipo=1 where tipo=2;
126
select release_lock("hello");
127
release_lock("hello")
128
0
129
select * from t1;
130
eta tipo c
131
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
132
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
133
10 1 ccccccccccccccccccccccccccccccccccccccccccc
134
20 1 ddddddddddddddddddddddddddddddddddddddddddd
135
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
136
40 1 fffffffffffffffffffffffffffffffffffffffffff
137
50 1 ggggggggggggggggggggggggggggggggggggggggggg
138
60 1 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
139
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
140
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
141
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
142
select * from t1;
143
eta tipo c
144
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
145
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
146
1 1 ccccccccccccccccccccccccccccccccccccccccccc
147
20 2 ddddddddddddddddddddddddddddddddddddddddddd
148
1 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
149
40 2 fffffffffffffffffffffffffffffffffffffffffff
150
1 1 ggggggggggggggggggggggggggggggggggggggggggg
151
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
152
1 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
153
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
154
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
155
commit;
156
select * from t1;
157
eta tipo c
158
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
159
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
160
10 1 ccccccccccccccccccccccccccccccccccccccccccc
161
20 1 ddddddddddddddddddddddddddddddddddddddddddd
162
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
163
40 1 fffffffffffffffffffffffffffffffffffffffffff
164
50 1 ggggggggggggggggggggggggggggggggggggggggggg
165
60 1 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
166
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
167
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
168
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
169
commit;
170
select * from t1;
171
eta tipo c
172
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
173
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
174
10 1 ccccccccccccccccccccccccccccccccccccccccccc
175
20 1 ddddddddddddddddddddddddddddddddddddddddddd
176
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
177
40 1 fffffffffffffffffffffffffffffffffffffffffff
178
50 1 ggggggggggggggggggggggggggggggggggggggggggg
179
60 1 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
180
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
181
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
182
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
183
select * from t1;
184
eta tipo c
185
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
186
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
187
1 1 ccccccccccccccccccccccccccccccccccccccccccc
188
20 1 ddddddddddddddddddddddddddddddddddddddddddd
189
1 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
190
40 1 fffffffffffffffffffffffffffffffffffffffffff
191
1 1 ggggggggggggggggggggggggggggggggggggggggggg
192
60 1 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
193
1 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
194
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
195
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
196
select * from t1;
197
eta tipo c
198
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
199
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
200
1 1 ccccccccccccccccccccccccccccccccccccccccccc
201
20 1 ddddddddddddddddddddddddddddddddddddddddddd
202
1 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
203
40 1 fffffffffffffffffffffffffffffffffffffffffff
204
1 1 ggggggggggggggggggggggggggggggggggggggggggg
205
60 1 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
206
1 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
207
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
208
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
209
drop table t1;
210
create table t1 (a int not null, b int not null);
211
insert into t1 values (1,1),(2,1),(3,1),(4,1);
212
select get_lock("hello2",1000);
213
get_lock("hello2",1000)
214
1
215
begin;
216
update t1 set b=10+get_lock(concat("hello",a),1000)*0 where
217
a=2;
218
insert into t1 values (1,1);
219
select release_lock("hello2");
220
release_lock("hello2")
221
1
222
select * from t1;
223
a b
224
1 1
225
2 1
226
3 1
227
4 1
228
1 1
229
select * from t1;
230
a b
231
1 1
232
2 10
233
3 1
234
4 1
235
1 1
236
commit;
237
drop table t1;
238
create table t1(eta int(11) not null, tipo int(11), c varchar(255));
239
insert into t1 values (7,7, "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa");
240
insert into t1 values (8,8, "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb");
241
insert into t1 values (10,1,"ccccccccccccccccccccccccccccccccccccccccccc");
242
insert into t1 values (20,2,"ddddddddddddddddddddddddddddddddddddddddddd");
243
insert into t1 values (30,1,"eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee");
244
insert into t1 values (40,2,"fffffffffffffffffffffffffffffffffffffffffff");
245
insert into t1 values (50,1,"ggggggggggggggggggggggggggggggggggggggggggg");
246
insert into t1 values (60,2,"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh");
247
insert into t1 values (70,1,"iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii");
248
insert into t1 values (80,22,"jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj");
249
insert into t1 values (90,11,"kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");
250
select get_lock("hello",10);
251
get_lock("hello",10)
252
1
253
begin;
254
select * from t1 where tipo=2 FOR UPDATE;
255
begin;
256
select release_lock("hello");
257
release_lock("hello")
258
1
259
update t1 set tipo=1+get_lock("hello",10)*0 where tipo=2;
260
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
261
select * from t1;
262
eta tipo c
263
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
264
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
265
10 1 ccccccccccccccccccccccccccccccccccccccccccc
266
20 2 ddddddddddddddddddddddddddddddddddddddddddd
267
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
268
40 2 fffffffffffffffffffffffffffffffffffffffffff
269
50 1 ggggggggggggggggggggggggggggggggggggggggggg
270
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
271
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
272
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
273
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
274
eta tipo c
275
20 2 ddddddddddddddddddddddddddddddddddddddddddd
276
40 2 fffffffffffffffffffffffffffffffffffffffffff
277
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
278
select * from t1;
279
eta tipo c
280
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
281
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
282
10 1 ccccccccccccccccccccccccccccccccccccccccccc
283
20 2 ddddddddddddddddddddddddddddddddddddddddddd
284
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
285
40 2 fffffffffffffffffffffffffffffffffffffffffff
286
50 1 ggggggggggggggggggggggggggggggggggggggggggg
287
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
288
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
289
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
290
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
291
commit;
292
commit;
293
select * from t1;
294
eta tipo c
295
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
296
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
297
10 1 ccccccccccccccccccccccccccccccccccccccccccc
298
20 2 ddddddddddddddddddddddddddddddddddddddddddd
299
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
300
40 2 fffffffffffffffffffffffffffffffffffffffffff
301
50 1 ggggggggggggggggggggggggggggggggggggggggggg
302
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
303
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
304
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
305
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
306
select * from t1;
307
eta tipo c
308
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
309
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
310
10 1 ccccccccccccccccccccccccccccccccccccccccccc
311
20 2 ddddddddddddddddddddddddddddddddddddddddddd
312
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
313
40 2 fffffffffffffffffffffffffffffffffffffffffff
314
50 1 ggggggggggggggggggggggggggggggggggggggggggg
315
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
316
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
317
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
318
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
319
drop table t1;
320
create table t1(eta int(11) not null, tipo int(11), c varchar(255));
321
insert into t1 values (7,7, "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa");
322
insert into t1 values (8,8, "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb");
323
insert into t1 values (10,1,"ccccccccccccccccccccccccccccccccccccccccccc");
324
insert into t1 values (20,2,"ddddddddddddddddddddddddddddddddddddddddddd");
325
insert into t1 values (30,1,"eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee");
326
insert into t1 values (40,2,"fffffffffffffffffffffffffffffffffffffffffff");
327
insert into t1 values (50,1,"ggggggggggggggggggggggggggggggggggggggggggg");
328
insert into t1 values (60,2,"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh");
329
insert into t1 values (70,1,"iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii");
330
insert into t1 values (80,22,"jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj");
331
insert into t1 values (90,11,"kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");
332
select get_lock("hello",10);
333
get_lock("hello",10)
334
1
335
begin;
336
select * from t1 where tipo=2 FOR UPDATE;
337
begin;
338
select release_lock("hello");
339
release_lock("hello")
340
1
341
update t1 set tipo=11+get_lock("hello",10)*0 where tipo=22;
342
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
343
select * from t1;
344
eta tipo c
345
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
346
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
347
10 1 ccccccccccccccccccccccccccccccccccccccccccc
348
20 2 ddddddddddddddddddddddddddddddddddddddddddd
349
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
350
40 2 fffffffffffffffffffffffffffffffffffffffffff
351
50 1 ggggggggggggggggggggggggggggggggggggggggggg
352
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
353
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
354
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
355
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
356
eta tipo c
357
20 2 ddddddddddddddddddddddddddddddddddddddddddd
358
40 2 fffffffffffffffffffffffffffffffffffffffffff
359
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
360
select * from t1;
361
eta tipo c
362
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
363
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
364
10 1 ccccccccccccccccccccccccccccccccccccccccccc
365
20 2 ddddddddddddddddddddddddddddddddddddddddddd
366
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
367
40 2 fffffffffffffffffffffffffffffffffffffffffff
368
50 1 ggggggggggggggggggggggggggggggggggggggggggg
369
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
370
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
371
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
372
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
373
commit;
374
commit;
375
select * from t1;
376
eta tipo c
377
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
378
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
379
10 1 ccccccccccccccccccccccccccccccccccccccccccc
380
20 2 ddddddddddddddddddddddddddddddddddddddddddd
381
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
382
40 2 fffffffffffffffffffffffffffffffffffffffffff
383
50 1 ggggggggggggggggggggggggggggggggggggggggggg
384
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
385
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
386
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
387
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
388
select * from t1;
389
eta tipo c
390
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
391
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
392
10 1 ccccccccccccccccccccccccccccccccccccccccccc
393
20 2 ddddddddddddddddddddddddddddddddddddddddddd
394
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
395
40 2 fffffffffffffffffffffffffffffffffffffffffff
396
50 1 ggggggggggggggggggggggggggggggggggggggggggg
397
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
398
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
399
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
400
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
401
drop table t1;
402
create table t1(eta int(11) not null, tipo int(11), c varchar(255));
403
insert into t1 values (7,7, "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa");
404
insert into t1 values (8,8, "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb");
405
insert into t1 values (10,1,"ccccccccccccccccccccccccccccccccccccccccccc");
406
insert into t1 values (20,2,"ddddddddddddddddddddddddddddddddddddddddddd");
407
insert into t1 values (30,1,"eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee");
408
insert into t1 values (40,2,"fffffffffffffffffffffffffffffffffffffffffff");
409
insert into t1 values (50,1,"ggggggggggggggggggggggggggggggggggggggggggg");
410
insert into t1 values (60,2,"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh");
411
insert into t1 values (70,1,"iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii");
412
insert into t1 values (80,22,"jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj");
413
insert into t1 values (90,11,"kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");
414
select get_lock("hello",10);
415
get_lock("hello",10)
416
1
417
begin;
418
select * from t1 where tipo=2 FOR UPDATE;
419
begin;
420
select release_lock("hello");
421
release_lock("hello")
422
1
423
select * from t1 where tipo=1 FOR UPDATE;
424
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
425
eta tipo c
426
20 2 ddddddddddddddddddddddddddddddddddddddddddd
427
40 2 fffffffffffffffffffffffffffffffffffffffffff
428
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
429
select * from t1;
430
eta tipo c
431
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
432
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
433
10 1 ccccccccccccccccccccccccccccccccccccccccccc
434
20 2 ddddddddddddddddddddddddddddddddddddddddddd
435
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
436
40 2 fffffffffffffffffffffffffffffffffffffffffff
437
50 1 ggggggggggggggggggggggggggggggggggggggggggg
438
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
439
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
440
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
441
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
442
commit;
443
commit;
444
select * from t1;
445
eta tipo c
446
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
447
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
448
10 1 ccccccccccccccccccccccccccccccccccccccccccc
449
20 2 ddddddddddddddddddddddddddddddddddddddddddd
450
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
451
40 2 fffffffffffffffffffffffffffffffffffffffffff
452
50 1 ggggggggggggggggggggggggggggggggggggggggggg
453
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
454
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
455
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
456
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
457
select * from t1;
458
eta tipo c
459
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
460
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
461
10 1 ccccccccccccccccccccccccccccccccccccccccccc
462
20 2 ddddddddddddddddddddddddddddddddddddddddddd
463
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
464
40 2 fffffffffffffffffffffffffffffffffffffffffff
465
50 1 ggggggggggggggggggggggggggggggggggggggggggg
466
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
467
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
468
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
469
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
470
drop table t1;
471
create table t1(eta int(11) not null, tipo int(11), c varchar(255));
472
insert into t1 values (7,7, "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa");
473
insert into t1 values (8,8, "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb");
474
insert into t1 values (10,1,"ccccccccccccccccccccccccccccccccccccccccccc");
475
insert into t1 values (20,2,"ddddddddddddddddddddddddddddddddddddddddddd");
476
insert into t1 values (30,1,"eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee");
477
insert into t1 values (40,2,"fffffffffffffffffffffffffffffffffffffffffff");
478
insert into t1 values (50,1,"ggggggggggggggggggggggggggggggggggggggggggg");
479
insert into t1 values (60,2,"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh");
480
insert into t1 values (70,1,"iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii");
481
insert into t1 values (80,22,"jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj");
482
insert into t1 values (90,11,"kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");
483
select get_lock("hello",10);
484
get_lock("hello",10)
485
1
486
begin;
487
delete from t1 where tipo=2;
488
begin;
489
select release_lock("hello");
490
release_lock("hello")
491
1
492
update t1 set tipo=1+get_lock("hello",10)*0 where tipo=2;
493
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
494
select * from t1;
495
eta tipo c
496
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
497
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
498
10 1 ccccccccccccccccccccccccccccccccccccccccccc
499
20 2 ddddddddddddddddddddddddddddddddddddddddddd
500
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
501
40 2 fffffffffffffffffffffffffffffffffffffffffff
502
50 1 ggggggggggggggggggggggggggggggggggggggggggg
503
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
504
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
505
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
506
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
507
select * from t1;
508
eta tipo c
509
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
510
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
511
10 1 ccccccccccccccccccccccccccccccccccccccccccc
512
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
513
50 1 ggggggggggggggggggggggggggggggggggggggggggg
514
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
515
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
516
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
517
commit;
518
commit;
519
select * from t1;
520
eta tipo c
521
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
522
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
523
10 1 ccccccccccccccccccccccccccccccccccccccccccc
524
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
525
50 1 ggggggggggggggggggggggggggggggggggggggggggg
526
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
527
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
528
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
529
select * from t1;
530
eta tipo c
531
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
532
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
533
10 1 ccccccccccccccccccccccccccccccccccccccccccc
534
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
535
50 1 ggggggggggggggggggggggggggggggggggggggggggg
536
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
537
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
538
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
539
drop table t1;
540
create table t1(eta int(11) not null, tipo int(11), c varchar(255));
541
insert into t1 values (7,7, "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa");
542
insert into t1 values (8,8, "bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb");
543
insert into t1 values (10,1,"ccccccccccccccccccccccccccccccccccccccccccc");
544
insert into t1 values (20,2,"ddddddddddddddddddddddddddddddddddddddddddd");
545
insert into t1 values (30,1,"eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee");
546
insert into t1 values (40,2,"fffffffffffffffffffffffffffffffffffffffffff");
547
insert into t1 values (50,1,"ggggggggggggggggggggggggggggggggggggggggggg");
548
insert into t1 values (60,2,"hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh");
549
insert into t1 values (70,1,"iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii");
550
insert into t1 values (80,22,"jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj");
551
insert into t1 values (90,11,"kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk");
552
select get_lock("hello",10);
553
get_lock("hello",10)
554
1
555
begin;
556
delete from t1 where tipo=2;
557
begin;
558
select release_lock("hello");
559
release_lock("hello")
560
1
561
update t1 set tipo=1+get_lock("hello",10)*0 where tipo=22;
562
select * from t1;
563
eta tipo c
564
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
565
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
566
10 1 ccccccccccccccccccccccccccccccccccccccccccc
567
20 2 ddddddddddddddddddddddddddddddddddddddddddd
568
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
569
40 2 fffffffffffffffffffffffffffffffffffffffffff
570
50 1 ggggggggggggggggggggggggggggggggggggggggggg
571
60 2 hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
572
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
573
80 1 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
574
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
575
select * from t1;
576
eta tipo c
577
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
578
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
579
10 1 ccccccccccccccccccccccccccccccccccccccccccc
580
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
581
50 1 ggggggggggggggggggggggggggggggggggggggggggg
582
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
583
80 22 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
584
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
585
commit;
586
commit;
587
select * from t1;
588
eta tipo c
589
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
590
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
591
10 1 ccccccccccccccccccccccccccccccccccccccccccc
592
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
593
50 1 ggggggggggggggggggggggggggggggggggggggggggg
594
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
595
80 1 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
596
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
597
select * from t1;
598
eta tipo c
599
7 7 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
600
8 8 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
601
10 1 ccccccccccccccccccccccccccccccccccccccccccc
602
30 1 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
603
50 1 ggggggggggggggggggggggggggggggggggggggggggg
604
70 1 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
605
80 1 jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
606
90 11 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
607
drop table t1;
1
select 1;
2
1
3
1
Loggerhead is a web-based interface for Breezy
Version: 2.0.1