« back to all changes in this revision
Viewing changes to tests/r/savepoints.result
- browse files at revision 1491.2.2
- compare with another revision
- compare with revision 38
- download diff
- download tarball
- view history from revision 1491.2.2
- Committer: Jay Pipes
- Date: 2010-04-22 17:52:19 UTC
- mto: This revision was merged to the branch mainline in revision 1505.
- Revision ID: jpipes@serialcoder-20100422175219-3pb4p1v11tnu8ede
Reduce large test case for savepoints on Bug 542299 down to the smallest reproduceable test case.
- files modified:
- tests/r/savepoints.result
added
removed
tests/r/savepoints.result
1
Start Test of Bug 534806
1
2
SET AUTOCOMMIT = 0;
2
3
CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY);
3
4
COMMIT;
4
5
UPDATE t1 SET id = 2 WHERE id != 2 LIMIT 0;
5
6
SAVEPOINT A;
7
End Test of Bug 534806
6
8
DROP TABLE t1;
7
9
CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY);
8
10
START TRANSACTION;
46
48
DROP TABLE t1;
47
49
Start Test of Bug 542299
48
50
CREATE TABLE t1 (a int,id integer auto_increment,b int,/*Indices*/key (a ),primary key (id)) ENGINE=innodb;
49
ALTER TABLE t1 DISABLE KEYS;
50
Warnings:
51
Note 1031 Table storage engine for 't1' doesn't have this option
52
51
INSERT INTO t1 VALUES (100, NULL, 100) , (100, NULL, 100) , (100, NULL, 100) , (100, NULL, 100) , (100, NULL, 100) , (100, NULL, 100) , (100, NULL, 100) , (100, NULL, 100);
53
COMMIT;
54
CREATE TABLE t2 (a int,b int,id integer auto_increment,/*Indices*/key (a ),primary key (id)) ENGINE=innodb;
55
ALTER TABLE t2 DISABLE KEYS;
56
Warnings:
57
Note 1031 Table storage engine for 't2' doesn't have this option
58
SHOW WARNINGS;
59
Level Code Message
60
Note 1031 Table storage engine for 't2' doesn't have this option
61
INSERT INTO t2 VALUES (100, 100, NULL) , (100, 100, NULL) , (100, 100, NULL) , (100, 100, NULL) , (100, 100, NULL) , (100, 100, NULL) , (100, 100, NULL) , (100, 100, NULL);
62
INSERT INTO t2 VALUES (100, 100, NULL) , (100, 100, NULL) , (100, 100, NULL) , (100, 100, NULL) , (100, 100, NULL) , (100, 100, NULL) , (100, 100, NULL) , (100, 100, NULL);
63
COMMIT;
64
ALTER TABLE t2 ENABLE KEYS;
65
Warnings:
66
Note 1031 Table storage engine for 't2' doesn't have this option
67
SHOW WARNINGS;
68
Level Code Message
69
Note 1031 Table storage engine for 't2' doesn't have this option
70
COMMIT;
71
SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ;
72
SET AUTOCOMMIT=OFF;
73
SELECT id FROM t1 WHERE b BETWEEN 1 and 5;
74
id
75
SELECT id FROM t1 WHERE b BETWEEN 1 and 5 /* no additional predicate */;
76
id
77
SELECT id FROM t1 WHERE b BETWEEN 1 and 5 AND id > -16777216;
78
id
79
UPDATE t1 SET a = 0 WHERE 1 = 1 LIMIT 4;
80
UPDATE t1 SET id = 0 WHERE id BETWEEN 0 and 1 LIMIT 1;
81
UPDATE t1 SET a = 5 WHERE a < 7 LIMIT 6;
82
INSERT INTO t2 ( a, b ) VALUES ( 6 , 7 );
83
DELETE FROM t2 WHERE 1 = 1 LIMIT 5;
84
SAVEPOINT A;
85
START TRANSACTION;
86
INSERT INTO t1 ( a, b ) VALUES ( 5 , 1 );
87
INSERT INTO t1 ( a, b ) VALUES ( 5 , 9 );
88
SELECT id FROM t2 WHERE id IN ( 1 , 2 , 1 );
89
id
90
SELECT id FROM t2 WHERE id IN ( 1 , 2 , 1 ) /* no additional predicate */;
91
id
92
SELECT id FROM t2 WHERE id IN ( 1 , 2 , 1 ) AND id > -16777216;
93
id
94
INSERT INTO t1 ( a, b ) VALUES ( 0 , 2 );
95
UPDATE t1 SET b = 1 WHERE 1 = 1 LIMIT 0;
96
INSERT INTO t1 ( a, b ) VALUES ( 1 , 6 );
97
ROLLBACK TO SAVEPOINT A;
98
ERROR 42000: SAVEPOINT A does not exist
99
INSERT INTO t1 ( a, b ) VALUES ( 7 , 5 );
100
SELECT b FROM t1 WHERE a IN ( 3 , 9 , 0 );
101
b
102
2
103
SELECT b FROM t1 WHERE a IN ( 3 , 9 , 0 ) /* no additional predicate */;
104
b
105
2
106
SELECT b FROM t1 WHERE a IN ( 3 , 9 , 0 ) AND id > -16777216;
107
b
108
2
109
INSERT INTO t1 ( a, b ) VALUES ( 8 , 9 );
110
SAVEPOINT A;
111
INSERT INTO t1 ( a, b ) VALUES ( 9 , 2 );
112
UPDATE t2 SET a = 0 WHERE a < 1 LIMIT 4;
113
UPDATE t1 SET b = 1 WHERE a = 4 LIMIT 7;
114
DELETE FROM t2 WHERE id < 1 LIMIT 1;
115
UPDATE t1 SET id = 5 WHERE b = 2 LIMIT 8;
116
ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
117
SAVEPOINT A;
118
UPDATE t1 SET id = 8 WHERE b BETWEEN 4 and 8 LIMIT 3;
119
ERROR 23000: Duplicate entry '8' for key 'PRIMARY'
120
SELECT id FROM t1 WHERE 1 = 1;
121
id
122
0
123
2
124
3
125
4
126
5
127
6
128
7
129
8
130
9
131
10
132
11
133
12
134
13
135
14
136
15
137
SELECT id FROM t1 WHERE 1 = 1 /* no additional predicate */;
138
id
139
0
140
2
141
3
142
4
143
5
144
6
145
7
146
8
147
9
148
10
149
11
150
12
151
13
152
14
153
15
154
SELECT id FROM t1 WHERE 1 = 1 AND id > -16777216;
155
id
156
0
157
2
158
3
159
4
160
5
161
6
162
7
163
8
164
9
165
10
166
11
167
12
168
13
169
14
170
15
171
DELETE FROM t2 WHERE a BETWEEN 8 and 1 LIMIT 2;
172
UPDATE t1 SET b = 7 WHERE id = 9 LIMIT 7;
173
ROLLBACK TO SAVEPOINT A;
174
ROLLBACK;
175
UPDATE t2 SET a = 3 WHERE id IN ( 8 , 4 , 5 ) LIMIT 0;
176
SELECT id FROM t2 WHERE 1 = 1;
177
id
178
6
179
7
180
8
181
9
182
10
183
11
184
12
185
13
186
14
187
15
188
16
189
17
190
SELECT id FROM t2 WHERE 1 = 1 /* no additional predicate */;
191
id
192
6
193
7
194
8
195
9
196
10
197
11
198
12
199
13
200
14
201
15
202
16
203
17
204
SELECT id FROM t2 WHERE 1 = 1 AND id > -16777216;
205
id
206
6
207
7
208
8
209
9
210
10
211
11
212
12
213
13
214
14
215
15
216
16
217
17
218
SELECT a FROM t2 WHERE a = 3;
219
a
220
SELECT a FROM t2 WHERE a = 3 /* no additional predicate */;
221
a
222
SELECT a FROM t2 WHERE a = 3 AND id > -16777216;
223
a
224
DELETE FROM t1 WHERE b = 2 LIMIT 2;
225
ROLLBACK;
226
INSERT INTO t1 ( a, b ) VALUES ( 7 , 4 );
227
UPDATE t1 SET a = 0 WHERE a > 0 LIMIT 4;
228
COMMIT;
229
DELETE FROM t2 WHERE id = 5 LIMIT 2;
230
DELETE FROM t2 WHERE a = 3 LIMIT 0;
231
SELECT b FROM t1 WHERE a = 2;
232
b
233
SELECT b FROM t1 WHERE a = 2 /* no additional predicate */;
234
b
235
SELECT b FROM t1 WHERE a = 2 AND id > -16777216;
236
b
237
UPDATE t1 SET b = 8 WHERE id BETWEEN 8 and 4 LIMIT 8;
238
UPDATE t1 SET b = 2 WHERE id = 1 LIMIT 6;
239
INSERT INTO t1 ( a, b ) VALUES ( 9 , 7 );
240
SELECT a FROM t1 WHERE id > 5;
241
a
242
100
243
100
244
100
245
7
246
9
247
SELECT a FROM t1 WHERE id > 5 /* no additional predicate */;
248
a
249
100
250
100
251
100
252
7
253
9
254
SELECT a FROM t1 WHERE id > 5 AND id > -16777216;
255
a
256
100
257
100
258
100
259
7
260
9
261
DELETE FROM t2 WHERE id < 3 LIMIT 3;
262
UPDATE t2 SET id = 8 WHERE id = 4 LIMIT 5;
263
UPDATE t1 SET a = 3 WHERE a = 0 LIMIT 4;
264
SET AUTOCOMMIT=1;
265
SELECT b FROM t1 WHERE id = 7;
266
b
267
100
268
SELECT DATABASE();
269
DATABASE()
270
test
271
SELECT b FROM t1 WHERE id = 7 /* no additional predicate */;
272
b
273
100
274
SELECT VERSION();
275
VERSION()
276
2010.04.1491
277
SELECT b FROM t1 WHERE id = 7 AND id > -16777216;
278
b
279
100
280
ROLLBACK TO SAVEPOINT A;
281
ERROR 42000: SAVEPOINT A does not exist
282
INSERT INTO t2 ( a, b ) VALUES ( 2 , 9 );
283
SELECT a FROM t1 WHERE id BETWEEN 9 and 5;
284
a
285
SELECT a FROM t1 WHERE id BETWEEN 9 and 5 /* no additional predicate */;
286
a
287
SELECT a FROM t1 WHERE id BETWEEN 9 and 5 AND id > -16777216;
288
a
289
ROLLBACK TO SAVEPOINT A;
290
ERROR 42000: SAVEPOINT A does not exist
291
DELETE FROM t1 WHERE a BETWEEN 8 and 8 LIMIT 5;
292
ROLLBACK TO SAVEPOINT A;
293
ERROR 42000: SAVEPOINT A does not exist
294
COMMIT;
295
DELETE FROM t1 WHERE id IN ( 9 , 1 , 9 ) LIMIT 8;
296
INSERT INTO t2 ( a, b ) VALUES ( 5 , 2 );
297
DELETE FROM t1 WHERE a < 7 LIMIT 0;
298
DELETE FROM t2 WHERE 1 = 1 LIMIT 2;
299
START TRANSACTION;
300
INSERT INTO t2 ( a, b ) VALUES ( 2 , 0 );
301
UPDATE t2 SET a = 7 WHERE a BETWEEN 9 and 0 LIMIT 7;
302
SELECT b FROM t2 WHERE 1 = 1;
303
b
304
100
305
100
306
100
307
100
308
100
309
100
310
100
311
100
312
100
313
7
314
9
315
2
316
0
317
SELECT b FROM t2 WHERE 1 = 1 /* no additional predicate */;
318
b
319
100
320
100
321
100
322
100
323
100
324
100
325
100
326
100
327
100
328
7
329
9
330
2
331
0
332
SELECT b FROM t2 WHERE 1 = 1 AND id > -16777216;
333
b
334
100
335
100
336
100
337
100
338
100
339
100
340
100
341
100
342
100
343
7
344
9
345
2
346
0
347
DELETE FROM t1 WHERE 1 = 1 LIMIT 1;
348
SELECT a FROM t2 WHERE b = 1;
349
a
350
SELECT a FROM t2 WHERE b = 1 /* no additional predicate */;
351
a
352
SELECT a FROM t2 WHERE b = 1 AND id > -16777216;
353
a
354
INSERT INTO t1 ( a, b ) VALUES ( 5 , 9 );
355
INSERT INTO t2 ( a, b ) VALUES ( 9 , 4 );
356
DELETE FROM t2 WHERE b > 1 LIMIT 8;
357
UPDATE t2 SET id = 7 WHERE b > 4 LIMIT 0;
358
SELECT a FROM t2 WHERE a < 0;
359
a
360
SELECT a FROM t2 WHERE a < 0 /* no additional predicate */;
361
a
362
SELECT a FROM t2 WHERE a < 0 AND id > -16777216;
363
a
364
SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ;
365
START TRANSACTION;
366
SET AUTOCOMMIT=OFF;
367
START TRANSACTION;
368
DELETE FROM t1 WHERE 1 = 1 LIMIT 2;
369
INSERT INTO t1 ( a, b ) VALUES ( 0 , 2 );
370
SELECT a FROM t2 WHERE b > 9;
371
a
372
100
373
UPDATE t1 SET b = 3 WHERE id < 5 LIMIT 6;
374
SELECT id FROM t2 WHERE id BETWEEN 3 and 4;
375
id
376
SELECT a FROM t2 WHERE b > 9 /* no additional predicate */;
377
a
378
100
379
SELECT id FROM t2 WHERE id BETWEEN 3 and 4 /* no additional predicate */;
380
id
381
SELECT id FROM t2 WHERE id BETWEEN 3 and 4 AND id > -16777216;
382
id
383
INSERT INTO t1 ( a, b ) VALUES ( 1 , 8 );
384
SELECT a FROM t2 WHERE b > 9 AND id > -16777216;
385
a
386
100
387
SELECT a FROM t1 WHERE a BETWEEN 0 and 0;
388
a
389
0
390
SELECT a FROM t1 WHERE a BETWEEN 0 and 0 /* no additional predicate */;
391
a
392
0
393
SELECT a FROM t1 WHERE a BETWEEN 0 and 0 AND id > -16777216;
394
a
395
0
396
SELECT b FROM t2 WHERE b = 7;
397
b
398
7
399
SELECT b FROM t2 WHERE b = 7 /* no additional predicate */;
400
b
401
7
402
SELECT b FROM t2 WHERE b = 7 AND id > -16777216;
403
b
404
7
405
DELETE FROM t2 WHERE a BETWEEN 6 and 7 LIMIT 0;
406
UPDATE t2 SET id = 5 WHERE b = 6 LIMIT 4;
407
INSERT INTO t1 ( a, b ) VALUES ( 1 , 4 );
408
UPDATE t1 SET b = 7 WHERE id IN ( 7 , 2 , 0 ) LIMIT 0;
409
DELETE FROM t1 WHERE a < 1 LIMIT 1;
410
START TRANSACTION;
411
UPDATE t2 SET a = 5 WHERE id IN ( 7 , 8 , 9 ) LIMIT 2;
412
SELECT a FROM t2 WHERE b < 9;
413
a
414
6
415
5
416
2
417
9
418
SELECT a FROM t2 WHERE b < 9 /* no additional predicate */;
419
a
420
6
421
5
422
2
423
9
424
SELECT a FROM t2 WHERE b < 9 AND id > -16777216;
425
a
426
6
427
5
428
2
429
9
430
UPDATE t1 SET id = 0 WHERE 1 = 1 LIMIT 9;
431
ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
432
INSERT INTO t1 ( a, b ) VALUES ( 6 , 1 );
433
INSERT INTO t1 ( a, b ) VALUES ( 4 , 7 );
434
INSERT INTO t1 ( a, b ) VALUES ( 7 , 4 );
435
SELECT a FROM t2 WHERE b = 0;
436
a
437
2
438
SELECT a FROM t2 WHERE b = 0 /* no additional predicate */;
439
a
440
2
441
ROLLBACK;
442
START TRANSACTION;
443
SELECT a FROM t2 WHERE b = 0 AND id > -16777216;
444
a
445
2
446
ROLLBACK TO SAVEPOINT A;
447
ERROR 42000: SAVEPOINT A does not exist
448
UPDATE t1 SET id = 2 WHERE id < 1 LIMIT 6;
449
DELETE FROM t2 WHERE b > 4 LIMIT 3;
450
SELECT a FROM t2 WHERE b BETWEEN 1 and 2;
451
a
452
5
453
SELECT a FROM t2 WHERE b BETWEEN 1 and 2 /* no additional predicate */;
454
a
455
5
456
SELECT id FROM t1 WHERE id BETWEEN 0 and 4;
457
id
458
4
459
SELECT a FROM t2 WHERE b BETWEEN 1 and 2 AND id > -16777216;
460
a
461
5
462
SELECT id FROM t1 WHERE id BETWEEN 0 and 4 /* no additional predicate */;
463
id
464
4
465
SELECT id FROM t1 WHERE id BETWEEN 0 and 4 AND id > -16777216;
466
id
467
4
468
INSERT INTO t2 ( a, b ) VALUES ( 6 , 3 );
469
UPDATE t1 SET a = 5 WHERE id < 5 LIMIT 0;
470
INSERT INTO t2 ( a, b ) VALUES ( 4 , 1 );
471
INSERT INTO t2 ( a, b ) VALUES ( 8 , 5 );
472
INSERT INTO t1 ( a, b ) VALUES ( 5 , 0 );
473
UPDATE t1 SET id = 7 WHERE id > 7 LIMIT 7;
474
ERROR 23000: Duplicate entry '7' for key 'PRIMARY'
475
INSERT INTO t2 ( a, b ) VALUES ( 8 , 6 );
476
INSERT INTO t1 ( a, b ) VALUES ( 5 , 1 );
477
DELETE FROM t2 WHERE a < 3 LIMIT 6;
478
SAVEPOINT A;
479
START TRANSACTION;
480
DELETE FROM t1 WHERE a BETWEEN 7 and 4 LIMIT 4;
481
DELETE FROM t1 WHERE 1 = 1 LIMIT 3;
482
UPDATE t1 SET id = 9 WHERE 1 = 1 LIMIT 6;
483
ERROR 23000: Duplicate entry '9' for key 'PRIMARY'
484
UPDATE t2 SET b = 4 WHERE b IN ( 2 , 5 , 0 ) LIMIT 2;
485
DELETE FROM t2 WHERE b BETWEEN 4 and 9 LIMIT 7;
486
INSERT INTO t1 ( a, b ) VALUES ( 6 , 0 );
487
INSERT INTO t2 ( a, b ) VALUES ( 3 , 6 );
488
INSERT INTO t1 ( a, b ) VALUES ( 0 , 9 );
489
SELECT a FROM t2 WHERE a < 6;
490
a
491
3
492
4
493
ROLLBACK;
494
ROLLBACK;
495
SELECT a FROM t2 WHERE a < 6 /* no additional predicate */;
496
a
497
4
498
5
499
START TRANSACTION;
500
SELECT a FROM t2 WHERE a < 6 AND id > -16777216;
501
a
502
4
503
5
504
ROLLBACK TO SAVEPOINT A;
505
ERROR 42000: SAVEPOINT A does not exist
506
SELECT b FROM t2 WHERE a > 0;
507
b
508
2
509
4
510
3
511
1
512
5
513
6
514
SELECT b FROM t2 WHERE a > 0 /* no additional predicate */;
515
b
516
2
517
4
518
3
519
1
520
5
521
6
522
SELECT b FROM t2 WHERE a > 0 AND id > -16777216;
523
b
524
2
525
4
526
3
527
1
528
5
529
6
530
DELETE FROM t2 WHERE b BETWEEN 1 and 7 LIMIT 2;
531
COMMIT;
532
UPDATE t2 SET b = 1 WHERE a = 0 LIMIT 8;
533
DELETE FROM t2 WHERE id BETWEEN 9 and 4 LIMIT 8;
534
SELECT a FROM t2 WHERE a > 5;
535
a
536
6
537
8
538
8
539
SELECT a FROM t2 WHERE a > 5 /* no additional predicate */;
540
a
541
6
542
8
543
8
544
COMMIT;
545
SET AUTOCOMMIT=1;
546
SELECT id FROM t2 WHERE b > 8;
547
id
548
SELECT id FROM t2 WHERE b > 8 /* no additional predicate */;
549
id
550
SELECT a FROM t2 WHERE a > 5 AND id > -16777216;
551
a
552
6
553
8
554
8
555
SELECT id FROM t2 WHERE b > 8 AND id > -16777216;
556
id
557
SAVEPOINT A;
558
UPDATE t1 SET b = 6 WHERE b > 4 LIMIT 1;
559
UPDATE t2 SET b = 4 WHERE 1 = 1 LIMIT 8;
560
DELETE FROM t2 WHERE 1 = 1 LIMIT 0;
561
DELETE FROM t1 WHERE b = 7 LIMIT 2;
562
ROLLBACK TO SAVEPOINT A;
563
ERROR 42000: SAVEPOINT A does not exist
564
INSERT INTO t1 ( a, b ) VALUES ( 4 , 7 );
565
DELETE FROM t2 WHERE id = 8 LIMIT 8;
566
DELETE FROM t1 WHERE 1 = 1 LIMIT 7;
567
INSERT INTO t1 ( a, b ) VALUES ( 2 , 0 );
568
SELECT b FROM t1 WHERE b < 5;
569
b
570
4
571
0
572
1
573
0
574
SELECT b FROM t1 WHERE b < 5 /* no additional predicate */;
575
b
576
4
577
0
578
1
579
0
580
SELECT b FROM t1 WHERE b < 5 AND id > -16777216;
581
b
582
4
583
0
584
1
585
0
586
DELETE FROM t1 WHERE 1 = 1 LIMIT 0;
587
UPDATE t1 SET id = 3 WHERE id < 4 LIMIT 7;
588
DELETE FROM t2 WHERE 1 = 1 LIMIT 0;
589
SELECT id FROM t2 WHERE id BETWEEN 0 and 0;
590
id
591
SELECT id FROM t2 WHERE id BETWEEN 0 and 0 /* no additional predicate */;
592
id
593
SELECT id FROM t2 WHERE id BETWEEN 0 and 0 AND id > -16777216;
594
id
595
DELETE FROM t1 WHERE b < 3 LIMIT 6;
596
START TRANSACTION;
597
UPDATE t1 SET b = 2 WHERE 1 = 1 LIMIT 1;
598
SELECT b FROM t2 WHERE a < 2;
599
b
600
SELECT b FROM t2 WHERE a < 2 /* no additional predicate */;
601
b
602
SELECT b FROM t2 WHERE a < 2 AND id > -16777216;
603
b
604
UPDATE t1 SET b = 8 WHERE id = 8 LIMIT 5;
605
ROLLBACK;
606
UPDATE t1 SET id = 5 WHERE 1 = 1 LIMIT 8;
607
ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
608
UPDATE t1 SET id = 7 WHERE id = 4 LIMIT 0;
609
SELECT a FROM t2 WHERE a > 1;
610
a
611
4
612
6
613
8
614
8
615
SAVEPOINT A;
616
SELECT a FROM t2 WHERE a > 1 /* no additional predicate */;
617
a
618
4
619
6
620
8
621
8
622
INSERT INTO t2 ( a, b ) VALUES ( 9 , 8 );
623
SELECT a FROM t2 WHERE a > 1 AND id > -16777216;
624
a
625
6
626
4
627
8
628
8
629
9
630
UPDATE t2 SET b = 0 WHERE a > 1 LIMIT 3;
631
ROLLBACK TO SAVEPOINT A;
632
ERROR 42000: SAVEPOINT A does not exist
633
DELETE FROM t2 WHERE a = 9 LIMIT 1;
634
SAVEPOINT A;
635
UPDATE t1 SET a = 8 WHERE b BETWEEN 1 and 9 LIMIT 2;
636
UPDATE t1 SET b = 8 WHERE a = 2 LIMIT 6;
637
COMMIT;
638
COMMIT;
639
INSERT INTO t2 ( a, b ) VALUES ( 8 , 9 );
640
DELETE FROM t1 WHERE b > 3 LIMIT 6;
641
UPDATE t2 SET b = 0 WHERE a < 5 LIMIT 0;
642
START TRANSACTION;
643
SELECT VERSION();
644
VERSION()
645
2010.04.1491
646
SELECT collation_name,character_set_name FROM data_dictionary.collations;
647
collation_name character_set_name
648
utf8_general_ci utf8_general_ci
649
utf8_bin utf8_general_ci
650
utf8_unicode_ci utf8_general_ci
651
utf8_icelandic_ci utf8_general_ci
652
utf8_latvian_ci utf8_general_ci
653
utf8_romanian_ci utf8_general_ci
654
utf8_slovenian_ci utf8_general_ci
655
utf8_polish_ci utf8_general_ci
656
utf8_estonian_ci utf8_general_ci
657
utf8_spanish_ci utf8_general_ci
658
utf8_swedish_ci utf8_general_ci
659
utf8_turkish_ci utf8_general_ci
660
utf8_czech_ci utf8_general_ci
661
utf8_danish_ci utf8_general_ci
662
utf8_lithuanian_ci utf8_general_ci
663
utf8_slovak_ci utf8_general_ci
664
utf8_spanish2_ci utf8_general_ci
665
utf8_roman_ci utf8_general_ci
666
utf8_persian_ci utf8_general_ci
667
utf8_esperanto_ci utf8_general_ci
668
utf8_hungarian_ci utf8_general_ci
669
utf8_sinhala_ci utf8_general_ci
670
binary binary
671
UPDATE t1 SET b = 2 WHERE a < 1 LIMIT 0;
672
UPDATE t2 SET id = 8 WHERE 1 = 1 LIMIT 9;
673
ERROR 23000: Duplicate entry '8' for key 'PRIMARY'
674
UPDATE t2 SET b = 7 WHERE a IN ( 8 , 6 , 2 ) LIMIT 6;
675
COMMIT;
676
COMMIT;
677
DELETE FROM t2 WHERE a IN ( 5 , 8 , 1 ) LIMIT 1;
678
DELETE FROM t1 WHERE 1 = 1 LIMIT 5;
679
INSERT INTO t1 ( a, b ) VALUES ( 0 , 4 );
680
SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ;
681
SAVEPOINT A;
682
SET AUTOCOMMIT=OFF;
683
DELETE FROM t2 WHERE a < 7 LIMIT 0;
684
UPDATE t2 SET id = 4 WHERE 1 = 1 LIMIT 0;
685
DELETE FROM t1 WHERE a IN ( 4 , 5 , 2 ) LIMIT 9;
686
INSERT INTO t2 ( a, b ) VALUES ( 6 , 0 );
687
DELETE FROM t1 WHERE id = 9 LIMIT 2;
688
UPDATE t2 SET a = 2 WHERE b BETWEEN 9 and 2 LIMIT 4;
689
SELECT a FROM t2 WHERE a BETWEEN 6 and 0;
690
a
691
INSERT INTO t2 ( a, b ) VALUES ( 0 , 0 );
692
SELECT a FROM t2 WHERE a BETWEEN 6 and 0 /* no additional predicate */;
693
a
694
INSERT INTO t1 ( a, b ) VALUES ( 6 , 8 );
695
SELECT a FROM t2 WHERE a BETWEEN 6 and 0 AND id > -16777216;
696
a
697
SAVEPOINT A;
698
SELECT b FROM t1 WHERE a < 5;
699
b
700
4
701
SELECT b FROM t1 WHERE a < 5 /* no additional predicate */;
702
b
703
4
704
SELECT b FROM t1 WHERE a < 5 AND id > -16777216;
705
b
706
4
707
DELETE FROM t2 WHERE id = 0 LIMIT 1;
708
SELECT a FROM t1 WHERE id < 0;
709
a
710
SELECT a FROM t1 WHERE id < 0 /* no additional predicate */;
711
a
712
SELECT a FROM t1 WHERE id < 0 AND id > -16777216;
713
a
714
UPDATE t1 SET a = 5 WHERE a < 1 LIMIT 2;
715
UPDATE t1 SET id = 0 WHERE 1 = 1 LIMIT 3;
716
ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
717
UPDATE t2 SET b = 8 WHERE b = 0 LIMIT 1;
718
SELECT a FROM t1 WHERE id = 4;
719
a
720
SELECT a FROM t1 WHERE id = 4 /* no additional predicate */;
721
a
722
SELECT a FROM t1 WHERE id = 4 AND id > -16777216;
723
a
724
UPDATE t2 SET a = 9 WHERE b > 4 LIMIT 9;
725
UPDATE t2 SET id = 9 WHERE b BETWEEN 7 and 1 LIMIT 1;
726
DELETE FROM t2 WHERE b BETWEEN 6 and 8 LIMIT 6;
727
COMMIT;
728
ROLLBACK;
729
UPDATE t2 SET a = 5 WHERE b < 2 LIMIT 9;
730
SELECT b FROM t1 WHERE b IN ( 8 , 3 , 5 );
731
b
732
8
733
SELECT b FROM t1 WHERE b IN ( 8 , 3 , 5 ) /* no additional predicate */;
734
b
735
8
736
INSERT INTO t2 ( a, b ) VALUES ( 4 , 4 );
737
SELECT b FROM t1 WHERE b IN ( 8 , 3 , 5 ) AND id > -16777216;
738
b
739
8
740
SELECT b FROM t2 WHERE id IN ( 0 , 1 , 1 );
741
b
742
SELECT a FROM t1 WHERE 1 = 1;
743
a
744
5
745
6
746
SELECT b FROM t2 WHERE id IN ( 0 , 1 , 1 ) /* no additional predicate */;
747
b
748
SELECT a FROM t1 WHERE 1 = 1 /* no additional predicate */;
749
a
750
5
751
6
752
SELECT b FROM t2 WHERE id IN ( 0 , 1 , 1 ) AND id > -16777216;
753
b
754
SELECT a FROM t1 WHERE 1 = 1 AND id > -16777216;
755
a
756
5
757
6
758
UPDATE t2 SET b = 2 WHERE id = 2 LIMIT 9;
759
SELECT b FROM t2 WHERE b IN ( 1 , 2 , 3 );
760
b
761
UPDATE t2 SET a = 0 WHERE id = 1 LIMIT 3;
762
SELECT b FROM t2 WHERE b IN ( 1 , 2 , 3 ) /* no additional predicate */;
763
b
764
SELECT id FROM t1 WHERE b < 9;
765
id
766
31
767
32
768
SELECT b FROM t2 WHERE b IN ( 1 , 2 , 3 ) AND id > -16777216;
769
b
770
SELECT id FROM t1 WHERE b < 9 /* no additional predicate */;
771
id
772
31
773
32
774
COMMIT;
775
ROLLBACK TO SAVEPOINT A;
776
ERROR 42000: SAVEPOINT A does not exist
777
SELECT id FROM t1 WHERE b < 9 AND id > -16777216;
778
id
779
31
780
32
781
SELECT a FROM t2 WHERE id BETWEEN 1 and 4;
782
a
783
INSERT INTO t2 ( a, b ) VALUES ( 3 , 0 );
784
START TRANSACTION;
785
SELECT a FROM t2 WHERE id BETWEEN 1 and 4 /* no additional predicate */;
786
a
787
SELECT a FROM t2 WHERE id BETWEEN 1 and 4 AND id > -16777216;
788
a
789
UPDATE t2 SET id = 7 WHERE b = 8 LIMIT 8;
790
SELECT b FROM t2 WHERE a BETWEEN 6 and 8;
791
b
792
UPDATE t1 SET id = 8 WHERE 1 = 1 LIMIT 8;
793
ERROR 23000: Duplicate entry '8' for key 'PRIMARY'
794
SELECT b FROM t2 WHERE a BETWEEN 6 and 8 /* no additional predicate */;
795
b
796
ROLLBACK TO SAVEPOINT A;
797
ERROR 42000: SAVEPOINT A does not exist
798
SELECT b FROM t2 WHERE a BETWEEN 6 and 8 AND id > -16777216;
799
b
800
UPDATE t1 SET a = 0 WHERE id > 7 LIMIT 1;
801
UPDATE t1 SET b = 1 WHERE b < 6 LIMIT 6;
802
INSERT INTO t1 ( a, b ) VALUES ( 6 , 2 );
803
INSERT INTO t2 ( a, b ) VALUES ( 4 , 4 );
804
UPDATE t1 SET id = 9 WHERE b > 8 LIMIT 3;
805
DELETE FROM t2 WHERE 1 = 1 LIMIT 4;
806
UPDATE t2 SET b = 1 WHERE b > 2 LIMIT 5;
807
SELECT id FROM t1 WHERE 1 = 1;
808
id
809
31
810
32
811
33
812
ROLLBACK TO SAVEPOINT A;
813
ERROR 42000: SAVEPOINT A does not exist
814
SELECT id FROM t1 WHERE 1 = 1 /* no additional predicate */;
815
id
816
31
817
32
818
33
819
SELECT id FROM t1 WHERE 1 = 1 AND id > -16777216;
820
id
821
31
822
32
823
33
824
UPDATE t2 SET b = 9 WHERE a IN ( 9 , 1 , 9 ) LIMIT 6;
825
UPDATE t2 SET id = 1 WHERE a > 6 LIMIT 8;
826
INSERT INTO t1 ( a, b ) VALUES ( 5 , 1 );
827
DELETE FROM t1 WHERE id IN ( 0 , 7 , 4 ) LIMIT 0;
828
DELETE FROM t1 WHERE id > 8 LIMIT 4;
829
SAVEPOINT A;
830
SELECT id FROM t2 WHERE 1 = 1;
831
id
832
33
833
SELECT id FROM t2 WHERE 1 = 1 /* no additional predicate */;
834
id
835
33
836
SELECT id FROM t2 WHERE 1 = 1 AND id > -16777216;
837
id
838
33
839
UPDATE t2 SET id = 5 WHERE id > 7 LIMIT 6;
840
DELETE FROM t1 WHERE id IN ( 1 , 5 , 3 ) LIMIT 8;
841
INSERT INTO t2 ( a, b ) VALUES ( 9 , 0 );
842
DELETE FROM t2 WHERE 1 = 1 LIMIT 2;
843
INSERT INTO t1 ( a, b ) VALUES ( 7 , 6 );
844
UPDATE t2 SET a = 0 WHERE id < 9 LIMIT 0;
845
UPDATE t1 SET a = 8 WHERE 1 = 1 LIMIT 5;
846
ROLLBACK TO SAVEPOINT A;
847
ROLLBACK;
848
INSERT INTO t2 ( a, b ) VALUES ( 7 , 3 );
849
SELECT id FROM t2 WHERE a > 2;
850
id
851
32
852
31
853
29
854
30
855
35
856
SELECT id FROM t2 WHERE a > 2 /* no additional predicate */;
857
id
858
32
859
31
860
29
861
30
862
35
863
SELECT id FROM t2 WHERE a > 2 AND id > -16777216;
864
id
865
29
866
30
867
31
868
32
869
35
870
ROLLBACK;
871
SELECT b FROM t2 WHERE id < 2;
872
b
873
SELECT b FROM t2 WHERE id < 2 /* no additional predicate */;
874
b
875
SELECT b FROM t2 WHERE id < 2 AND id > -16777216;
876
b
877
SELECT b FROM t1 WHERE b = 0;
878
b
879
SELECT a FROM t2 WHERE a BETWEEN 5 and 8;
880
a
881
5
882
5
883
SELECT b FROM t1 WHERE b = 0 /* no additional predicate */;
884
b
885
SELECT a FROM t2 WHERE a BETWEEN 5 and 8 /* no additional predicate */;
886
a
887
5
888
5
889
SELECT b FROM t1 WHERE b = 0 AND id > -16777216;
890
b
891
SELECT a FROM t2 WHERE a BETWEEN 5 and 8 AND id > -16777216;
892
a
893
5
894
5
895
UPDATE t1 SET b = 0 WHERE id < 0 LIMIT 6;
896
INSERT INTO t1 ( a, b ) VALUES ( 1 , 9 );
897
SET AUTOCOMMIT=1;
898
UPDATE t2 SET a = 8 WHERE 1 = 1 LIMIT 1;
899
SELECT b FROM t1 WHERE id BETWEEN 7 and 0;
900
b
901
UPDATE t2 SET a = 0 WHERE id IN ( 9 , 3 , 6 ) LIMIT 1;
902
SELECT DATABASE();
903
DATABASE()
904
test
905
SELECT b FROM t1 WHERE id BETWEEN 7 and 0 /* no additional predicate */;
906
b
907
SAVEPOINT A;
908
SELECT b FROM t1 WHERE id BETWEEN 7 and 0 AND id > -16777216;
909
b
910
UPDATE t2 SET b = 8 WHERE a IN ( 5 , 5 , 7 ) LIMIT 0;
911
UPDATE t1 SET b = 5 WHERE id < 3 LIMIT 8;
912
SELECT a FROM t1 WHERE a IN ( 8 , 2 , 4 );
913
a
914
SELECT a FROM t1 WHERE a IN ( 8 , 2 , 4 ) /* no additional predicate */;
915
a
916
SELECT a FROM t1 WHERE a IN ( 8 , 2 , 4 ) AND id > -16777216;
917
a
918
DELETE FROM t2 WHERE id IN ( 7 , 6 , 4 ) LIMIT 5;
919
SELECT a FROM t1 WHERE 1 = 1;
920
a
921
5
922
6
923
1
924
SELECT a FROM t1 WHERE 1 = 1 /* no additional predicate */;
925
a
926
5
927
6
928
1
929
SELECT a FROM t1 WHERE 1 = 1 AND id > -16777216;
930
a
931
5
932
6
933
1
934
ROLLBACK TO SAVEPOINT A;
935
ERROR 42000: SAVEPOINT A does not exist
936
INSERT INTO t2 ( a, b ) VALUES ( 6 , 6 );
937
SELECT a FROM t2 WHERE id BETWEEN 5 and 1;
938
a
939
SELECT a FROM t2 WHERE id BETWEEN 5 and 1 /* no additional predicate */;
940
a
941
SELECT a FROM t2 WHERE id BETWEEN 5 and 1 AND id > -16777216;
942
a
943
INSERT INTO t2 ( a, b ) VALUES ( 7 , 9 );
944
COMMIT;
945
START TRANSACTION;
946
COMMIT;
947
UPDATE t2 SET b = 8 WHERE b = 9 LIMIT 1;
948
DELETE FROM t1 WHERE 1 = 1 LIMIT 0;
949
UPDATE t2 SET a = 0 WHERE b = 0 LIMIT 4;
950
DELETE FROM t1 WHERE a < 1 LIMIT 4;
951
INSERT INTO t2 ( a, b ) VALUES ( 0 , 1 );
952
SELECT a FROM t1 WHERE a BETWEEN 2 and 1;
953
a
954
SELECT a FROM t1 WHERE a BETWEEN 2 and 1 /* no additional predicate */;
955
a
956
SELECT a FROM t1 WHERE a BETWEEN 2 and 1 AND id > -16777216;
957
a
958
UPDATE t2 SET b = 1 WHERE b = 3 LIMIT 0;
959
SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ;
960
SET AUTOCOMMIT=OFF;
961
INSERT INTO t2 ( a, b ) VALUES ( 1 , 0 );
962
SELECT id FROM t2 WHERE a = 3;
963
id
964
SELECT b FROM t1 WHERE a = 7;
965
b
966
SELECT id FROM t2 WHERE a = 3 /* no additional predicate */;
967
id
968
SELECT b FROM t1 WHERE a = 7 /* no additional predicate */;
969
b
970
SELECT id FROM t2 WHERE a = 3 AND id > -16777216;
971
id
972
SELECT b FROM t1 WHERE a = 7 AND id > -16777216;
973
b
974
SAVEPOINT A;
975
SAVEPOINT A;
976
INSERT INTO t1 ( a, b ) VALUES ( 4 , 0 );
977
UPDATE t1 SET b = 8 WHERE a BETWEEN 0 and 0 LIMIT 0;
978
DELETE FROM t1 WHERE 1 = 1 LIMIT 7;
979
ROLLBACK;
980
SAVEPOINT A;
981
SELECT b FROM t1 WHERE a = 3;
982
b
983
SELECT b FROM t1 WHERE a = 3 /* no additional predicate */;
984
b
985
UPDATE t2 SET b = 1 WHERE 1 = 1 LIMIT 1;
986
SELECT b FROM t1 WHERE a = 3 AND id > -16777216;
987
b
988
DELETE FROM t1 WHERE a BETWEEN 0 and 2 LIMIT 8;
989
DELETE FROM t2 WHERE b IN ( 3 , 2 , 0 ) LIMIT 9;
990
SELECT b FROM t1 WHERE b = 1;
991
b
992
INSERT INTO t1 ( a, b ) VALUES ( 0 , 1 );
993
SELECT id FROM t2 WHERE id IN ( 9 , 5 , 7 );
994
id
995
SELECT b FROM t1 WHERE b = 1 /* no additional predicate */;
996
b
997
1
998
INSERT INTO t2 ( a, b ) VALUES ( 2 , 7 );
999
SELECT id FROM t2 WHERE id IN ( 9 , 5 , 7 ) /* no additional predicate */;
1000
id
1001
SELECT b FROM t1 WHERE b = 1 AND id > -16777216;
1002
b
1003
1
1004
UPDATE t1 SET id = 9 WHERE b BETWEEN 9 and 0 LIMIT 5;
1005
SELECT id FROM t2 WHERE id IN ( 9 , 5 , 7 ) AND id > -16777216;
1006
id
1007
INSERT INTO t1 ( a, b ) VALUES ( 3 , 0 );
1008
INSERT INTO t1 ( a, b ) VALUES ( 1 , 9 );
1009
SELECT id FROM t1 WHERE b BETWEEN 2 and 3;
1010
id
1011
ROLLBACK TO SAVEPOINT A;
1012
SELECT id FROM t1 WHERE b BETWEEN 2 and 3 /* no additional predicate */;
1013
id
1014
SELECT id FROM t1 WHERE b BETWEEN 2 and 3 AND id > -16777216;
1015
id
1016
ROLLBACK TO SAVEPOINT A;
1017
DELETE FROM t2 WHERE 1 = 1 LIMIT 3;
1018
SELECT b FROM t1 WHERE id BETWEEN 0 and 0;
1019
b
1020
SELECT b FROM t1 WHERE id BETWEEN 0 and 0 /* no additional predicate */;
1021
b
1022
SELECT b FROM t1 WHERE id BETWEEN 0 and 0 AND id > -16777216;
1023
b
1024
INSERT INTO t1 ( a, b ) VALUES ( 5 , 8 );
1025
SAVEPOINT A;
1026
SELECT id FROM t1 WHERE 1 = 1;
1027
id
1028
31
1029
32
1030
38
1031
39
1032
40
1033
41
1034
SELECT id FROM t1 WHERE 1 = 1 /* no additional predicate */;
1035
id
1036
31
1037
32
1038
38
1039
39
1040
40
1041
41
1042
SELECT id FROM t1 WHERE 1 = 1 AND id > -16777216;
1043
id
1044
31
1045
32
1046
38
1047
39
1048
40
1049
41
1050
DELETE FROM t1 WHERE b IN ( 8 , 0 , 2 ) LIMIT 1;
1051
DELETE FROM t2 WHERE id < 2 LIMIT 2;
1052
UPDATE t1 SET id = 3 WHERE a > 5 LIMIT 4;
1053
DELETE FROM t2 WHERE id < 5 LIMIT 4;
1054
UPDATE t1 SET b = 7 WHERE a < 9 LIMIT 0;
1055
UPDATE t1 SET a = 9 WHERE b > 3 LIMIT 1;
1056
UPDATE t2 SET id = 2 WHERE b > 0 LIMIT 6;
1057
ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
1058
START TRANSACTION;
1059
START TRANSACTION;
1060
UPDATE t1 SET a = 2 WHERE b IN ( 5 , 5 , 0 ) LIMIT 7;
1061
SAVEPOINT A;
1062
SELECT id FROM t1 WHERE a < 9;
1063
id
1064
38
1065
40
1066
39
1067
41
1068
SELECT id FROM t1 WHERE a < 9 /* no additional predicate */;
1069
id
1070
38
1071
40
1072
39
1073
41
1074
SELECT id FROM t2 WHERE a > 9;
1075
id
1076
SELECT id FROM t1 WHERE a < 9 AND id > -16777216;
1077
id
1078
38
1079
39
1080
40
1081
41
1082
INSERT INTO t2 ( a, b ) VALUES ( 4 , 3 );
1083
SELECT id FROM t2 WHERE a > 9 /* no additional predicate */;
1084
id
1085
SAVEPOINT A;
1086
SELECT id FROM t1 WHERE id < 9;
1087
id
1088
SELECT id FROM t1 WHERE id < 9 /* no additional predicate */;
1089
id
1090
SELECT id FROM t2 WHERE a > 9 AND id > -16777216;
1091
id
1092
SELECT id FROM t1 WHERE id < 9 AND id > -16777216;
1093
id
1094
ROLLBACK;
1095
ROLLBACK;
1096
ROLLBACK;
1097
SELECT id FROM t2 WHERE b BETWEEN 9 and 1;
1098
id
1099
SELECT id FROM t2 WHERE b BETWEEN 9 and 1 /* no additional predicate */;
1100
id
1101
SELECT id FROM t2 WHERE b BETWEEN 9 and 1 AND id > -16777216;
1102
id
1103
SAVEPOINT A;
1104
DELETE FROM t1 WHERE a > 2 LIMIT 3;
1105
DELETE FROM t2 WHERE a < 0 LIMIT 7;
1106
UPDATE t1 SET b = 5 WHERE a IN ( 9 , 4 , 7 ) LIMIT 7;
1107
SELECT b FROM t1 WHERE id < 6;
1108
b
1109
INSERT INTO t2 ( a, b ) VALUES ( 1 , 0 );
1110
SELECT b FROM t1 WHERE id < 6 /* no additional predicate */;
1111
b
1112
SELECT b FROM t1 WHERE id < 6 AND id > -16777216;
1113
b
1114
SELECT a FROM t1 WHERE a BETWEEN 6 and 8;
1115
a
1116
SET AUTOCOMMIT=1;
1117
SELECT a FROM t1 WHERE a BETWEEN 6 and 8 /* no additional predicate */;
1118
a
1119
SELECT DATABASE();
1120
DATABASE()
1121
test
1122
INSERT INTO t1 ( a, b ) VALUES ( 7 , 3 );
1123
SELECT a FROM t1 WHERE a BETWEEN 6 and 8 AND id > -16777216;
1124
a
1125
7
1126
SELECT id FROM t2 WHERE b = 6;
1127
id
1128
INSERT INTO t1 ( a, b ) VALUES ( 9 , 4 );
1129
SELECT id FROM t2 WHERE b = 6 /* no additional predicate */;
1130
id
1131
ROLLBACK TO SAVEPOINT A;
1132
SELECT id FROM t2 WHERE b = 6 AND id > -16777216;
1133
id
1134
UPDATE t1 SET b = 4 WHERE b < 9 LIMIT 0;
1135
DELETE FROM t2 WHERE a < 1 LIMIT 1;
1136
INSERT INTO t2 ( a, b ) VALUES ( 6 , 6 );
1137
SAVEPOINT A;
1138
DELETE FROM t1 WHERE id IN ( 6 , 8 , 8 ) LIMIT 6;
1139
UPDATE t1 SET a = 1 WHERE a = 9 LIMIT 1;
1140
UPDATE t2 SET b = 7 WHERE id > 6 LIMIT 0;
1141
DELETE FROM t2 WHERE id < 1 LIMIT 4;
1142
DELETE FROM t1 WHERE a > 7 LIMIT 7;
1143
ROLLBACK;
1144
DELETE FROM t2 WHERE b IN ( 8 , 4 , 5 ) LIMIT 5;
1145
UPDATE t2 SET a = 7 WHERE b > 4 LIMIT 0;
1146
UPDATE t1 SET b = 6 WHERE b > 4 LIMIT 8;
1147
SAVEPOINT A;
1148
DELETE FROM t1 WHERE a > 9 LIMIT 3;
1149
INSERT INTO t2 ( a, b ) VALUES ( 3 , 5 );
1150
COMMIT;
1151
SAVEPOINT A;
1152
ROLLBACK TO SAVEPOINT A;
1153
SELECT b FROM t2 WHERE b BETWEEN 0 and 6;
1154
b
1155
3
1156
0
1157
6
1158
5
1159
SELECT b FROM t2 WHERE b BETWEEN 0 and 6 /* no additional predicate */;
1160
b
1161
3
1162
0
1163
6
1164
5
1165
SELECT b FROM t2 WHERE b BETWEEN 0 and 6 AND id > -16777216;
1166
b
1167
3
1168
0
1169
6
1170
5
1171
DELETE FROM t1 WHERE b > 4 LIMIT 9;
1172
UPDATE t1 SET b = 1 WHERE id > 2 LIMIT 2;
1173
SELECT b FROM t2 WHERE 1 = 1;
1174
b
1175
7
1176
3
1177
0
1178
6
1179
5
1180
SELECT b FROM t2 WHERE 1 = 1 /* no additional predicate */;
1181
b
1182
7
1183
3
1184
0
1185
6
1186
5
1187
SELECT b FROM t2 WHERE 1 = 1 AND id > -16777216;
1188
b
1189
7
1190
3
1191
0
1192
6
1193
5
1194
DELETE FROM t1 WHERE a = 7 LIMIT 4;
1195
DELETE FROM t1 WHERE id > 6 LIMIT 3;
1196
ROLLBACK;
1197
DELETE FROM t1 WHERE a > 7 LIMIT 2;
1198
INSERT INTO t2 ( a, b ) VALUES ( 8 , 3 );
1199
DELETE FROM t1 WHERE a BETWEEN 0 and 6 LIMIT 0;
1200
SELECT b FROM t2 WHERE id = 6;
1201
b
1202
DELETE FROM t1 WHERE b IN ( 9 , 1 , 0 ) LIMIT 2;
1203
SELECT b FROM t2 WHERE id = 6 /* no additional predicate */;
1204
b
1205
INSERT INTO t1 ( a, b ) VALUES ( 7 , 5 );
1206
SELECT b FROM t2 WHERE id = 6 AND id > -16777216;
1207
b
1208
INSERT INTO t1 ( a, b ) VALUES ( 2 , 7 );
1209
UPDATE t2 SET b = 6 WHERE b = 0 LIMIT 2;
1210
INSERT INTO t1 ( a, b ) VALUES ( 1 , 5 );
1211
INSERT INTO t2 ( a, b ) VALUES ( 1 , 5 );
1212
SELECT a FROM t2 WHERE b IN ( 8 , 1 , 1 );
1213
a
1214
SELECT a FROM t2 WHERE b IN ( 8 , 1 , 1 ) /* no additional predicate */;
1215
a
1216
SELECT a FROM t2 WHERE b IN ( 8 , 1 , 1 ) AND id > -16777216;
1217
a
1218
SELECT a FROM t1 WHERE b < 7;
1219
a
1220
7
1221
1
1222
SELECT a FROM t1 WHERE b < 7 /* no additional predicate */;
1223
a
1224
7
1225
1
1226
SELECT a FROM t1 WHERE b < 7 AND id > -16777216;
1227
a
1228
7
1229
1
1230
UPDATE t2 SET b = 5 WHERE b IN ( 8 , 0 , 6 ) LIMIT 3;
1231
START TRANSACTION;
1232
UPDATE t2 SET id = 1 WHERE 1 = 1 LIMIT 2;
1233
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
1234
UPDATE t1 SET a = 4 WHERE a IN ( 3 , 9 , 7 ) LIMIT 6;
1235
UPDATE t2 SET id = 9 WHERE 1 = 1 LIMIT 8;
1236
ERROR 23000: Duplicate entry '9' for key 'PRIMARY'
1237
SELECT id FROM t2 WHERE id > 5;
1238
id
1239
40
1240
41
1241
42
1242
43
1243
44
1244
45
1245
46
1246
SELECT a FROM t2 WHERE b = 7;
1247
a
1248
2
1249
SELECT id FROM t2 WHERE id > 5 /* no additional predicate */;
1250
id
1251
40
1252
41
1253
42
1254
43
1255
44
1256
45
1257
46
1258
SELECT a FROM t2 WHERE b = 7 /* no additional predicate */;
1259
a
1260
2
1261
SELECT a FROM t2 WHERE b = 7 AND id > -16777216;
1262
a
1263
2
1264
SELECT id FROM t2 WHERE id > 5 AND id > -16777216;
1265
id
1266
40
1267
41
1268
42
1269
43
1270
44
1271
45
1272
46
1273
SELECT VERSION();
1274
VERSION()
1275
2010.04.1491
1276
SELECT collation_name,character_set_name FROM data_dictionary.collations;
1277
collation_name character_set_name
1278
utf8_general_ci utf8_general_ci
1279
utf8_bin utf8_general_ci
1280
utf8_unicode_ci utf8_general_ci
1281
utf8_icelandic_ci utf8_general_ci
1282
utf8_latvian_ci utf8_general_ci
1283
utf8_romanian_ci utf8_general_ci
1284
utf8_slovenian_ci utf8_general_ci
1285
utf8_polish_ci utf8_general_ci
1286
utf8_estonian_ci utf8_general_ci
1287
utf8_spanish_ci utf8_general_ci
1288
utf8_swedish_ci utf8_general_ci
1289
utf8_turkish_ci utf8_general_ci
1290
utf8_czech_ci utf8_general_ci
1291
utf8_danish_ci utf8_general_ci
1292
utf8_lithuanian_ci utf8_general_ci
1293
utf8_slovak_ci utf8_general_ci
1294
utf8_spanish2_ci utf8_general_ci
1295
utf8_roman_ci utf8_general_ci
1296
utf8_persian_ci utf8_general_ci
1297
utf8_esperanto_ci utf8_general_ci
1298
utf8_hungarian_ci utf8_general_ci
1299
utf8_sinhala_ci utf8_general_ci
1300
binary binary
1301
ROLLBACK;
1302
SELECT id FROM t2 WHERE b BETWEEN 8 and 6;
1303
id
1304
SELECT id FROM t2 WHERE b BETWEEN 8 and 6 /* no additional predicate */;
1305
id
1306
SELECT id FROM t2 WHERE b BETWEEN 8 and 6 AND id > -16777216;
1307
id
1308
SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ;
1309
DELETE FROM t2 WHERE id = 7 LIMIT 9;
1310
SET AUTOCOMMIT=OFF;
1311
DELETE FROM t1 WHERE id IN ( 5 , 6 , 6 ) LIMIT 9;
1312
DELETE FROM t2 WHERE id BETWEEN 5 and 5 LIMIT 0;
1313
UPDATE t1 SET a = 5 WHERE b = 7 LIMIT 1;
1314
START TRANSACTION;
1315
UPDATE t1 SET a = 7 WHERE a > 7 LIMIT 8;
1316
DELETE FROM t1 WHERE a = 4 LIMIT 2;
1317
SELECT id FROM t2 WHERE id > 6;
1318
id
1319
40
1320
41
1321
42
1322
43
1323
44
1324
45
1325
46
1326
SELECT b FROM t2 WHERE b = 8;
1327
b
1328
SELECT b FROM t2 WHERE b = 8 /* no additional predicate */;
1329
b
1330
SELECT b FROM t2 WHERE b = 8 AND id > -16777216;
1331
b
1332
SELECT id FROM t2 WHERE id > 6 /* no additional predicate */;
1333
id
1334
40
1335
41
1336
42
1337
43
1338
44
1339
45
1340
46
1341
DELETE FROM t1 WHERE 1 = 1 LIMIT 6;
1342
SELECT id FROM t2 WHERE id > 6 AND id > -16777216;
1343
id
1344
40
1345
41
1346
42
1347
43
1348
44
1349
45
1350
46
1351
START TRANSACTION;
1352
ROLLBACK;
1353
INSERT INTO t1 ( a, b ) VALUES ( 0 , 7 );
1354
DELETE FROM t1 WHERE b IN ( 7 , 3 , 6 ) LIMIT 6;
1355
DELETE FROM t2 WHERE 1 = 1 LIMIT 2;
1356
SELECT id FROM t1 WHERE id IN ( 2 , 2 , 2 );
1357
id
1358
SELECT id FROM t1 WHERE id IN ( 2 , 2 , 2 ) /* no additional predicate */;
1359
id
1360
UPDATE t2 SET b = 2 WHERE a = 7 LIMIT 3;
1361
SELECT id FROM t1 WHERE id IN ( 2 , 2 , 2 ) AND id > -16777216;
1362
id
1363
UPDATE t2 SET b = 3 WHERE a < 3 LIMIT 1;
1364
UPDATE t1 SET id = 6 WHERE a < 1 LIMIT 6;
1365
UPDATE t2 SET b = 3 WHERE 1 = 1 LIMIT 5;
1366
DELETE FROM t2 WHERE b = 3 LIMIT 9;
1367
UPDATE t2 SET id = 2 WHERE id BETWEEN 0 and 0 LIMIT 1;
1368
DELETE FROM t1 WHERE b BETWEEN 5 and 9 LIMIT 5;
1369
UPDATE t2 SET id = 8 WHERE id = 9 LIMIT 2;
1370
START TRANSACTION;
1371
ROLLBACK;
1372
UPDATE t1 SET b = 0 WHERE a BETWEEN 8 and 8 LIMIT 8;
1373
ROLLBACK TO SAVEPOINT A;
1374
UPDATE t1 SET b = 0 WHERE 1 = 1 LIMIT 6;
1375
SELECT b FROM t1 WHERE id = 5;
1376
b
1377
INSERT INTO t1 ( a, b ) VALUES ( 0 , 5 );
1378
SELECT b FROM t1 WHERE id = 5 /* no additional predicate */;
1379
b
1380
SELECT b FROM t1 WHERE id > 7;
1381
b
1382
5
1383
SELECT b FROM t1 WHERE id = 5 AND id > -16777216;
1384
b
1385
SELECT b FROM t1 WHERE id > 7 /* no additional predicate */;
1386
b
1387
5
1388
DELETE FROM t1 WHERE 1 = 1 LIMIT 4;
1389
SELECT b FROM t1 WHERE id > 7 AND id > -16777216;
1390
b
1391
UPDATE t1 SET a = 8 WHERE a BETWEEN 3 and 5 LIMIT 9;
1392
SELECT b FROM t1 WHERE id > 8;
1393
b
1394
SELECT b FROM t1 WHERE id > 8 /* no additional predicate */;
1395
b
1396
UPDATE t2 SET id = 9 WHERE b = 7 LIMIT 2;
1397
SELECT b FROM t1 WHERE id > 8 AND id > -16777216;
1398
b
1399
DELETE FROM t2 WHERE b > 9 LIMIT 4;
1400
SELECT a FROM t1 WHERE a > 0;
1401
a
1402
SELECT a FROM t1 WHERE a > 0 /* no additional predicate */;
1403
a
1404
SELECT a FROM t1 WHERE a > 0 AND id > -16777216;
1405
a
1406
DELETE FROM t2 WHERE a < 5 LIMIT 6;
1407
INSERT INTO t2 ( a, b ) VALUES ( 2 , 7 );
1408
SELECT id FROM t2 WHERE 1 = 1;
1409
id
1410
47
1411
SELECT id FROM t2 WHERE 1 = 1 /* no additional predicate */;
1412
id
1413
47
1414
DELETE FROM t2 WHERE id BETWEEN 1 and 9 LIMIT 8;
1415
DELETE FROM t2 WHERE id = 9 LIMIT 5;
1416
UPDATE t1 SET id = 9 WHERE b > 5 LIMIT 2;
1417
SELECT id FROM t2 WHERE 1 = 1 AND id > -16777216;
1418
id
1419
47
1420
INSERT INTO t1 ( a, b ) VALUES ( 0 , 4 );
1421
INSERT INTO t2 ( a, b ) VALUES ( 9 , 9 );
1422
INSERT INTO t2 ( a, b ) VALUES ( 1 , 2 );
1423
UPDATE t2 SET a = 1 WHERE 1 = 1 LIMIT 4;
1424
SAVEPOINT A;
1425
DELETE FROM t1 WHERE a > 0 LIMIT 3;
1426
SELECT b FROM t2 WHERE id IN ( 0 , 0 , 3 );
1427
b
1428
SELECT b FROM t2 WHERE id IN ( 0 , 0 , 3 ) /* no additional predicate */;
1429
b
1430
SELECT a FROM t2 WHERE id BETWEEN 3 and 0;
1431
a
1432
SELECT a FROM t2 WHERE id BETWEEN 3 and 0 /* no additional predicate */;
1433
a
1434
SELECT b FROM t2 WHERE id IN ( 0 , 0 , 3 ) AND id > -16777216;
1435
b
1436
SELECT a FROM t2 WHERE id BETWEEN 3 and 0 AND id > -16777216;
1437
a
1438
INSERT INTO t2 ( a, b ) VALUES ( 6 , 9 );
1439
DELETE FROM t1 WHERE 1 = 1 LIMIT 1;
1440
UPDATE t1 SET b = 1 WHERE 1 = 1 LIMIT 2;
1441
INSERT INTO t2 ( a, b ) VALUES ( 1 , 6 );
1442
UPDATE t1 SET b = 7 WHERE b < 3 LIMIT 6;
1443
UPDATE t1 SET a = 3 WHERE id = 1 LIMIT 0;
1444
UPDATE t2 SET b = 1 WHERE id = 3 LIMIT 9;
1445
DELETE FROM t1 WHERE a > 3 LIMIT 6;
1446
SELECT id FROM t2 WHERE a BETWEEN 2 and 2;
1447
id
1448
UPDATE t1 SET a = 2 WHERE a BETWEEN 8 and 2 LIMIT 1;
1449
SELECT id FROM t2 WHERE a BETWEEN 2 and 2 /* no additional predicate */;
1450
id
1451
SELECT id FROM t2 WHERE a BETWEEN 2 and 2 AND id > -16777216;
1452
id
1453
UPDATE t1 SET a = 2 WHERE b > 3 LIMIT 9;
1454
SAVEPOINT A;
1455
INSERT INTO t2 ( a, b ) VALUES ( 3 , 0 );
1456
INSERT INTO t1 ( a, b ) VALUES ( 3 , 1 );
1457
SELECT id FROM t2 WHERE a BETWEEN 3 and 9;
1458
id
1459
52
1460
50
1461
SELECT id FROM t2 WHERE a BETWEEN 3 and 9 /* no additional predicate */;
1462
id
1463
52
1464
50
1465
SELECT id FROM t2 WHERE a BETWEEN 3 and 9 AND id > -16777216;
1466
id
1467
50
1468
52
1469
UPDATE t1 SET b = 9 WHERE id > 8 LIMIT 5;
1470
UPDATE t2 SET id = 1 WHERE b < 8 LIMIT 2;
1471
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
1472
DELETE FROM t1 WHERE id < 5 LIMIT 8;
1473
DELETE FROM t1 WHERE a IN ( 6 , 6 , 9 ) LIMIT 1;
1474
UPDATE t2 SET id = 7 WHERE 1 = 1 LIMIT 6;
1475
ERROR 23000: Duplicate entry '7' for key 'PRIMARY'
1476
SELECT id FROM t1 WHERE id IN ( 7 , 0 , 0 );
1477
id
1478
ROLLBACK;
1479
SELECT id FROM t1 WHERE id IN ( 7 , 0 , 0 ) /* no additional predicate */;
1480
id
1481
COMMIT;
1482
SELECT id FROM t1 WHERE id IN ( 7 , 0 , 0 ) AND id > -16777216;
1483
id
1484
SELECT a FROM t1 WHERE a IN ( 8 , 3 , 6 );
1485
a
1486
3
1487
UPDATE t2 SET id = 5 WHERE id = 9 LIMIT 4;
1488
SELECT a FROM t1 WHERE a IN ( 8 , 3 , 6 ) /* no additional predicate */;
1489
a
1490
3
1491
UPDATE t2 SET a = 8 WHERE id = 4 LIMIT 0;
1492
SELECT a FROM t1 WHERE a IN ( 8 , 3 , 6 ) AND id > -16777216;
1493
a
1494
3
1495
DELETE FROM t2 WHERE a BETWEEN 7 and 3 LIMIT 7;
1496
COMMIT;
1497
INSERT INTO t1 ( a, b ) VALUES ( 9 , 2 );
1498
SAVEPOINT A;
1499
SELECT a FROM t1 WHERE id = 9;
1500
a
1501
SELECT a FROM t1 WHERE id = 9 /* no additional predicate */;
1502
a
1503
SELECT a FROM t1 WHERE b IN ( 9 , 0 , 1 );
1504
a
1505
3
1506
SELECT a FROM t1 WHERE id = 9 AND id > -16777216;
1507
a
1508
SELECT a FROM t1 WHERE b IN ( 9 , 0 , 1 ) /* no additional predicate */;
1509
a
1510
3
1511
INSERT INTO t2 ( a, b ) VALUES ( 9 , 1 );
1512
SELECT a FROM t1 WHERE b IN ( 9 , 0 , 1 ) AND id > -16777216;
1513
a
1514
3
1515
DELETE FROM t1 WHERE id IN ( 2 , 0 , 9 ) LIMIT 7;
1516
COMMIT;
1517
UPDATE t1 SET b = 4 WHERE a = 6 LIMIT 5;
1518
SAVEPOINT A;
1519
DELETE FROM t1 WHERE a BETWEEN 3 and 3 LIMIT 3;
1520
INSERT INTO t1 ( a, b ) VALUES ( 7 , 4 );
1521
SELECT a FROM t2 WHERE id BETWEEN 9 and 5;
1522
a
1523
UPDATE t1 SET id = 2 WHERE a > 0 LIMIT 6;
1524
ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
1525
SELECT a FROM t2 WHERE id BETWEEN 9 and 5 /* no additional predicate */;
1526
a
1527
INSERT INTO t2 ( a, b ) VALUES ( 0 , 3 );
1528
SELECT id FROM t2 WHERE b < 9;
1529
id
1530
47
1531
49
1532
51
1533
52
1534
53
1535
54
1536
SELECT a FROM t2 WHERE id BETWEEN 9 and 5 AND id > -16777216;
1537
a
1538
SELECT id FROM t2 WHERE b < 9 /* no additional predicate */;
1539
id
1540
47
1541
49
1542
51
1543
52
1544
53
1545
54
1546
SELECT b FROM t2 WHERE a > 3;
1547
b
1548
9
1549
1
1550
SELECT id FROM t2 WHERE b < 9 AND id > -16777216;
1551
id
1552
47
1553
49
1554
51
1555
52
1556
53
1557
54
1558
UPDATE t2 SET id = 6 WHERE b = 8 LIMIT 6;
1559
UPDATE t1 SET a = 7 WHERE a = 4 LIMIT 0;
1560
SELECT b FROM t2 WHERE a > 3 /* no additional predicate */;
1561
b
1562
9
1563
1
1564
UPDATE t1 SET id = 4 WHERE id = 0 LIMIT 2;
1565
INSERT INTO t1 ( a, b ) VALUES ( 9 , 2 );
1566
DELETE FROM t1 WHERE id > 0 LIMIT 8;
1567
SELECT b FROM t2 WHERE a > 3 AND id > -16777216;
1568
b
1569
9
1570
1
1571
START TRANSACTION;
1572
UPDATE t2 SET a = 6 WHERE id = 9 LIMIT 9;
1573
SELECT b FROM t1 WHERE a BETWEEN 5 and 3;
1574
b
1575
SELECT b FROM t1 WHERE a BETWEEN 5 and 3 /* no additional predicate */;
1576
b
1577
DELETE FROM t2 WHERE b IN ( 4 , 0 , 3 ) LIMIT 2;
1578
SELECT b FROM t1 WHERE a BETWEEN 5 and 3 AND id > -16777216;
1579
b
1580
ROLLBACK TO SAVEPOINT A;
1581
SELECT a FROM t2 WHERE b < 5;
1582
a
1583
1
1584
9
1585
SELECT a FROM t2 WHERE b < 5 /* no additional predicate */;
1586
a
1587
1
1588
9
1589
UPDATE t2 SET a = 9 WHERE 1 = 1 LIMIT 1;
1590
COMMIT;
1591
SELECT a FROM t2 WHERE b < 5 AND id > -16777216;
1592
a
1593
1
1594
9
1595
UPDATE t1 SET id = 1 WHERE b < 2 LIMIT 6;
1596
INSERT INTO t1 ( a, b ) VALUES ( 9 , 0 );
1597
UPDATE t2 SET a = 5 WHERE b BETWEEN 8 and 0 LIMIT 9;
1598
DELETE FROM t2 WHERE b IN ( 9 , 2 , 3 ) LIMIT 7;
1599
UPDATE t1 SET b = 5 WHERE id IN ( 0 , 8 , 9 ) LIMIT 7;
1600
SAVEPOINT A;
1601
DELETE FROM t2 WHERE id BETWEEN 5 and 4 LIMIT 1;
1602
DELETE FROM t2 WHERE b BETWEEN 3 and 3 LIMIT 4;
1603
SELECT id FROM t2 WHERE b < 6;
1604
id
1605
53
1606
SELECT id FROM t2 WHERE b < 6 /* no additional predicate */;
1607
id
1608
53
1609
UPDATE t1 SET b = 8 WHERE id BETWEEN 7 and 6 LIMIT 1;
1610
DELETE FROM t1 WHERE id = 8 LIMIT 5;
1611
SELECT id FROM t2 WHERE b < 6 AND id > -16777216;
1612
id
1613
53
1614
ROLLBACK TO SAVEPOINT A;
1615
DELETE FROM t1 WHERE id = 2 LIMIT 6;
1616
SELECT a FROM t1 WHERE id > 7;
1617
a
1618
9
1619
COMMIT;
1620
SELECT a FROM t1 WHERE id > 7 /* no additional predicate */;
1621
a
1622
9
1623
SELECT id FROM t2 WHERE id < 6;
1624
id
1625
SELECT a FROM t1 WHERE id > 7 AND id > -16777216;
1626
a
1627
9
1628
SELECT id FROM t2 WHERE id < 6 /* no additional predicate */;
1629
id
1630
SELECT id FROM t2 WHERE id < 6 AND id > -16777216;
1631
id
1632
COMMIT;
1633
UPDATE t2 SET b = 6 WHERE 1 = 1 LIMIT 8;
1634
COMMIT;
1635
SELECT b FROM t2 WHERE a > 6;
1636
b
1637
6
1638
6
1639
INSERT INTO t2 ( a, b ) VALUES ( 3 , 0 );
1640
UPDATE t1 SET id = 2 WHERE b = 9 LIMIT 4;
1641
SELECT b FROM t2 WHERE a > 6 /* no additional predicate */;
1642
b
1643
6
1644
6
1645
SELECT b FROM t2 WHERE a > 6 AND id > -16777216;
1646
b
1647
6
1648
6
1649
DELETE FROM t2 WHERE a IN ( 5 , 7 , 6 ) LIMIT 1;
1650
DELETE FROM t1 WHERE b IN ( 2 , 7 , 3 ) LIMIT 1;
1651
SAVEPOINT A;
1652
DELETE FROM t2 WHERE b BETWEEN 3 and 7 LIMIT 2;
1653
DELETE FROM t2 WHERE id IN ( 3 , 7 , 6 ) LIMIT 6;
1654
DELETE FROM t1 WHERE b = 8 LIMIT 0;
1655
DELETE FROM t1 WHERE a = 1 LIMIT 3;
1656
DELETE FROM t2 WHERE id < 8 LIMIT 9;
1657
DELETE FROM t1 WHERE a < 9 LIMIT 3;
1658
INSERT INTO t2 ( a, b ) VALUES ( 7 , 3 );
1659
DELETE FROM t1 WHERE b IN ( 7 , 0 , 1 ) LIMIT 9;
1660
SELECT a FROM t1 WHERE id = 8;
1661
a
1662
SELECT a FROM t1 WHERE id = 8 /* no additional predicate */;
1663
a
1664
SELECT a FROM t1 WHERE id = 8 AND id > -16777216;
1665
a
1666
DELETE FROM t1 WHERE id > 5 LIMIT 0;
1667
UPDATE t2 SET a = 4 WHERE 1 = 1 LIMIT 5;
1668
SELECT id FROM t2 WHERE a > 6;
1669
id
1670
SELECT id FROM t2 WHERE a > 6 /* no additional predicate */;
1671
id
1672
SELECT id FROM t2 WHERE a > 6 AND id > -16777216;
1673
id
1674
UPDATE t1 SET id = 7 WHERE 1 = 1 LIMIT 6;
1675
UPDATE t2 SET b = 0 WHERE a IN ( 5 , 9 , 3 ) LIMIT 1;
1676
INSERT INTO t1 ( a, b ) VALUES ( 4 , 8 );
1677
DELETE FROM t1 WHERE b > 8 LIMIT 1;
1678
ROLLBACK;
1679
UPDATE t1 SET id = 5 WHERE 1 = 1 LIMIT 5;
1680
INSERT INTO t2 ( a, b ) VALUES ( 4 , 0 );
1681
UPDATE t2 SET id = 4 WHERE 1 = 1 LIMIT 9;
1682
ERROR 23000: Duplicate entry '4' for key 'PRIMARY'
1683
DELETE FROM t1 WHERE id BETWEEN 0 and 0 LIMIT 7;
1684
DELETE FROM t1 WHERE b IN ( 1 , 8 , 0 ) LIMIT 3;
1685
COMMIT;
1686
SELECT a FROM t1 WHERE id < 5;
1687
a
1688
START TRANSACTION;
1689
INSERT INTO t1 ( a, b ) VALUES ( 6 , 9 );
1690
SELECT a FROM t1 WHERE 1 = 1;
1691
a
1692
6
1693
SAVEPOINT A;
1694
SELECT a FROM t1 WHERE 1 = 1 /* no additional predicate */;
1695
a
1696
6
1697
SELECT a FROM t1 WHERE id < 5 /* no additional predicate */;
1698
a
1699
ROLLBACK TO SAVEPOINT A;
1700
SELECT a FROM t1 WHERE 1 = 1 AND id > -16777216;
1701
a
1702
6
1703
ROLLBACK TO SAVEPOINT A;
1704
SELECT a FROM t1 WHERE id < 5 AND id > -16777216;
1705
a
1706
ROLLBACK;
1707
SAVEPOINT A;
1708
UPDATE t1 SET id = 7 WHERE b > 8 LIMIT 4;
1709
ROLLBACK;
1710
START TRANSACTION;
1711
UPDATE t2 SET a = 8 WHERE id > 7 LIMIT 2;
1712
START TRANSACTION;
1713
DELETE FROM t2 WHERE id IN ( 5 , 1 , 3 ) LIMIT 7;
1714
SELECT id FROM t1 WHERE a < 5;
1715
id
1716
DELETE FROM t2 WHERE id BETWEEN 6 and 9 LIMIT 6;
1717
INSERT INTO t1 ( a, b ) VALUES ( 7 , 6 );
1718
SELECT id FROM t1 WHERE a < 5 /* no additional predicate */;
1719
id
1720
INSERT INTO t1 ( a, b ) VALUES ( 1 , 7 );
1721
SELECT id FROM t1 WHERE a < 5 AND id > -16777216;
1722
id
1723
58
1724
SELECT id FROM t1 WHERE 1 = 1;
1725
id
1726
7
1727
57
1728
58
1729
UPDATE t1 SET a = 1 WHERE b BETWEEN 6 and 6 LIMIT 2;
1730
SELECT id FROM t1 WHERE 1 = 1 /* no additional predicate */;
1731
id
1732
7
1733
57
1734
58
1735
INSERT INTO t1 ( a, b ) VALUES ( 4 , 6 );
1736
SELECT id FROM t1 WHERE 1 = 1 AND id > -16777216;
1737
id
1738
7
1739
57
1740
58
1741
59
1742
DELETE FROM t1 WHERE b BETWEEN 5 and 6 LIMIT 2;
1743
ROLLBACK;
1744
SELECT a FROM t1 WHERE b BETWEEN 9 and 4;
1745
a
1746
SELECT a FROM t1 WHERE a IN ( 8 , 7 , 2 );
1747
a
1748
SELECT a FROM t1 WHERE b BETWEEN 9 and 4 /* no additional predicate */;
1749
a
1750
INSERT INTO t1 ( a, b ) VALUES ( 3 , 6 );
1751
SELECT a FROM t1 WHERE b BETWEEN 9 and 4 AND id > -16777216;
1752
a
1753
SELECT a FROM t1 WHERE a IN ( 8 , 7 , 2 ) /* no additional predicate */;
1754
a
1755
UPDATE t2 SET id = 9 WHERE a BETWEEN 6 and 1 LIMIT 8;
1756
SELECT id FROM t1 WHERE id BETWEEN 1 and 4;
1757
id
1758
SELECT a FROM t1 WHERE a IN ( 8 , 7 , 2 ) AND id > -16777216;
1759
a
1760
SELECT id FROM t1 WHERE id BETWEEN 1 and 4 /* no additional predicate */;
1761
id
1762
SELECT id FROM t1 WHERE id BETWEEN 1 and 4 AND id > -16777216;
1763
id
1764
SELECT a FROM t2 WHERE b BETWEEN 7 and 3;
1765
a
1766
UPDATE t2 SET b = 6 WHERE b IN ( 7 , 6 , 4 ) LIMIT 9;
1767
SELECT a FROM t2 WHERE b BETWEEN 7 and 3 /* no additional predicate */;
1768
a
1769
SELECT a FROM t2 WHERE b BETWEEN 7 and 3 AND id > -16777216;
1770
a
1771
SELECT id FROM t1 WHERE a BETWEEN 1 and 4;
1772
id
1773
58
1774
60
1775
SELECT id FROM t1 WHERE a BETWEEN 1 and 4 /* no additional predicate */;
1776
id
1777
58
1778
60
1779
UPDATE t2 SET a = 7 WHERE b = 9 LIMIT 6;
1780
SELECT id FROM t1 WHERE a BETWEEN 1 and 4 AND id > -16777216;
1781
id
1782
58
1783
60
1784
SELECT id FROM t2 WHERE id BETWEEN 9 and 3;
1785
id
1786
UPDATE t1 SET b = 9 WHERE 1 = 1 LIMIT 6;
1787
ROLLBACK TO SAVEPOINT A;
1788
SELECT id FROM t2 WHERE id BETWEEN 9 and 3 /* no additional predicate */;
1789
id
1790
UPDATE t1 SET a = 7 WHERE 1 = 1 LIMIT 8;
1791
SELECT id FROM t2 WHERE id BETWEEN 9 and 3 AND id > -16777216;
1792
id
1793
START TRANSACTION;
1794
COMMIT;
1795
SAVEPOINT A;
1796
DELETE FROM t1 WHERE id BETWEEN 9 and 2 LIMIT 4;
1797
SELECT b FROM t1 WHERE id BETWEEN 4 and 7;
1798
b
1799
9
1800
SELECT b FROM t1 WHERE 1 = 1;
1801
b
1802
9
1803
9
1804
9
1805
UPDATE t2 SET b = 5 WHERE b < 1 LIMIT 1;
1806
SELECT b FROM t1 WHERE id BETWEEN 4 and 7 /* no additional predicate */;
1807
b
1808
9
1809
SELECT b FROM t1 WHERE 1 = 1 /* no additional predicate */;
1810
b
1811
9
1812
9
1813
9
1814
SELECT b FROM t1 WHERE 1 = 1 AND id > -16777216;
1815
b
1816
9
1817
9
1818
9
1819
INSERT INTO t1 ( a, b ) VALUES ( 9 , 5 );
1820
SELECT b FROM t1 WHERE id BETWEEN 4 and 7 AND id > -16777216;
1821
b
1822
9
1823
INSERT INTO t2 ( a, b ) VALUES ( 9 , 1 );
1824
INSERT INTO t1 ( a, b ) VALUES ( 3 , 8 );
1825
UPDATE t1 SET b = 8 WHERE 1 = 1 LIMIT 5;
1826
SELECT a FROM t2 WHERE id < 9;
1827
a
1828
SELECT a FROM t2 WHERE id < 9 /* no additional predicate */;
1829
a
1830
SELECT a FROM t2 WHERE id < 9 AND id > -16777216;
1831
a
1832
INSERT INTO t2 ( a, b ) VALUES ( 1 , 0 );
1833
SELECT id FROM t2 WHERE a < 2;
1834
id
1835
59
1836
INSERT INTO t2 ( a, b ) VALUES ( 6 , 6 );
1837
SELECT id FROM t2 WHERE a < 2 /* no additional predicate */;
1838
id
1839
59
1840
SELECT a FROM t2 WHERE id IN ( 2 , 8 , 8 );
1841
a
1842
DELETE FROM t2 WHERE a BETWEEN 2 and 1 LIMIT 2;
1843
SELECT a FROM t2 WHERE id IN ( 2 , 8 , 8 ) /* no additional predicate */;
1844
a
1845
SELECT id FROM t2 WHERE a < 2 AND id > -16777216;
1846
id
1847
59
1848
SELECT a FROM t2 WHERE id IN ( 2 , 8 , 8 ) AND id > -16777216;
1849
a
1850
START TRANSACTION;
1851
INSERT INTO t1 ( a, b ) VALUES ( 8 , 4 );
1852
START TRANSACTION;
1853
DELETE FROM t1 WHERE a > 4 LIMIT 5;
1854
ROLLBACK;
1855
INSERT INTO t1 ( a, b ) VALUES ( 6 , 5 );
1856
DELETE FROM t1 WHERE 1 = 1 LIMIT 0;
1857
START TRANSACTION;
1858
UPDATE t1 SET b = 3 WHERE a IN ( 7 , 1 , 1 ) LIMIT 7;
1859
DELETE FROM t2 WHERE a < 4 LIMIT 2;
1860
UPDATE t1 SET b = 2 WHERE 1 = 1 LIMIT 8;
1861
UPDATE t2 SET id = 3 WHERE 1 = 1 LIMIT 3;
1862
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
1863
SELECT id FROM t1 WHERE a = 6;
1864
id
1865
64
1866
SELECT id FROM t1 WHERE a = 6 /* no additional predicate */;
1867
id
1868
64
1869
DELETE FROM t2 WHERE id > 5 LIMIT 2;
1870
SELECT id FROM t1 WHERE a = 6 AND id > -16777216;
1871
id
1872
64
1873
UPDATE t1 SET a = 5 WHERE id BETWEEN 2 and 4 LIMIT 2;
1874
ROLLBACK TO SAVEPOINT A;
1875
INSERT INTO t2 ( a, b ) VALUES ( 2 , 8 );
1876
INSERT INTO t2 ( a, b ) VALUES ( 0 , 7 );
1877
UPDATE t2 SET b = 0 WHERE b BETWEEN 6 and 3 LIMIT 9;
1878
SELECT b FROM t1 WHERE a > 3;
1879
b
1880
2
1881
ROLLBACK;
1882
DELETE FROM t1 WHERE id > 1 LIMIT 4;
1883
SELECT b FROM t1 WHERE a > 3 /* no additional predicate */;
1884
b
1885
ROLLBACK;
1886
SELECT b FROM t1 WHERE a > 3 AND id > -16777216;
1887
b
1888
COMMIT;
1889
SELECT a FROM t2 WHERE id < 6;
1890
a
1891
INSERT INTO t1 ( a, b ) VALUES ( 4 , 2 );
1892
SELECT a FROM t2 WHERE id < 6 /* no additional predicate */;
1893
a
1894
INSERT INTO t2 ( a, b ) VALUES ( 5 , 8 );
1895
SELECT b FROM t1 WHERE b BETWEEN 8 and 6;
1896
b
1897
SELECT a FROM t2 WHERE id < 6 AND id > -16777216;
1898
a
1899
DELETE FROM t1 WHERE a BETWEEN 6 and 5 LIMIT 4;
1900
SELECT b FROM t1 WHERE b BETWEEN 8 and 6 /* no additional predicate */;
1901
b
1902
UPDATE t1 SET a = 4 WHERE id > 4 LIMIT 7;
1903
SELECT a FROM t1 WHERE id > 0;
1904
a
1905
4
1906
SELECT b FROM t1 WHERE b BETWEEN 8 and 6 AND id > -16777216;
1907
b
1908
SELECT a FROM t1 WHERE id > 0 /* no additional predicate */;
1909
a
1910
4
1911
ROLLBACK;
1912
SELECT a FROM t1 WHERE id > 0 AND id > -16777216;
1913
a
1914
4
1915
SELECT id FROM t1 WHERE id = 7;
1916
id
1917
SELECT id FROM t1 WHERE id = 7 /* no additional predicate */;
1918
id
1919
SELECT b FROM t1 WHERE a BETWEEN 6 and 3;
1920
b
1921
SELECT id FROM t1 WHERE id = 7 AND id > -16777216;
1922
id
1923
SELECT b FROM t1 WHERE a BETWEEN 6 and 3 /* no additional predicate */;
1924
b
1925
SELECT b FROM t1 WHERE a BETWEEN 6 and 3 AND id > -16777216;
1926
b
1927
UPDATE t2 SET a = 6 WHERE id IN ( 4 , 3 , 0 ) LIMIT 2;
1928
COMMIT;
1929
SELECT id FROM t2 WHERE b > 5;
1930
id
1931
60
1932
61
1933
62
1934
63
1935
SELECT id FROM t2 WHERE b > 5 /* no additional predicate */;
1936
id
1937
60
1938
61
1939
62
1940
63
1941
SELECT id FROM t2 WHERE b > 5 AND id > -16777216;
1942
id
1943
60
1944
61
1945
62
1946
63
1947
SELECT a FROM t2 WHERE a = 8;
1948
a
1949
COMMIT;
1950
SELECT a FROM t2 WHERE a = 8 /* no additional predicate */;
1951
a
1952
SELECT a FROM t2 WHERE a = 8 AND id > -16777216;
1953
a
1954
UPDATE t1 SET id = 9 WHERE a IN ( 1 , 2 , 5 ) LIMIT 4;
1955
DELETE FROM t2 WHERE a IN ( 0 , 9 , 0 ) LIMIT 1;
1956
UPDATE t2 SET a = 7 WHERE b = 2 LIMIT 7;
1957
UPDATE t2 SET id = 6 WHERE a = 0 LIMIT 8;
1958
INSERT INTO t1 ( a, b ) VALUES ( 3 , 1 );
1959
DELETE FROM t2 WHERE b = 7 LIMIT 0;
1960
DELETE FROM t1 WHERE id < 3 LIMIT 9;
1961
INSERT INTO t2 ( a, b ) VALUES ( 6 , 7 );
1962
SELECT id FROM t1 WHERE b IN ( 8 , 1 , 7 );
1963
id
1964
66
1965
START TRANSACTION;
1966
SELECT id FROM t1 WHERE b IN ( 8 , 1 , 7 ) /* no additional predicate */;
1967
id
1968
66
1969
SELECT id FROM t1 WHERE b IN ( 8 , 1 , 7 ) AND id > -16777216;
1970
id
1971
66
1972
INSERT INTO t1 ( a, b ) VALUES ( 3 , 7 );
1973
INSERT INTO t1 ( a, b ) VALUES ( 2 , 2 );
1974
SAVEPOINT A;
1975
COMMIT;
1976
DELETE FROM t1 WHERE 1 = 1 LIMIT 9;
1977
UPDATE t1 SET id = 4 WHERE 1 = 1 LIMIT 4;
1978
UPDATE t2 SET id = 2 WHERE 1 = 1 LIMIT 5;
1979
ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
1980
ROLLBACK;
1981
INSERT INTO t2 ( a, b ) VALUES ( 5 , 6 );
1982
SELECT a FROM t1 WHERE 1 = 1;
1983
a
1984
ROLLBACK TO SAVEPOINT A;
1985
SELECT a FROM t1 WHERE 1 = 1 /* no additional predicate */;
1986
a
1987
INSERT INTO t1 ( a, b ) VALUES ( 1 , 3 );
1988
SELECT a FROM t1 WHERE 1 = 1 AND id > -16777216;
1989
a
1990
1
1991
UPDATE t2 SET a = 2 WHERE b > 3 LIMIT 4;
1992
SELECT a FROM t1 WHERE id > 5;
1993
a
1994
1
1995
SELECT a FROM t1 WHERE id > 5 /* no additional predicate */;
1996
a
1997
1
1998
SELECT a FROM t1 WHERE id > 5 AND id > -16777216;
1999
a
2000
1
2001
UPDATE t1 SET id = 1 WHERE 1 = 1 LIMIT 3;
2002
UPDATE t1 SET b = 3 WHERE a < 1 LIMIT 5;
2003
UPDATE t1 SET b = 8 WHERE a < 9 LIMIT 1;
2004
UPDATE t2 SET id = 8 WHERE a BETWEEN 3 and 1 LIMIT 9;
2005
UPDATE t2 SET a = 3 WHERE b < 2 LIMIT 6;
2006
DELETE FROM t2 WHERE a IN ( 5 , 8 , 8 ) LIMIT 9;
2007
DELETE FROM t2 WHERE a BETWEEN 3 and 0 LIMIT 8;
2008
DELETE FROM t1 WHERE id < 8 LIMIT 7;
2009
UPDATE t1 SET id = 4 WHERE b > 5 LIMIT 7;
2010
DELETE FROM t1 WHERE b BETWEEN 9 and 2 LIMIT 2;
2011
DELETE FROM t1 WHERE b = 6 LIMIT 9;
2012
COMMIT;
2013
ROLLBACK;
2014
UPDATE t1 SET id = 2 WHERE a = 8 LIMIT 9;
2015
INSERT INTO t1 ( a, b ) VALUES ( 5 , 1 );
2016
INSERT INTO t1 ( a, b ) VALUES ( 2 , 4 );
2017
SAVEPOINT A;
2018
DELETE FROM t2 WHERE id < 3 LIMIT 9;
2019
UPDATE t2 SET a = 7 WHERE 1 = 1 LIMIT 7;
2020
COMMIT;
2021
ROLLBACK;
2022
INSERT INTO t1 ( a, b ) VALUES ( 5 , 6 );
2023
INSERT INTO t1 ( a, b ) VALUES ( 4 , 1 );
2024
SELECT b FROM t1 WHERE id BETWEEN 7 and 0;
2025
b
2026
SELECT b FROM t1 WHERE id BETWEEN 7 and 0 /* no additional predicate */;
2027
b
2028
SELECT b FROM t1 WHERE id BETWEEN 7 and 0 AND id > -16777216;
2029
b
2030
INSERT INTO t1 ( a, b ) VALUES ( 6 , 7 );
2031
SELECT b FROM t2 WHERE a > 2;
2032
b
2033
3
2034
0
2035
1
2036
6
2037
8
2038
8
2039
7
2040
SELECT b FROM t2 WHERE a > 2 /* no additional predicate */;
2041
b
2042
3
2043
0
2044
1
2045
6
2046
8
2047
8
2048
7
2049
SELECT b FROM t2 WHERE a > 2 AND id > -16777216;
2050
b
2051
3
2052
0
2053
1
2054
6
2055
8
2056
8
2057
7
2058
UPDATE t2 SET id = 7 WHERE b IN ( 2 , 6 , 8 ) LIMIT 3;
2059
ERROR 23000: Duplicate entry '7' for key 'PRIMARY'
2060
UPDATE t2 SET b = 5 WHERE a IN ( 1 , 5 , 0 ) LIMIT 9;
2061
DELETE FROM t2 WHERE b > 8 LIMIT 9;
2062
INSERT INTO t1 ( a, b ) VALUES ( 5 , 3 );
2063
SELECT a FROM t2 WHERE id < 5;
2064
a
2065
DELETE FROM t2 WHERE id IN ( 0 , 2 , 9 ) LIMIT 5;
2066
SELECT a FROM t2 WHERE id < 5 /* no additional predicate */;
2067
a
2068
SELECT a FROM t2 WHERE id < 5 AND id > -16777216;
2069
a
2070
INSERT INTO t1 ( a, b ) VALUES ( 1 , 6 );
2071
INSERT INTO t2 ( a, b ) VALUES ( 7 , 3 );
2072
SELECT id FROM t2 WHERE a > 2;
2073
id
2074
56
2075
57
2076
58
2077
60
2078
61
2079
63
2080
64
2081
66
2082
SELECT id FROM t2 WHERE a > 2 /* no additional predicate */;
2083
id
2084
56
2085
57
2086
58
2087
60
2088
61
2089
63
2090
64
2091
66
2092
SELECT id FROM t2 WHERE a > 2 AND id > -16777216;
2093
id
2094
56
2095
57
2096
58
2097
60
2098
61
2099
63
2100
64
2101
66
2102
INSERT INTO t2 ( a, b ) VALUES ( 1 , 9 );
2103
INSERT INTO t1 ( a, b ) VALUES ( 1 , 0 );
2104
UPDATE t1 SET a = 3 WHERE b < 4 LIMIT 8;
2105
DELETE FROM t1 WHERE a < 8 LIMIT 2;
2106
DELETE FROM t2 WHERE id < 8 LIMIT 0;
2107
DELETE FROM t2 WHERE a = 9 LIMIT 4;
2108
DELETE FROM t2 WHERE 1 = 1 LIMIT 7;
2109
INSERT INTO t1 ( a, b ) VALUES ( 8 , 2 );
2110
DELETE FROM t1 WHERE a IN ( 4 , 6 , 5 ) LIMIT 2;
2111
DELETE FROM t1 WHERE a IN ( 8 , 9 , 8 ) LIMIT 9;
2112
DELETE FROM t1 WHERE b IN ( 1 , 5 , 0 ) LIMIT 8;
2113
UPDATE t1 SET a = 8 WHERE id > 3 LIMIT 6;
2114
INSERT INTO t1 ( a, b ) VALUES ( 0 , 5 );
2115
DELETE FROM t1 WHERE a IN ( 8 , 4 , 2 ) LIMIT 1;
2116
SAVEPOINT A;
2117
DELETE FROM t1 WHERE id < 2 LIMIT 0;
2118
SELECT a FROM t1 WHERE 1 = 1;
2119
a
2120
0
2121
SELECT a FROM t1 WHERE 1 = 1 /* no additional predicate */;
2122
a
2123
0
2124
SELECT a FROM t1 WHERE 1 = 1 AND id > -16777216;
2125
a
2126
0
2127
UPDATE t2 SET b = 1 WHERE id < 3 LIMIT 3;
2128
DELETE FROM t1 WHERE b < 6 LIMIT 3;
2129
DELETE FROM t1 WHERE a BETWEEN 3 and 8 LIMIT 7;
2130
SELECT b FROM t2 WHERE id = 6;
2131
b
2132
INSERT INTO t2 ( a, b ) VALUES ( 7 , 9 );
2133
SELECT b FROM t2 WHERE id = 6 /* no additional predicate */;
2134
b
2135
SELECT b FROM t2 WHERE id = 6 AND id > -16777216;
2136
b
2137
UPDATE t2 SET a = 3 WHERE id > 5 LIMIT 8;
2138
SELECT b FROM t2 WHERE id BETWEEN 3 and 5;
2139
b
2140
DELETE FROM t2 WHERE 1 = 1 LIMIT 9;
2141
SELECT b FROM t2 WHERE id BETWEEN 3 and 5 /* no additional predicate */;
2142
b
2143
SELECT b FROM t2 WHERE id BETWEEN 3 and 5 AND id > -16777216;
2144
b
2145
DELETE FROM t2 WHERE 1 = 1 LIMIT 7;
2146
INSERT INTO t1 ( a, b ) VALUES ( 9 , 7 );
2147
DELETE FROM t2 WHERE b = 1 LIMIT 3;
2148
INSERT INTO t2 ( a, b ) VALUES ( 9 , 5 );
2149
SELECT id FROM t2 WHERE 1 = 1;
2150
id
2151
69
2152
SELECT id FROM t2 WHERE b > 0;
2153
id
2154
69
2155
SELECT id FROM t2 WHERE 1 = 1 /* no additional predicate */;
2156
id
2157
69
2158
SELECT id FROM t2 WHERE b > 0 /* no additional predicate */;
2159
id
2160
69
2161
SELECT id FROM t2 WHERE 1 = 1 AND id > -16777216;
2162
id
2163
69
2164
SELECT id FROM t2 WHERE b > 0 AND id > -16777216;
2165
id
2166
69
2167
START TRANSACTION;
2168
START TRANSACTION;
2169
DELETE FROM t1 WHERE b > 7 LIMIT 6;
2170
SELECT a FROM t2 WHERE 1 = 1;
2171
a
2172
9
2173
UPDATE t2 SET a = 4 WHERE 1 = 1 LIMIT 3;
2174
DELETE FROM t1 WHERE b < 6 LIMIT 1;
2175
DELETE FROM t1 WHERE 1 = 1 LIMIT 2;
2176
INSERT INTO t2 ( a, b ) VALUES ( 4 , 5 );
2177
SELECT a FROM t2 WHERE 1 = 1 /* no additional predicate */;
2178
a
2179
4
2180
4
2181
UPDATE t1 SET a = 8 WHERE a < 7 LIMIT 5;
2182
INSERT INTO t2 ( a, b ) VALUES ( 7 , 8 );
2183
SAVEPOINT A;
2184
UPDATE t1 SET a = 9 WHERE 1 = 1 LIMIT 8;
2185
SELECT a FROM t2 WHERE 1 = 1 AND id > -16777216;
2186
a
2187
4
2188
4
2189
7
2190
INSERT INTO t2 ( a, b ) VALUES ( 3 , 4 );
2191
SELECT b FROM t2 WHERE 1 = 1;
2192
b
2193
5
2194
5
2195
8
2196
4
2197
DELETE FROM t1 WHERE b BETWEEN 9 and 4 LIMIT 3;
2198
INSERT INTO t1 ( a, b ) VALUES ( 9 , 6 );
2199
SELECT b FROM t2 WHERE 1 = 1 /* no additional predicate */;
2200
b
2201
5
2202
5
2203
8
2204
4
2205
DELETE FROM t2 WHERE id IN ( 8 , 3 , 6 ) LIMIT 5;
2206
START TRANSACTION;
2207
INSERT INTO t2 ( a, b ) VALUES ( 3 , 7 );
2208
DELETE FROM t1 WHERE b > 2 LIMIT 7;
2209
ROLLBACK TO SAVEPOINT A;
2210
SELECT b FROM t2 WHERE 1 = 1 AND id > -16777216;
2211
b
2212
5
2213
5
2214
8
2215
4
2216
7
2217
UPDATE t2 SET id = 7 WHERE id IN ( 8 , 0 , 3 ) LIMIT 0;
2218
DELETE FROM t2 WHERE id BETWEEN 5 and 0 LIMIT 5;
2219
DELETE FROM t2 WHERE 1 = 1 LIMIT 8;
2220
DELETE FROM t1 WHERE b > 6 LIMIT 4;
2221
UPDATE t2 SET a = 9 WHERE id IN ( 6 , 7 , 5 ) LIMIT 0;
2222
UPDATE t2 SET a = 0 WHERE a > 1 LIMIT 3;
2223
COMMIT;
2224
START TRANSACTION;
2225
DELETE FROM t1 WHERE 1 = 1 LIMIT 0;
2226
SELECT id FROM t1 WHERE b < 7;
2227
id
2228
SELECT id FROM t1 WHERE b < 7 /* no additional predicate */;
2229
id
2230
SELECT a FROM t2 WHERE 1 = 1;
2231
a
2232
SELECT id FROM t1 WHERE b < 7 AND id > -16777216;
2233
id
2234
SELECT a FROM t2 WHERE 1 = 1 /* no additional predicate */;
2235
a
2236
DELETE FROM t1 WHERE b > 3 LIMIT 6;
2237
INSERT INTO t2 ( a, b ) VALUES ( 7 , 3 );
2238
SELECT a FROM t2 WHERE 1 = 1;
2239
a
2240
7
2241
SELECT a FROM t2 WHERE 1 = 1 AND id > -16777216;
2242
a
2243
7
2244
SELECT a FROM t2 WHERE 1 = 1 /* no additional predicate */;
2245
a
2246
7
2247
SELECT a FROM t1 WHERE a = 4;
2248
a
2249
SELECT a FROM t1 WHERE a = 4 /* no additional predicate */;
2250
a
2251
SELECT a FROM t2 WHERE 1 = 1 AND id > -16777216;
2252
a
2253
7
2254
SELECT a FROM t1 WHERE a = 4 AND id > -16777216;
2255
a
2256
SELECT a FROM t2 WHERE 1 = 1;
2257
a
2258
7
2259
UPDATE t2 SET a = 3 WHERE a IN ( 4 , 7 , 2 ) LIMIT 1;
2260
SELECT a FROM t2 WHERE 1 = 1 /* no additional predicate */;
2261
a
2262
3
2263
DELETE FROM t1 WHERE b < 3 LIMIT 1;
2264
UPDATE t1 SET a = 7 WHERE id > 3 LIMIT 1;
2265
SELECT a FROM t2 WHERE 1 = 1 AND id > -16777216;
2266
a
2267
3
2268
ROLLBACK;
2269
START TRANSACTION;
2270
ROLLBACK;
2271
ROLLBACK;
2272
START TRANSACTION;
2273
DELETE FROM t2 WHERE id = 7 LIMIT 0;
2274
INSERT INTO t2 ( a, b ) VALUES ( 7 , 2 );
2275
SELECT a FROM t1 WHERE b = 3;
2276
a
2277
SAVEPOINT A;
2278
SELECT a FROM t1 WHERE b = 3 /* no additional predicate */;
2279
a
2280
INSERT INTO t2 ( a, b ) VALUES ( 8 , 7 );
2281
DELETE FROM t1 WHERE a = 7 LIMIT 6;
2282
SELECT b FROM t1 WHERE b IN ( 3 , 5 , 4 );
2283
b
2284
SELECT a FROM t1 WHERE b = 3 AND id > -16777216;
2285
a
2286
UPDATE t1 SET a = 6 WHERE b BETWEEN 8 and 1 LIMIT 7;
2287
SELECT b FROM t1 WHERE b IN ( 3 , 5 , 4 ) /* no additional predicate */;
2288
b
2289
UPDATE t1 SET id = 5 WHERE a > 3 LIMIT 3;
2290
SELECT b FROM t1 WHERE b IN ( 3 , 5 , 4 ) AND id > -16777216;
2291
b
2292
UPDATE t2 SET b = 6 WHERE a IN ( 8 , 3 , 0 ) LIMIT 2;
2293
SAVEPOINT A;
2294
COMMIT;
2295
DELETE FROM t2 WHERE b < 3 LIMIT 1;
2296
DELETE FROM t2 WHERE b < 0 LIMIT 5;
2297
SELECT id FROM t2 WHERE b IN ( 9 , 7 , 2 );
2298
id
2299
SELECT id FROM t2 WHERE b IN ( 9 , 7 , 2 ) /* no additional predicate */;
2300
id
2301
SELECT a FROM t2 WHERE 1 = 1;
2302
a
2303
3
2304
8
2305
SELECT id FROM t2 WHERE b IN ( 9 , 7 , 2 ) AND id > -16777216;
2306
id
2307
SAVEPOINT A;
2308
SELECT a FROM t2 WHERE 1 = 1 /* no additional predicate */;
2309
a
2310
3
2311
8
2312
SELECT a FROM t2 WHERE 1 = 1 AND id > -16777216;
2313
a
2314
3
2315
8
2316
DELETE FROM t2 WHERE id < 9 LIMIT 4;
2317
SELECT a FROM t1 WHERE a > 1;
2318
a
2319
SELECT a FROM t1 WHERE a > 1 /* no additional predicate */;
2320
a
2321
SELECT a FROM t1 WHERE a > 1 AND id > -16777216;
2322
a
2323
SELECT a FROM t2 WHERE b IN ( 0 , 7 , 6 );
2324
a
2325
3
2326
8
2327
SELECT a FROM t2 WHERE b IN ( 0 , 7 , 6 ) /* no additional predicate */;
2328
a
2329
3
2330
8
2331
START TRANSACTION;
2332
SELECT a FROM t2 WHERE b IN ( 0 , 7 , 6 ) AND id > -16777216;
2333
a
2334
3
2335
8
2336
SELECT id FROM t2 WHERE id = 8;
2337
id
2338
SELECT id FROM t2 WHERE id = 8 /* no additional predicate */;
2339
id
2340
DELETE FROM t2 WHERE 1 = 1 LIMIT 4;
2341
SELECT id FROM t2 WHERE id = 8 AND id > -16777216;
2342
id
2343
DELETE FROM t1 WHERE b > 2 LIMIT 5;
2344
INSERT INTO t1 ( a, b ) VALUES ( 2 , 0 );
2345
DELETE FROM t2 WHERE b > 4 LIMIT 4;
2346
INSERT INTO t2 ( a, b ) VALUES ( 7 , 9 );
2347
INSERT INTO t2 ( a, b ) VALUES ( 5 , 6 );
2348
INSERT INTO t2 ( a, b ) VALUES ( 2 , 5 );
2349
SELECT a FROM t2 WHERE b < 8;
2350
a
2351
5
2352
2
2353
SELECT a FROM t2 WHERE b < 8 /* no additional predicate */;
2354
a
2355
5
2356
2
2357
SELECT a FROM t2 WHERE b < 8 AND id > -16777216;
2358
a
2359
5
2360
2
2361
SELECT id FROM t1 WHERE b > 7;
2362
id
2363
SELECT id FROM t1 WHERE b > 7 /* no additional predicate */;
2364
id
2365
SELECT id FROM t1 WHERE b > 7 AND id > -16777216;
2366
id
2367
DELETE FROM t2 WHERE a > 0 LIMIT 2;
2368
DELETE FROM t1 WHERE b < 7 LIMIT 7;
2369
UPDATE t1 SET id = 3 WHERE 1 = 1 LIMIT 1;
2370
DELETE FROM t2 WHERE b = 1 LIMIT 8;
2371
UPDATE t1 SET id = 5 WHERE a < 1 LIMIT 8;
2372
SELECT a FROM t1 WHERE id > 2;
2373
a
2374
SELECT a FROM t1 WHERE id BETWEEN 4 and 0;
2375
a
2376
SELECT a FROM t1 WHERE id > 2 /* no additional predicate */;
2377
a
2378
SELECT a FROM t1 WHERE id > 7;
2379
a
2380
SELECT a FROM t1 WHERE id BETWEEN 4 and 0 /* no additional predicate */;
2381
a
2382
SELECT a FROM t1 WHERE id > 2 AND id > -16777216;
2383
a
2384
DELETE FROM t1 WHERE id BETWEEN 2 and 5 LIMIT 3;
2385
SELECT a FROM t1 WHERE id > 7 /* no additional predicate */;
2386
a
2387
SELECT a FROM t1 WHERE id BETWEEN 4 and 0 AND id > -16777216;
2388
a
2389
INSERT INTO t2 ( a, b ) VALUES ( 6 , 2 );
2390
SELECT a FROM t1 WHERE id > 7 AND id > -16777216;
2391
a
2392
SELECT b FROM t1 WHERE b BETWEEN 3 and 4;
2393
b
2394
UPDATE t1 SET a = 7 WHERE b BETWEEN 6 and 3 LIMIT 2;
2395
SELECT b FROM t1 WHERE b BETWEEN 3 and 4 /* no additional predicate */;
2396
b
2397
INSERT INTO t1 ( a, b ) VALUES ( 6 , 0 );
2398
UPDATE t1 SET b = 2 WHERE 1 = 1 LIMIT 9;
2399
SELECT b FROM t1 WHERE b BETWEEN 3 and 4 AND id > -16777216;
2400
b
2401
UPDATE t1 SET b = 2 WHERE id = 4 LIMIT 0;
2402
INSERT INTO t1 ( a, b ) VALUES ( 0 , 3 );
2403
UPDATE t2 SET a = 8 WHERE a > 0 LIMIT 0;
2404
COMMIT;
2405
SELECT b FROM t1 WHERE 1 = 1;
2406
b
2407
2
2408
3
2409
SELECT b FROM t1 WHERE 1 = 1 /* no additional predicate */;
2410
b
2411
2
2412
3
2413
INSERT INTO t1 ( a, b ) VALUES ( 1 , 4 );
2414
SELECT b FROM t1 WHERE b = 7;
2415
b
2416
SELECT b FROM t1 WHERE 1 = 1 AND id > -16777216;
2417
b
2418
2
2419
3
2420
4
2421
SELECT b FROM t1 WHERE b = 7 /* no additional predicate */;
2422
b
2423
INSERT INTO t2 ( a, b ) VALUES ( 5 , 7 );
2424
SELECT b FROM t1 WHERE b = 7 AND id > -16777216;
2425
b
2426
INSERT INTO t2 ( a, b ) VALUES ( 7 , 2 );
2427
DELETE FROM t2 WHERE a BETWEEN 8 and 4 LIMIT 5;
2428
SELECT a FROM t1 WHERE b = 4;
2429
a
2430
1
2431
UPDATE t1 SET b = 1 WHERE b > 4 LIMIT 4;
2432
SELECT a FROM t1 WHERE b = 4 /* no additional predicate */;
2433
a
2434
1
2435
UPDATE t1 SET b = 4 WHERE b IN ( 0 , 9 , 4 ) LIMIT 4;
2436
SELECT a FROM t1 WHERE b = 4 AND id > -16777216;
2437
a
2438
1
2439
ROLLBACK TO SAVEPOINT A;
2440
INSERT INTO t2 ( a, b ) VALUES ( 8 , 7 );
2441
SELECT id FROM t2 WHERE 1 = 1;
2442
id
2443
77
2444
80
2445
81
2446
82
2447
83
2448
UPDATE t1 SET b = 8 WHERE a = 7 LIMIT 2;
2449
DELETE FROM t1 WHERE 1 = 1 LIMIT 7;
2450
SELECT id FROM t2 WHERE 1 = 1 /* no additional predicate */;
2451
id
2452
77
2453
80
2454
81
2455
82
2456
83
2457
START TRANSACTION;
2458
COMMIT;
2459
SELECT id FROM t2 WHERE a > 9;
2460
id
2461
SELECT id FROM t2 WHERE 1 = 1 AND id > -16777216;
2462
id
2463
77
2464
80
2465
81
2466
82
2467
83
2468
DELETE FROM t2 WHERE 1 = 1 LIMIT 4;
2469
SELECT id FROM t2 WHERE a > 9 /* no additional predicate */;
2470
id
2471
SELECT id FROM t2 WHERE id IN ( 3 , 3 , 2 );
2472
id
2473
UPDATE t1 SET a = 7 WHERE a > 9 LIMIT 7;
2474
SELECT id FROM t2 WHERE id IN ( 3 , 3 , 2 ) /* no additional predicate */;
2475
id
2476
SELECT id FROM t2 WHERE id IN ( 3 , 3 , 2 ) AND id > -16777216;
2477
id
2478
SELECT id FROM t2 WHERE a > 9 AND id > -16777216;
2479
id
2480
UPDATE t1 SET b = 6 WHERE id IN ( 4 , 7 , 6 ) LIMIT 3;
2481
SELECT b FROM t1 WHERE id BETWEEN 6 and 8;
2482
b
2483
SELECT b FROM t1 WHERE id BETWEEN 6 and 8 /* no additional predicate */;
2484
b
2485
START TRANSACTION;
2486
SELECT b FROM t1 WHERE id BETWEEN 6 and 8 AND id > -16777216;
2487
b
2488
COMMIT;
2489
DELETE FROM t2 WHERE a BETWEEN 0 and 1 LIMIT 3;
2490
SELECT b FROM t1 WHERE b IN ( 7 , 1 , 5 );
2491
b
2492
SELECT b FROM t1 WHERE b IN ( 7 , 1 , 5 ) /* no additional predicate */;
2493
b
2494
DELETE FROM t1 WHERE a < 6 LIMIT 1;
2495
SELECT b FROM t1 WHERE b IN ( 7 , 1 , 5 ) AND id > -16777216;
2496
b
2497
SELECT b FROM t2 WHERE b BETWEEN 5 and 3;
2498
b
2499
ROLLBACK TO SAVEPOINT A;
2500
SELECT b FROM t2 WHERE b BETWEEN 5 and 3 /* no additional predicate */;
2501
b
2502
ROLLBACK TO SAVEPOINT A;
2503
SELECT b FROM t2 WHERE b BETWEEN 5 and 3 AND id > -16777216;
2504
b
2505
UPDATE t1 SET a = 1 WHERE b > 8 LIMIT 4;
2506
ROLLBACK TO SAVEPOINT A;
2507
SELECT a FROM t2 WHERE a BETWEEN 9 and 7;
2508
a
2509
UPDATE t2 SET id = 8 WHERE 1 = 1 LIMIT 7;
2510
SELECT a FROM t2 WHERE a BETWEEN 9 and 7 /* no additional predicate */;
2511
a
2512
SELECT a FROM t2 WHERE a BETWEEN 9 and 7 AND id > -16777216;
2513
a
2514
SELECT b FROM t2 WHERE a > 8;
2515
b
2516
SELECT b FROM t1 WHERE 1 = 1;
2517
b
2518
SELECT b FROM t1 WHERE 1 = 1 /* no additional predicate */;
2519
b
2520
SELECT b FROM t2 WHERE a > 8 /* no additional predicate */;
2521
b
2522
SELECT b FROM t1 WHERE 1 = 1 AND id > -16777216;
2523
b
2524
SELECT b FROM t2 WHERE a > 8 AND id > -16777216;
2525
b
2526
DELETE FROM t2 WHERE b = 3 LIMIT 7;
2527
SAVEPOINT A;
2528
SELECT id FROM t2 WHERE id < 7;
2529
id
2530
INSERT INTO t2 ( a, b ) VALUES ( 8 , 3 );
2531
SELECT id FROM t2 WHERE id < 7 /* no additional predicate */;
2532
id
2533
UPDATE t2 SET id = 8 WHERE b > 7 LIMIT 0;
2534
SELECT id FROM t2 WHERE id < 7 AND id > -16777216;
2535
id
2536
START TRANSACTION;
2537
UPDATE t1 SET b = 0 WHERE id > 0 LIMIT 9;
2538
COMMIT;
2539
DELETE FROM t1 WHERE id < 4 LIMIT 2;
2540
ROLLBACK;
2541
UPDATE t1 SET id = 2 WHERE id < 6 LIMIT 3;
2542
INSERT INTO t1 ( a, b ) VALUES ( 5 , 5 );
2543
SELECT a FROM t1 WHERE b = 3;
2544
a
2545
UPDATE t2 SET id = 1 WHERE a > 3 LIMIT 6;
2546
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
2547
INSERT INTO t2 ( a, b ) VALUES ( 7 , 2 );
2548
SELECT a FROM t1 WHERE b = 3 /* no additional predicate */;
2549
a
2550
SAVEPOINT A;
2551
SELECT a FROM t1 WHERE b = 3 AND id > -16777216;
2552
a
2553
ROLLBACK TO SAVEPOINT A;
2554
SELECT id FROM t1 WHERE a IN ( 2 , 8 , 3 );
2555
id
2556
START TRANSACTION;
2557
SELECT id FROM t1 WHERE a IN ( 2 , 8 , 3 ) /* no additional predicate */;
2558
id
2559
SELECT id FROM t1 WHERE a IN ( 2 , 8 , 3 ) AND id > -16777216;
2560
id
2561
UPDATE t2 SET b = 1 WHERE b > 7 LIMIT 5;
2562
DELETE FROM t2 WHERE a = 5 LIMIT 3;
2563
SELECT id FROM t1 WHERE a = 6;
2564
id
2565
SELECT id FROM t1 WHERE a = 6 /* no additional predicate */;
2566
id
2567
SELECT id FROM t1 WHERE a = 6 AND id > -16777216;
2568
id
2569
SELECT b FROM t1 WHERE 1 = 1;
2570
b
2571
5
2572
SELECT b FROM t1 WHERE 1 = 1 /* no additional predicate */;
2573
b
2574
5
2575
SELECT b FROM t1 WHERE 1 = 1 AND id > -16777216;
2576
b
2577
5
2578
DELETE FROM t2 WHERE id = 0 LIMIT 7;
2579
UPDATE t1 SET a = 8 WHERE 1 = 1 LIMIT 8;
2580
SAVEPOINT A;
2581
UPDATE t1 SET a = 2 WHERE a IN ( 9 , 5 , 9 ) LIMIT 4;
2582
DELETE FROM t1 WHERE a < 7 LIMIT 0;
2583
DELETE FROM t2 WHERE id = 2 LIMIT 7;
2584
SELECT a FROM t2 WHERE b > 5;
2585
a
2586
8
2587
DELETE FROM t2 WHERE id > 0 LIMIT 6;
2588
SELECT a FROM t2 WHERE b > 5 /* no additional predicate */;
2589
a
2590
SELECT a FROM t2 WHERE b > 5 AND id > -16777216;
2591
a
2592
SELECT a FROM t2 WHERE a > 2;
2593
a
2594
SELECT a FROM t2 WHERE a > 2 /* no additional predicate */;
2595
a
2596
SELECT a FROM t2 WHERE a > 2 AND id > -16777216;
2597
a
2598
DELETE FROM t1 WHERE b > 7 LIMIT 8;
2599
ROLLBACK;
2600
SELECT a FROM t1 WHERE 1 = 1;
2601
a
2602
8
2603
SELECT b FROM t1 WHERE a IN ( 9 , 7 , 3 );
2604
b
2605
SELECT a FROM t1 WHERE 1 = 1 /* no additional predicate */;
2606
a
2607
8
2608
SELECT b FROM t1 WHERE a IN ( 9 , 7 , 3 ) /* no additional predicate */;
2609
b
2610
SELECT a FROM t1 WHERE 1 = 1 AND id > -16777216;
2611
a
2612
8
2613
SELECT b FROM t1 WHERE a IN ( 9 , 7 , 3 ) AND id > -16777216;
2614
b
2615
ROLLBACK TO SAVEPOINT A;
2616
UPDATE t2 SET b = 6 WHERE a < 5 LIMIT 4;
2617
UPDATE t1 SET b = 3 WHERE id = 1 LIMIT 1;
2618
DELETE FROM t1 WHERE b > 4 LIMIT 3;
2619
DELETE FROM t1 WHERE 1 = 1 LIMIT 8;
2620
SAVEPOINT A;
2621
SELECT b FROM t2 WHERE b BETWEEN 8 and 3;
2622
b
2623
SELECT b FROM t2 WHERE b BETWEEN 8 and 3 /* no additional predicate */;
2624
b
2625
INSERT INTO t2 ( a, b ) VALUES ( 5 , 3 );
2626
SELECT b FROM t2 WHERE b BETWEEN 8 and 3 AND id > -16777216;
2627
b
2628
UPDATE t2 SET b = 7 WHERE b = 6 LIMIT 8;
2629
DELETE FROM t2 WHERE 1 = 1 LIMIT 2;
2630
ROLLBACK;
2631
UPDATE t1 SET a = 2 WHERE id > 1 LIMIT 5;
2632
COMMIT;
2633
UPDATE t1 SET a = 6 WHERE b < 3 LIMIT 7;
2634
UPDATE t1 SET b = 7 WHERE 1 = 1 LIMIT 9;
2635
INSERT INTO t2 ( a, b ) VALUES ( 2 , 4 );
2636
UPDATE t1 SET b = 2 WHERE id > 2 LIMIT 5;
2637
UPDATE t1 SET id = 1 WHERE id BETWEEN 1 and 5 LIMIT 7;
2638
SELECT b FROM t1 WHERE b IN ( 1 , 7 , 5 );
2639
b
2640
INSERT INTO t2 ( a, b ) VALUES ( 1 , 2 );
2641
SELECT b FROM t1 WHERE b IN ( 1 , 7 , 5 ) /* no additional predicate */;
2642
b
2643
SELECT b FROM t1 WHERE b IN ( 1 , 7 , 5 ) AND id > -16777216;
2644
b
2645
SELECT id FROM t2 WHERE b < 7;
2646
id
2647
87
2648
88
2649
SELECT id FROM t2 WHERE b < 7 /* no additional predicate */;
2650
id
2651
87
2652
88
2653
SELECT b FROM t2 WHERE id > 1;
2654
b
2655
4
2656
2
2657
SELECT id FROM t2 WHERE b < 7 AND id > -16777216;
2658
id
2659
87
2660
88
2661
SELECT b FROM t2 WHERE id > 1 /* no additional predicate */;
2662
b
2663
4
2664
2
2665
SELECT b FROM t1 WHERE id = 5;
2666
b
2667
SELECT b FROM t1 WHERE id = 5 /* no additional predicate */;
2668
b
2669
SELECT b FROM t1 WHERE id = 5 AND id > -16777216;
2670
b
2671
SELECT b FROM t2 WHERE id > 1 AND id > -16777216;
2672
b
2673
4
2674
2
2675
DELETE FROM t1 WHERE b < 4 LIMIT 7;
2676
SAVEPOINT A;
2677
DELETE FROM t2 WHERE a < 0 LIMIT 2;
2678
SELECT a FROM t1 WHERE b < 6;
2679
a
2680
START TRANSACTION;
2681
INSERT INTO t2 ( a, b ) VALUES ( 4 , 2 );
2682
SELECT a FROM t1 WHERE b < 6 /* no additional predicate */;
2683
a
2684
UPDATE t1 SET b = 5 WHERE 1 = 1 LIMIT 4;
2685
SELECT a FROM t1 WHERE b < 6 AND id > -16777216;
2686
a
2687
UPDATE t1 SET b = 3 WHERE a IN ( 1 , 2 , 4 ) LIMIT 5;
2688
UPDATE t2 SET id = 3 WHERE 1 = 1 LIMIT 6;
2689
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
2690
START TRANSACTION;
2691
DELETE FROM t1 WHERE a > 0 LIMIT 7;
2692
SELECT a FROM t1 WHERE a BETWEEN 4 and 8;
2693
a
2694
UPDATE t2 SET b = 2 WHERE 1 = 1 LIMIT 4;
2695
SELECT a FROM t1 WHERE a BETWEEN 4 and 8 /* no additional predicate */;
2696
a
2697
SELECT a FROM t1 WHERE b > 2;
2698
a
2699
SELECT a FROM t1 WHERE b > 2 /* no additional predicate */;
2700
a
2701
SELECT a FROM t1 WHERE a BETWEEN 4 and 8 AND id > -16777216;
2702
a
2703
SELECT a FROM t1 WHERE b > 2 AND id > -16777216;
2704
a
2705
INSERT INTO t1 ( a, b ) VALUES ( 9 , 8 );
2706
INSERT INTO t1 ( a, b ) VALUES ( 8 , 1 );
2707
SELECT a FROM t2 WHERE id IN ( 6 , 8 , 6 );
2708
a
2709
DELETE FROM t2 WHERE b < 3 LIMIT 2;
2710
SELECT a FROM t2 WHERE id IN ( 6 , 8 , 6 ) /* no additional predicate */;
2711
a
2712
INSERT INTO t2 ( a, b ) VALUES ( 6 , 4 );
2713
SELECT a FROM t2 WHERE id IN ( 6 , 8 , 6 ) AND id > -16777216;
2714
a
2715
START TRANSACTION;
2716
INSERT INTO t1 ( a, b ) VALUES ( 2 , 2 );
2717
SAVEPOINT A;
2718
UPDATE t1 SET id = 3 WHERE id BETWEEN 9 and 8 LIMIT 3;
2719
DELETE FROM t2 WHERE b = 0 LIMIT 4;
2720
DELETE FROM t2 WHERE id = 9 LIMIT 2;
2721
DELETE FROM t1 WHERE id < 9 LIMIT 9;
2722
DELETE FROM t2 WHERE b = 0 LIMIT 5;
2723
UPDATE t1 SET b = 0 WHERE a BETWEEN 8 and 5 LIMIT 0;
2724
DELETE FROM t2 WHERE id = 3 LIMIT 0;
2725
UPDATE t1 SET b = 1 WHERE b = 8 LIMIT 4;
2726
SELECT a FROM t1 WHERE 1 = 1;
2727
a
2728
9
2729
8
2730
2
2731
SELECT b FROM t2 WHERE b > 2;
2732
b
2733
4
2734
SELECT a FROM t1 WHERE 1 = 1 /* no additional predicate */;
2735
a
2736
9
2737
8
2738
2
2739
DELETE FROM t1 WHERE a IN ( 9 , 5 , 3 ) LIMIT 3;
2740
SELECT b FROM t2 WHERE b > 2 /* no additional predicate */;
2741
b
2742
4
2743
SELECT a FROM t1 WHERE 1 = 1 AND id > -16777216;
2744
a
2745
8
2746
2
2747
SELECT id FROM t2 WHERE b > 9;
2748
id
2749
SELECT b FROM t2 WHERE b > 2 AND id > -16777216;
2750
b
2751
4
2752
UPDATE t2 SET id = 2 WHERE a IN ( 4 , 8 , 7 ) LIMIT 1;
2753
SELECT id FROM t2 WHERE b > 9 /* no additional predicate */;
2754
id
2755
DELETE FROM t1 WHERE id = 5 LIMIT 1;
2756
SELECT id FROM t2 WHERE 1 = 1;
2757
id
2758
2
2759
90
2760
INSERT INTO t2 ( a, b ) VALUES ( 4 , 7 );
2761
SELECT id FROM t2 WHERE 1 = 1 /* no additional predicate */;
2762
id
2763
2
2764
90
2765
91
2766
SELECT id FROM t2 WHERE b > 9 AND id > -16777216;
2767
id
2768
COMMIT;
2769
SELECT id FROM t2 WHERE 1 = 1 AND id > -16777216;
2770
id
2771
2
2772
90
2773
91
2774
SELECT id FROM t1 WHERE b = 7;
2775
id
2776
SELECT id FROM t1 WHERE b = 7 /* no additional predicate */;
2777
id
2778
UPDATE t1 SET b = 8 WHERE b IN ( 0 , 5 , 9 ) LIMIT 7;
2779
UPDATE t1 SET a = 2 WHERE b BETWEEN 2 and 7 LIMIT 8;
2780
SELECT id FROM t1 WHERE b = 7 AND id > -16777216;
2781
id
2782
ROLLBACK TO SAVEPOINT A;
2783
INSERT INTO t1 ( a, b ) VALUES ( 0 , 3 );
2784
INSERT INTO t1 ( a, b ) VALUES ( 0 , 5 );
2785
SELECT b FROM t2 WHERE a > 6;
2786
b
2787
DELETE FROM t1 WHERE a < 2 LIMIT 1;
2788
SELECT b FROM t2 WHERE a > 6 /* no additional predicate */;
2789
b
2790
COMMIT;
2791
ROLLBACK TO SAVEPOINT A;
2792
SELECT b FROM t2 WHERE a > 6 AND id > -16777216;
2793
b
2794
DELETE FROM t1 WHERE id > 0 LIMIT 5;
2795
DELETE FROM t1 WHERE a BETWEEN 9 and 2 LIMIT 1;
2796
UPDATE t2 SET b = 6 WHERE a < 3 LIMIT 0;
2797
UPDATE t2 SET id = 5 WHERE 1 = 1 LIMIT 3;
2798
ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
2799
UPDATE t2 SET a = 5 WHERE 1 = 1 LIMIT 9;
2800
SELECT id FROM t2 WHERE a < 7;
2801
id
2802
2
2803
90
2804
91
2805
UPDATE t1 SET a = 9 WHERE a = 9 LIMIT 1;
2806
SAVEPOINT A;
2807
SELECT id FROM t2 WHERE a < 7 /* no additional predicate */;
2808
id
2809
2
2810
90
2811
91
2812
SELECT a FROM t1 WHERE id BETWEEN 1 and 5;
2813
a
2814
SELECT id FROM t2 WHERE a < 7 AND id > -16777216;
2815
id
2816
2
2817
90
2818
91
2819
SELECT a FROM t1 WHERE id BETWEEN 1 and 5 /* no additional predicate */;
2820
a
2821
SELECT a FROM t1 WHERE id BETWEEN 1 and 5 AND id > -16777216;
2822
a
2823
INSERT INTO t1 ( a, b ) VALUES ( 2 , 6 );
2824
INSERT INTO t2 ( a, b ) VALUES ( 3 , 6 );
2825
DELETE FROM t2 WHERE 1 = 1 LIMIT 3;
2826
SELECT b FROM t2 WHERE b = 6;
2827
b
2828
6
2829
SELECT b FROM t2 WHERE b = 6 /* no additional predicate */;
2830
b
2831
6
2832
SELECT b FROM t2 WHERE b = 6 AND id > -16777216;
2833
b
2834
6
2835
SELECT id FROM t1 WHERE id > 1;
2836
id
2837
92
2838
SELECT id FROM t1 WHERE id > 1 /* no additional predicate */;
2839
id
2840
92
2841
SELECT id FROM t1 WHERE id > 1 AND id > -16777216;
2842
id
2843
92
2844
SELECT a FROM t1 WHERE id < 8;
2845
a
2846
SELECT a FROM t1 WHERE id < 8 /* no additional predicate */;
2847
a
2848
SELECT a FROM t1 WHERE id < 8 AND id > -16777216;
2849
a
2850
UPDATE t1 SET id = 8 WHERE a IN ( 3 , 4 , 7 ) LIMIT 7;
2851
DELETE FROM t1 WHERE a > 0 LIMIT 6;
2852
DELETE FROM t2 WHERE b > 4 LIMIT 0;
2853
ROLLBACK TO SAVEPOINT A;
2854
UPDATE t2 SET a = 9 WHERE a < 3 LIMIT 5;
2855
SELECT id FROM t2 WHERE id < 6;
2856
id
2857
SELECT id FROM t2 WHERE id < 6 /* no additional predicate */;
2858
id
2859
SELECT id FROM t2 WHERE id < 6 AND id > -16777216;
2860
id
2861
DELETE FROM t1 WHERE a IN ( 6 , 8 , 0 ) LIMIT 1;
2862
DELETE FROM t2 WHERE id < 4 LIMIT 4;
2863
DELETE FROM t1 WHERE a < 5 LIMIT 2;
2864
DELETE FROM t1 WHERE b > 1 LIMIT 9;
2865
SELECT b FROM t1 WHERE a IN ( 9 , 9 , 7 );
2866
b
2867
SELECT b FROM t1 WHERE a IN ( 9 , 9 , 7 ) /* no additional predicate */;
2868
b
2869
UPDATE t1 SET id = 1 WHERE b BETWEEN 7 and 3 LIMIT 0;
2870
SELECT b FROM t1 WHERE a IN ( 9 , 9 , 7 ) AND id > -16777216;
2871
b
2872
DELETE FROM t2 WHERE a = 2 LIMIT 0;
2873
INSERT INTO t2 ( a, b ) VALUES ( 6 , 6 );
2874
DELETE FROM t2 WHERE b < 8 LIMIT 5;
2875
ROLLBACK TO SAVEPOINT A;
2876
SELECT b FROM t2 WHERE 1 = 1;
2877
b
2878
SELECT b FROM t2 WHERE 1 = 1 /* no additional predicate */;
2879
b
2880
SELECT b FROM t2 WHERE 1 = 1 AND id > -16777216;
2881
b
2882
COMMIT;
2883
INSERT INTO t1 ( a, b ) VALUES ( 5 , 2 );
2884
UPDATE t1 SET id = 2 WHERE b > 5 LIMIT 9;
2885
SELECT a FROM t1 WHERE a BETWEEN 9 and 2;
2886
a
2887
SELECT a FROM t1 WHERE a BETWEEN 9 and 2 /* no additional predicate */;
2888
a
2889
SELECT a FROM t1 WHERE a BETWEEN 9 and 2 AND id > -16777216;
2890
a
2891
DELETE FROM t1 WHERE b = 5 LIMIT 2;
2892
ROLLBACK;
2893
DELETE FROM t2 WHERE a < 1 LIMIT 2;
2894
DELETE FROM t2 WHERE b < 4 LIMIT 7;
2895
DELETE FROM t1 WHERE b IN ( 0 , 8 , 7 ) LIMIT 4;
2896
INSERT INTO t2 ( a, b ) VALUES ( 6 , 7 );
2897
SELECT b FROM t2 WHERE 1 = 1;
2898
b
2899
7
2900
DELETE FROM t2 WHERE b > 0 LIMIT 5;
2901
DELETE FROM t1 WHERE a = 6 LIMIT 8;
2902
SELECT b FROM t2 WHERE 1 = 1 /* no additional predicate */;
2903
b
2904
SELECT a FROM t1 WHERE b BETWEEN 7 and 1;
2905
a
2906
SELECT a FROM t1 WHERE b BETWEEN 7 and 1 /* no additional predicate */;
2907
a
2908
SELECT a FROM t1 WHERE b BETWEEN 7 and 1 AND id > -16777216;
2909
a
2910
SELECT b FROM t2 WHERE 1 = 1 AND id > -16777216;
2911
b
2912
SELECT a FROM t2 WHERE 1 = 1;
2913
a
2914
SELECT a FROM t2 WHERE 1 = 1 /* no additional predicate */;
2915
a
2916
DELETE FROM t2 WHERE id > 5 LIMIT 6;
2917
INSERT INTO t1 ( a, b ) VALUES ( 0 , 7 );
2918
SELECT a FROM t2 WHERE 1 = 1 AND id > -16777216;
2919
a
2920
SELECT b FROM t1 WHERE b < 1;
2921
b
2922
SELECT b FROM t1 WHERE b < 1 /* no additional predicate */;
2923
b
2924
SELECT b FROM t1 WHERE b < 1 AND id > -16777216;
2925
b
2926
COMMIT;
2927
START TRANSACTION;
2928
DELETE FROM t2 WHERE b < 1 LIMIT 9;
2929
DELETE FROM t1 WHERE id BETWEEN 2 and 7 LIMIT 5;
2930
DELETE FROM t2 WHERE a IN ( 1 , 9 , 1 ) LIMIT 9;
2931
START TRANSACTION;
2932
INSERT INTO t1 ( a, b ) VALUES ( 6 , 2 );
2933
INSERT INTO t2 ( a, b ) VALUES ( 1 , 6 );
2934
SELECT b FROM t2 WHERE id IN ( 8 , 5 , 1 );
2935
b
2936
INSERT INTO t2 ( a, b ) VALUES ( 4 , 7 );
2937
SELECT b FROM t2 WHERE id IN ( 8 , 5 , 1 ) /* no additional predicate */;
2938
b
2939
UPDATE t1 SET a = 2 WHERE id BETWEEN 8 and 3 LIMIT 6;
2940
INSERT INTO t1 ( a, b ) VALUES ( 2 , 8 );
2941
SELECT b FROM t2 WHERE id IN ( 8 , 5 , 1 ) AND id > -16777216;
2942
b
2943
DELETE FROM t2 WHERE 1 = 1 LIMIT 3;
2944
UPDATE t2 SET id = 5 WHERE id BETWEEN 1 and 2 LIMIT 5;
2945
DELETE FROM t1 WHERE b < 2 LIMIT 6;
2946
DELETE FROM t2 WHERE a > 4 LIMIT 7;
2947
SELECT a FROM t1 WHERE b IN ( 7 , 7 , 9 );
2948
a
2949
0
2950
START TRANSACTION;
2951
SELECT a FROM t1 WHERE b IN ( 7 , 7 , 9 ) /* no additional predicate */;
2952
a
2953
0
2954
SELECT id FROM t2 WHERE b = 1;
2955
id
2956
SELECT a FROM t1 WHERE b IN ( 7 , 7 , 9 ) AND id > -16777216;
2957
a
2958
0
2959
SELECT id FROM t2 WHERE b = 1 /* no additional predicate */;
2960
id
2961
SAVEPOINT A;
2962
SELECT id FROM t2 WHERE b = 1 AND id > -16777216;
2963
id
2964
UPDATE t2 SET a = 5 WHERE b = 8 LIMIT 4;
2965
UPDATE t2 SET a = 7 WHERE id BETWEEN 5 and 1 LIMIT 1;
2966
DELETE FROM t2 WHERE id < 4 LIMIT 6;
2967
DELETE FROM t2 WHERE b IN ( 9 , 3 , 2 ) LIMIT 1;
2968
UPDATE t2 SET id = 2 WHERE 1 = 1 LIMIT 0;
2969
INSERT INTO t1 ( a, b ) VALUES ( 7 , 4 );
2970
INSERT INTO t1 ( a, b ) VALUES ( 3 , 4 );
2971
SELECT b FROM t2 WHERE b = 3;
2972
b
2973
UPDATE t2 SET b = 7 WHERE a IN ( 0 , 3 , 5 ) LIMIT 6;
2974
INSERT INTO t2 ( a, b ) VALUES ( 1 , 4 );
2975
SELECT b FROM t2 WHERE b = 3 /* no additional predicate */;
2976
b
2977
INSERT INTO t2 ( a, b ) VALUES ( 4 , 9 );
2978
UPDATE t2 SET id = 3 WHERE a < 3 LIMIT 1;
2979
UPDATE t2 SET id = 6 WHERE id = 6 LIMIT 2;
2980
SELECT b FROM t2 WHERE b = 3 AND id > -16777216;
2981
b
2982
ROLLBACK TO SAVEPOINT A;
2983
DELETE FROM t1 WHERE id = 3 LIMIT 6;
2984
COMMIT;
2985
INSERT INTO t1 ( a, b ) VALUES ( 1 , 7 );
2986
COMMIT;
2987
INSERT INTO t1 ( a, b ) VALUES ( 3 , 5 );
2988
SELECT b FROM t1 WHERE b IN ( 4 , 7 , 7 );
2989
b
2990
7
2991
4
2992
4
2993
7
2994
SELECT b FROM t1 WHERE b IN ( 4 , 7 , 7 ) /* no additional predicate */;
2995
b
2996
7
2997
4
2998
4
2999
7
3000
UPDATE t1 SET a = 1 WHERE 1 = 1 LIMIT 5;
3001
SELECT b FROM t1 WHERE b IN ( 4 , 7 , 7 ) AND id > -16777216;
3002
b
3003
7
3004
4
3005
4
3006
7
3007
INSERT INTO t2 ( a, b ) VALUES ( 4 , 4 );
3008
DELETE FROM t1 WHERE a IN ( 3 , 2 , 4 ) LIMIT 8;
3009
SAVEPOINT A;
3010
UPDATE t2 SET a = 5 WHERE id < 9 LIMIT 2;
3011
COMMIT;
3012
SELECT id FROM t1 WHERE a IN ( 0 , 5 , 3 );
3013
id
3014
COMMIT;
3015
SELECT id FROM t1 WHERE a IN ( 0 , 5 , 3 ) /* no additional predicate */;
3016
id
3017
INSERT INTO t1 ( a, b ) VALUES ( 7 , 1 );
3018
SELECT id FROM t1 WHERE a IN ( 0 , 5 , 3 ) AND id > -16777216;
3019
id
3020
SELECT b FROM t2 WHERE a > 7;
3021
b
3022
SELECT b FROM t2 WHERE a > 7 /* no additional predicate */;
3023
b
3024
SELECT b FROM t2 WHERE a > 7 AND id > -16777216;
3025
b
3026
INSERT INTO t1 ( a, b ) VALUES ( 7 , 4 );
3027
DELETE FROM t2 WHERE id IN ( 3 , 0 , 8 ) LIMIT 9;
3028
COMMIT;
3029
INSERT INTO t1 ( a, b ) VALUES ( 9 , 1 );
3030
ROLLBACK TO SAVEPOINT A;
3031
INSERT INTO t1 ( a, b ) VALUES ( 4 , 7 );
3032
SAVEPOINT A;
3033
SELECT a FROM t1 WHERE a IN ( 4 , 4 , 2 );
3034
a
3035
4
3036
SELECT a FROM t1 WHERE a IN ( 4 , 4 , 2 ) /* no additional predicate */;
3037
a
3038
4
3039
SELECT a FROM t1 WHERE a IN ( 4 , 4 , 2 ) AND id > -16777216;
3040
a
3041
4
3042
DELETE FROM t1 WHERE id = 1 LIMIT 5;
3043
INSERT INTO t2 ( a, b ) VALUES ( 5 , 3 );
3044
UPDATE t1 SET b = 8 WHERE a BETWEEN 9 and 9 LIMIT 5;
3045
START TRANSACTION;
3046
DELETE FROM t1 WHERE b BETWEEN 2 and 3 LIMIT 7;
3047
DELETE FROM t2 WHERE b BETWEEN 7 and 1 LIMIT 6;
3048
SELECT a FROM t1 WHERE id > 4;
3049
a
3050
1
3051
1
3052
1
3053
1
3054
7
3055
7
3056
9
3057
4
3058
SELECT id FROM t1 WHERE id < 3;
3059
id
3060
SELECT a FROM t1 WHERE id > 4 /* no additional predicate */;
3061
a
3062
1
3063
1
3064
1
3065
1
3066
7
3067
7
3068
9
3069
4
3070
SELECT id FROM t1 WHERE id < 3 /* no additional predicate */;
3071
id
3072
SELECT a FROM t1 WHERE id > 4 AND id > -16777216;
3073
a
3074
1
3075
1
3076
1
3077
1
3078
7
3079
7
3080
9
3081
4
3082
SELECT id FROM t1 WHERE id < 3 AND id > -16777216;
3083
id
3084
UPDATE t1 SET b = 2 WHERE id IN ( 2 , 0 , 9 ) LIMIT 2;
3085
UPDATE t2 SET id = 8 WHERE id IN ( 0 , 8 , 7 ) LIMIT 4;
3086
DELETE FROM t2 WHERE id BETWEEN 3 and 5 LIMIT 4;
3087
INSERT INTO t2 ( a, b ) VALUES ( 1 , 4 );
3088
SELECT id FROM t2 WHERE a BETWEEN 7 and 6;
3089
id
3090
START TRANSACTION;
3091
SELECT id FROM t2 WHERE a BETWEEN 7 and 6 /* no additional predicate */;
3092
id
3093
DELETE FROM t2 WHERE id IN ( 5 , 2 , 5 ) LIMIT 0;
3094
SELECT id FROM t2 WHERE a BETWEEN 7 and 6 AND id > -16777216;
3095
id
3096
UPDATE t1 SET id = 3 WHERE id = 0 LIMIT 0;
3097
INSERT INTO t1 ( a, b ) VALUES ( 3 , 1 );
3098
INSERT INTO t1 ( a, b ) VALUES ( 5 , 5 );
3099
SELECT id FROM t2 WHERE id IN ( 8 , 2 , 7 );
3100
id
3101
SELECT id FROM t2 WHERE id IN ( 8 , 2 , 7 ) /* no additional predicate */;
3102
id
3103
DELETE FROM t2 WHERE a = 4 LIMIT 7;
3104
SELECT id FROM t2 WHERE id IN ( 8 , 2 , 7 ) AND id > -16777216;
3105
id
3106
UPDATE t2 SET id = 7 WHERE 1 = 1 LIMIT 6;
3107
ERROR 23000: Duplicate entry '7' for key 'PRIMARY'
3108
DELETE FROM t1 WHERE id > 7 LIMIT 8;
3109
SELECT b FROM t1 WHERE b < 3;
3110
b
3111
1
3112
SELECT b FROM t1 WHERE b < 3 /* no additional predicate */;
3113
b
3114
1
3115
SELECT b FROM t1 WHERE b < 3 AND id > -16777216;
3116
b
3117
1
3118
SELECT id FROM t2 WHERE id < 8;
3119
id
3120
SELECT id FROM t2 WHERE id < 8 /* no additional predicate */;
3121
id
3122
SELECT id FROM t2 WHERE id < 8 AND id > -16777216;
3123
id
3124
UPDATE t2 SET a = 8 WHERE b BETWEEN 4 and 9 LIMIT 5;
3125
SELECT a FROM t2 WHERE b IN ( 9 , 5 , 4 );
3126
a
3127
8
3128
SELECT a FROM t2 WHERE b IN ( 9 , 5 , 4 ) /* no additional predicate */;
3129
a
3130
8
3131
SELECT a FROM t2 WHERE b IN ( 9 , 5 , 4 ) AND id > -16777216;
3132
a
3133
8
3134
INSERT INTO t1 ( a, b ) VALUES ( 7 , 1 );
3135
UPDATE t2 SET b = 2 WHERE 1 = 1 LIMIT 8;
3136
COMMIT;
3137
SELECT id FROM t1 WHERE b BETWEEN 0 and 2;
3138
id
3139
105
3140
107
3141
SELECT id FROM t1 WHERE b BETWEEN 0 and 2 /* no additional predicate */;
3142
id
3143
105
3144
107
3145
SELECT id FROM t1 WHERE b BETWEEN 0 and 2 AND id > -16777216;
3146
id
3147
105
3148
107
3149
DELETE FROM t2 WHERE id > 6 LIMIT 2;
3150
DELETE FROM t2 WHERE id > 0 LIMIT 9;
3151
UPDATE t2 SET b = 2 WHERE id < 7 LIMIT 6;
3152
DELETE FROM t2 WHERE id BETWEEN 0 and 9 LIMIT 2;
3153
UPDATE t1 SET b = 2 WHERE 1 = 1 LIMIT 7;
3154
ROLLBACK;
3155
DELETE FROM t2 WHERE a IN ( 5 , 5 , 7 ) LIMIT 7;
3156
SELECT a FROM t1 WHERE id < 5;
3157
a
3158
SELECT a FROM t2 WHERE b BETWEEN 1 and 6;
3159
a
3160
START TRANSACTION;
3161
SELECT a FROM t1 WHERE id < 5 /* no additional predicate */;
3162
a
3163
SELECT a FROM t2 WHERE b BETWEEN 1 and 6 /* no additional predicate */;
3164
a
3165
SELECT a FROM t1 WHERE id < 5 AND id > -16777216;
3166
a
3167
INSERT INTO t2 ( a, b ) VALUES ( 3 , 5 );
3168
SELECT a FROM t2 WHERE b BETWEEN 1 and 6 AND id > -16777216;
3169
a
3170
3
3171
UPDATE t1 SET b = 3 WHERE a = 7 LIMIT 1;
3172
SELECT id FROM t2 WHERE 1 = 1;
3173
id
3174
102
3175
SELECT id FROM t2 WHERE 1 = 1 /* no additional predicate */;
3176
id
3177
102
3178
SELECT id FROM t2 WHERE 1 = 1 AND id > -16777216;
3179
id
3180
102
3181
SELECT id FROM t2 WHERE id IN ( 1 , 0 , 3 );
3182
id
3183
SELECT id FROM t2 WHERE id IN ( 1 , 0 , 3 ) /* no additional predicate */;
3184
id
3185
SELECT id FROM t2 WHERE id IN ( 1 , 0 , 3 ) AND id > -16777216;
3186
id
3187
SELECT b FROM t1 WHERE b = 5;
3188
b
3189
SELECT b FROM t1 WHERE b = 5 /* no additional predicate */;
3190
b
3191
SELECT b FROM t1 WHERE b = 5 AND id > -16777216;
3192
b
3193
SELECT id FROM t2 WHERE id > 3;
3194
id
3195
102
3196
SELECT id FROM t2 WHERE id > 3 /* no additional predicate */;
3197
id
3198
102
3199
SELECT id FROM t2 WHERE id > 3 AND id > -16777216;
3200
id
3201
102
3202
DELETE FROM t1 WHERE b > 6 LIMIT 4;
3203
SELECT id FROM t2 WHERE 1 = 1;
3204
id
3205
102
3206
SELECT id FROM t2 WHERE 1 = 1 /* no additional predicate */;
3207
id
3208
102
3209
SELECT id FROM t2 WHERE 1 = 1 AND id > -16777216;
3210
id
3211
102
3212
ROLLBACK TO SAVEPOINT A;
3213
SELECT a FROM t1 WHERE b BETWEEN 0 and 8;
3214
a
3215
3
3216
5
3217
7
3218
SELECT a FROM t1 WHERE b BETWEEN 0 and 8 /* no additional predicate */;
3219
a
3220
3
3221
5
3222
7
3223
SELECT a FROM t1 WHERE b BETWEEN 0 and 8 AND id > -16777216;
3224
a
3225
3
3226
5
3227
7
3228
UPDATE t1 SET id = 3 WHERE b IN ( 5 , 4 , 0 ) LIMIT 3;
3229
DELETE FROM t1 WHERE id < 7 LIMIT 3;
3230
SELECT id FROM t2 WHERE id BETWEEN 6 and 1;
3231
id
3232
SELECT id FROM t2 WHERE id BETWEEN 6 and 1 /* no additional predicate */;
3233
id
3234
SELECT id FROM t2 WHERE id BETWEEN 6 and 1 AND id > -16777216;
3235
id
3236
SAVEPOINT A;
3237
INSERT INTO t1 ( a, b ) VALUES ( 3 , 5 );
3238
DELETE FROM t1 WHERE id IN ( 1 , 7 , 4 ) LIMIT 7;
3239
INSERT INTO t1 ( a, b ) VALUES ( 7 , 2 );
3240
SELECT b FROM t1 WHERE b BETWEEN 4 and 9;
3241
b
3242
5
3243
SELECT b FROM t1 WHERE b BETWEEN 4 and 9 /* no additional predicate */;
3244
b
3245
5
3246
SELECT b FROM t1 WHERE b BETWEEN 4 and 9 AND id > -16777216;
3247
b
3248
5
3249
SELECT b FROM t2 WHERE 1 = 1;
3250
b
3251
5
3252
SELECT b FROM t2 WHERE 1 = 1 /* no additional predicate */;
3253
b
3254
5
3255
SELECT b FROM t2 WHERE 1 = 1 AND id > -16777216;
3256
b
3257
5
3258
SELECT b FROM t2 WHERE id IN ( 2 , 7 , 8 );
3259
b
3260
SELECT b FROM t2 WHERE id IN ( 2 , 7 , 8 ) /* no additional predicate */;
3261
b
3262
SELECT b FROM t2 WHERE id IN ( 2 , 7 , 8 ) AND id > -16777216;
3263
b
3264
INSERT INTO t2 ( a, b ) VALUES ( 9 , 2 );
3265
UPDATE t1 SET id = 9 WHERE a BETWEEN 6 and 2 LIMIT 0;
3266
DELETE FROM t1 WHERE id < 6 LIMIT 8;
3267
ROLLBACK;
3268
DELETE FROM t1 WHERE id BETWEEN 3 and 5 LIMIT 9;
3269
UPDATE t1 SET b = 1 WHERE b BETWEEN 3 and 4 LIMIT 1;
3270
ROLLBACK TO SAVEPOINT A;
3271
INSERT INTO t2 ( a, b ) VALUES ( 8 , 3 );
3272
DELETE FROM t1 WHERE b < 2 LIMIT 9;
3273
DELETE FROM t2 WHERE 1 = 1 LIMIT 7;
3274
UPDATE t1 SET a = 3 WHERE id < 2 LIMIT 1;
3275
DELETE FROM t2 WHERE 1 = 1 LIMIT 2;
3276
UPDATE t1 SET a = 1 WHERE b > 0 LIMIT 1;
3277
SELECT a FROM t1 WHERE b = 8;
3278
a
3279
UPDATE t2 SET id = 1 WHERE id = 8 LIMIT 4;
3280
INSERT INTO t1 ( a, b ) VALUES ( 5 , 8 );
3281
SELECT a FROM t1 WHERE b = 8 /* no additional predicate */;
3282
a
3283
5
3284
SELECT a FROM t1 WHERE b = 8 AND id > -16777216;
3285
a
3286
5
3287
INSERT INTO t1 ( a, b ) VALUES ( 4 , 3 );
3288
ROLLBACK;
3289
UPDATE t1 SET b = 8 WHERE b < 3 LIMIT 6;
3290
INSERT INTO t1 ( a, b ) VALUES ( 9 , 6 );
3291
SELECT a FROM t2 WHERE 1 = 1;
3292
a
3293
SELECT id FROM t2 WHERE 1 = 1;
3294
id
3295
SELECT a FROM t2 WHERE 1 = 1 /* no additional predicate */;
3296
a
3297
SELECT id FROM t2 WHERE 1 = 1 /* no additional predicate */;
3298
id
3299
SELECT a FROM t2 WHERE 1 = 1 AND id > -16777216;
3300
a
3301
SELECT id FROM t2 WHERE 1 = 1 AND id > -16777216;
3302
id
3303
SAVEPOINT A;
3304
DELETE FROM t1 WHERE b = 4 LIMIT 4;
3305
DELETE FROM t1 WHERE b > 8 LIMIT 7;
3306
UPDATE t1 SET b = 9 WHERE a > 1 LIMIT 7;
3307
INSERT INTO t2 ( a, b ) VALUES ( 2 , 4 );
3308
INSERT INTO t2 ( a, b ) VALUES ( 1 , 9 );
3309
INSERT INTO t1 ( a, b ) VALUES ( 1 , 8 );
3310
UPDATE t1 SET id = 0 WHERE 1 = 1 LIMIT 6;
3311
ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
3312
UPDATE t2 SET a = 4 WHERE a IN ( 0 , 6 , 5 ) LIMIT 5;
3313
INSERT INTO t1 ( a, b ) VALUES ( 6 , 9 );
3314
INSERT INTO t2 ( a, b ) VALUES ( 4 , 8 );
3315
INSERT INTO t2 ( a, b ) VALUES ( 2 , 6 );
3316
SELECT b FROM t2 WHERE b > 8;
3317
b
3318
9
3319
INSERT INTO t1 ( a, b ) VALUES ( 0 , 8 );
3320
SAVEPOINT A;
3321
SELECT b FROM t2 WHERE b > 8 /* no additional predicate */;
3322
b
3323
9
3324
UPDATE t2 SET a = 0 WHERE a BETWEEN 1 and 0 LIMIT 2;
3325
ROLLBACK TO SAVEPOINT A;
3326
SELECT b FROM t2 WHERE b > 8 AND id > -16777216;
3327
b
3328
9
3329
DELETE FROM t2 WHERE b IN ( 2 , 9 , 2 ) LIMIT 0;
3330
INSERT INTO t2 ( a, b ) VALUES ( 7 , 0 );
3331
SAVEPOINT A;
3332
UPDATE t1 SET a = 9 WHERE id > 1 LIMIT 6;
3333
DELETE FROM t1 WHERE id > 1 LIMIT 6;
3334
SELECT b FROM t2 WHERE 1 = 1;
3335
b
3336
4
3337
9
3338
8
3339
6
3340
0
3341
DELETE FROM t1 WHERE a < 2 LIMIT 0;
3342
SELECT b FROM t2 WHERE 1 = 1 /* no additional predicate */;
3343
b
3344
4
3345
9
3346
8
3347
6
3348
0
3349
SELECT b FROM t2 WHERE 1 = 1 AND id > -16777216;
3350
b
3351
4
3352
9
3353
8
3354
6
3355
0
3356
INSERT INTO t2 ( a, b ) VALUES ( 7 , 1 );
3357
START TRANSACTION;
3358
DELETE FROM t2 WHERE a IN ( 3 , 7 , 0 ) LIMIT 7;
3359
DELETE FROM t1 WHERE b IN ( 0 , 7 , 0 ) LIMIT 1;
3360
DELETE FROM t2 WHERE a IN ( 5 , 7 , 7 ) LIMIT 4;
3361
ROLLBACK TO SAVEPOINT A;
3362
DELETE FROM t1 WHERE b < 2 LIMIT 8;
3363
DELETE FROM t2 WHERE a = 2 LIMIT 3;
3364
SAVEPOINT A;
3365
UPDATE t2 SET b = 1 WHERE id IN ( 3 , 4 , 8 ) LIMIT 4;
3366
ROLLBACK TO SAVEPOINT A;
3367
START TRANSACTION;
3368
INSERT INTO t1 ( a, b ) VALUES ( 4 , 5 );
3369
SELECT b FROM t2 WHERE id = 8;
3370
b
3371
SELECT b FROM t2 WHERE id = 8 /* no additional predicate */;
3372
b
3373
UPDATE t2 SET a = 7 WHERE b IN ( 6 , 3 , 0 ) LIMIT 7;
3374
SELECT b FROM t2 WHERE id = 8 AND id > -16777216;
3375
b
3376
DELETE FROM t2 WHERE b = 5 LIMIT 3;
3377
DELETE FROM t1 WHERE 1 = 1 LIMIT 6;
3378
INSERT INTO t1 ( a, b ) VALUES ( 4 , 4 );
3379
UPDATE t2 SET id = 8 WHERE b IN ( 3 , 6 , 7 ) LIMIT 3;
3380
SELECT b FROM t2 WHERE a > 6;
3381
b
3382
START TRANSACTION;
3383
UPDATE t2 SET b = 5 WHERE b IN ( 1 , 4 , 5 ) LIMIT 4;
3384
COMMIT;
3385
START TRANSACTION;
3386
INSERT INTO t1 ( a, b ) VALUES ( 8 , 6 );
3387
DELETE FROM t1 WHERE a > 5 LIMIT 5;
3388
SELECT b FROM t1 WHERE id = 0;
3389
b
3390
DELETE FROM t2 WHERE b > 9 LIMIT 1;
3391
ROLLBACK TO SAVEPOINT A;
3392
SELECT b FROM t1 WHERE id = 0 /* no additional predicate */;
3393
b
3394
SELECT b FROM t2 WHERE a > 6 /* no additional predicate */;
3395
b
3396
INSERT INTO t2 ( a, b ) VALUES ( 9 , 6 );
3397
INSERT INTO t2 ( a, b ) VALUES ( 4 , 4 );
3398
SELECT b FROM t1 WHERE id = 0 AND id > -16777216;
3399
b
3400
ROLLBACK TO SAVEPOINT A;
3401
START TRANSACTION;
3402
INSERT INTO t1 ( a, b ) VALUES ( 4 , 7 );
3403
SELECT b FROM t2 WHERE a > 6 AND id > -16777216;
3404
b
3405
6
3406
UPDATE t2 SET a = 0 WHERE id BETWEEN 7 and 2 LIMIT 0;
3407
UPDATE t2 SET id = 3 WHERE b IN ( 0 , 2 , 6 ) LIMIT 6;
3408
DELETE FROM t2 WHERE id IN ( 2 , 1 , 6 ) LIMIT 4;
3409
DELETE FROM t1 WHERE id IN ( 0 , 1 , 7 ) LIMIT 8;
3410
SELECT a FROM t1 WHERE b IN ( 0 , 0 , 3 );
3411
a
3412
INSERT INTO t1 ( a, b ) VALUES ( 4 , 8 );
3413
SAVEPOINT A;
3414
INSERT INTO t2 ( a, b ) VALUES ( 7 , 1 );
3415
SELECT a FROM t1 WHERE b IN ( 0 , 0 , 3 ) /* no additional predicate */;
3416
a
3417
ROLLBACK;
3418
SELECT id FROM t2 WHERE b < 0;
3419
id
3420
SELECT a FROM t1 WHERE b IN ( 0 , 0 , 3 ) AND id > -16777216;
3421
a
3422
SELECT b FROM t1 WHERE id > 6;
3423
b
3424
4
3425
7
3426
8
3427
DELETE FROM t1 WHERE 1 = 1 LIMIT 0;
3428
SELECT id FROM t2 WHERE b < 0 /* no additional predicate */;
3429
id
3430
SELECT b FROM t1 WHERE id > 6 /* no additional predicate */;
3431
b
3432
4
3433
7
3434
8
3435
SELECT id FROM t2 WHERE b < 0 AND id > -16777216;
3436
id
3437
SELECT b FROM t1 WHERE id > 6 AND id > -16777216;
3438
b
3439
4
3440
7
3441
8
3442
INSERT INTO t2 ( a, b ) VALUES ( 6 , 4 );
3443
UPDATE t2 SET a = 7 WHERE id IN ( 4 , 3 , 0 ) LIMIT 8;
3444
INSERT INTO t2 ( a, b ) VALUES ( 8 , 8 );
3445
UPDATE t1 SET a = 9 WHERE b > 0 LIMIT 2;
3446
UPDATE t2 SET b = 8 WHERE a > 5 LIMIT 8;
3447
UPDATE t2 SET id = 4 WHERE a BETWEEN 6 and 4 LIMIT 7;
3448
ROLLBACK;
3449
ROLLBACK;
3450
DELETE FROM t2 WHERE a = 3 LIMIT 3;
3451
UPDATE t1 SET id = 4 WHERE id = 3 LIMIT 4;
3452
DELETE FROM t1 WHERE a > 9 LIMIT 8;
3453
DELETE FROM t2 WHERE b IN ( 5 , 7 , 6 ) LIMIT 7;
3454
INSERT INTO t1 ( a, b ) VALUES ( 8 , 5 );
3455
INSERT INTO t1 ( a, b ) VALUES ( 7 , 6 );
3456
INSERT INTO t1 ( a, b ) VALUES ( 5 , 8 );
3457
SELECT b FROM t2 WHERE id > 2;
3458
b
3459
8
3460
9
3461
8
3462
4
3463
8
3464
8
3465
8
3466
DELETE FROM t1 WHERE a IN ( 5 , 3 , 1 ) LIMIT 2;
3467
SELECT b FROM t2 WHERE id > 2 /* no additional predicate */;
3468
b
3469
8
3470
9
3471
8
3472
4
3473
8
3474
8
3475
8
3476
UPDATE t1 SET a = 2 WHERE 1 = 1 LIMIT 5;
3477
DELETE FROM t1 WHERE id < 6 LIMIT 5;
3478
SELECT b FROM t2 WHERE id > 2 AND id > -16777216;
3479
b
3480
8
3481
9
3482
8
3483
4
3484
8
3485
8
3486
8
3487
DELETE FROM t2 WHERE a < 8 LIMIT 6;
3488
DELETE FROM t2 WHERE a > 5 LIMIT 6;
3489
UPDATE t2 SET b = 6 WHERE b < 4 LIMIT 0;
3490
ROLLBACK TO SAVEPOINT A;
3491
START TRANSACTION;
3492
SAVEPOINT A;
3493
UPDATE t1 SET a = 4 WHERE b > 4 LIMIT 9;
3494
UPDATE t2 SET id = 0 WHERE a BETWEEN 7 and 7 LIMIT 8;
3495
UPDATE t2 SET b = 5 WHERE id = 7 LIMIT 5;
3496
INSERT INTO t1 ( a, b ) VALUES ( 4 , 1 );
3497
UPDATE t1 SET b = 6 WHERE id BETWEEN 0 and 2 LIMIT 4;
3498
DELETE FROM t1 WHERE a IN ( 9 , 0 , 1 ) LIMIT 6;
3499
DELETE FROM t2 WHERE id IN ( 4 , 5 , 0 ) LIMIT 5;
3500
SELECT id FROM t1 WHERE a = 7;
3501
id
3502
ROLLBACK;
3503
COMMIT;
3504
SELECT id FROM t1 WHERE a = 7 /* no additional predicate */;
3505
id
3506
SELECT id FROM t1 WHERE a = 7 AND id > -16777216;
3507
id
3508
UPDATE t2 SET id = 1 WHERE 1 = 1 LIMIT 5;
3509
INSERT INTO t2 ( a, b ) VALUES ( 6 , 6 );
3510
DELETE FROM t1 WHERE a = 8 LIMIT 8;
3511
SELECT id FROM t2 WHERE b BETWEEN 3 and 2;
3512
id
3513
SELECT id FROM t2 WHERE b BETWEEN 3 and 2 /* no additional predicate */;
3514
id
3515
SELECT id FROM t2 WHERE b BETWEEN 3 and 2 AND id > -16777216;
3516
id
3517
UPDATE t2 SET b = 9 WHERE a BETWEEN 2 and 6 LIMIT 3;
3518
UPDATE t2 SET b = 2 WHERE a = 8 LIMIT 4;
3519
UPDATE t1 SET a = 5 WHERE b IN ( 0 , 7 , 8 ) LIMIT 8;
3520
ROLLBACK TO SAVEPOINT A;
3521
INSERT INTO t2 ( a, b ) VALUES ( 4 , 5 );
3522
ROLLBACK TO SAVEPOINT A;
3523
UPDATE t2 SET b = 6 WHERE a IN ( 0 , 8 , 0 ) LIMIT 5;
3524
UPDATE t1 SET id = 8 WHERE id < 2 LIMIT 9;
3525
UPDATE t1 SET a = 1 WHERE b > 2 LIMIT 8;
3526
DELETE FROM t2 WHERE a IN ( 9 , 7 , 6 ) LIMIT 1;
3527
UPDATE t1 SET b = 7 WHERE b > 6 LIMIT 9;
3528
UPDATE t1 SET b = 0 WHERE 1 = 1 LIMIT 0;
3529
ROLLBACK;
3530
SAVEPOINT A;
3531
DELETE FROM t2 WHERE a = 9 LIMIT 1;
3532
SELECT id FROM t1 WHERE a BETWEEN 9 and 7;
3533
id
3534
SELECT id FROM t1 WHERE a BETWEEN 9 and 7 /* no additional predicate */;
3535
id
3536
UPDATE t1 SET a = 3 WHERE a = 0 LIMIT 6;
3537
SELECT id FROM t1 WHERE a BETWEEN 9 and 7 AND id > -16777216;
3538
id
3539
SELECT a FROM t1 WHERE id = 5;
3540
a
3541
INSERT INTO t2 ( a, b ) VALUES ( 6 , 3 );
3542
SELECT a FROM t1 WHERE id = 5 /* no additional predicate */;
3543
a
3544
SELECT a FROM t1 WHERE id = 5 AND id > -16777216;
3545
a
3546
INSERT INTO t1 ( a, b ) VALUES ( 9 , 3 );
3547
UPDATE t2 SET id = 4 WHERE b = 6 LIMIT 6;
3548
SELECT b FROM t2 WHERE id < 9;
3549
b
3550
SELECT b FROM t2 WHERE id < 9 /* no additional predicate */;
3551
b
3552
DELETE FROM t2 WHERE a < 3 LIMIT 7;
3553
SELECT b FROM t2 WHERE id < 9 AND id > -16777216;
3554
b
3555
ROLLBACK TO SAVEPOINT A;
3556
ROLLBACK TO SAVEPOINT A;
3557
DELETE FROM t2 WHERE id > 5 LIMIT 7;
3558
UPDATE t1 SET id = 6 WHERE id = 6 LIMIT 3;
3559
ROLLBACK;
3560
INSERT INTO t2 ( a, b ) VALUES ( 6 , 5 );
3561
INSERT INTO t1 ( a, b ) VALUES ( 7 , 8 );
3562
INSERT INTO t2 ( a, b ) VALUES ( 5 , 9 );
3563
INSERT INTO t2 ( a, b ) VALUES ( 4 , 0 );
3564
INSERT INTO t1 ( a, b ) VALUES ( 0 , 8 );
3565
INSERT INTO t1 ( a, b ) VALUES ( 9 , 0 );
3566
UPDATE t2 SET id = 9 WHERE b BETWEEN 9 and 7 LIMIT 7;
3567
SELECT id FROM t1 WHERE b = 0;
3568
id
3569
128
3570
SELECT id FROM t1 WHERE b = 0 /* no additional predicate */;
3571
id
3572
128
3573
DELETE FROM t1 WHERE 1 = 1 LIMIT 7;
3574
DELETE FROM t1 WHERE b < 5 LIMIT 4;
3575
SELECT id FROM t1 WHERE b = 0 AND id > -16777216;
3576
id
3577
DELETE FROM t2 WHERE id BETWEEN 8 and 5 LIMIT 6;
3578
UPDATE t2 SET b = 1 WHERE a = 6 LIMIT 0;
3579
ROLLBACK;
3580
SELECT a FROM t1 WHERE b IN ( 6 , 0 , 5 );
3581
a
3582
SELECT a FROM t2 WHERE a IN ( 1 , 6 , 4 );
3583
a
3584
4
3585
6
3586
SELECT a FROM t1 WHERE b IN ( 6 , 0 , 5 ) /* no additional predicate */;
3587
a
3588
SELECT a FROM t2 WHERE a IN ( 1 , 6 , 4 ) /* no additional predicate */;
3589
a
3590
4
3591
6
3592
SELECT a FROM t1 WHERE b IN ( 6 , 0 , 5 ) AND id > -16777216;
3593
a
3594
SELECT a FROM t2 WHERE a IN ( 1 , 6 , 4 ) AND id > -16777216;
3595
a
3596
4
3597
6
3598
UPDATE t1 SET id = 5 WHERE a IN ( 1 , 0 , 9 ) LIMIT 8;
3599
INSERT INTO t2 ( a, b ) VALUES ( 3 , 0 );
3600
DELETE FROM t2 WHERE b BETWEEN 0 and 0 LIMIT 0;
3601
INSERT INTO t2 ( a, b ) VALUES ( 5 , 5 );
3602
SELECT b FROM t1 WHERE a = 6;
3603
b
3604
DELETE FROM t2 WHERE a = 6 LIMIT 1;
3605
SELECT b FROM t1 WHERE a = 6 /* no additional predicate */;
3606
b
3607
SELECT b FROM t1 WHERE a = 6 AND id > -16777216;
3608
b
3609
UPDATE t2 SET a = 8 WHERE id > 5 LIMIT 5;
3610
DELETE FROM t1 WHERE 1 = 1 LIMIT 6;
3611
SELECT b FROM t2 WHERE id = 8;
3612
b
3613
SELECT b FROM t2 WHERE id = 8 /* no additional predicate */;
3614
b
3615
INSERT INTO t1 ( a, b ) VALUES ( 1 , 2 );
3616
SELECT b FROM t2 WHERE id = 8 AND id > -16777216;
3617
b
3618
DELETE FROM t1 WHERE id > 4 LIMIT 9;
3619
ROLLBACK TO SAVEPOINT A;
3620
SELECT b FROM t1 WHERE a > 0;
3621
b
3622
SELECT b FROM t1 WHERE a > 0 /* no additional predicate */;
3623
b
3624
SELECT b FROM t1 WHERE a > 0 AND id > -16777216;
3625
b
3626
SELECT a FROM t1 WHERE b > 8;
3627
a
3628
SELECT a FROM t1 WHERE b > 8 /* no additional predicate */;
3629
a
3630
COMMIT;
3631
COMMIT;
3632
SELECT a FROM t1 WHERE b > 8 AND id > -16777216;
3633
a
3634
SELECT b FROM t2 WHERE b > 1;
3635
b
3636
9
3637
5
3638
SELECT b FROM t2 WHERE b > 1 /* no additional predicate */;
3639
b
3640
9
3641
5
3642
DELETE FROM t2 WHERE b BETWEEN 3 and 3 LIMIT 9;
3643
DELETE FROM t1 WHERE b < 9 LIMIT 1;
3644
DELETE FROM t1 WHERE b IN ( 5 , 4 , 9 ) LIMIT 2;
3645
SELECT b FROM t2 WHERE b > 1 AND id > -16777216;
3646
b
3647
9
3648
5
3649
DELETE FROM t1 WHERE a < 1 LIMIT 4;
3650
UPDATE t2 SET id = 8 WHERE id IN ( 5 , 3 , 2 ) LIMIT 7;
3651
UPDATE t2 SET a = 0 WHERE b BETWEEN 7 and 2 LIMIT 9;
3652
INSERT INTO t2 ( a, b ) VALUES ( 5 , 7 );
3653
SELECT id FROM t1 WHERE a > 9;
3654
id
3655
DELETE FROM t2 WHERE b > 7 LIMIT 6;
3656
SELECT id FROM t1 WHERE a > 9 /* no additional predicate */;
3657
id
3658
DELETE FROM t2 WHERE b IN ( 0 , 7 , 5 ) LIMIT 6;
3659
SELECT a FROM t1 WHERE b < 9;
3660
a
3661
SELECT id FROM t1 WHERE a > 9 AND id > -16777216;
3662
id
3663
ROLLBACK;
3664
SELECT a FROM t1 WHERE b < 9 /* no additional predicate */;
3665
a
3666
SELECT a FROM t1 WHERE b < 9 AND id > -16777216;
3667
a
3668
INSERT INTO t1 ( a, b ) VALUES ( 1 , 1 );
3669
DELETE FROM t2 WHERE id > 0 LIMIT 7;
3670
SELECT a FROM t1 WHERE a < 4;
3671
a
3672
1
3673
SELECT a FROM t1 WHERE a < 4 /* no additional predicate */;
3674
a
3675
1
3676
SELECT a FROM t1 WHERE a < 4 AND id > -16777216;
3677
a
3678
1
3679
SAVEPOINT A;
3680
DELETE FROM t1 WHERE a = 3 LIMIT 2;
3681
ROLLBACK;
3682
UPDATE t1 SET id = 7 WHERE a > 8 LIMIT 1;
3683
UPDATE t2 SET id = 8 WHERE id < 6 LIMIT 9;
3684
ROLLBACK;
3685
INSERT INTO t2 ( a, b ) VALUES ( 0 , 7 );
3686
UPDATE t2 SET b = 7 WHERE a IN ( 9 , 7 , 5 ) LIMIT 8;
3687
SELECT id FROM t1 WHERE b BETWEEN 3 and 7;
3688
id
3689
SELECT id FROM t1 WHERE b BETWEEN 3 and 7 /* no additional predicate */;
3690
id
3691
SELECT id FROM t1 WHERE b BETWEEN 3 and 7 AND id > -16777216;
3692
id
3693
INSERT INTO t1 ( a, b ) VALUES ( 4 , 4 );
3694
SELECT a FROM t2 WHERE 1 = 1;
3695
a
3696
0
3697
SELECT a FROM t2 WHERE 1 = 1 /* no additional predicate */;
3698
a
3699
0
3700
SELECT a FROM t2 WHERE 1 = 1 AND id > -16777216;
3701
a
3702
0
3703
SELECT a FROM t2 WHERE a BETWEEN 0 and 4;
3704
a
3705
0
3706
SELECT a FROM t2 WHERE a BETWEEN 0 and 4 /* no additional predicate */;
3707
a
3708
0
3709
SELECT a FROM t2 WHERE a BETWEEN 0 and 4 AND id > -16777216;
3710
a
3711
0
3712
INSERT INTO t2 ( a, b ) VALUES ( 1 , 5 );
3713
UPDATE t1 SET b = 0 WHERE id < 7 LIMIT 8;
3714
SELECT b FROM t1 WHERE 1 = 1;
3715
b
3716
1
3717
4
3718
SELECT b FROM t1 WHERE 1 = 1 /* no additional predicate */;
3719
b
3720
1
3721
4
3722
SELECT b FROM t1 WHERE 1 = 1 AND id > -16777216;
3723
b
3724
1
3725
4
3726
UPDATE t1 SET b = 9 WHERE id = 6 LIMIT 8;
3727
DELETE FROM t1 WHERE b BETWEEN 6 and 1 LIMIT 5;
3728
SELECT a FROM t1 WHERE a < 6;
3729
a
3730
1
3731
4
3732
SELECT a FROM t1 WHERE a < 6 /* no additional predicate */;
3733
a
3734
1
3735
4
3736
SELECT a FROM t1 WHERE a < 6 AND id > -16777216;
3737
a
3738
1
3739
4
3740
UPDATE t1 SET a = 3 WHERE 1 = 1 LIMIT 2;
3741
DELETE FROM t1 WHERE id = 5 LIMIT 7;
3742
SELECT a FROM t2 WHERE a IN ( 1 , 2 , 2 );
3743
a
3744
1
3745
SELECT a FROM t2 WHERE a IN ( 1 , 2 , 2 ) /* no additional predicate */;
3746
a
3747
1
3748
SELECT a FROM t2 WHERE a IN ( 1 , 2 , 2 ) AND id > -16777216;
3749
a
3750
1
3751
UPDATE t1 SET a = 0 WHERE id > 1 LIMIT 6;
3752
SELECT a FROM t2 WHERE b < 2;
3753
a
3754
SELECT a FROM t2 WHERE b < 2 /* no additional predicate */;
3755
a
3756
SELECT a FROM t2 WHERE b < 2 AND id > -16777216;
3757
a
3758
DELETE FROM t1 WHERE a IN ( 2 , 1 , 2 ) LIMIT 2;
3759
SELECT a FROM t1 WHERE id < 0;
3760
a
3761
SELECT a FROM t1 WHERE id < 0 /* no additional predicate */;
3762
a
3763
SELECT a FROM t1 WHERE id < 0 AND id > -16777216;
3764
a
3765
DELETE FROM t1 WHERE a IN ( 0 , 3 , 1 ) LIMIT 0;
3766
UPDATE t2 SET id = 1 WHERE 1 = 1 LIMIT 8;
3767
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
3768
UPDATE t1 SET b = 5 WHERE a < 6 LIMIT 3;
3769
UPDATE t2 SET a = 6 WHERE b BETWEEN 0 and 6 LIMIT 2;
3770
DELETE FROM t1 WHERE a > 4 LIMIT 3;
3771
ROLLBACK;
3772
SAVEPOINT A;
3773
SELECT id FROM t2 WHERE b < 1;
3774
id
3775
INSERT INTO t1 ( a, b ) VALUES ( 1 , 2 );
3776
SELECT id FROM t2 WHERE b < 1 /* no additional predicate */;
3777
id
3778
SELECT id FROM t2 WHERE b < 1 AND id > -16777216;
3779
id
3780
SELECT id FROM t2 WHERE b BETWEEN 4 and 7;
3781
id
3782
125
3783
126
3784
SELECT b FROM t1 WHERE id > 8;
3785
b
3786
5
3787
5
3788
2
3789
SELECT a FROM t1 WHERE 1 = 1;
3790
a
3791
0
3792
0
3793
1
3794
SELECT id FROM t2 WHERE b BETWEEN 4 and 7 /* no additional predicate */;
3795
id
3796
125
3797
126
3798
SELECT b FROM t1 WHERE id > 8 /* no additional predicate */;
3799
b
3800
5
3801
5
3802
2
3803
SELECT a FROM t1 WHERE 1 = 1 /* no additional predicate */;
3804
a
3805
0
3806
0
3807
1
3808
SELECT a FROM t1 WHERE 1 = 1 AND id > -16777216;
3809
a
3810
0
3811
0
3812
1
3813
SELECT id FROM t2 WHERE b BETWEEN 4 and 7 AND id > -16777216;
3814
id
3815
125
3816
126
3817
SELECT b FROM t1 WHERE id > 8 AND id > -16777216;
3818
b
3819
5
3820
5
3821
2
3822
INSERT INTO t1 ( a, b ) VALUES ( 3 , 7 );
3823
SELECT id FROM t1 WHERE id BETWEEN 8 and 1;
3824
id
3825
SELECT a FROM t1 WHERE 1 = 1;
3826
a
3827
0
3828
0
3829
1
3830
3
3831
SELECT id FROM t1 WHERE id BETWEEN 8 and 1 /* no additional predicate */;
3832
id
3833
SELECT a FROM t1 WHERE 1 = 1 /* no additional predicate */;
3834
a
3835
0
3836
0
3837
1
3838
3
3839
SELECT id FROM t1 WHERE id BETWEEN 8 and 1 AND id > -16777216;
3840
id
3841
SELECT a FROM t1 WHERE 1 = 1 AND id > -16777216;
3842
a
3843
0
3844
0
3845
1
3846
3
3847
INSERT INTO t2 ( a, b ) VALUES ( 8 , 6 );
3848
SELECT b FROM t1 WHERE b IN ( 8 , 3 , 9 );
3849
b
3850
SELECT a FROM t2 WHERE a > 2;
3851
a
3852
6
3853
8
3854
SELECT b FROM t1 WHERE b IN ( 8 , 3 , 9 ) /* no additional predicate */;
3855
b
3856
SELECT b FROM t1 WHERE b IN ( 8 , 3 , 9 ) AND id > -16777216;
3857
b
3858
SELECT a FROM t2 WHERE a > 2 /* no additional predicate */;
3859
a
3860
6
3861
8
3862
DELETE FROM t2 WHERE id > 6 LIMIT 3;
3863
SELECT a FROM t2 WHERE a > 2 AND id > -16777216;
3864
a
3865
UPDATE t1 SET b = 2 WHERE 1 = 1 LIMIT 7;
3866
DELETE FROM t2 WHERE a < 2 LIMIT 3;
3867
ROLLBACK;
3868
UPDATE t1 SET b = 1 WHERE a BETWEEN 1 and 3 LIMIT 1;
3869
COMMIT;
3870
ROLLBACK TO SAVEPOINT A;
3871
UPDATE t1 SET b = 0 WHERE a = 7 LIMIT 2;
3872
DELETE FROM t2 WHERE a < 7 LIMIT 1;
3873
DELETE FROM t2 WHERE a IN ( 3 , 9 , 0 ) LIMIT 2;
3874
UPDATE t2 SET b = 7 WHERE 1 = 1 LIMIT 3;
3875
INSERT INTO t2 ( a, b ) VALUES ( 3 , 6 );
3876
INSERT INTO t2 ( a, b ) VALUES ( 3 , 7 );
3877
SELECT id FROM t1 WHERE b BETWEEN 3 and 9;
3878
id
3879
INSERT INTO t2 ( a, b ) VALUES ( 9 , 6 );
3880
SELECT id FROM t1 WHERE b BETWEEN 3 and 9 /* no additional predicate */;
3881
id
3882
SELECT id FROM t1 WHERE b BETWEEN 3 and 9 AND id > -16777216;
3883
id
3884
DELETE FROM t1 WHERE 1 = 1 LIMIT 8;
3885
UPDATE t1 SET b = 6 WHERE a < 4 LIMIT 3;
3886
ROLLBACK TO SAVEPOINT A;
3887
DROP TABLE t1, t2;
52
SET AUTOCOMMIT=OFF;
53
DELETE FROM t1 WHERE 1 = 1 LIMIT 1;
54
COMMIT;
55
/* OR ROLLBACK... */
56
SAVEPOINT A;
57
INSERT INTO t1 ( a, b ) VALUES ( 1 , 9 );
58
ROLLBACK TO SAVEPOINT A;
3888
59
End Test of Bug 542299
Loggerhead is a web-based interface for Breezy
Version: 2.0.1