Debian Codegraph @

mysql-test/suite/innodb/r/lock_end_of_range.result

raw
1 #
2 # Bug #29508068 UNNECESSARY NEXT-KEY LOCK TAKEN
3 #
4 CREATE TABLE t1 (
5 id INT NOT NULL,
6 PRIMARY KEY (id ASC)
7 ) ENGINE=InnoDB;
8 CREATE TABLE t2 (
9 id INT NOT NULL,
10 PRIMARY KEY (id DESC)
11 ) ENGINE=InnoDB;
12 SET @conditions = CONCAT(
13 '<=0 <1 <=1 <7 <=7 <=8 <9 <=9 <=10 ',
14 '>=10 >9 >=9 >3 >=3 >=2 >1 >=1 >0'
15 );
16 INSERT INTO t1 VALUES (1), (3), (4), (5), (6), (7), (9);
17 ANALYZE TABLE t1;
18 Table Op Msg_type Msg_text
19 test.t1 analyze status OK
20 BEGIN;
21 SELECT *
22 FROM t1 FORCE INDEX (PRIMARY)
23 WHERE id <=0
24 ORDER BY id ASC
25 FOR UPDATE;
26 id
27 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
28 FROM performance_schema.data_locks
29 WHERE object_name = 't1';
30 index_name lock_type lock_mode lock_status lock_data
31 NULL TABLE IX GRANTED NULL
32 PRIMARY RECORD X,GAP GRANTED 1
33 ROLLBACK;
34 BEGIN;
35 SELECT *
36 FROM t1 FORCE INDEX (PRIMARY)
37 WHERE id <=0
38 ORDER BY id DESC
39 FOR UPDATE;
40 id
41 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
42 FROM performance_schema.data_locks
43 WHERE object_name = 't1';
44 index_name lock_type lock_mode lock_status lock_data
45 NULL TABLE IX GRANTED NULL
46 PRIMARY RECORD X,GAP GRANTED 1
47 ROLLBACK;
48 BEGIN;
49 SELECT *
50 FROM t1 FORCE INDEX (PRIMARY)
51 WHERE id <1
52 ORDER BY id ASC
53 FOR UPDATE;
54 id
55 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
56 FROM performance_schema.data_locks
57 WHERE object_name = 't1';
58 index_name lock_type lock_mode lock_status lock_data
59 NULL TABLE IX GRANTED NULL
60 PRIMARY RECORD X,GAP GRANTED 1
61 ROLLBACK;
62 BEGIN;
63 SELECT *
64 FROM t1 FORCE INDEX (PRIMARY)
65 WHERE id <1
66 ORDER BY id DESC
67 FOR UPDATE;
68 id
69 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
70 FROM performance_schema.data_locks
71 WHERE object_name = 't1';
72 index_name lock_type lock_mode lock_status lock_data
73 NULL TABLE IX GRANTED NULL
74 PRIMARY RECORD X,GAP GRANTED 1
75 ROLLBACK;
76 BEGIN;
77 SELECT *
78 FROM t1 FORCE INDEX (PRIMARY)
79 WHERE id <=1
80 ORDER BY id ASC
81 FOR UPDATE;
82 id
83 1
84 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
85 FROM performance_schema.data_locks
86 WHERE object_name = 't1';
87 index_name lock_type lock_mode lock_status lock_data
88 NULL TABLE IX GRANTED NULL
89 PRIMARY RECORD X GRANTED 1
90 ROLLBACK;
91 BEGIN;
92 SELECT *
93 FROM t1 FORCE INDEX (PRIMARY)
94 WHERE id <=1
95 ORDER BY id DESC
96 FOR UPDATE;
97 id
98 1
99 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
100 FROM performance_schema.data_locks
101 WHERE object_name = 't1';
102 index_name lock_type lock_mode lock_status lock_data
103 NULL TABLE IX GRANTED NULL
104 PRIMARY RECORD X GRANTED 1
105 PRIMARY RECORD X,GAP GRANTED 3
106 ROLLBACK;
107 BEGIN;
108 SELECT *
109 FROM t1 FORCE INDEX (PRIMARY)
110 WHERE id <7
111 ORDER BY id ASC
112 FOR UPDATE;
113 id
114 1
115 3
116 4
117 5
118 6
119 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
120 FROM performance_schema.data_locks
121 WHERE object_name = 't1';
122 index_name lock_type lock_mode lock_status lock_data
123 NULL TABLE IX GRANTED NULL
124 PRIMARY RECORD X GRANTED 1
125 PRIMARY RECORD X GRANTED 3
126 PRIMARY RECORD X GRANTED 4
127 PRIMARY RECORD X GRANTED 5
128 PRIMARY RECORD X GRANTED 6
129 PRIMARY RECORD X,GAP GRANTED 7
130 ROLLBACK;
131 BEGIN;
132 SELECT *
133 FROM t1 FORCE INDEX (PRIMARY)
134 WHERE id <7
135 ORDER BY id DESC
136 FOR UPDATE;
137 id
138 6
139 5
140 4
141 3
142 1
143 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
144 FROM performance_schema.data_locks
145 WHERE object_name = 't1';
146 index_name lock_type lock_mode lock_status lock_data
147 NULL TABLE IX GRANTED NULL
148 PRIMARY RECORD X GRANTED 1
149 PRIMARY RECORD X GRANTED 3
150 PRIMARY RECORD X GRANTED 4
151 PRIMARY RECORD X GRANTED 5
152 PRIMARY RECORD X GRANTED 6
153 PRIMARY RECORD X,GAP GRANTED 7
154 ROLLBACK;
155 BEGIN;
156 SELECT *
157 FROM t1 FORCE INDEX (PRIMARY)
158 WHERE id <=7
159 ORDER BY id ASC
160 FOR UPDATE;
161 id
162 1
163 3
164 4
165 5
166 6
167 7
168 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
169 FROM performance_schema.data_locks
170 WHERE object_name = 't1';
171 index_name lock_type lock_mode lock_status lock_data
172 NULL TABLE IX GRANTED NULL
173 PRIMARY RECORD X GRANTED 1
174 PRIMARY RECORD X GRANTED 3
175 PRIMARY RECORD X GRANTED 4
176 PRIMARY RECORD X GRANTED 5
177 PRIMARY RECORD X GRANTED 6
178 PRIMARY RECORD X GRANTED 7
179 ROLLBACK;
180 BEGIN;
181 SELECT *
182 FROM t1 FORCE INDEX (PRIMARY)
183 WHERE id <=7
184 ORDER BY id DESC
185 FOR UPDATE;
186 id
187 7
188 6
189 5
190 4
191 3
192 1
193 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
194 FROM performance_schema.data_locks
195 WHERE object_name = 't1';
196 index_name lock_type lock_mode lock_status lock_data
197 NULL TABLE IX GRANTED NULL
198 PRIMARY RECORD X GRANTED 1
199 PRIMARY RECORD X GRANTED 3
200 PRIMARY RECORD X GRANTED 4
201 PRIMARY RECORD X GRANTED 5
202 PRIMARY RECORD X GRANTED 6
203 PRIMARY RECORD X GRANTED 7
204 PRIMARY RECORD X,GAP GRANTED 9
205 ROLLBACK;
206 BEGIN;
207 SELECT *
208 FROM t1 FORCE INDEX (PRIMARY)
209 WHERE id <=8
210 ORDER BY id ASC
211 FOR UPDATE;
212 id
213 1
214 3
215 4
216 5
217 6
218 7
219 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
220 FROM performance_schema.data_locks
221 WHERE object_name = 't1';
222 index_name lock_type lock_mode lock_status lock_data
223 NULL TABLE IX GRANTED NULL
224 PRIMARY RECORD X GRANTED 1
225 PRIMARY RECORD X GRANTED 3
226 PRIMARY RECORD X GRANTED 4
227 PRIMARY RECORD X GRANTED 5
228 PRIMARY RECORD X GRANTED 6
229 PRIMARY RECORD X GRANTED 7
230 PRIMARY RECORD X,GAP GRANTED 9
231 ROLLBACK;
232 BEGIN;
233 SELECT *
234 FROM t1 FORCE INDEX (PRIMARY)
235 WHERE id <=8
236 ORDER BY id DESC
237 FOR UPDATE;
238 id
239 7
240 6
241 5
242 4
243 3
244 1
245 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
246 FROM performance_schema.data_locks
247 WHERE object_name = 't1';
248 index_name lock_type lock_mode lock_status lock_data
249 NULL TABLE IX GRANTED NULL
250 PRIMARY RECORD X GRANTED 1
251 PRIMARY RECORD X GRANTED 3
252 PRIMARY RECORD X GRANTED 4
253 PRIMARY RECORD X GRANTED 5
254 PRIMARY RECORD X GRANTED 6
255 PRIMARY RECORD X GRANTED 7
256 PRIMARY RECORD X,GAP GRANTED 9
257 ROLLBACK;
258 BEGIN;
259 SELECT *
260 FROM t1 FORCE INDEX (PRIMARY)
261 WHERE id <9
262 ORDER BY id ASC
263 FOR UPDATE;
264 id
265 1
266 3
267 4
268 5
269 6
270 7
271 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
272 FROM performance_schema.data_locks
273 WHERE object_name = 't1';
274 index_name lock_type lock_mode lock_status lock_data
275 NULL TABLE IX GRANTED NULL
276 PRIMARY RECORD X GRANTED 1
277 PRIMARY RECORD X GRANTED 3
278 PRIMARY RECORD X GRANTED 4
279 PRIMARY RECORD X GRANTED 5
280 PRIMARY RECORD X GRANTED 6
281 PRIMARY RECORD X GRANTED 7
282 PRIMARY RECORD X,GAP GRANTED 9
283 ROLLBACK;
284 BEGIN;
285 SELECT *
286 FROM t1 FORCE INDEX (PRIMARY)
287 WHERE id <9
288 ORDER BY id DESC
289 FOR UPDATE;
290 id
291 7
292 6
293 5
294 4
295 3
296 1
297 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
298 FROM performance_schema.data_locks
299 WHERE object_name = 't1';
300 index_name lock_type lock_mode lock_status lock_data
301 NULL TABLE IX GRANTED NULL
302 PRIMARY RECORD X GRANTED 1
303 PRIMARY RECORD X GRANTED 3
304 PRIMARY RECORD X GRANTED 4
305 PRIMARY RECORD X GRANTED 5
306 PRIMARY RECORD X GRANTED 6
307 PRIMARY RECORD X GRANTED 7
308 PRIMARY RECORD X,GAP GRANTED 9
309 ROLLBACK;
310 BEGIN;
311 SELECT *
312 FROM t1 FORCE INDEX (PRIMARY)
313 WHERE id <=9
314 ORDER BY id ASC
315 FOR UPDATE;
316 id
317 1
318 3
319 4
320 5
321 6
322 7
323 9
324 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
325 FROM performance_schema.data_locks
326 WHERE object_name = 't1';
327 index_name lock_type lock_mode lock_status lock_data
328 NULL TABLE IX GRANTED NULL
329 PRIMARY RECORD X GRANTED 1
330 PRIMARY RECORD X GRANTED 3
331 PRIMARY RECORD X GRANTED 4
332 PRIMARY RECORD X GRANTED 5
333 PRIMARY RECORD X GRANTED 6
334 PRIMARY RECORD X GRANTED 7
335 PRIMARY RECORD X GRANTED 9
336 PRIMARY RECORD X GRANTED supremum pseudo-record
337 ROLLBACK;
338 BEGIN;
339 SELECT *
340 FROM t1 FORCE INDEX (PRIMARY)
341 WHERE id <=9
342 ORDER BY id DESC
343 FOR UPDATE;
344 id
345 9
346 7
347 6
348 5
349 4
350 3
351 1
352 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
353 FROM performance_schema.data_locks
354 WHERE object_name = 't1';
355 index_name lock_type lock_mode lock_status lock_data
356 NULL TABLE IX GRANTED NULL
357 PRIMARY RECORD X GRANTED 1
358 PRIMARY RECORD X GRANTED 3
359 PRIMARY RECORD X GRANTED 4
360 PRIMARY RECORD X GRANTED 5
361 PRIMARY RECORD X GRANTED 6
362 PRIMARY RECORD X GRANTED 7
363 PRIMARY RECORD X GRANTED 9
364 PRIMARY RECORD X GRANTED supremum pseudo-record
365 ROLLBACK;
366 BEGIN;
367 SELECT *
368 FROM t1 FORCE INDEX (PRIMARY)
369 WHERE id <=10
370 ORDER BY id ASC
371 FOR UPDATE;
372 id
373 1
374 3
375 4
376 5
377 6
378 7
379 9
380 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
381 FROM performance_schema.data_locks
382 WHERE object_name = 't1';
383 index_name lock_type lock_mode lock_status lock_data
384 NULL TABLE IX GRANTED NULL
385 PRIMARY RECORD X GRANTED 1
386 PRIMARY RECORD X GRANTED 3
387 PRIMARY RECORD X GRANTED 4
388 PRIMARY RECORD X GRANTED 5
389 PRIMARY RECORD X GRANTED 6
390 PRIMARY RECORD X GRANTED 7
391 PRIMARY RECORD X GRANTED 9
392 PRIMARY RECORD X GRANTED supremum pseudo-record
393 ROLLBACK;
394 BEGIN;
395 SELECT *
396 FROM t1 FORCE INDEX (PRIMARY)
397 WHERE id <=10
398 ORDER BY id DESC
399 FOR UPDATE;
400 id
401 9
402 7
403 6
404 5
405 4
406 3
407 1
408 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
409 FROM performance_schema.data_locks
410 WHERE object_name = 't1';
411 index_name lock_type lock_mode lock_status lock_data
412 NULL TABLE IX GRANTED NULL
413 PRIMARY RECORD X GRANTED 1
414 PRIMARY RECORD X GRANTED 3
415 PRIMARY RECORD X GRANTED 4
416 PRIMARY RECORD X GRANTED 5
417 PRIMARY RECORD X GRANTED 6
418 PRIMARY RECORD X GRANTED 7
419 PRIMARY RECORD X GRANTED 9
420 PRIMARY RECORD X GRANTED supremum pseudo-record
421 ROLLBACK;
422 BEGIN;
423 SELECT *
424 FROM t1 FORCE INDEX (PRIMARY)
425 WHERE id >=10
426 ORDER BY id ASC
427 FOR UPDATE;
428 id
429 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
430 FROM performance_schema.data_locks
431 WHERE object_name = 't1';
432 index_name lock_type lock_mode lock_status lock_data
433 NULL TABLE IX GRANTED NULL
434 PRIMARY RECORD X GRANTED supremum pseudo-record
435 ROLLBACK;
436 BEGIN;
437 SELECT *
438 FROM t1 FORCE INDEX (PRIMARY)
439 WHERE id >=10
440 ORDER BY id DESC
441 FOR UPDATE;
442 id
443 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
444 FROM performance_schema.data_locks
445 WHERE object_name = 't1';
446 index_name lock_type lock_mode lock_status lock_data
447 NULL TABLE IX GRANTED NULL
448 PRIMARY RECORD X GRANTED 9
449 PRIMARY RECORD X GRANTED supremum pseudo-record
450 ROLLBACK;
451 BEGIN;
452 SELECT *
453 FROM t1 FORCE INDEX (PRIMARY)
454 WHERE id >9
455 ORDER BY id ASC
456 FOR UPDATE;
457 id
458 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
459 FROM performance_schema.data_locks
460 WHERE object_name = 't1';
461 index_name lock_type lock_mode lock_status lock_data
462 NULL TABLE IX GRANTED NULL
463 PRIMARY RECORD X GRANTED supremum pseudo-record
464 ROLLBACK;
465 BEGIN;
466 SELECT *
467 FROM t1 FORCE INDEX (PRIMARY)
468 WHERE id >9
469 ORDER BY id DESC
470 FOR UPDATE;
471 id
472 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
473 FROM performance_schema.data_locks
474 WHERE object_name = 't1';
475 index_name lock_type lock_mode lock_status lock_data
476 NULL TABLE IX GRANTED NULL
477 PRIMARY RECORD X GRANTED 9
478 PRIMARY RECORD X GRANTED supremum pseudo-record
479 ROLLBACK;
480 BEGIN;
481 SELECT *
482 FROM t1 FORCE INDEX (PRIMARY)
483 WHERE id >=9
484 ORDER BY id ASC
485 FOR UPDATE;
486 id
487 9
488 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
489 FROM performance_schema.data_locks
490 WHERE object_name = 't1';
491 index_name lock_type lock_mode lock_status lock_data
492 NULL TABLE IX GRANTED NULL
493 PRIMARY RECORD X GRANTED supremum pseudo-record
494 PRIMARY RECORD X,REC_NOT_GAP GRANTED 9
495 ROLLBACK;
496 BEGIN;
497 SELECT *
498 FROM t1 FORCE INDEX (PRIMARY)
499 WHERE id >=9
500 ORDER BY id DESC
501 FOR UPDATE;
502 id
503 9
504 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
505 FROM performance_schema.data_locks
506 WHERE object_name = 't1';
507 index_name lock_type lock_mode lock_status lock_data
508 NULL TABLE IX GRANTED NULL
509 PRIMARY RECORD X GRANTED 7
510 PRIMARY RECORD X GRANTED 9
511 PRIMARY RECORD X GRANTED supremum pseudo-record
512 ROLLBACK;
513 BEGIN;
514 SELECT *
515 FROM t1 FORCE INDEX (PRIMARY)
516 WHERE id >3
517 ORDER BY id ASC
518 FOR UPDATE;
519 id
520 4
521 5
522 6
523 7
524 9
525 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
526 FROM performance_schema.data_locks
527 WHERE object_name = 't1';
528 index_name lock_type lock_mode lock_status lock_data
529 NULL TABLE IX GRANTED NULL
530 PRIMARY RECORD X GRANTED 4
531 PRIMARY RECORD X GRANTED 5
532 PRIMARY RECORD X GRANTED 6
533 PRIMARY RECORD X GRANTED 7
534 PRIMARY RECORD X GRANTED 9
535 PRIMARY RECORD X GRANTED supremum pseudo-record
536 ROLLBACK;
537 BEGIN;
538 SELECT *
539 FROM t1 FORCE INDEX (PRIMARY)
540 WHERE id >3
541 ORDER BY id DESC
542 FOR UPDATE;
543 id
544 9
545 7
546 6
547 5
548 4
549 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
550 FROM performance_schema.data_locks
551 WHERE object_name = 't1';
552 index_name lock_type lock_mode lock_status lock_data
553 NULL TABLE IX GRANTED NULL
554 PRIMARY RECORD X GRANTED 3
555 PRIMARY RECORD X GRANTED 4
556 PRIMARY RECORD X GRANTED 5
557 PRIMARY RECORD X GRANTED 6
558 PRIMARY RECORD X GRANTED 7
559 PRIMARY RECORD X GRANTED 9
560 PRIMARY RECORD X GRANTED supremum pseudo-record
561 ROLLBACK;
562 BEGIN;
563 SELECT *
564 FROM t1 FORCE INDEX (PRIMARY)
565 WHERE id >=3
566 ORDER BY id ASC
567 FOR UPDATE;
568 id
569 3
570 4
571 5
572 6
573 7
574 9
575 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
576 FROM performance_schema.data_locks
577 WHERE object_name = 't1';
578 index_name lock_type lock_mode lock_status lock_data
579 NULL TABLE IX GRANTED NULL
580 PRIMARY RECORD X GRANTED 4
581 PRIMARY RECORD X GRANTED 5
582 PRIMARY RECORD X GRANTED 6
583 PRIMARY RECORD X GRANTED 7
584 PRIMARY RECORD X GRANTED 9
585 PRIMARY RECORD X GRANTED supremum pseudo-record
586 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3
587 ROLLBACK;
588 BEGIN;
589 SELECT *
590 FROM t1 FORCE INDEX (PRIMARY)
591 WHERE id >=3
592 ORDER BY id DESC
593 FOR UPDATE;
594 id
595 9
596 7
597 6
598 5
599 4
600 3
601 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
602 FROM performance_schema.data_locks
603 WHERE object_name = 't1';
604 index_name lock_type lock_mode lock_status lock_data
605 NULL TABLE IX GRANTED NULL
606 PRIMARY RECORD X GRANTED 1
607 PRIMARY RECORD X GRANTED 3
608 PRIMARY RECORD X GRANTED 4
609 PRIMARY RECORD X GRANTED 5
610 PRIMARY RECORD X GRANTED 6
611 PRIMARY RECORD X GRANTED 7
612 PRIMARY RECORD X GRANTED 9
613 PRIMARY RECORD X GRANTED supremum pseudo-record
614 ROLLBACK;
615 BEGIN;
616 SELECT *
617 FROM t1 FORCE INDEX (PRIMARY)
618 WHERE id >=2
619 ORDER BY id ASC
620 FOR UPDATE;
621 id
622 3
623 4
624 5
625 6
626 7
627 9
628 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
629 FROM performance_schema.data_locks
630 WHERE object_name = 't1';
631 index_name lock_type lock_mode lock_status lock_data
632 NULL TABLE IX GRANTED NULL
633 PRIMARY RECORD X GRANTED 3
634 PRIMARY RECORD X GRANTED 4
635 PRIMARY RECORD X GRANTED 5
636 PRIMARY RECORD X GRANTED 6
637 PRIMARY RECORD X GRANTED 7
638 PRIMARY RECORD X GRANTED 9
639 PRIMARY RECORD X GRANTED supremum pseudo-record
640 ROLLBACK;
641 BEGIN;
642 SELECT *
643 FROM t1 FORCE INDEX (PRIMARY)
644 WHERE id >=2
645 ORDER BY id DESC
646 FOR UPDATE;
647 id
648 9
649 7
650 6
651 5
652 4
653 3
654 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
655 FROM performance_schema.data_locks
656 WHERE object_name = 't1';
657 index_name lock_type lock_mode lock_status lock_data
658 NULL TABLE IX GRANTED NULL
659 PRIMARY RECORD X GRANTED 1
660 PRIMARY RECORD X GRANTED 3
661 PRIMARY RECORD X GRANTED 4
662 PRIMARY RECORD X GRANTED 5
663 PRIMARY RECORD X GRANTED 6
664 PRIMARY RECORD X GRANTED 7
665 PRIMARY RECORD X GRANTED 9
666 PRIMARY RECORD X GRANTED supremum pseudo-record
667 ROLLBACK;
668 BEGIN;
669 SELECT *
670 FROM t1 FORCE INDEX (PRIMARY)
671 WHERE id >1
672 ORDER BY id ASC
673 FOR UPDATE;
674 id
675 3
676 4
677 5
678 6
679 7
680 9
681 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
682 FROM performance_schema.data_locks
683 WHERE object_name = 't1';
684 index_name lock_type lock_mode lock_status lock_data
685 NULL TABLE IX GRANTED NULL
686 PRIMARY RECORD X GRANTED 3
687 PRIMARY RECORD X GRANTED 4
688 PRIMARY RECORD X GRANTED 5
689 PRIMARY RECORD X GRANTED 6
690 PRIMARY RECORD X GRANTED 7
691 PRIMARY RECORD X GRANTED 9
692 PRIMARY RECORD X GRANTED supremum pseudo-record
693 ROLLBACK;
694 BEGIN;
695 SELECT *
696 FROM t1 FORCE INDEX (PRIMARY)
697 WHERE id >1
698 ORDER BY id DESC
699 FOR UPDATE;
700 id
701 9
702 7
703 6
704 5
705 4
706 3
707 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
708 FROM performance_schema.data_locks
709 WHERE object_name = 't1';
710 index_name lock_type lock_mode lock_status lock_data
711 NULL TABLE IX GRANTED NULL
712 PRIMARY RECORD X GRANTED 1
713 PRIMARY RECORD X GRANTED 3
714 PRIMARY RECORD X GRANTED 4
715 PRIMARY RECORD X GRANTED 5
716 PRIMARY RECORD X GRANTED 6
717 PRIMARY RECORD X GRANTED 7
718 PRIMARY RECORD X GRANTED 9
719 PRIMARY RECORD X GRANTED supremum pseudo-record
720 ROLLBACK;
721 BEGIN;
722 SELECT *
723 FROM t1 FORCE INDEX (PRIMARY)
724 WHERE id >=1
725 ORDER BY id ASC
726 FOR UPDATE;
727 id
728 1
729 3
730 4
731 5
732 6
733 7
734 9
735 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
736 FROM performance_schema.data_locks
737 WHERE object_name = 't1';
738 index_name lock_type lock_mode lock_status lock_data
739 NULL TABLE IX GRANTED NULL
740 PRIMARY RECORD X GRANTED 3
741 PRIMARY RECORD X GRANTED 4
742 PRIMARY RECORD X GRANTED 5
743 PRIMARY RECORD X GRANTED 6
744 PRIMARY RECORD X GRANTED 7
745 PRIMARY RECORD X GRANTED 9
746 PRIMARY RECORD X GRANTED supremum pseudo-record
747 PRIMARY RECORD X,REC_NOT_GAP GRANTED 1
748 ROLLBACK;
749 BEGIN;
750 SELECT *
751 FROM t1 FORCE INDEX (PRIMARY)
752 WHERE id >=1
753 ORDER BY id DESC
754 FOR UPDATE;
755 id
756 9
757 7
758 6
759 5
760 4
761 3
762 1
763 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
764 FROM performance_schema.data_locks
765 WHERE object_name = 't1';
766 index_name lock_type lock_mode lock_status lock_data
767 NULL TABLE IX GRANTED NULL
768 PRIMARY RECORD X GRANTED 1
769 PRIMARY RECORD X GRANTED 3
770 PRIMARY RECORD X GRANTED 4
771 PRIMARY RECORD X GRANTED 5
772 PRIMARY RECORD X GRANTED 6
773 PRIMARY RECORD X GRANTED 7
774 PRIMARY RECORD X GRANTED 9
775 PRIMARY RECORD X GRANTED supremum pseudo-record
776 ROLLBACK;
777 BEGIN;
778 SELECT *
779 FROM t1 FORCE INDEX (PRIMARY)
780 WHERE id >0
781 ORDER BY id ASC
782 FOR UPDATE;
783 id
784 1
785 3
786 4
787 5
788 6
789 7
790 9
791 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
792 FROM performance_schema.data_locks
793 WHERE object_name = 't1';
794 index_name lock_type lock_mode lock_status lock_data
795 NULL TABLE IX GRANTED NULL
796 PRIMARY RECORD X GRANTED 1
797 PRIMARY RECORD X GRANTED 3
798 PRIMARY RECORD X GRANTED 4
799 PRIMARY RECORD X GRANTED 5
800 PRIMARY RECORD X GRANTED 6
801 PRIMARY RECORD X GRANTED 7
802 PRIMARY RECORD X GRANTED 9
803 PRIMARY RECORD X GRANTED supremum pseudo-record
804 ROLLBACK;
805 BEGIN;
806 SELECT *
807 FROM t1 FORCE INDEX (PRIMARY)
808 WHERE id >0
809 ORDER BY id DESC
810 FOR UPDATE;
811 id
812 9
813 7
814 6
815 5
816 4
817 3
818 1
819 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
820 FROM performance_schema.data_locks
821 WHERE object_name = 't1';
822 index_name lock_type lock_mode lock_status lock_data
823 NULL TABLE IX GRANTED NULL
824 PRIMARY RECORD X GRANTED 1
825 PRIMARY RECORD X GRANTED 3
826 PRIMARY RECORD X GRANTED 4
827 PRIMARY RECORD X GRANTED 5
828 PRIMARY RECORD X GRANTED 6
829 PRIMARY RECORD X GRANTED 7
830 PRIMARY RECORD X GRANTED 9
831 PRIMARY RECORD X GRANTED supremum pseudo-record
832 ROLLBACK;
833 DROP TABLE t1;
834 INSERT INTO t2 VALUES (1), (3), (4), (5), (6), (7), (9);
835 ANALYZE TABLE t2;
836 Table Op Msg_type Msg_text
837 test.t2 analyze status OK
838 BEGIN;
839 SELECT *
840 FROM t2 FORCE INDEX (PRIMARY)
841 WHERE id <=0
842 ORDER BY id ASC
843 FOR UPDATE;
844 id
845 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
846 FROM performance_schema.data_locks
847 WHERE object_name = 't2';
848 index_name lock_type lock_mode lock_status lock_data
849 NULL TABLE IX GRANTED NULL
850 PRIMARY RECORD X GRANTED 1
851 PRIMARY RECORD X GRANTED supremum pseudo-record
852 ROLLBACK;
853 BEGIN;
854 SELECT *
855 FROM t2 FORCE INDEX (PRIMARY)
856 WHERE id <=0
857 ORDER BY id DESC
858 FOR UPDATE;
859 id
860 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
861 FROM performance_schema.data_locks
862 WHERE object_name = 't2';
863 index_name lock_type lock_mode lock_status lock_data
864 NULL TABLE IX GRANTED NULL
865 PRIMARY RECORD X GRANTED supremum pseudo-record
866 ROLLBACK;
867 BEGIN;
868 SELECT *
869 FROM t2 FORCE INDEX (PRIMARY)
870 WHERE id <1
871 ORDER BY id ASC
872 FOR UPDATE;
873 id
874 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
875 FROM performance_schema.data_locks
876 WHERE object_name = 't2';
877 index_name lock_type lock_mode lock_status lock_data
878 NULL TABLE IX GRANTED NULL
879 PRIMARY RECORD X GRANTED 1
880 PRIMARY RECORD X GRANTED supremum pseudo-record
881 ROLLBACK;
882 BEGIN;
883 SELECT *
884 FROM t2 FORCE INDEX (PRIMARY)
885 WHERE id <1
886 ORDER BY id DESC
887 FOR UPDATE;
888 id
889 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
890 FROM performance_schema.data_locks
891 WHERE object_name = 't2';
892 index_name lock_type lock_mode lock_status lock_data
893 NULL TABLE IX GRANTED NULL
894 PRIMARY RECORD X GRANTED supremum pseudo-record
895 ROLLBACK;
896 BEGIN;
897 SELECT *
898 FROM t2 FORCE INDEX (PRIMARY)
899 WHERE id <=1
900 ORDER BY id ASC
901 FOR UPDATE;
902 id
903 1
904 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
905 FROM performance_schema.data_locks
906 WHERE object_name = 't2';
907 index_name lock_type lock_mode lock_status lock_data
908 NULL TABLE IX GRANTED NULL
909 PRIMARY RECORD X GRANTED 1
910 PRIMARY RECORD X GRANTED 3
911 PRIMARY RECORD X GRANTED supremum pseudo-record
912 ROLLBACK;
913 BEGIN;
914 SELECT *
915 FROM t2 FORCE INDEX (PRIMARY)
916 WHERE id <=1
917 ORDER BY id DESC
918 FOR UPDATE;
919 id
920 1
921 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
922 FROM performance_schema.data_locks
923 WHERE object_name = 't2';
924 index_name lock_type lock_mode lock_status lock_data
925 NULL TABLE IX GRANTED NULL
926 PRIMARY RECORD X GRANTED supremum pseudo-record
927 PRIMARY RECORD X,REC_NOT_GAP GRANTED 1
928 ROLLBACK;
929 BEGIN;
930 SELECT *
931 FROM t2 FORCE INDEX (PRIMARY)
932 WHERE id <7
933 ORDER BY id ASC
934 FOR UPDATE;
935 id
936 1
937 3
938 4
939 5
940 6
941 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
942 FROM performance_schema.data_locks
943 WHERE object_name = 't2';
944 index_name lock_type lock_mode lock_status lock_data
945 NULL TABLE IX GRANTED NULL
946 PRIMARY RECORD X GRANTED 1
947 PRIMARY RECORD X GRANTED 3
948 PRIMARY RECORD X GRANTED 4
949 PRIMARY RECORD X GRANTED 5
950 PRIMARY RECORD X GRANTED 6
951 PRIMARY RECORD X GRANTED 7
952 PRIMARY RECORD X GRANTED supremum pseudo-record
953 ROLLBACK;
954 BEGIN;
955 SELECT *
956 FROM t2 FORCE INDEX (PRIMARY)
957 WHERE id <7
958 ORDER BY id DESC
959 FOR UPDATE;
960 id
961 6
962 5
963 4
964 3
965 1
966 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
967 FROM performance_schema.data_locks
968 WHERE object_name = 't2';
969 index_name lock_type lock_mode lock_status lock_data
970 NULL TABLE IX GRANTED NULL
971 PRIMARY RECORD X GRANTED 1
972 PRIMARY RECORD X GRANTED 3
973 PRIMARY RECORD X GRANTED 4
974 PRIMARY RECORD X GRANTED 5
975 PRIMARY RECORD X GRANTED 6
976 PRIMARY RECORD X GRANTED supremum pseudo-record
977 ROLLBACK;
978 BEGIN;
979 SELECT *
980 FROM t2 FORCE INDEX (PRIMARY)
981 WHERE id <=7
982 ORDER BY id ASC
983 FOR UPDATE;
984 id
985 1
986 3
987 4
988 5
989 6
990 7
991 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
992 FROM performance_schema.data_locks
993 WHERE object_name = 't2';
994 index_name lock_type lock_mode lock_status lock_data
995 NULL TABLE IX GRANTED NULL
996 PRIMARY RECORD X GRANTED 1
997 PRIMARY RECORD X GRANTED 3
998 PRIMARY RECORD X GRANTED 4
999 PRIMARY RECORD X GRANTED 5
1000 PRIMARY RECORD X GRANTED 6
1001 PRIMARY RECORD X GRANTED 7
1002 PRIMARY RECORD X GRANTED 9
1003 PRIMARY RECORD X GRANTED supremum pseudo-record
1004 ROLLBACK;
1005 BEGIN;
1006 SELECT *
1007 FROM t2 FORCE INDEX (PRIMARY)
1008 WHERE id <=7
1009 ORDER BY id DESC
1010 FOR UPDATE;
1011 id
1012 7
1013 6
1014 5
1015 4
1016 3
1017 1
1018 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1019 FROM performance_schema.data_locks
1020 WHERE object_name = 't2';
1021 index_name lock_type lock_mode lock_status lock_data
1022 NULL TABLE IX GRANTED NULL
1023 PRIMARY RECORD X GRANTED 1
1024 PRIMARY RECORD X GRANTED 3
1025 PRIMARY RECORD X GRANTED 4
1026 PRIMARY RECORD X GRANTED 5
1027 PRIMARY RECORD X GRANTED 6
1028 PRIMARY RECORD X GRANTED supremum pseudo-record
1029 PRIMARY RECORD X,REC_NOT_GAP GRANTED 7
1030 ROLLBACK;
1031 BEGIN;
1032 SELECT *
1033 FROM t2 FORCE INDEX (PRIMARY)
1034 WHERE id <=8
1035 ORDER BY id ASC
1036 FOR UPDATE;
1037 id
1038 1
1039 3
1040 4
1041 5
1042 6
1043 7
1044 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1045 FROM performance_schema.data_locks
1046 WHERE object_name = 't2';
1047 index_name lock_type lock_mode lock_status lock_data
1048 NULL TABLE IX GRANTED NULL
1049 PRIMARY RECORD X GRANTED 1
1050 PRIMARY RECORD X GRANTED 3
1051 PRIMARY RECORD X GRANTED 4
1052 PRIMARY RECORD X GRANTED 5
1053 PRIMARY RECORD X GRANTED 6
1054 PRIMARY RECORD X GRANTED 7
1055 PRIMARY RECORD X GRANTED 9
1056 PRIMARY RECORD X GRANTED supremum pseudo-record
1057 ROLLBACK;
1058 BEGIN;
1059 SELECT *
1060 FROM t2 FORCE INDEX (PRIMARY)
1061 WHERE id <=8
1062 ORDER BY id DESC
1063 FOR UPDATE;
1064 id
1065 7
1066 6
1067 5
1068 4
1069 3
1070 1
1071 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1072 FROM performance_schema.data_locks
1073 WHERE object_name = 't2';
1074 index_name lock_type lock_mode lock_status lock_data
1075 NULL TABLE IX GRANTED NULL
1076 PRIMARY RECORD X GRANTED 1
1077 PRIMARY RECORD X GRANTED 3
1078 PRIMARY RECORD X GRANTED 4
1079 PRIMARY RECORD X GRANTED 5
1080 PRIMARY RECORD X GRANTED 6
1081 PRIMARY RECORD X GRANTED 7
1082 PRIMARY RECORD X GRANTED supremum pseudo-record
1083 ROLLBACK;
1084 BEGIN;
1085 SELECT *
1086 FROM t2 FORCE INDEX (PRIMARY)
1087 WHERE id <9
1088 ORDER BY id ASC
1089 FOR UPDATE;
1090 id
1091 1
1092 3
1093 4
1094 5
1095 6
1096 7
1097 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1098 FROM performance_schema.data_locks
1099 WHERE object_name = 't2';
1100 index_name lock_type lock_mode lock_status lock_data
1101 NULL TABLE IX GRANTED NULL
1102 PRIMARY RECORD X GRANTED 1
1103 PRIMARY RECORD X GRANTED 3
1104 PRIMARY RECORD X GRANTED 4
1105 PRIMARY RECORD X GRANTED 5
1106 PRIMARY RECORD X GRANTED 6
1107 PRIMARY RECORD X GRANTED 7
1108 PRIMARY RECORD X GRANTED 9
1109 PRIMARY RECORD X GRANTED supremum pseudo-record
1110 ROLLBACK;
1111 BEGIN;
1112 SELECT *
1113 FROM t2 FORCE INDEX (PRIMARY)
1114 WHERE id <9
1115 ORDER BY id DESC
1116 FOR UPDATE;
1117 id
1118 7
1119 6
1120 5
1121 4
1122 3
1123 1
1124 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1125 FROM performance_schema.data_locks
1126 WHERE object_name = 't2';
1127 index_name lock_type lock_mode lock_status lock_data
1128 NULL TABLE IX GRANTED NULL
1129 PRIMARY RECORD X GRANTED 1
1130 PRIMARY RECORD X GRANTED 3
1131 PRIMARY RECORD X GRANTED 4
1132 PRIMARY RECORD X GRANTED 5
1133 PRIMARY RECORD X GRANTED 6
1134 PRIMARY RECORD X GRANTED 7
1135 PRIMARY RECORD X GRANTED supremum pseudo-record
1136 ROLLBACK;
1137 BEGIN;
1138 SELECT *
1139 FROM t2 FORCE INDEX (PRIMARY)
1140 WHERE id <=9
1141 ORDER BY id ASC
1142 FOR UPDATE;
1143 id
1144 1
1145 3
1146 4
1147 5
1148 6
1149 7
1150 9
1151 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1152 FROM performance_schema.data_locks
1153 WHERE object_name = 't2';
1154 index_name lock_type lock_mode lock_status lock_data
1155 NULL TABLE IX GRANTED NULL
1156 PRIMARY RECORD X GRANTED 1
1157 PRIMARY RECORD X GRANTED 3
1158 PRIMARY RECORD X GRANTED 4
1159 PRIMARY RECORD X GRANTED 5
1160 PRIMARY RECORD X GRANTED 6
1161 PRIMARY RECORD X GRANTED 7
1162 PRIMARY RECORD X GRANTED 9
1163 PRIMARY RECORD X GRANTED supremum pseudo-record
1164 ROLLBACK;
1165 BEGIN;
1166 SELECT *
1167 FROM t2 FORCE INDEX (PRIMARY)
1168 WHERE id <=9
1169 ORDER BY id DESC
1170 FOR UPDATE;
1171 id
1172 9
1173 7
1174 6
1175 5
1176 4
1177 3
1178 1
1179 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1180 FROM performance_schema.data_locks
1181 WHERE object_name = 't2';
1182 index_name lock_type lock_mode lock_status lock_data
1183 NULL TABLE IX GRANTED NULL
1184 PRIMARY RECORD X GRANTED 1
1185 PRIMARY RECORD X GRANTED 3
1186 PRIMARY RECORD X GRANTED 4
1187 PRIMARY RECORD X GRANTED 5
1188 PRIMARY RECORD X GRANTED 6
1189 PRIMARY RECORD X GRANTED 7
1190 PRIMARY RECORD X GRANTED supremum pseudo-record
1191 PRIMARY RECORD X,REC_NOT_GAP GRANTED 9
1192 ROLLBACK;
1193 BEGIN;
1194 SELECT *
1195 FROM t2 FORCE INDEX (PRIMARY)
1196 WHERE id <=10
1197 ORDER BY id ASC
1198 FOR UPDATE;
1199 id
1200 1
1201 3
1202 4
1203 5
1204 6
1205 7
1206 9
1207 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1208 FROM performance_schema.data_locks
1209 WHERE object_name = 't2';
1210 index_name lock_type lock_mode lock_status lock_data
1211 NULL TABLE IX GRANTED NULL
1212 PRIMARY RECORD X GRANTED 1
1213 PRIMARY RECORD X GRANTED 3
1214 PRIMARY RECORD X GRANTED 4
1215 PRIMARY RECORD X GRANTED 5
1216 PRIMARY RECORD X GRANTED 6
1217 PRIMARY RECORD X GRANTED 7
1218 PRIMARY RECORD X GRANTED 9
1219 PRIMARY RECORD X GRANTED supremum pseudo-record
1220 ROLLBACK;
1221 BEGIN;
1222 SELECT *
1223 FROM t2 FORCE INDEX (PRIMARY)
1224 WHERE id <=10
1225 ORDER BY id DESC
1226 FOR UPDATE;
1227 id
1228 9
1229 7
1230 6
1231 5
1232 4
1233 3
1234 1
1235 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1236 FROM performance_schema.data_locks
1237 WHERE object_name = 't2';
1238 index_name lock_type lock_mode lock_status lock_data
1239 NULL TABLE IX GRANTED NULL
1240 PRIMARY RECORD X GRANTED 1
1241 PRIMARY RECORD X GRANTED 3
1242 PRIMARY RECORD X GRANTED 4
1243 PRIMARY RECORD X GRANTED 5
1244 PRIMARY RECORD X GRANTED 6
1245 PRIMARY RECORD X GRANTED 7
1246 PRIMARY RECORD X GRANTED 9
1247 PRIMARY RECORD X GRANTED supremum pseudo-record
1248 ROLLBACK;
1249 BEGIN;
1250 SELECT *
1251 FROM t2 FORCE INDEX (PRIMARY)
1252 WHERE id >=10
1253 ORDER BY id ASC
1254 FOR UPDATE;
1255 id
1256 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1257 FROM performance_schema.data_locks
1258 WHERE object_name = 't2';
1259 index_name lock_type lock_mode lock_status lock_data
1260 NULL TABLE IX GRANTED NULL
1261 PRIMARY RECORD X,GAP GRANTED 9
1262 ROLLBACK;
1263 BEGIN;
1264 SELECT *
1265 FROM t2 FORCE INDEX (PRIMARY)
1266 WHERE id >=10
1267 ORDER BY id DESC
1268 FOR UPDATE;
1269 id
1270 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1271 FROM performance_schema.data_locks
1272 WHERE object_name = 't2';
1273 index_name lock_type lock_mode lock_status lock_data
1274 NULL TABLE IX GRANTED NULL
1275 PRIMARY RECORD X,GAP GRANTED 9
1276 ROLLBACK;
1277 BEGIN;
1278 SELECT *
1279 FROM t2 FORCE INDEX (PRIMARY)
1280 WHERE id >9
1281 ORDER BY id ASC
1282 FOR UPDATE;
1283 id
1284 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1285 FROM performance_schema.data_locks
1286 WHERE object_name = 't2';
1287 index_name lock_type lock_mode lock_status lock_data
1288 NULL TABLE IX GRANTED NULL
1289 PRIMARY RECORD X,GAP GRANTED 9
1290 ROLLBACK;
1291 BEGIN;
1292 SELECT *
1293 FROM t2 FORCE INDEX (PRIMARY)
1294 WHERE id >9
1295 ORDER BY id DESC
1296 FOR UPDATE;
1297 id
1298 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1299 FROM performance_schema.data_locks
1300 WHERE object_name = 't2';
1301 index_name lock_type lock_mode lock_status lock_data
1302 NULL TABLE IX GRANTED NULL
1303 PRIMARY RECORD X,GAP GRANTED 9
1304 ROLLBACK;
1305 BEGIN;
1306 SELECT *
1307 FROM t2 FORCE INDEX (PRIMARY)
1308 WHERE id >=9
1309 ORDER BY id ASC
1310 FOR UPDATE;
1311 id
1312 9
1313 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1314 FROM performance_schema.data_locks
1315 WHERE object_name = 't2';
1316 index_name lock_type lock_mode lock_status lock_data
1317 NULL TABLE IX GRANTED NULL
1318 PRIMARY RECORD X GRANTED 9
1319 PRIMARY RECORD X,GAP GRANTED 7
1320 ROLLBACK;
1321 BEGIN;
1322 SELECT *
1323 FROM t2 FORCE INDEX (PRIMARY)
1324 WHERE id >=9
1325 ORDER BY id DESC
1326 FOR UPDATE;
1327 id
1328 9
1329 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1330 FROM performance_schema.data_locks
1331 WHERE object_name = 't2';
1332 index_name lock_type lock_mode lock_status lock_data
1333 NULL TABLE IX GRANTED NULL
1334 PRIMARY RECORD X GRANTED 9
1335 ROLLBACK;
1336 BEGIN;
1337 SELECT *
1338 FROM t2 FORCE INDEX (PRIMARY)
1339 WHERE id >3
1340 ORDER BY id ASC
1341 FOR UPDATE;
1342 id
1343 4
1344 5
1345 6
1346 7
1347 9
1348 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1349 FROM performance_schema.data_locks
1350 WHERE object_name = 't2';
1351 index_name lock_type lock_mode lock_status lock_data
1352 NULL TABLE IX GRANTED NULL
1353 PRIMARY RECORD X GRANTED 4
1354 PRIMARY RECORD X GRANTED 5
1355 PRIMARY RECORD X GRANTED 6
1356 PRIMARY RECORD X GRANTED 7
1357 PRIMARY RECORD X GRANTED 9
1358 PRIMARY RECORD X,GAP GRANTED 3
1359 ROLLBACK;
1360 BEGIN;
1361 SELECT *
1362 FROM t2 FORCE INDEX (PRIMARY)
1363 WHERE id >3
1364 ORDER BY id DESC
1365 FOR UPDATE;
1366 id
1367 9
1368 7
1369 6
1370 5
1371 4
1372 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1373 FROM performance_schema.data_locks
1374 WHERE object_name = 't2';
1375 index_name lock_type lock_mode lock_status lock_data
1376 NULL TABLE IX GRANTED NULL
1377 PRIMARY RECORD X GRANTED 4
1378 PRIMARY RECORD X GRANTED 5
1379 PRIMARY RECORD X GRANTED 6
1380 PRIMARY RECORD X GRANTED 7
1381 PRIMARY RECORD X GRANTED 9
1382 PRIMARY RECORD X,GAP GRANTED 3
1383 ROLLBACK;
1384 BEGIN;
1385 SELECT *
1386 FROM t2 FORCE INDEX (PRIMARY)
1387 WHERE id >=3
1388 ORDER BY id ASC
1389 FOR UPDATE;
1390 id
1391 3
1392 4
1393 5
1394 6
1395 7
1396 9
1397 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1398 FROM performance_schema.data_locks
1399 WHERE object_name = 't2';
1400 index_name lock_type lock_mode lock_status lock_data
1401 NULL TABLE IX GRANTED NULL
1402 PRIMARY RECORD X GRANTED 3
1403 PRIMARY RECORD X GRANTED 4
1404 PRIMARY RECORD X GRANTED 5
1405 PRIMARY RECORD X GRANTED 6
1406 PRIMARY RECORD X GRANTED 7
1407 PRIMARY RECORD X GRANTED 9
1408 PRIMARY RECORD X,GAP GRANTED 1
1409 ROLLBACK;
1410 BEGIN;
1411 SELECT *
1412 FROM t2 FORCE INDEX (PRIMARY)
1413 WHERE id >=3
1414 ORDER BY id DESC
1415 FOR UPDATE;
1416 id
1417 9
1418 7
1419 6
1420 5
1421 4
1422 3
1423 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1424 FROM performance_schema.data_locks
1425 WHERE object_name = 't2';
1426 index_name lock_type lock_mode lock_status lock_data
1427 NULL TABLE IX GRANTED NULL
1428 PRIMARY RECORD X GRANTED 3
1429 PRIMARY RECORD X GRANTED 4
1430 PRIMARY RECORD X GRANTED 5
1431 PRIMARY RECORD X GRANTED 6
1432 PRIMARY RECORD X GRANTED 7
1433 PRIMARY RECORD X GRANTED 9
1434 ROLLBACK;
1435 BEGIN;
1436 SELECT *
1437 FROM t2 FORCE INDEX (PRIMARY)
1438 WHERE id >=2
1439 ORDER BY id ASC
1440 FOR UPDATE;
1441 id
1442 3
1443 4
1444 5
1445 6
1446 7
1447 9
1448 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1449 FROM performance_schema.data_locks
1450 WHERE object_name = 't2';
1451 index_name lock_type lock_mode lock_status lock_data
1452 NULL TABLE IX GRANTED NULL
1453 PRIMARY RECORD X GRANTED 3
1454 PRIMARY RECORD X GRANTED 4
1455 PRIMARY RECORD X GRANTED 5
1456 PRIMARY RECORD X GRANTED 6
1457 PRIMARY RECORD X GRANTED 7
1458 PRIMARY RECORD X GRANTED 9
1459 PRIMARY RECORD X,GAP GRANTED 1
1460 ROLLBACK;
1461 BEGIN;
1462 SELECT *
1463 FROM t2 FORCE INDEX (PRIMARY)
1464 WHERE id >=2
1465 ORDER BY id DESC
1466 FOR UPDATE;
1467 id
1468 9
1469 7
1470 6
1471 5
1472 4
1473 3
1474 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1475 FROM performance_schema.data_locks
1476 WHERE object_name = 't2';
1477 index_name lock_type lock_mode lock_status lock_data
1478 NULL TABLE IX GRANTED NULL
1479 PRIMARY RECORD X GRANTED 3
1480 PRIMARY RECORD X GRANTED 4
1481 PRIMARY RECORD X GRANTED 5
1482 PRIMARY RECORD X GRANTED 6
1483 PRIMARY RECORD X GRANTED 7
1484 PRIMARY RECORD X GRANTED 9
1485 PRIMARY RECORD X,GAP GRANTED 1
1486 ROLLBACK;
1487 BEGIN;
1488 SELECT *
1489 FROM t2 FORCE INDEX (PRIMARY)
1490 WHERE id >1
1491 ORDER BY id ASC
1492 FOR UPDATE;
1493 id
1494 3
1495 4
1496 5
1497 6
1498 7
1499 9
1500 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1501 FROM performance_schema.data_locks
1502 WHERE object_name = 't2';
1503 index_name lock_type lock_mode lock_status lock_data
1504 NULL TABLE IX GRANTED NULL
1505 PRIMARY RECORD X GRANTED 3
1506 PRIMARY RECORD X GRANTED 4
1507 PRIMARY RECORD X GRANTED 5
1508 PRIMARY RECORD X GRANTED 6
1509 PRIMARY RECORD X GRANTED 7
1510 PRIMARY RECORD X GRANTED 9
1511 PRIMARY RECORD X,GAP GRANTED 1
1512 ROLLBACK;
1513 BEGIN;
1514 SELECT *
1515 FROM t2 FORCE INDEX (PRIMARY)
1516 WHERE id >1
1517 ORDER BY id DESC
1518 FOR UPDATE;
1519 id
1520 9
1521 7
1522 6
1523 5
1524 4
1525 3
1526 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1527 FROM performance_schema.data_locks
1528 WHERE object_name = 't2';
1529 index_name lock_type lock_mode lock_status lock_data
1530 NULL TABLE IX GRANTED NULL
1531 PRIMARY RECORD X GRANTED 3
1532 PRIMARY RECORD X GRANTED 4
1533 PRIMARY RECORD X GRANTED 5
1534 PRIMARY RECORD X GRANTED 6
1535 PRIMARY RECORD X GRANTED 7
1536 PRIMARY RECORD X GRANTED 9
1537 PRIMARY RECORD X,GAP GRANTED 1
1538 ROLLBACK;
1539 BEGIN;
1540 SELECT *
1541 FROM t2 FORCE INDEX (PRIMARY)
1542 WHERE id >=1
1543 ORDER BY id ASC
1544 FOR UPDATE;
1545 id
1546 1
1547 3
1548 4
1549 5
1550 6
1551 7
1552 9
1553 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1554 FROM performance_schema.data_locks
1555 WHERE object_name = 't2';
1556 index_name lock_type lock_mode lock_status lock_data
1557 NULL TABLE IX GRANTED NULL
1558 PRIMARY RECORD X GRANTED 1
1559 PRIMARY RECORD X GRANTED 3
1560 PRIMARY RECORD X GRANTED 4
1561 PRIMARY RECORD X GRANTED 5
1562 PRIMARY RECORD X GRANTED 6
1563 PRIMARY RECORD X GRANTED 7
1564 PRIMARY RECORD X GRANTED 9
1565 PRIMARY RECORD X GRANTED supremum pseudo-record
1566 ROLLBACK;
1567 BEGIN;
1568 SELECT *
1569 FROM t2 FORCE INDEX (PRIMARY)
1570 WHERE id >=1
1571 ORDER BY id DESC
1572 FOR UPDATE;
1573 id
1574 9
1575 7
1576 6
1577 5
1578 4
1579 3
1580 1
1581 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1582 FROM performance_schema.data_locks
1583 WHERE object_name = 't2';
1584 index_name lock_type lock_mode lock_status lock_data
1585 NULL TABLE IX GRANTED NULL
1586 PRIMARY RECORD X GRANTED 1
1587 PRIMARY RECORD X GRANTED 3
1588 PRIMARY RECORD X GRANTED 4
1589 PRIMARY RECORD X GRANTED 5
1590 PRIMARY RECORD X GRANTED 6
1591 PRIMARY RECORD X GRANTED 7
1592 PRIMARY RECORD X GRANTED 9
1593 PRIMARY RECORD X GRANTED supremum pseudo-record
1594 ROLLBACK;
1595 BEGIN;
1596 SELECT *
1597 FROM t2 FORCE INDEX (PRIMARY)
1598 WHERE id >0
1599 ORDER BY id ASC
1600 FOR UPDATE;
1601 id
1602 1
1603 3
1604 4
1605 5
1606 6
1607 7
1608 9
1609 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1610 FROM performance_schema.data_locks
1611 WHERE object_name = 't2';
1612 index_name lock_type lock_mode lock_status lock_data
1613 NULL TABLE IX GRANTED NULL
1614 PRIMARY RECORD X GRANTED 1
1615 PRIMARY RECORD X GRANTED 3
1616 PRIMARY RECORD X GRANTED 4
1617 PRIMARY RECORD X GRANTED 5
1618 PRIMARY RECORD X GRANTED 6
1619 PRIMARY RECORD X GRANTED 7
1620 PRIMARY RECORD X GRANTED 9
1621 PRIMARY RECORD X GRANTED supremum pseudo-record
1622 ROLLBACK;
1623 BEGIN;
1624 SELECT *
1625 FROM t2 FORCE INDEX (PRIMARY)
1626 WHERE id >0
1627 ORDER BY id DESC
1628 FOR UPDATE;
1629 id
1630 9
1631 7
1632 6
1633 5
1634 4
1635 3
1636 1
1637 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1638 FROM performance_schema.data_locks
1639 WHERE object_name = 't2';
1640 index_name lock_type lock_mode lock_status lock_data
1641 NULL TABLE IX GRANTED NULL
1642 PRIMARY RECORD X GRANTED 1
1643 PRIMARY RECORD X GRANTED 3
1644 PRIMARY RECORD X GRANTED 4
1645 PRIMARY RECORD X GRANTED 5
1646 PRIMARY RECORD X GRANTED 6
1647 PRIMARY RECORD X GRANTED 7
1648 PRIMARY RECORD X GRANTED 9
1649 PRIMARY RECORD X GRANTED supremum pseudo-record
1650 ROLLBACK;
1651 DROP TABLE t2;
1652 CREATE TABLE t1 (
1653 id1 INT NOT NULL,
1654 id2 INT NOT NULL,
1655 PRIMARY KEY (id1 ASC, id2 ASC)
1656 ) ENGINE=InnoDB;
1657 CREATE TABLE t2 (
1658 id1 INT NOT NULL,
1659 id2 INT NOT NULL,
1660 PRIMARY KEY (id1 ASC, id2 DESC)
1661 ) ENGINE=InnoDB;
1662 CREATE TABLE t3 (
1663 id1 INT NOT NULL,
1664 id2 INT NOT NULL,
1665 PRIMARY KEY (id1 DESC, id2 ASC)
1666 ) ENGINE=InnoDB;
1667 CREATE TABLE t4 (
1668 id1 INT NOT NULL,
1669 id2 INT NOT NULL,
1670 PRIMARY KEY (id1 DESC, id2 DESC)
1671 ) ENGINE=InnoDB;
1672 SET @conditions = CONCAT(
1673 '<0 <1 <3 <=3 <=4 <5 <=5 ',
1674 '>6 >5 >3 >=3 >=2 >1 >=1'
1675 );
1676 INSERT INTO t1 (id1,id2) VALUES
1677 (1,1),(1,3),(1,5),(3,1),(3,3),(3,5),(5,1),(5,3),(5,5);
1678 ANALYZE TABLE t1;
1679 Table Op Msg_type Msg_text
1680 test.t1 analyze status OK
1681 BEGIN;
1682 SELECT *
1683 FROM t1 FORCE INDEX (PRIMARY)
1684 WHERE id1 <0
1685 ORDER BY id1 ASC
1686 FOR UPDATE;
1687 id1 id2
1688 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1689 FROM performance_schema.data_locks
1690 WHERE object_name = 't1';
1691 index_name lock_type lock_mode lock_status lock_data
1692 NULL TABLE IX GRANTED NULL
1693 PRIMARY RECORD X,GAP GRANTED 1, 1
1694 ROLLBACK;
1695 BEGIN;
1696 SELECT *
1697 FROM t1 FORCE INDEX (PRIMARY)
1698 WHERE id1=3 AND id2 <0
1699 ORDER BY id2 ASC
1700 FOR UPDATE;
1701 id1 id2
1702 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1703 FROM performance_schema.data_locks
1704 WHERE object_name = 't1';
1705 index_name lock_type lock_mode lock_status lock_data
1706 NULL TABLE IX GRANTED NULL
1707 PRIMARY RECORD X,GAP GRANTED 3, 1
1708 ROLLBACK;
1709 BEGIN;
1710 SELECT *
1711 FROM t1 FORCE INDEX (PRIMARY)
1712 WHERE id1 <0
1713 ORDER BY id1 DESC
1714 FOR UPDATE;
1715 id1 id2
1716 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1717 FROM performance_schema.data_locks
1718 WHERE object_name = 't1';
1719 index_name lock_type lock_mode lock_status lock_data
1720 NULL TABLE IX GRANTED NULL
1721 PRIMARY RECORD X,GAP GRANTED 1, 1
1722 ROLLBACK;
1723 BEGIN;
1724 SELECT *
1725 FROM t1 FORCE INDEX (PRIMARY)
1726 WHERE id1=3 AND id2 <0
1727 ORDER BY id2 DESC
1728 FOR UPDATE;
1729 id1 id2
1730 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1731 FROM performance_schema.data_locks
1732 WHERE object_name = 't1';
1733 index_name lock_type lock_mode lock_status lock_data
1734 NULL TABLE IX GRANTED NULL
1735 PRIMARY RECORD X GRANTED 1, 5
1736 PRIMARY RECORD X,GAP GRANTED 3, 1
1737 ROLLBACK;
1738 BEGIN;
1739 SELECT *
1740 FROM t1 FORCE INDEX (PRIMARY)
1741 WHERE id1 <1
1742 ORDER BY id1 ASC
1743 FOR UPDATE;
1744 id1 id2
1745 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1746 FROM performance_schema.data_locks
1747 WHERE object_name = 't1';
1748 index_name lock_type lock_mode lock_status lock_data
1749 NULL TABLE IX GRANTED NULL
1750 PRIMARY RECORD X,GAP GRANTED 1, 1
1751 ROLLBACK;
1752 BEGIN;
1753 SELECT *
1754 FROM t1 FORCE INDEX (PRIMARY)
1755 WHERE id1=3 AND id2 <1
1756 ORDER BY id2 ASC
1757 FOR UPDATE;
1758 id1 id2
1759 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1760 FROM performance_schema.data_locks
1761 WHERE object_name = 't1';
1762 index_name lock_type lock_mode lock_status lock_data
1763 NULL TABLE IX GRANTED NULL
1764 PRIMARY RECORD X,GAP GRANTED 3, 1
1765 ROLLBACK;
1766 BEGIN;
1767 SELECT *
1768 FROM t1 FORCE INDEX (PRIMARY)
1769 WHERE id1 <1
1770 ORDER BY id1 DESC
1771 FOR UPDATE;
1772 id1 id2
1773 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1774 FROM performance_schema.data_locks
1775 WHERE object_name = 't1';
1776 index_name lock_type lock_mode lock_status lock_data
1777 NULL TABLE IX GRANTED NULL
1778 PRIMARY RECORD X,GAP GRANTED 1, 1
1779 ROLLBACK;
1780 BEGIN;
1781 SELECT *
1782 FROM t1 FORCE INDEX (PRIMARY)
1783 WHERE id1=3 AND id2 <1
1784 ORDER BY id2 DESC
1785 FOR UPDATE;
1786 id1 id2
1787 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1788 FROM performance_schema.data_locks
1789 WHERE object_name = 't1';
1790 index_name lock_type lock_mode lock_status lock_data
1791 NULL TABLE IX GRANTED NULL
1792 PRIMARY RECORD X GRANTED 1, 5
1793 PRIMARY RECORD X,GAP GRANTED 3, 1
1794 ROLLBACK;
1795 BEGIN;
1796 SELECT *
1797 FROM t1 FORCE INDEX (PRIMARY)
1798 WHERE id1 <3
1799 ORDER BY id1 ASC
1800 FOR UPDATE;
1801 id1 id2
1802 1 1
1803 1 3
1804 1 5
1805 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1806 FROM performance_schema.data_locks
1807 WHERE object_name = 't1';
1808 index_name lock_type lock_mode lock_status lock_data
1809 NULL TABLE IX GRANTED NULL
1810 PRIMARY RECORD X GRANTED 1, 1
1811 PRIMARY RECORD X GRANTED 1, 3
1812 PRIMARY RECORD X GRANTED 1, 5
1813 PRIMARY RECORD X,GAP GRANTED 3, 1
1814 ROLLBACK;
1815 BEGIN;
1816 SELECT *
1817 FROM t1 FORCE INDEX (PRIMARY)
1818 WHERE id1=3 AND id2 <3
1819 ORDER BY id2 ASC
1820 FOR UPDATE;
1821 id1 id2
1822 3 1
1823 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1824 FROM performance_schema.data_locks
1825 WHERE object_name = 't1';
1826 index_name lock_type lock_mode lock_status lock_data
1827 NULL TABLE IX GRANTED NULL
1828 PRIMARY RECORD X GRANTED 3, 1
1829 PRIMARY RECORD X,GAP GRANTED 3, 3
1830 ROLLBACK;
1831 BEGIN;
1832 SELECT *
1833 FROM t1 FORCE INDEX (PRIMARY)
1834 WHERE id1 <3
1835 ORDER BY id1 DESC
1836 FOR UPDATE;
1837 id1 id2
1838 1 5
1839 1 3
1840 1 1
1841 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1842 FROM performance_schema.data_locks
1843 WHERE object_name = 't1';
1844 index_name lock_type lock_mode lock_status lock_data
1845 NULL TABLE IX GRANTED NULL
1846 PRIMARY RECORD X GRANTED 1, 1
1847 PRIMARY RECORD X GRANTED 1, 3
1848 PRIMARY RECORD X GRANTED 1, 5
1849 PRIMARY RECORD X,GAP GRANTED 3, 1
1850 ROLLBACK;
1851 BEGIN;
1852 SELECT *
1853 FROM t1 FORCE INDEX (PRIMARY)
1854 WHERE id1=3 AND id2 <3
1855 ORDER BY id2 DESC
1856 FOR UPDATE;
1857 id1 id2
1858 3 1
1859 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1860 FROM performance_schema.data_locks
1861 WHERE object_name = 't1';
1862 index_name lock_type lock_mode lock_status lock_data
1863 NULL TABLE IX GRANTED NULL
1864 PRIMARY RECORD X GRANTED 1, 5
1865 PRIMARY RECORD X GRANTED 3, 1
1866 PRIMARY RECORD X,GAP GRANTED 3, 3
1867 ROLLBACK;
1868 BEGIN;
1869 SELECT *
1870 FROM t1 FORCE INDEX (PRIMARY)
1871 WHERE id1 <=3
1872 ORDER BY id1 ASC
1873 FOR UPDATE;
1874 id1 id2
1875 1 1
1876 1 3
1877 1 5
1878 3 1
1879 3 3
1880 3 5
1881 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1882 FROM performance_schema.data_locks
1883 WHERE object_name = 't1';
1884 index_name lock_type lock_mode lock_status lock_data
1885 NULL TABLE IX GRANTED NULL
1886 PRIMARY RECORD X GRANTED 1, 1
1887 PRIMARY RECORD X GRANTED 1, 3
1888 PRIMARY RECORD X GRANTED 1, 5
1889 PRIMARY RECORD X GRANTED 3, 1
1890 PRIMARY RECORD X GRANTED 3, 3
1891 PRIMARY RECORD X GRANTED 3, 5
1892 PRIMARY RECORD X,GAP GRANTED 5, 1
1893 ROLLBACK;
1894 BEGIN;
1895 SELECT *
1896 FROM t1 FORCE INDEX (PRIMARY)
1897 WHERE id1=3 AND id2 <=3
1898 ORDER BY id2 ASC
1899 FOR UPDATE;
1900 id1 id2
1901 3 1
1902 3 3
1903 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1904 FROM performance_schema.data_locks
1905 WHERE object_name = 't1';
1906 index_name lock_type lock_mode lock_status lock_data
1907 NULL TABLE IX GRANTED NULL
1908 PRIMARY RECORD X GRANTED 3, 1
1909 PRIMARY RECORD X GRANTED 3, 3
1910 ROLLBACK;
1911 BEGIN;
1912 SELECT *
1913 FROM t1 FORCE INDEX (PRIMARY)
1914 WHERE id1 <=3
1915 ORDER BY id1 DESC
1916 FOR UPDATE;
1917 id1 id2
1918 3 5
1919 3 3
1920 3 1
1921 1 5
1922 1 3
1923 1 1
1924 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1925 FROM performance_schema.data_locks
1926 WHERE object_name = 't1';
1927 index_name lock_type lock_mode lock_status lock_data
1928 NULL TABLE IX GRANTED NULL
1929 PRIMARY RECORD X GRANTED 1, 1
1930 PRIMARY RECORD X GRANTED 1, 3
1931 PRIMARY RECORD X GRANTED 1, 5
1932 PRIMARY RECORD X GRANTED 3, 1
1933 PRIMARY RECORD X GRANTED 3, 3
1934 PRIMARY RECORD X GRANTED 3, 5
1935 PRIMARY RECORD X,GAP GRANTED 5, 1
1936 ROLLBACK;
1937 BEGIN;
1938 SELECT *
1939 FROM t1 FORCE INDEX (PRIMARY)
1940 WHERE id1=3 AND id2 <=3
1941 ORDER BY id2 DESC
1942 FOR UPDATE;
1943 id1 id2
1944 3 3
1945 3 1
1946 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1947 FROM performance_schema.data_locks
1948 WHERE object_name = 't1';
1949 index_name lock_type lock_mode lock_status lock_data
1950 NULL TABLE IX GRANTED NULL
1951 PRIMARY RECORD X GRANTED 1, 5
1952 PRIMARY RECORD X GRANTED 3, 1
1953 PRIMARY RECORD X GRANTED 3, 3
1954 PRIMARY RECORD X,GAP GRANTED 3, 5
1955 ROLLBACK;
1956 BEGIN;
1957 SELECT *
1958 FROM t1 FORCE INDEX (PRIMARY)
1959 WHERE id1 <=4
1960 ORDER BY id1 ASC
1961 FOR UPDATE;
1962 id1 id2
1963 1 1
1964 1 3
1965 1 5
1966 3 1
1967 3 3
1968 3 5
1969 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1970 FROM performance_schema.data_locks
1971 WHERE object_name = 't1';
1972 index_name lock_type lock_mode lock_status lock_data
1973 NULL TABLE IX GRANTED NULL
1974 PRIMARY RECORD X GRANTED 1, 1
1975 PRIMARY RECORD X GRANTED 1, 3
1976 PRIMARY RECORD X GRANTED 1, 5
1977 PRIMARY RECORD X GRANTED 3, 1
1978 PRIMARY RECORD X GRANTED 3, 3
1979 PRIMARY RECORD X GRANTED 3, 5
1980 PRIMARY RECORD X,GAP GRANTED 5, 1
1981 ROLLBACK;
1982 BEGIN;
1983 SELECT *
1984 FROM t1 FORCE INDEX (PRIMARY)
1985 WHERE id1=3 AND id2 <=4
1986 ORDER BY id2 ASC
1987 FOR UPDATE;
1988 id1 id2
1989 3 1
1990 3 3
1991 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
1992 FROM performance_schema.data_locks
1993 WHERE object_name = 't1';
1994 index_name lock_type lock_mode lock_status lock_data
1995 NULL TABLE IX GRANTED NULL
1996 PRIMARY RECORD X GRANTED 3, 1
1997 PRIMARY RECORD X GRANTED 3, 3
1998 PRIMARY RECORD X,GAP GRANTED 3, 5
1999 ROLLBACK;
2000 BEGIN;
2001 SELECT *
2002 FROM t1 FORCE INDEX (PRIMARY)
2003 WHERE id1 <=4
2004 ORDER BY id1 DESC
2005 FOR UPDATE;
2006 id1 id2
2007 3 5
2008 3 3
2009 3 1
2010 1 5
2011 1 3
2012 1 1
2013 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2014 FROM performance_schema.data_locks
2015 WHERE object_name = 't1';
2016 index_name lock_type lock_mode lock_status lock_data
2017 NULL TABLE IX GRANTED NULL
2018 PRIMARY RECORD X GRANTED 1, 1
2019 PRIMARY RECORD X GRANTED 1, 3
2020 PRIMARY RECORD X GRANTED 1, 5
2021 PRIMARY RECORD X GRANTED 3, 1
2022 PRIMARY RECORD X GRANTED 3, 3
2023 PRIMARY RECORD X GRANTED 3, 5
2024 PRIMARY RECORD X,GAP GRANTED 5, 1
2025 ROLLBACK;
2026 BEGIN;
2027 SELECT *
2028 FROM t1 FORCE INDEX (PRIMARY)
2029 WHERE id1=3 AND id2 <=4
2030 ORDER BY id2 DESC
2031 FOR UPDATE;
2032 id1 id2
2033 3 3
2034 3 1
2035 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2036 FROM performance_schema.data_locks
2037 WHERE object_name = 't1';
2038 index_name lock_type lock_mode lock_status lock_data
2039 NULL TABLE IX GRANTED NULL
2040 PRIMARY RECORD X GRANTED 1, 5
2041 PRIMARY RECORD X GRANTED 3, 1
2042 PRIMARY RECORD X GRANTED 3, 3
2043 PRIMARY RECORD X,GAP GRANTED 3, 5
2044 ROLLBACK;
2045 BEGIN;
2046 SELECT *
2047 FROM t1 FORCE INDEX (PRIMARY)
2048 WHERE id1 <5
2049 ORDER BY id1 ASC
2050 FOR UPDATE;
2051 id1 id2
2052 1 1
2053 1 3
2054 1 5
2055 3 1
2056 3 3
2057 3 5
2058 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2059 FROM performance_schema.data_locks
2060 WHERE object_name = 't1';
2061 index_name lock_type lock_mode lock_status lock_data
2062 NULL TABLE IX GRANTED NULL
2063 PRIMARY RECORD X GRANTED 1, 1
2064 PRIMARY RECORD X GRANTED 1, 3
2065 PRIMARY RECORD X GRANTED 1, 5
2066 PRIMARY RECORD X GRANTED 3, 1
2067 PRIMARY RECORD X GRANTED 3, 3
2068 PRIMARY RECORD X GRANTED 3, 5
2069 PRIMARY RECORD X,GAP GRANTED 5, 1
2070 ROLLBACK;
2071 BEGIN;
2072 SELECT *
2073 FROM t1 FORCE INDEX (PRIMARY)
2074 WHERE id1=3 AND id2 <5
2075 ORDER BY id2 ASC
2076 FOR UPDATE;
2077 id1 id2
2078 3 1
2079 3 3
2080 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2081 FROM performance_schema.data_locks
2082 WHERE object_name = 't1';
2083 index_name lock_type lock_mode lock_status lock_data
2084 NULL TABLE IX GRANTED NULL
2085 PRIMARY RECORD X GRANTED 3, 1
2086 PRIMARY RECORD X GRANTED 3, 3
2087 PRIMARY RECORD X,GAP GRANTED 3, 5
2088 ROLLBACK;
2089 BEGIN;
2090 SELECT *
2091 FROM t1 FORCE INDEX (PRIMARY)
2092 WHERE id1 <5
2093 ORDER BY id1 DESC
2094 FOR UPDATE;
2095 id1 id2
2096 3 5
2097 3 3
2098 3 1
2099 1 5
2100 1 3
2101 1 1
2102 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2103 FROM performance_schema.data_locks
2104 WHERE object_name = 't1';
2105 index_name lock_type lock_mode lock_status lock_data
2106 NULL TABLE IX GRANTED NULL
2107 PRIMARY RECORD X GRANTED 1, 1
2108 PRIMARY RECORD X GRANTED 1, 3
2109 PRIMARY RECORD X GRANTED 1, 5
2110 PRIMARY RECORD X GRANTED 3, 1
2111 PRIMARY RECORD X GRANTED 3, 3
2112 PRIMARY RECORD X GRANTED 3, 5
2113 PRIMARY RECORD X,GAP GRANTED 5, 1
2114 ROLLBACK;
2115 BEGIN;
2116 SELECT *
2117 FROM t1 FORCE INDEX (PRIMARY)
2118 WHERE id1=3 AND id2 <5
2119 ORDER BY id2 DESC
2120 FOR UPDATE;
2121 id1 id2
2122 3 3
2123 3 1
2124 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2125 FROM performance_schema.data_locks
2126 WHERE object_name = 't1';
2127 index_name lock_type lock_mode lock_status lock_data
2128 NULL TABLE IX GRANTED NULL
2129 PRIMARY RECORD X GRANTED 1, 5
2130 PRIMARY RECORD X GRANTED 3, 1
2131 PRIMARY RECORD X GRANTED 3, 3
2132 PRIMARY RECORD X,GAP GRANTED 3, 5
2133 ROLLBACK;
2134 BEGIN;
2135 SELECT *
2136 FROM t1 FORCE INDEX (PRIMARY)
2137 WHERE id1 <=5
2138 ORDER BY id1 ASC
2139 FOR UPDATE;
2140 id1 id2
2141 1 1
2142 1 3
2143 1 5
2144 3 1
2145 3 3
2146 3 5
2147 5 1
2148 5 3
2149 5 5
2150 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2151 FROM performance_schema.data_locks
2152 WHERE object_name = 't1';
2153 index_name lock_type lock_mode lock_status lock_data
2154 NULL TABLE IX GRANTED NULL
2155 PRIMARY RECORD X GRANTED 1, 1
2156 PRIMARY RECORD X GRANTED 1, 3
2157 PRIMARY RECORD X GRANTED 1, 5
2158 PRIMARY RECORD X GRANTED 3, 1
2159 PRIMARY RECORD X GRANTED 3, 3
2160 PRIMARY RECORD X GRANTED 3, 5
2161 PRIMARY RECORD X GRANTED 5, 1
2162 PRIMARY RECORD X GRANTED 5, 3
2163 PRIMARY RECORD X GRANTED 5, 5
2164 PRIMARY RECORD X GRANTED supremum pseudo-record
2165 ROLLBACK;
2166 BEGIN;
2167 SELECT *
2168 FROM t1 FORCE INDEX (PRIMARY)
2169 WHERE id1=3 AND id2 <=5
2170 ORDER BY id2 ASC
2171 FOR UPDATE;
2172 id1 id2
2173 3 1
2174 3 3
2175 3 5
2176 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2177 FROM performance_schema.data_locks
2178 WHERE object_name = 't1';
2179 index_name lock_type lock_mode lock_status lock_data
2180 NULL TABLE IX GRANTED NULL
2181 PRIMARY RECORD X GRANTED 3, 1
2182 PRIMARY RECORD X GRANTED 3, 3
2183 PRIMARY RECORD X GRANTED 3, 5
2184 ROLLBACK;
2185 BEGIN;
2186 SELECT *
2187 FROM t1 FORCE INDEX (PRIMARY)
2188 WHERE id1 <=5
2189 ORDER BY id1 DESC
2190 FOR UPDATE;
2191 id1 id2
2192 5 5
2193 5 3
2194 5 1
2195 3 5
2196 3 3
2197 3 1
2198 1 5
2199 1 3
2200 1 1
2201 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2202 FROM performance_schema.data_locks
2203 WHERE object_name = 't1';
2204 index_name lock_type lock_mode lock_status lock_data
2205 NULL TABLE IX GRANTED NULL
2206 PRIMARY RECORD X GRANTED 1, 1
2207 PRIMARY RECORD X GRANTED 1, 3
2208 PRIMARY RECORD X GRANTED 1, 5
2209 PRIMARY RECORD X GRANTED 3, 1
2210 PRIMARY RECORD X GRANTED 3, 3
2211 PRIMARY RECORD X GRANTED 3, 5
2212 PRIMARY RECORD X GRANTED 5, 1
2213 PRIMARY RECORD X GRANTED 5, 3
2214 PRIMARY RECORD X GRANTED 5, 5
2215 PRIMARY RECORD X GRANTED supremum pseudo-record
2216 ROLLBACK;
2217 BEGIN;
2218 SELECT *
2219 FROM t1 FORCE INDEX (PRIMARY)
2220 WHERE id1=3 AND id2 <=5
2221 ORDER BY id2 DESC
2222 FOR UPDATE;
2223 id1 id2
2224 3 5
2225 3 3
2226 3 1
2227 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2228 FROM performance_schema.data_locks
2229 WHERE object_name = 't1';
2230 index_name lock_type lock_mode lock_status lock_data
2231 NULL TABLE IX GRANTED NULL
2232 PRIMARY RECORD X GRANTED 1, 5
2233 PRIMARY RECORD X GRANTED 3, 1
2234 PRIMARY RECORD X GRANTED 3, 3
2235 PRIMARY RECORD X GRANTED 3, 5
2236 PRIMARY RECORD X,GAP GRANTED 5, 1
2237 ROLLBACK;
2238 BEGIN;
2239 SELECT *
2240 FROM t1 FORCE INDEX (PRIMARY)
2241 WHERE id1 >6
2242 ORDER BY id1 ASC
2243 FOR UPDATE;
2244 id1 id2
2245 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2246 FROM performance_schema.data_locks
2247 WHERE object_name = 't1';
2248 index_name lock_type lock_mode lock_status lock_data
2249 NULL TABLE IX GRANTED NULL
2250 PRIMARY RECORD X GRANTED supremum pseudo-record
2251 ROLLBACK;
2252 BEGIN;
2253 SELECT *
2254 FROM t1 FORCE INDEX (PRIMARY)
2255 WHERE id1=3 AND id2 >6
2256 ORDER BY id2 ASC
2257 FOR UPDATE;
2258 id1 id2
2259 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2260 FROM performance_schema.data_locks
2261 WHERE object_name = 't1';
2262 index_name lock_type lock_mode lock_status lock_data
2263 NULL TABLE IX GRANTED NULL
2264 PRIMARY RECORD X,GAP GRANTED 5, 1
2265 ROLLBACK;
2266 BEGIN;
2267 SELECT *
2268 FROM t1 FORCE INDEX (PRIMARY)
2269 WHERE id1 >6
2270 ORDER BY id1 DESC
2271 FOR UPDATE;
2272 id1 id2
2273 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2274 FROM performance_schema.data_locks
2275 WHERE object_name = 't1';
2276 index_name lock_type lock_mode lock_status lock_data
2277 NULL TABLE IX GRANTED NULL
2278 PRIMARY RECORD X GRANTED 5, 5
2279 PRIMARY RECORD X GRANTED supremum pseudo-record
2280 ROLLBACK;
2281 BEGIN;
2282 SELECT *
2283 FROM t1 FORCE INDEX (PRIMARY)
2284 WHERE id1=3 AND id2 >6
2285 ORDER BY id2 DESC
2286 FOR UPDATE;
2287 id1 id2
2288 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2289 FROM performance_schema.data_locks
2290 WHERE object_name = 't1';
2291 index_name lock_type lock_mode lock_status lock_data
2292 NULL TABLE IX GRANTED NULL
2293 PRIMARY RECORD X GRANTED 3, 5
2294 PRIMARY RECORD X,GAP GRANTED 5, 1
2295 ROLLBACK;
2296 BEGIN;
2297 SELECT *
2298 FROM t1 FORCE INDEX (PRIMARY)
2299 WHERE id1 >5
2300 ORDER BY id1 ASC
2301 FOR UPDATE;
2302 id1 id2
2303 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2304 FROM performance_schema.data_locks
2305 WHERE object_name = 't1';
2306 index_name lock_type lock_mode lock_status lock_data
2307 NULL TABLE IX GRANTED NULL
2308 PRIMARY RECORD X GRANTED supremum pseudo-record
2309 ROLLBACK;
2310 BEGIN;
2311 SELECT *
2312 FROM t1 FORCE INDEX (PRIMARY)
2313 WHERE id1=3 AND id2 >5
2314 ORDER BY id2 ASC
2315 FOR UPDATE;
2316 id1 id2
2317 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2318 FROM performance_schema.data_locks
2319 WHERE object_name = 't1';
2320 index_name lock_type lock_mode lock_status lock_data
2321 NULL TABLE IX GRANTED NULL
2322 PRIMARY RECORD X,GAP GRANTED 5, 1
2323 ROLLBACK;
2324 BEGIN;
2325 SELECT *
2326 FROM t1 FORCE INDEX (PRIMARY)
2327 WHERE id1 >5
2328 ORDER BY id1 DESC
2329 FOR UPDATE;
2330 id1 id2
2331 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2332 FROM performance_schema.data_locks
2333 WHERE object_name = 't1';
2334 index_name lock_type lock_mode lock_status lock_data
2335 NULL TABLE IX GRANTED NULL
2336 PRIMARY RECORD X GRANTED 5, 5
2337 PRIMARY RECORD X GRANTED supremum pseudo-record
2338 ROLLBACK;
2339 BEGIN;
2340 SELECT *
2341 FROM t1 FORCE INDEX (PRIMARY)
2342 WHERE id1=3 AND id2 >5
2343 ORDER BY id2 DESC
2344 FOR UPDATE;
2345 id1 id2
2346 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2347 FROM performance_schema.data_locks
2348 WHERE object_name = 't1';
2349 index_name lock_type lock_mode lock_status lock_data
2350 NULL TABLE IX GRANTED NULL
2351 PRIMARY RECORD X GRANTED 3, 5
2352 PRIMARY RECORD X,GAP GRANTED 5, 1
2353 ROLLBACK;
2354 BEGIN;
2355 SELECT *
2356 FROM t1 FORCE INDEX (PRIMARY)
2357 WHERE id1 >3
2358 ORDER BY id1 ASC
2359 FOR UPDATE;
2360 id1 id2
2361 5 1
2362 5 3
2363 5 5
2364 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2365 FROM performance_schema.data_locks
2366 WHERE object_name = 't1';
2367 index_name lock_type lock_mode lock_status lock_data
2368 NULL TABLE IX GRANTED NULL
2369 PRIMARY RECORD X GRANTED 5, 1
2370 PRIMARY RECORD X GRANTED 5, 3
2371 PRIMARY RECORD X GRANTED 5, 5
2372 PRIMARY RECORD X GRANTED supremum pseudo-record
2373 ROLLBACK;
2374 BEGIN;
2375 SELECT *
2376 FROM t1 FORCE INDEX (PRIMARY)
2377 WHERE id1=3 AND id2 >3
2378 ORDER BY id2 ASC
2379 FOR UPDATE;
2380 id1 id2
2381 3 5
2382 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2383 FROM performance_schema.data_locks
2384 WHERE object_name = 't1';
2385 index_name lock_type lock_mode lock_status lock_data
2386 NULL TABLE IX GRANTED NULL
2387 PRIMARY RECORD X GRANTED 3, 5
2388 PRIMARY RECORD X,GAP GRANTED 5, 1
2389 ROLLBACK;
2390 BEGIN;
2391 SELECT *
2392 FROM t1 FORCE INDEX (PRIMARY)
2393 WHERE id1 >3
2394 ORDER BY id1 DESC
2395 FOR UPDATE;
2396 id1 id2
2397 5 5
2398 5 3
2399 5 1
2400 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2401 FROM performance_schema.data_locks
2402 WHERE object_name = 't1';
2403 index_name lock_type lock_mode lock_status lock_data
2404 NULL TABLE IX GRANTED NULL
2405 PRIMARY RECORD X GRANTED 3, 5
2406 PRIMARY RECORD X GRANTED 5, 1
2407 PRIMARY RECORD X GRANTED 5, 3
2408 PRIMARY RECORD X GRANTED 5, 5
2409 PRIMARY RECORD X GRANTED supremum pseudo-record
2410 ROLLBACK;
2411 BEGIN;
2412 SELECT *
2413 FROM t1 FORCE INDEX (PRIMARY)
2414 WHERE id1=3 AND id2 >3
2415 ORDER BY id2 DESC
2416 FOR UPDATE;
2417 id1 id2
2418 3 5
2419 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2420 FROM performance_schema.data_locks
2421 WHERE object_name = 't1';
2422 index_name lock_type lock_mode lock_status lock_data
2423 NULL TABLE IX GRANTED NULL
2424 PRIMARY RECORD X GRANTED 3, 3
2425 PRIMARY RECORD X GRANTED 3, 5
2426 PRIMARY RECORD X,GAP GRANTED 5, 1
2427 ROLLBACK;
2428 BEGIN;
2429 SELECT *
2430 FROM t1 FORCE INDEX (PRIMARY)
2431 WHERE id1 >=3
2432 ORDER BY id1 ASC
2433 FOR UPDATE;
2434 id1 id2
2435 3 1
2436 3 3
2437 3 5
2438 5 1
2439 5 3
2440 5 5
2441 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2442 FROM performance_schema.data_locks
2443 WHERE object_name = 't1';
2444 index_name lock_type lock_mode lock_status lock_data
2445 NULL TABLE IX GRANTED NULL
2446 PRIMARY RECORD X GRANTED 3, 1
2447 PRIMARY RECORD X GRANTED 3, 3
2448 PRIMARY RECORD X GRANTED 3, 5
2449 PRIMARY RECORD X GRANTED 5, 1
2450 PRIMARY RECORD X GRANTED 5, 3
2451 PRIMARY RECORD X GRANTED 5, 5
2452 PRIMARY RECORD X GRANTED supremum pseudo-record
2453 ROLLBACK;
2454 BEGIN;
2455 SELECT *
2456 FROM t1 FORCE INDEX (PRIMARY)
2457 WHERE id1=3 AND id2 >=3
2458 ORDER BY id2 ASC
2459 FOR UPDATE;
2460 id1 id2
2461 3 3
2462 3 5
2463 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2464 FROM performance_schema.data_locks
2465 WHERE object_name = 't1';
2466 index_name lock_type lock_mode lock_status lock_data
2467 NULL TABLE IX GRANTED NULL
2468 PRIMARY RECORD X GRANTED 3, 5
2469 PRIMARY RECORD X,GAP GRANTED 5, 1
2470 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3, 3
2471 ROLLBACK;
2472 BEGIN;
2473 SELECT *
2474 FROM t1 FORCE INDEX (PRIMARY)
2475 WHERE id1 >=3
2476 ORDER BY id1 DESC
2477 FOR UPDATE;
2478 id1 id2
2479 5 5
2480 5 3
2481 5 1
2482 3 5
2483 3 3
2484 3 1
2485 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2486 FROM performance_schema.data_locks
2487 WHERE object_name = 't1';
2488 index_name lock_type lock_mode lock_status lock_data
2489 NULL TABLE IX GRANTED NULL
2490 PRIMARY RECORD X GRANTED 1, 5
2491 PRIMARY RECORD X GRANTED 3, 1
2492 PRIMARY RECORD X GRANTED 3, 3
2493 PRIMARY RECORD X GRANTED 3, 5
2494 PRIMARY RECORD X GRANTED 5, 1
2495 PRIMARY RECORD X GRANTED 5, 3
2496 PRIMARY RECORD X GRANTED 5, 5
2497 PRIMARY RECORD X GRANTED supremum pseudo-record
2498 ROLLBACK;
2499 BEGIN;
2500 SELECT *
2501 FROM t1 FORCE INDEX (PRIMARY)
2502 WHERE id1=3 AND id2 >=3
2503 ORDER BY id2 DESC
2504 FOR UPDATE;
2505 id1 id2
2506 3 5
2507 3 3
2508 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2509 FROM performance_schema.data_locks
2510 WHERE object_name = 't1';
2511 index_name lock_type lock_mode lock_status lock_data
2512 NULL TABLE IX GRANTED NULL
2513 PRIMARY RECORD X GRANTED 3, 1
2514 PRIMARY RECORD X GRANTED 3, 3
2515 PRIMARY RECORD X GRANTED 3, 5
2516 PRIMARY RECORD X,GAP GRANTED 5, 1
2517 ROLLBACK;
2518 BEGIN;
2519 SELECT *
2520 FROM t1 FORCE INDEX (PRIMARY)
2521 WHERE id1 >=2
2522 ORDER BY id1 ASC
2523 FOR UPDATE;
2524 id1 id2
2525 3 1
2526 3 3
2527 3 5
2528 5 1
2529 5 3
2530 5 5
2531 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2532 FROM performance_schema.data_locks
2533 WHERE object_name = 't1';
2534 index_name lock_type lock_mode lock_status lock_data
2535 NULL TABLE IX GRANTED NULL
2536 PRIMARY RECORD X GRANTED 3, 1
2537 PRIMARY RECORD X GRANTED 3, 3
2538 PRIMARY RECORD X GRANTED 3, 5
2539 PRIMARY RECORD X GRANTED 5, 1
2540 PRIMARY RECORD X GRANTED 5, 3
2541 PRIMARY RECORD X GRANTED 5, 5
2542 PRIMARY RECORD X GRANTED supremum pseudo-record
2543 ROLLBACK;
2544 BEGIN;
2545 SELECT *
2546 FROM t1 FORCE INDEX (PRIMARY)
2547 WHERE id1=3 AND id2 >=2
2548 ORDER BY id2 ASC
2549 FOR UPDATE;
2550 id1 id2
2551 3 3
2552 3 5
2553 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2554 FROM performance_schema.data_locks
2555 WHERE object_name = 't1';
2556 index_name lock_type lock_mode lock_status lock_data
2557 NULL TABLE IX GRANTED NULL
2558 PRIMARY RECORD X GRANTED 3, 3
2559 PRIMARY RECORD X GRANTED 3, 5
2560 PRIMARY RECORD X,GAP GRANTED 5, 1
2561 ROLLBACK;
2562 BEGIN;
2563 SELECT *
2564 FROM t1 FORCE INDEX (PRIMARY)
2565 WHERE id1 >=2
2566 ORDER BY id1 DESC
2567 FOR UPDATE;
2568 id1 id2
2569 5 5
2570 5 3
2571 5 1
2572 3 5
2573 3 3
2574 3 1
2575 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2576 FROM performance_schema.data_locks
2577 WHERE object_name = 't1';
2578 index_name lock_type lock_mode lock_status lock_data
2579 NULL TABLE IX GRANTED NULL
2580 PRIMARY RECORD X GRANTED 1, 5
2581 PRIMARY RECORD X GRANTED 3, 1
2582 PRIMARY RECORD X GRANTED 3, 3
2583 PRIMARY RECORD X GRANTED 3, 5
2584 PRIMARY RECORD X GRANTED 5, 1
2585 PRIMARY RECORD X GRANTED 5, 3
2586 PRIMARY RECORD X GRANTED 5, 5
2587 PRIMARY RECORD X GRANTED supremum pseudo-record
2588 ROLLBACK;
2589 BEGIN;
2590 SELECT *
2591 FROM t1 FORCE INDEX (PRIMARY)
2592 WHERE id1=3 AND id2 >=2
2593 ORDER BY id2 DESC
2594 FOR UPDATE;
2595 id1 id2
2596 3 5
2597 3 3
2598 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2599 FROM performance_schema.data_locks
2600 WHERE object_name = 't1';
2601 index_name lock_type lock_mode lock_status lock_data
2602 NULL TABLE IX GRANTED NULL
2603 PRIMARY RECORD X GRANTED 3, 1
2604 PRIMARY RECORD X GRANTED 3, 3
2605 PRIMARY RECORD X GRANTED 3, 5
2606 PRIMARY RECORD X,GAP GRANTED 5, 1
2607 ROLLBACK;
2608 BEGIN;
2609 SELECT *
2610 FROM t1 FORCE INDEX (PRIMARY)
2611 WHERE id1 >1
2612 ORDER BY id1 ASC
2613 FOR UPDATE;
2614 id1 id2
2615 3 1
2616 3 3
2617 3 5
2618 5 1
2619 5 3
2620 5 5
2621 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2622 FROM performance_schema.data_locks
2623 WHERE object_name = 't1';
2624 index_name lock_type lock_mode lock_status lock_data
2625 NULL TABLE IX GRANTED NULL
2626 PRIMARY RECORD X GRANTED 3, 1
2627 PRIMARY RECORD X GRANTED 3, 3
2628 PRIMARY RECORD X GRANTED 3, 5
2629 PRIMARY RECORD X GRANTED 5, 1
2630 PRIMARY RECORD X GRANTED 5, 3
2631 PRIMARY RECORD X GRANTED 5, 5
2632 PRIMARY RECORD X GRANTED supremum pseudo-record
2633 ROLLBACK;
2634 BEGIN;
2635 SELECT *
2636 FROM t1 FORCE INDEX (PRIMARY)
2637 WHERE id1=3 AND id2 >1
2638 ORDER BY id2 ASC
2639 FOR UPDATE;
2640 id1 id2
2641 3 3
2642 3 5
2643 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2644 FROM performance_schema.data_locks
2645 WHERE object_name = 't1';
2646 index_name lock_type lock_mode lock_status lock_data
2647 NULL TABLE IX GRANTED NULL
2648 PRIMARY RECORD X GRANTED 3, 3
2649 PRIMARY RECORD X GRANTED 3, 5
2650 PRIMARY RECORD X,GAP GRANTED 5, 1
2651 ROLLBACK;
2652 BEGIN;
2653 SELECT *
2654 FROM t1 FORCE INDEX (PRIMARY)
2655 WHERE id1 >1
2656 ORDER BY id1 DESC
2657 FOR UPDATE;
2658 id1 id2
2659 5 5
2660 5 3
2661 5 1
2662 3 5
2663 3 3
2664 3 1
2665 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2666 FROM performance_schema.data_locks
2667 WHERE object_name = 't1';
2668 index_name lock_type lock_mode lock_status lock_data
2669 NULL TABLE IX GRANTED NULL
2670 PRIMARY RECORD X GRANTED 1, 5
2671 PRIMARY RECORD X GRANTED 3, 1
2672 PRIMARY RECORD X GRANTED 3, 3
2673 PRIMARY RECORD X GRANTED 3, 5
2674 PRIMARY RECORD X GRANTED 5, 1
2675 PRIMARY RECORD X GRANTED 5, 3
2676 PRIMARY RECORD X GRANTED 5, 5
2677 PRIMARY RECORD X GRANTED supremum pseudo-record
2678 ROLLBACK;
2679 BEGIN;
2680 SELECT *
2681 FROM t1 FORCE INDEX (PRIMARY)
2682 WHERE id1=3 AND id2 >1
2683 ORDER BY id2 DESC
2684 FOR UPDATE;
2685 id1 id2
2686 3 5
2687 3 3
2688 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2689 FROM performance_schema.data_locks
2690 WHERE object_name = 't1';
2691 index_name lock_type lock_mode lock_status lock_data
2692 NULL TABLE IX GRANTED NULL
2693 PRIMARY RECORD X GRANTED 3, 1
2694 PRIMARY RECORD X GRANTED 3, 3
2695 PRIMARY RECORD X GRANTED 3, 5
2696 PRIMARY RECORD X,GAP GRANTED 5, 1
2697 ROLLBACK;
2698 BEGIN;
2699 SELECT *
2700 FROM t1 FORCE INDEX (PRIMARY)
2701 WHERE id1 >=1
2702 ORDER BY id1 ASC
2703 FOR UPDATE;
2704 id1 id2
2705 1 1
2706 1 3
2707 1 5
2708 3 1
2709 3 3
2710 3 5
2711 5 1
2712 5 3
2713 5 5
2714 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2715 FROM performance_schema.data_locks
2716 WHERE object_name = 't1';
2717 index_name lock_type lock_mode lock_status lock_data
2718 NULL TABLE IX GRANTED NULL
2719 PRIMARY RECORD X GRANTED 1, 1
2720 PRIMARY RECORD X GRANTED 1, 3
2721 PRIMARY RECORD X GRANTED 1, 5
2722 PRIMARY RECORD X GRANTED 3, 1
2723 PRIMARY RECORD X GRANTED 3, 3
2724 PRIMARY RECORD X GRANTED 3, 5
2725 PRIMARY RECORD X GRANTED 5, 1
2726 PRIMARY RECORD X GRANTED 5, 3
2727 PRIMARY RECORD X GRANTED 5, 5
2728 PRIMARY RECORD X GRANTED supremum pseudo-record
2729 ROLLBACK;
2730 BEGIN;
2731 SELECT *
2732 FROM t1 FORCE INDEX (PRIMARY)
2733 WHERE id1=3 AND id2 >=1
2734 ORDER BY id2 ASC
2735 FOR UPDATE;
2736 id1 id2
2737 3 1
2738 3 3
2739 3 5
2740 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2741 FROM performance_schema.data_locks
2742 WHERE object_name = 't1';
2743 index_name lock_type lock_mode lock_status lock_data
2744 NULL TABLE IX GRANTED NULL
2745 PRIMARY RECORD X GRANTED 3, 3
2746 PRIMARY RECORD X GRANTED 3, 5
2747 PRIMARY RECORD X,GAP GRANTED 5, 1
2748 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3, 1
2749 ROLLBACK;
2750 BEGIN;
2751 SELECT *
2752 FROM t1 FORCE INDEX (PRIMARY)
2753 WHERE id1 >=1
2754 ORDER BY id1 DESC
2755 FOR UPDATE;
2756 id1 id2
2757 5 5
2758 5 3
2759 5 1
2760 3 5
2761 3 3
2762 3 1
2763 1 5
2764 1 3
2765 1 1
2766 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2767 FROM performance_schema.data_locks
2768 WHERE object_name = 't1';
2769 index_name lock_type lock_mode lock_status lock_data
2770 NULL TABLE IX GRANTED NULL
2771 PRIMARY RECORD X GRANTED 1, 1
2772 PRIMARY RECORD X GRANTED 1, 3
2773 PRIMARY RECORD X GRANTED 1, 5
2774 PRIMARY RECORD X GRANTED 3, 1
2775 PRIMARY RECORD X GRANTED 3, 3
2776 PRIMARY RECORD X GRANTED 3, 5
2777 PRIMARY RECORD X GRANTED 5, 1
2778 PRIMARY RECORD X GRANTED 5, 3
2779 PRIMARY RECORD X GRANTED 5, 5
2780 PRIMARY RECORD X GRANTED supremum pseudo-record
2781 ROLLBACK;
2782 BEGIN;
2783 SELECT *
2784 FROM t1 FORCE INDEX (PRIMARY)
2785 WHERE id1=3 AND id2 >=1
2786 ORDER BY id2 DESC
2787 FOR UPDATE;
2788 id1 id2
2789 3 5
2790 3 3
2791 3 1
2792 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2793 FROM performance_schema.data_locks
2794 WHERE object_name = 't1';
2795 index_name lock_type lock_mode lock_status lock_data
2796 NULL TABLE IX GRANTED NULL
2797 PRIMARY RECORD X GRANTED 1, 5
2798 PRIMARY RECORD X GRANTED 3, 1
2799 PRIMARY RECORD X GRANTED 3, 3
2800 PRIMARY RECORD X GRANTED 3, 5
2801 PRIMARY RECORD X,GAP GRANTED 5, 1
2802 ROLLBACK;
2803 DROP TABLE t1;
2804 INSERT INTO t2 (id1,id2) VALUES
2805 (1,1),(1,3),(1,5),(3,1),(3,3),(3,5),(5,1),(5,3),(5,5);
2806 ANALYZE TABLE t2;
2807 Table Op Msg_type Msg_text
2808 test.t2 analyze status OK
2809 BEGIN;
2810 SELECT *
2811 FROM t2 FORCE INDEX (PRIMARY)
2812 WHERE id1 <0
2813 ORDER BY id1 ASC
2814 FOR UPDATE;
2815 id1 id2
2816 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2817 FROM performance_schema.data_locks
2818 WHERE object_name = 't2';
2819 index_name lock_type lock_mode lock_status lock_data
2820 NULL TABLE IX GRANTED NULL
2821 PRIMARY RECORD X,GAP GRANTED 1, 5
2822 ROLLBACK;
2823 BEGIN;
2824 SELECT *
2825 FROM t2 FORCE INDEX (PRIMARY)
2826 WHERE id1=3 AND id2 <0
2827 ORDER BY id2 ASC
2828 FOR UPDATE;
2829 id1 id2
2830 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2831 FROM performance_schema.data_locks
2832 WHERE object_name = 't2';
2833 index_name lock_type lock_mode lock_status lock_data
2834 NULL TABLE IX GRANTED NULL
2835 PRIMARY RECORD X,GAP GRANTED 5, 5
2836 ROLLBACK;
2837 BEGIN;
2838 SELECT *
2839 FROM t2 FORCE INDEX (PRIMARY)
2840 WHERE id1 <0
2841 ORDER BY id1 DESC
2842 FOR UPDATE;
2843 id1 id2
2844 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2845 FROM performance_schema.data_locks
2846 WHERE object_name = 't2';
2847 index_name lock_type lock_mode lock_status lock_data
2848 NULL TABLE IX GRANTED NULL
2849 PRIMARY RECORD X,GAP GRANTED 1, 5
2850 ROLLBACK;
2851 BEGIN;
2852 SELECT *
2853 FROM t2 FORCE INDEX (PRIMARY)
2854 WHERE id1=3 AND id2 <0
2855 ORDER BY id2 DESC
2856 FOR UPDATE;
2857 id1 id2
2858 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2859 FROM performance_schema.data_locks
2860 WHERE object_name = 't2';
2861 index_name lock_type lock_mode lock_status lock_data
2862 NULL TABLE IX GRANTED NULL
2863 PRIMARY RECORD X,GAP GRANTED 5, 5
2864 ROLLBACK;
2865 BEGIN;
2866 SELECT *
2867 FROM t2 FORCE INDEX (PRIMARY)
2868 WHERE id1 <1
2869 ORDER BY id1 ASC
2870 FOR UPDATE;
2871 id1 id2
2872 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2873 FROM performance_schema.data_locks
2874 WHERE object_name = 't2';
2875 index_name lock_type lock_mode lock_status lock_data
2876 NULL TABLE IX GRANTED NULL
2877 PRIMARY RECORD X,GAP GRANTED 1, 5
2878 ROLLBACK;
2879 BEGIN;
2880 SELECT *
2881 FROM t2 FORCE INDEX (PRIMARY)
2882 WHERE id1=3 AND id2 <1
2883 ORDER BY id2 ASC
2884 FOR UPDATE;
2885 id1 id2
2886 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2887 FROM performance_schema.data_locks
2888 WHERE object_name = 't2';
2889 index_name lock_type lock_mode lock_status lock_data
2890 NULL TABLE IX GRANTED NULL
2891 PRIMARY RECORD X,GAP GRANTED 5, 5
2892 ROLLBACK;
2893 BEGIN;
2894 SELECT *
2895 FROM t2 FORCE INDEX (PRIMARY)
2896 WHERE id1 <1
2897 ORDER BY id1 DESC
2898 FOR UPDATE;
2899 id1 id2
2900 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2901 FROM performance_schema.data_locks
2902 WHERE object_name = 't2';
2903 index_name lock_type lock_mode lock_status lock_data
2904 NULL TABLE IX GRANTED NULL
2905 PRIMARY RECORD X,GAP GRANTED 1, 5
2906 ROLLBACK;
2907 BEGIN;
2908 SELECT *
2909 FROM t2 FORCE INDEX (PRIMARY)
2910 WHERE id1=3 AND id2 <1
2911 ORDER BY id2 DESC
2912 FOR UPDATE;
2913 id1 id2
2914 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2915 FROM performance_schema.data_locks
2916 WHERE object_name = 't2';
2917 index_name lock_type lock_mode lock_status lock_data
2918 NULL TABLE IX GRANTED NULL
2919 PRIMARY RECORD X,GAP GRANTED 5, 5
2920 ROLLBACK;
2921 BEGIN;
2922 SELECT *
2923 FROM t2 FORCE INDEX (PRIMARY)
2924 WHERE id1 <3
2925 ORDER BY id1 ASC
2926 FOR UPDATE;
2927 id1 id2
2928 1 5
2929 1 3
2930 1 1
2931 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2932 FROM performance_schema.data_locks
2933 WHERE object_name = 't2';
2934 index_name lock_type lock_mode lock_status lock_data
2935 NULL TABLE IX GRANTED NULL
2936 PRIMARY RECORD X GRANTED 1, 1
2937 PRIMARY RECORD X GRANTED 1, 3
2938 PRIMARY RECORD X GRANTED 1, 5
2939 PRIMARY RECORD X,GAP GRANTED 3, 5
2940 ROLLBACK;
2941 BEGIN;
2942 SELECT *
2943 FROM t2 FORCE INDEX (PRIMARY)
2944 WHERE id1=3 AND id2 <3
2945 ORDER BY id2 ASC
2946 FOR UPDATE;
2947 id1 id2
2948 3 1
2949 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2950 FROM performance_schema.data_locks
2951 WHERE object_name = 't2';
2952 index_name lock_type lock_mode lock_status lock_data
2953 NULL TABLE IX GRANTED NULL
2954 PRIMARY RECORD X GRANTED 3, 1
2955 PRIMARY RECORD X,GAP GRANTED 5, 5
2956 ROLLBACK;
2957 BEGIN;
2958 SELECT *
2959 FROM t2 FORCE INDEX (PRIMARY)
2960 WHERE id1 <3
2961 ORDER BY id1 DESC
2962 FOR UPDATE;
2963 id1 id2
2964 1 1
2965 1 3
2966 1 5
2967 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2968 FROM performance_schema.data_locks
2969 WHERE object_name = 't2';
2970 index_name lock_type lock_mode lock_status lock_data
2971 NULL TABLE IX GRANTED NULL
2972 PRIMARY RECORD X GRANTED 1, 1
2973 PRIMARY RECORD X GRANTED 1, 3
2974 PRIMARY RECORD X GRANTED 1, 5
2975 PRIMARY RECORD X,GAP GRANTED 3, 5
2976 ROLLBACK;
2977 BEGIN;
2978 SELECT *
2979 FROM t2 FORCE INDEX (PRIMARY)
2980 WHERE id1=3 AND id2 <3
2981 ORDER BY id2 DESC
2982 FOR UPDATE;
2983 id1 id2
2984 3 1
2985 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
2986 FROM performance_schema.data_locks
2987 WHERE object_name = 't2';
2988 index_name lock_type lock_mode lock_status lock_data
2989 NULL TABLE IX GRANTED NULL
2990 PRIMARY RECORD X GRANTED 3, 1
2991 PRIMARY RECORD X,GAP GRANTED 5, 5
2992 ROLLBACK;
2993 BEGIN;
2994 SELECT *
2995 FROM t2 FORCE INDEX (PRIMARY)
2996 WHERE id1 <=3
2997 ORDER BY id1 ASC
2998 FOR UPDATE;
2999 id1 id2
3000 1 5
3001 1 3
3002 1 1
3003 3 5
3004 3 3
3005 3 1
3006 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3007 FROM performance_schema.data_locks
3008 WHERE object_name = 't2';
3009 index_name lock_type lock_mode lock_status lock_data
3010 NULL TABLE IX GRANTED NULL
3011 PRIMARY RECORD X GRANTED 1, 1
3012 PRIMARY RECORD X GRANTED 1, 3
3013 PRIMARY RECORD X GRANTED 1, 5
3014 PRIMARY RECORD X GRANTED 3, 1
3015 PRIMARY RECORD X GRANTED 3, 3
3016 PRIMARY RECORD X GRANTED 3, 5
3017 PRIMARY RECORD X,GAP GRANTED 5, 5
3018 ROLLBACK;
3019 BEGIN;
3020 SELECT *
3021 FROM t2 FORCE INDEX (PRIMARY)
3022 WHERE id1=3 AND id2 <=3
3023 ORDER BY id2 ASC
3024 FOR UPDATE;
3025 id1 id2
3026 3 1
3027 3 3
3028 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3029 FROM performance_schema.data_locks
3030 WHERE object_name = 't2';
3031 index_name lock_type lock_mode lock_status lock_data
3032 NULL TABLE IX GRANTED NULL
3033 PRIMARY RECORD X GRANTED 3, 1
3034 PRIMARY RECORD X,GAP GRANTED 5, 5
3035 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3, 3
3036 ROLLBACK;
3037 BEGIN;
3038 SELECT *
3039 FROM t2 FORCE INDEX (PRIMARY)
3040 WHERE id1 <=3
3041 ORDER BY id1 DESC
3042 FOR UPDATE;
3043 id1 id2
3044 3 1
3045 3 3
3046 3 5
3047 1 1
3048 1 3
3049 1 5
3050 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3051 FROM performance_schema.data_locks
3052 WHERE object_name = 't2';
3053 index_name lock_type lock_mode lock_status lock_data
3054 NULL TABLE IX GRANTED NULL
3055 PRIMARY RECORD X GRANTED 1, 1
3056 PRIMARY RECORD X GRANTED 1, 3
3057 PRIMARY RECORD X GRANTED 1, 5
3058 PRIMARY RECORD X GRANTED 3, 1
3059 PRIMARY RECORD X GRANTED 3, 3
3060 PRIMARY RECORD X GRANTED 3, 5
3061 PRIMARY RECORD X,GAP GRANTED 5, 5
3062 ROLLBACK;
3063 BEGIN;
3064 SELECT *
3065 FROM t2 FORCE INDEX (PRIMARY)
3066 WHERE id1=3 AND id2 <=3
3067 ORDER BY id2 DESC
3068 FOR UPDATE;
3069 id1 id2
3070 3 3
3071 3 1
3072 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3073 FROM performance_schema.data_locks
3074 WHERE object_name = 't2';
3075 index_name lock_type lock_mode lock_status lock_data
3076 NULL TABLE IX GRANTED NULL
3077 PRIMARY RECORD X GRANTED 3, 1
3078 PRIMARY RECORD X,GAP GRANTED 5, 5
3079 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3, 3
3080 ROLLBACK;
3081 BEGIN;
3082 SELECT *
3083 FROM t2 FORCE INDEX (PRIMARY)
3084 WHERE id1 <=4
3085 ORDER BY id1 ASC
3086 FOR UPDATE;
3087 id1 id2
3088 1 5
3089 1 3
3090 1 1
3091 3 5
3092 3 3
3093 3 1
3094 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3095 FROM performance_schema.data_locks
3096 WHERE object_name = 't2';
3097 index_name lock_type lock_mode lock_status lock_data
3098 NULL TABLE IX GRANTED NULL
3099 PRIMARY RECORD X GRANTED 1, 1
3100 PRIMARY RECORD X GRANTED 1, 3
3101 PRIMARY RECORD X GRANTED 1, 5
3102 PRIMARY RECORD X GRANTED 3, 1
3103 PRIMARY RECORD X GRANTED 3, 3
3104 PRIMARY RECORD X GRANTED 3, 5
3105 PRIMARY RECORD X,GAP GRANTED 5, 5
3106 ROLLBACK;
3107 BEGIN;
3108 SELECT *
3109 FROM t2 FORCE INDEX (PRIMARY)
3110 WHERE id1=3 AND id2 <=4
3111 ORDER BY id2 ASC
3112 FOR UPDATE;
3113 id1 id2
3114 3 1
3115 3 3
3116 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3117 FROM performance_schema.data_locks
3118 WHERE object_name = 't2';
3119 index_name lock_type lock_mode lock_status lock_data
3120 NULL TABLE IX GRANTED NULL
3121 PRIMARY RECORD X GRANTED 3, 1
3122 PRIMARY RECORD X GRANTED 3, 3
3123 PRIMARY RECORD X,GAP GRANTED 5, 5
3124 ROLLBACK;
3125 BEGIN;
3126 SELECT *
3127 FROM t2 FORCE INDEX (PRIMARY)
3128 WHERE id1 <=4
3129 ORDER BY id1 DESC
3130 FOR UPDATE;
3131 id1 id2
3132 3 1
3133 3 3
3134 3 5
3135 1 1
3136 1 3
3137 1 5
3138 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3139 FROM performance_schema.data_locks
3140 WHERE object_name = 't2';
3141 index_name lock_type lock_mode lock_status lock_data
3142 NULL TABLE IX GRANTED NULL
3143 PRIMARY RECORD X GRANTED 1, 1
3144 PRIMARY RECORD X GRANTED 1, 3
3145 PRIMARY RECORD X GRANTED 1, 5
3146 PRIMARY RECORD X GRANTED 3, 1
3147 PRIMARY RECORD X GRANTED 3, 3
3148 PRIMARY RECORD X GRANTED 3, 5
3149 PRIMARY RECORD X,GAP GRANTED 5, 5
3150 ROLLBACK;
3151 BEGIN;
3152 SELECT *
3153 FROM t2 FORCE INDEX (PRIMARY)
3154 WHERE id1=3 AND id2 <=4
3155 ORDER BY id2 DESC
3156 FOR UPDATE;
3157 id1 id2
3158 3 3
3159 3 1
3160 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3161 FROM performance_schema.data_locks
3162 WHERE object_name = 't2';
3163 index_name lock_type lock_mode lock_status lock_data
3164 NULL TABLE IX GRANTED NULL
3165 PRIMARY RECORD X GRANTED 3, 1
3166 PRIMARY RECORD X GRANTED 3, 3
3167 PRIMARY RECORD X,GAP GRANTED 5, 5
3168 ROLLBACK;
3169 BEGIN;
3170 SELECT *
3171 FROM t2 FORCE INDEX (PRIMARY)
3172 WHERE id1 <5
3173 ORDER BY id1 ASC
3174 FOR UPDATE;
3175 id1 id2
3176 1 5
3177 1 3
3178 1 1
3179 3 5
3180 3 3
3181 3 1
3182 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3183 FROM performance_schema.data_locks
3184 WHERE object_name = 't2';
3185 index_name lock_type lock_mode lock_status lock_data
3186 NULL TABLE IX GRANTED NULL
3187 PRIMARY RECORD X GRANTED 1, 1
3188 PRIMARY RECORD X GRANTED 1, 3
3189 PRIMARY RECORD X GRANTED 1, 5
3190 PRIMARY RECORD X GRANTED 3, 1
3191 PRIMARY RECORD X GRANTED 3, 3
3192 PRIMARY RECORD X GRANTED 3, 5
3193 PRIMARY RECORD X,GAP GRANTED 5, 5
3194 ROLLBACK;
3195 BEGIN;
3196 SELECT *
3197 FROM t2 FORCE INDEX (PRIMARY)
3198 WHERE id1=3 AND id2 <5
3199 ORDER BY id2 ASC
3200 FOR UPDATE;
3201 id1 id2
3202 3 1
3203 3 3
3204 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3205 FROM performance_schema.data_locks
3206 WHERE object_name = 't2';
3207 index_name lock_type lock_mode lock_status lock_data
3208 NULL TABLE IX GRANTED NULL
3209 PRIMARY RECORD X GRANTED 3, 1
3210 PRIMARY RECORD X GRANTED 3, 3
3211 PRIMARY RECORD X,GAP GRANTED 5, 5
3212 ROLLBACK;
3213 BEGIN;
3214 SELECT *
3215 FROM t2 FORCE INDEX (PRIMARY)
3216 WHERE id1 <5
3217 ORDER BY id1 DESC
3218 FOR UPDATE;
3219 id1 id2
3220 3 1
3221 3 3
3222 3 5
3223 1 1
3224 1 3
3225 1 5
3226 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3227 FROM performance_schema.data_locks
3228 WHERE object_name = 't2';
3229 index_name lock_type lock_mode lock_status lock_data
3230 NULL TABLE IX GRANTED NULL
3231 PRIMARY RECORD X GRANTED 1, 1
3232 PRIMARY RECORD X GRANTED 1, 3
3233 PRIMARY RECORD X GRANTED 1, 5
3234 PRIMARY RECORD X GRANTED 3, 1
3235 PRIMARY RECORD X GRANTED 3, 3
3236 PRIMARY RECORD X GRANTED 3, 5
3237 PRIMARY RECORD X,GAP GRANTED 5, 5
3238 ROLLBACK;
3239 BEGIN;
3240 SELECT *
3241 FROM t2 FORCE INDEX (PRIMARY)
3242 WHERE id1=3 AND id2 <5
3243 ORDER BY id2 DESC
3244 FOR UPDATE;
3245 id1 id2
3246 3 3
3247 3 1
3248 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3249 FROM performance_schema.data_locks
3250 WHERE object_name = 't2';
3251 index_name lock_type lock_mode lock_status lock_data
3252 NULL TABLE IX GRANTED NULL
3253 PRIMARY RECORD X GRANTED 3, 1
3254 PRIMARY RECORD X GRANTED 3, 3
3255 PRIMARY RECORD X,GAP GRANTED 5, 5
3256 ROLLBACK;
3257 BEGIN;
3258 SELECT *
3259 FROM t2 FORCE INDEX (PRIMARY)
3260 WHERE id1 <=5
3261 ORDER BY id1 ASC
3262 FOR UPDATE;
3263 id1 id2
3264 1 5
3265 1 3
3266 1 1
3267 3 5
3268 3 3
3269 3 1
3270 5 5
3271 5 3
3272 5 1
3273 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3274 FROM performance_schema.data_locks
3275 WHERE object_name = 't2';
3276 index_name lock_type lock_mode lock_status lock_data
3277 NULL TABLE IX GRANTED NULL
3278 PRIMARY RECORD X GRANTED 1, 1
3279 PRIMARY RECORD X GRANTED 1, 3
3280 PRIMARY RECORD X GRANTED 1, 5
3281 PRIMARY RECORD X GRANTED 3, 1
3282 PRIMARY RECORD X GRANTED 3, 3
3283 PRIMARY RECORD X GRANTED 3, 5
3284 PRIMARY RECORD X GRANTED 5, 1
3285 PRIMARY RECORD X GRANTED 5, 3
3286 PRIMARY RECORD X GRANTED 5, 5
3287 PRIMARY RECORD X GRANTED supremum pseudo-record
3288 ROLLBACK;
3289 BEGIN;
3290 SELECT *
3291 FROM t2 FORCE INDEX (PRIMARY)
3292 WHERE id1=3 AND id2 <=5
3293 ORDER BY id2 ASC
3294 FOR UPDATE;
3295 id1 id2
3296 3 1
3297 3 3
3298 3 5
3299 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3300 FROM performance_schema.data_locks
3301 WHERE object_name = 't2';
3302 index_name lock_type lock_mode lock_status lock_data
3303 NULL TABLE IX GRANTED NULL
3304 PRIMARY RECORD X GRANTED 3, 1
3305 PRIMARY RECORD X GRANTED 3, 3
3306 PRIMARY RECORD X,GAP GRANTED 5, 5
3307 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3, 5
3308 ROLLBACK;
3309 BEGIN;
3310 SELECT *
3311 FROM t2 FORCE INDEX (PRIMARY)
3312 WHERE id1 <=5
3313 ORDER BY id1 DESC
3314 FOR UPDATE;
3315 id1 id2
3316 5 1
3317 5 3
3318 5 5
3319 3 1
3320 3 3
3321 3 5
3322 1 1
3323 1 3
3324 1 5
3325 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3326 FROM performance_schema.data_locks
3327 WHERE object_name = 't2';
3328 index_name lock_type lock_mode lock_status lock_data
3329 NULL TABLE IX GRANTED NULL
3330 PRIMARY RECORD X GRANTED 1, 1
3331 PRIMARY RECORD X GRANTED 1, 3
3332 PRIMARY RECORD X GRANTED 1, 5
3333 PRIMARY RECORD X GRANTED 3, 1
3334 PRIMARY RECORD X GRANTED 3, 3
3335 PRIMARY RECORD X GRANTED 3, 5
3336 PRIMARY RECORD X GRANTED 5, 1
3337 PRIMARY RECORD X GRANTED 5, 3
3338 PRIMARY RECORD X GRANTED 5, 5
3339 PRIMARY RECORD X GRANTED supremum pseudo-record
3340 ROLLBACK;
3341 BEGIN;
3342 SELECT *
3343 FROM t2 FORCE INDEX (PRIMARY)
3344 WHERE id1=3 AND id2 <=5
3345 ORDER BY id2 DESC
3346 FOR UPDATE;
3347 id1 id2
3348 3 5
3349 3 3
3350 3 1
3351 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3352 FROM performance_schema.data_locks
3353 WHERE object_name = 't2';
3354 index_name lock_type lock_mode lock_status lock_data
3355 NULL TABLE IX GRANTED NULL
3356 PRIMARY RECORD X GRANTED 3, 1
3357 PRIMARY RECORD X GRANTED 3, 3
3358 PRIMARY RECORD X,GAP GRANTED 5, 5
3359 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3, 5
3360 ROLLBACK;
3361 BEGIN;
3362 SELECT *
3363 FROM t2 FORCE INDEX (PRIMARY)
3364 WHERE id1 >6
3365 ORDER BY id1 ASC
3366 FOR UPDATE;
3367 id1 id2
3368 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3369 FROM performance_schema.data_locks
3370 WHERE object_name = 't2';
3371 index_name lock_type lock_mode lock_status lock_data
3372 NULL TABLE IX GRANTED NULL
3373 PRIMARY RECORD X GRANTED supremum pseudo-record
3374 ROLLBACK;
3375 BEGIN;
3376 SELECT *
3377 FROM t2 FORCE INDEX (PRIMARY)
3378 WHERE id1=3 AND id2 >6
3379 ORDER BY id2 ASC
3380 FOR UPDATE;
3381 id1 id2
3382 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3383 FROM performance_schema.data_locks
3384 WHERE object_name = 't2';
3385 index_name lock_type lock_mode lock_status lock_data
3386 NULL TABLE IX GRANTED NULL
3387 PRIMARY RECORD X,GAP GRANTED 3, 5
3388 ROLLBACK;
3389 BEGIN;
3390 SELECT *
3391 FROM t2 FORCE INDEX (PRIMARY)
3392 WHERE id1 >6
3393 ORDER BY id1 DESC
3394 FOR UPDATE;
3395 id1 id2
3396 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3397 FROM performance_schema.data_locks
3398 WHERE object_name = 't2';
3399 index_name lock_type lock_mode lock_status lock_data
3400 NULL TABLE IX GRANTED NULL
3401 PRIMARY RECORD X GRANTED 5, 1
3402 PRIMARY RECORD X GRANTED supremum pseudo-record
3403 ROLLBACK;
3404 BEGIN;
3405 SELECT *
3406 FROM t2 FORCE INDEX (PRIMARY)
3407 WHERE id1=3 AND id2 >6
3408 ORDER BY id2 DESC
3409 FOR UPDATE;
3410 id1 id2
3411 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3412 FROM performance_schema.data_locks
3413 WHERE object_name = 't2';
3414 index_name lock_type lock_mode lock_status lock_data
3415 NULL TABLE IX GRANTED NULL
3416 PRIMARY RECORD X,GAP GRANTED 3, 5
3417 ROLLBACK;
3418 BEGIN;
3419 SELECT *
3420 FROM t2 FORCE INDEX (PRIMARY)
3421 WHERE id1 >5
3422 ORDER BY id1 ASC
3423 FOR UPDATE;
3424 id1 id2
3425 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3426 FROM performance_schema.data_locks
3427 WHERE object_name = 't2';
3428 index_name lock_type lock_mode lock_status lock_data
3429 NULL TABLE IX GRANTED NULL
3430 PRIMARY RECORD X GRANTED supremum pseudo-record
3431 ROLLBACK;
3432 BEGIN;
3433 SELECT *
3434 FROM t2 FORCE INDEX (PRIMARY)
3435 WHERE id1=3 AND id2 >5
3436 ORDER BY id2 ASC
3437 FOR UPDATE;
3438 id1 id2
3439 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3440 FROM performance_schema.data_locks
3441 WHERE object_name = 't2';
3442 index_name lock_type lock_mode lock_status lock_data
3443 NULL TABLE IX GRANTED NULL
3444 PRIMARY RECORD X,GAP GRANTED 3, 5
3445 ROLLBACK;
3446 BEGIN;
3447 SELECT *
3448 FROM t2 FORCE INDEX (PRIMARY)
3449 WHERE id1 >5
3450 ORDER BY id1 DESC
3451 FOR UPDATE;
3452 id1 id2
3453 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3454 FROM performance_schema.data_locks
3455 WHERE object_name = 't2';
3456 index_name lock_type lock_mode lock_status lock_data
3457 NULL TABLE IX GRANTED NULL
3458 PRIMARY RECORD X GRANTED 5, 1
3459 PRIMARY RECORD X GRANTED supremum pseudo-record
3460 ROLLBACK;
3461 BEGIN;
3462 SELECT *
3463 FROM t2 FORCE INDEX (PRIMARY)
3464 WHERE id1=3 AND id2 >5
3465 ORDER BY id2 DESC
3466 FOR UPDATE;
3467 id1 id2
3468 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3469 FROM performance_schema.data_locks
3470 WHERE object_name = 't2';
3471 index_name lock_type lock_mode lock_status lock_data
3472 NULL TABLE IX GRANTED NULL
3473 PRIMARY RECORD X,GAP GRANTED 3, 5
3474 ROLLBACK;
3475 BEGIN;
3476 SELECT *
3477 FROM t2 FORCE INDEX (PRIMARY)
3478 WHERE id1 >3
3479 ORDER BY id1 ASC
3480 FOR UPDATE;
3481 id1 id2
3482 5 5
3483 5 3
3484 5 1
3485 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3486 FROM performance_schema.data_locks
3487 WHERE object_name = 't2';
3488 index_name lock_type lock_mode lock_status lock_data
3489 NULL TABLE IX GRANTED NULL
3490 PRIMARY RECORD X GRANTED 5, 1
3491 PRIMARY RECORD X GRANTED 5, 3
3492 PRIMARY RECORD X GRANTED 5, 5
3493 PRIMARY RECORD X GRANTED supremum pseudo-record
3494 ROLLBACK;
3495 BEGIN;
3496 SELECT *
3497 FROM t2 FORCE INDEX (PRIMARY)
3498 WHERE id1=3 AND id2 >3
3499 ORDER BY id2 ASC
3500 FOR UPDATE;
3501 id1 id2
3502 3 5
3503 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3504 FROM performance_schema.data_locks
3505 WHERE object_name = 't2';
3506 index_name lock_type lock_mode lock_status lock_data
3507 NULL TABLE IX GRANTED NULL
3508 PRIMARY RECORD X GRANTED 3, 5
3509 PRIMARY RECORD X,GAP GRANTED 3, 3
3510 ROLLBACK;
3511 BEGIN;
3512 SELECT *
3513 FROM t2 FORCE INDEX (PRIMARY)
3514 WHERE id1 >3
3515 ORDER BY id1 DESC
3516 FOR UPDATE;
3517 id1 id2
3518 5 1
3519 5 3
3520 5 5
3521 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3522 FROM performance_schema.data_locks
3523 WHERE object_name = 't2';
3524 index_name lock_type lock_mode lock_status lock_data
3525 NULL TABLE IX GRANTED NULL
3526 PRIMARY RECORD X GRANTED 3, 1
3527 PRIMARY RECORD X GRANTED 5, 1
3528 PRIMARY RECORD X GRANTED 5, 3
3529 PRIMARY RECORD X GRANTED 5, 5
3530 PRIMARY RECORD X GRANTED supremum pseudo-record
3531 ROLLBACK;
3532 BEGIN;
3533 SELECT *
3534 FROM t2 FORCE INDEX (PRIMARY)
3535 WHERE id1=3 AND id2 >3
3536 ORDER BY id2 DESC
3537 FOR UPDATE;
3538 id1 id2
3539 3 5
3540 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3541 FROM performance_schema.data_locks
3542 WHERE object_name = 't2';
3543 index_name lock_type lock_mode lock_status lock_data
3544 NULL TABLE IX GRANTED NULL
3545 PRIMARY RECORD X GRANTED 3, 5
3546 PRIMARY RECORD X,GAP GRANTED 3, 3
3547 ROLLBACK;
3548 BEGIN;
3549 SELECT *
3550 FROM t2 FORCE INDEX (PRIMARY)
3551 WHERE id1 >=3
3552 ORDER BY id1 ASC
3553 FOR UPDATE;
3554 id1 id2
3555 3 5
3556 3 3
3557 3 1
3558 5 5
3559 5 3
3560 5 1
3561 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3562 FROM performance_schema.data_locks
3563 WHERE object_name = 't2';
3564 index_name lock_type lock_mode lock_status lock_data
3565 NULL TABLE IX GRANTED NULL
3566 PRIMARY RECORD X GRANTED 3, 1
3567 PRIMARY RECORD X GRANTED 3, 3
3568 PRIMARY RECORD X GRANTED 3, 5
3569 PRIMARY RECORD X GRANTED 5, 1
3570 PRIMARY RECORD X GRANTED 5, 3
3571 PRIMARY RECORD X GRANTED 5, 5
3572 PRIMARY RECORD X GRANTED supremum pseudo-record
3573 ROLLBACK;
3574 BEGIN;
3575 SELECT *
3576 FROM t2 FORCE INDEX (PRIMARY)
3577 WHERE id1=3 AND id2 >=3
3578 ORDER BY id2 ASC
3579 FOR UPDATE;
3580 id1 id2
3581 3 3
3582 3 5
3583 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3584 FROM performance_schema.data_locks
3585 WHERE object_name = 't2';
3586 index_name lock_type lock_mode lock_status lock_data
3587 NULL TABLE IX GRANTED NULL
3588 PRIMARY RECORD X GRANTED 3, 3
3589 PRIMARY RECORD X GRANTED 3, 5
3590 ROLLBACK;
3591 BEGIN;
3592 SELECT *
3593 FROM t2 FORCE INDEX (PRIMARY)
3594 WHERE id1 >=3
3595 ORDER BY id1 DESC
3596 FOR UPDATE;
3597 id1 id2
3598 5 1
3599 5 3
3600 5 5
3601 3 1
3602 3 3
3603 3 5
3604 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3605 FROM performance_schema.data_locks
3606 WHERE object_name = 't2';
3607 index_name lock_type lock_mode lock_status lock_data
3608 NULL TABLE IX GRANTED NULL
3609 PRIMARY RECORD X GRANTED 1, 1
3610 PRIMARY RECORD X GRANTED 3, 1
3611 PRIMARY RECORD X GRANTED 3, 3
3612 PRIMARY RECORD X GRANTED 3, 5
3613 PRIMARY RECORD X GRANTED 5, 1
3614 PRIMARY RECORD X GRANTED 5, 3
3615 PRIMARY RECORD X GRANTED 5, 5
3616 PRIMARY RECORD X GRANTED supremum pseudo-record
3617 ROLLBACK;
3618 BEGIN;
3619 SELECT *
3620 FROM t2 FORCE INDEX (PRIMARY)
3621 WHERE id1=3 AND id2 >=3
3622 ORDER BY id2 DESC
3623 FOR UPDATE;
3624 id1 id2
3625 3 5
3626 3 3
3627 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3628 FROM performance_schema.data_locks
3629 WHERE object_name = 't2';
3630 index_name lock_type lock_mode lock_status lock_data
3631 NULL TABLE IX GRANTED NULL
3632 PRIMARY RECORD X GRANTED 3, 3
3633 PRIMARY RECORD X GRANTED 3, 5
3634 ROLLBACK;
3635 BEGIN;
3636 SELECT *
3637 FROM t2 FORCE INDEX (PRIMARY)
3638 WHERE id1 >=2
3639 ORDER BY id1 ASC
3640 FOR UPDATE;
3641 id1 id2
3642 3 5
3643 3 3
3644 3 1
3645 5 5
3646 5 3
3647 5 1
3648 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3649 FROM performance_schema.data_locks
3650 WHERE object_name = 't2';
3651 index_name lock_type lock_mode lock_status lock_data
3652 NULL TABLE IX GRANTED NULL
3653 PRIMARY RECORD X GRANTED 3, 1
3654 PRIMARY RECORD X GRANTED 3, 3
3655 PRIMARY RECORD X GRANTED 3, 5
3656 PRIMARY RECORD X GRANTED 5, 1
3657 PRIMARY RECORD X GRANTED 5, 3
3658 PRIMARY RECORD X GRANTED 5, 5
3659 PRIMARY RECORD X GRANTED supremum pseudo-record
3660 ROLLBACK;
3661 BEGIN;
3662 SELECT *
3663 FROM t2 FORCE INDEX (PRIMARY)
3664 WHERE id1=3 AND id2 >=2
3665 ORDER BY id2 ASC
3666 FOR UPDATE;
3667 id1 id2
3668 3 3
3669 3 5
3670 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3671 FROM performance_schema.data_locks
3672 WHERE object_name = 't2';
3673 index_name lock_type lock_mode lock_status lock_data
3674 NULL TABLE IX GRANTED NULL
3675 PRIMARY RECORD X GRANTED 3, 3
3676 PRIMARY RECORD X GRANTED 3, 5
3677 PRIMARY RECORD X,GAP GRANTED 3, 1
3678 ROLLBACK;
3679 BEGIN;
3680 SELECT *
3681 FROM t2 FORCE INDEX (PRIMARY)
3682 WHERE id1 >=2
3683 ORDER BY id1 DESC
3684 FOR UPDATE;
3685 id1 id2
3686 5 1
3687 5 3
3688 5 5
3689 3 1
3690 3 3
3691 3 5
3692 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3693 FROM performance_schema.data_locks
3694 WHERE object_name = 't2';
3695 index_name lock_type lock_mode lock_status lock_data
3696 NULL TABLE IX GRANTED NULL
3697 PRIMARY RECORD X GRANTED 1, 1
3698 PRIMARY RECORD X GRANTED 3, 1
3699 PRIMARY RECORD X GRANTED 3, 3
3700 PRIMARY RECORD X GRANTED 3, 5
3701 PRIMARY RECORD X GRANTED 5, 1
3702 PRIMARY RECORD X GRANTED 5, 3
3703 PRIMARY RECORD X GRANTED 5, 5
3704 PRIMARY RECORD X GRANTED supremum pseudo-record
3705 ROLLBACK;
3706 BEGIN;
3707 SELECT *
3708 FROM t2 FORCE INDEX (PRIMARY)
3709 WHERE id1=3 AND id2 >=2
3710 ORDER BY id2 DESC
3711 FOR UPDATE;
3712 id1 id2
3713 3 5
3714 3 3
3715 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3716 FROM performance_schema.data_locks
3717 WHERE object_name = 't2';
3718 index_name lock_type lock_mode lock_status lock_data
3719 NULL TABLE IX GRANTED NULL
3720 PRIMARY RECORD X GRANTED 3, 3
3721 PRIMARY RECORD X GRANTED 3, 5
3722 PRIMARY RECORD X,GAP GRANTED 3, 1
3723 ROLLBACK;
3724 BEGIN;
3725 SELECT *
3726 FROM t2 FORCE INDEX (PRIMARY)
3727 WHERE id1 >1
3728 ORDER BY id1 ASC
3729 FOR UPDATE;
3730 id1 id2
3731 3 5
3732 3 3
3733 3 1
3734 5 5
3735 5 3
3736 5 1
3737 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3738 FROM performance_schema.data_locks
3739 WHERE object_name = 't2';
3740 index_name lock_type lock_mode lock_status lock_data
3741 NULL TABLE IX GRANTED NULL
3742 PRIMARY RECORD X GRANTED 3, 1
3743 PRIMARY RECORD X GRANTED 3, 3
3744 PRIMARY RECORD X GRANTED 3, 5
3745 PRIMARY RECORD X GRANTED 5, 1
3746 PRIMARY RECORD X GRANTED 5, 3
3747 PRIMARY RECORD X GRANTED 5, 5
3748 PRIMARY RECORD X GRANTED supremum pseudo-record
3749 ROLLBACK;
3750 BEGIN;
3751 SELECT *
3752 FROM t2 FORCE INDEX (PRIMARY)
3753 WHERE id1=3 AND id2 >1
3754 ORDER BY id2 ASC
3755 FOR UPDATE;
3756 id1 id2
3757 3 3
3758 3 5
3759 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3760 FROM performance_schema.data_locks
3761 WHERE object_name = 't2';
3762 index_name lock_type lock_mode lock_status lock_data
3763 NULL TABLE IX GRANTED NULL
3764 PRIMARY RECORD X GRANTED 3, 3
3765 PRIMARY RECORD X GRANTED 3, 5
3766 PRIMARY RECORD X,GAP GRANTED 3, 1
3767 ROLLBACK;
3768 BEGIN;
3769 SELECT *
3770 FROM t2 FORCE INDEX (PRIMARY)
3771 WHERE id1 >1
3772 ORDER BY id1 DESC
3773 FOR UPDATE;
3774 id1 id2
3775 5 1
3776 5 3
3777 5 5
3778 3 1
3779 3 3
3780 3 5
3781 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3782 FROM performance_schema.data_locks
3783 WHERE object_name = 't2';
3784 index_name lock_type lock_mode lock_status lock_data
3785 NULL TABLE IX GRANTED NULL
3786 PRIMARY RECORD X GRANTED 1, 1
3787 PRIMARY RECORD X GRANTED 3, 1
3788 PRIMARY RECORD X GRANTED 3, 3
3789 PRIMARY RECORD X GRANTED 3, 5
3790 PRIMARY RECORD X GRANTED 5, 1
3791 PRIMARY RECORD X GRANTED 5, 3
3792 PRIMARY RECORD X GRANTED 5, 5
3793 PRIMARY RECORD X GRANTED supremum pseudo-record
3794 ROLLBACK;
3795 BEGIN;
3796 SELECT *
3797 FROM t2 FORCE INDEX (PRIMARY)
3798 WHERE id1=3 AND id2 >1
3799 ORDER BY id2 DESC
3800 FOR UPDATE;
3801 id1 id2
3802 3 5
3803 3 3
3804 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3805 FROM performance_schema.data_locks
3806 WHERE object_name = 't2';
3807 index_name lock_type lock_mode lock_status lock_data
3808 NULL TABLE IX GRANTED NULL
3809 PRIMARY RECORD X GRANTED 3, 3
3810 PRIMARY RECORD X GRANTED 3, 5
3811 PRIMARY RECORD X,GAP GRANTED 3, 1
3812 ROLLBACK;
3813 BEGIN;
3814 SELECT *
3815 FROM t2 FORCE INDEX (PRIMARY)
3816 WHERE id1 >=1
3817 ORDER BY id1 ASC
3818 FOR UPDATE;
3819 id1 id2
3820 1 5
3821 1 3
3822 1 1
3823 3 5
3824 3 3
3825 3 1
3826 5 5
3827 5 3
3828 5 1
3829 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3830 FROM performance_schema.data_locks
3831 WHERE object_name = 't2';
3832 index_name lock_type lock_mode lock_status lock_data
3833 NULL TABLE IX GRANTED NULL
3834 PRIMARY RECORD X GRANTED 1, 1
3835 PRIMARY RECORD X GRANTED 1, 3
3836 PRIMARY RECORD X GRANTED 1, 5
3837 PRIMARY RECORD X GRANTED 3, 1
3838 PRIMARY RECORD X GRANTED 3, 3
3839 PRIMARY RECORD X GRANTED 3, 5
3840 PRIMARY RECORD X GRANTED 5, 1
3841 PRIMARY RECORD X GRANTED 5, 3
3842 PRIMARY RECORD X GRANTED 5, 5
3843 PRIMARY RECORD X GRANTED supremum pseudo-record
3844 ROLLBACK;
3845 BEGIN;
3846 SELECT *
3847 FROM t2 FORCE INDEX (PRIMARY)
3848 WHERE id1=3 AND id2 >=1
3849 ORDER BY id2 ASC
3850 FOR UPDATE;
3851 id1 id2
3852 3 1
3853 3 3
3854 3 5
3855 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3856 FROM performance_schema.data_locks
3857 WHERE object_name = 't2';
3858 index_name lock_type lock_mode lock_status lock_data
3859 NULL TABLE IX GRANTED NULL
3860 PRIMARY RECORD X GRANTED 3, 1
3861 PRIMARY RECORD X GRANTED 3, 3
3862 PRIMARY RECORD X GRANTED 3, 5
3863 ROLLBACK;
3864 BEGIN;
3865 SELECT *
3866 FROM t2 FORCE INDEX (PRIMARY)
3867 WHERE id1 >=1
3868 ORDER BY id1 DESC
3869 FOR UPDATE;
3870 id1 id2
3871 5 1
3872 5 3
3873 5 5
3874 3 1
3875 3 3
3876 3 5
3877 1 1
3878 1 3
3879 1 5
3880 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3881 FROM performance_schema.data_locks
3882 WHERE object_name = 't2';
3883 index_name lock_type lock_mode lock_status lock_data
3884 NULL TABLE IX GRANTED NULL
3885 PRIMARY RECORD X GRANTED 1, 1
3886 PRIMARY RECORD X GRANTED 1, 3
3887 PRIMARY RECORD X GRANTED 1, 5
3888 PRIMARY RECORD X GRANTED 3, 1
3889 PRIMARY RECORD X GRANTED 3, 3
3890 PRIMARY RECORD X GRANTED 3, 5
3891 PRIMARY RECORD X GRANTED 5, 1
3892 PRIMARY RECORD X GRANTED 5, 3
3893 PRIMARY RECORD X GRANTED 5, 5
3894 PRIMARY RECORD X GRANTED supremum pseudo-record
3895 ROLLBACK;
3896 BEGIN;
3897 SELECT *
3898 FROM t2 FORCE INDEX (PRIMARY)
3899 WHERE id1=3 AND id2 >=1
3900 ORDER BY id2 DESC
3901 FOR UPDATE;
3902 id1 id2
3903 3 5
3904 3 3
3905 3 1
3906 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3907 FROM performance_schema.data_locks
3908 WHERE object_name = 't2';
3909 index_name lock_type lock_mode lock_status lock_data
3910 NULL TABLE IX GRANTED NULL
3911 PRIMARY RECORD X GRANTED 3, 1
3912 PRIMARY RECORD X GRANTED 3, 3
3913 PRIMARY RECORD X GRANTED 3, 5
3914 ROLLBACK;
3915 DROP TABLE t2;
3916 INSERT INTO t3 (id1,id2) VALUES
3917 (1,1),(1,3),(1,5),(3,1),(3,3),(3,5),(5,1),(5,3),(5,5);
3918 ANALYZE TABLE t3;
3919 Table Op Msg_type Msg_text
3920 test.t3 analyze status OK
3921 BEGIN;
3922 SELECT *
3923 FROM t3 FORCE INDEX (PRIMARY)
3924 WHERE id1 <0
3925 ORDER BY id1 ASC
3926 FOR UPDATE;
3927 id1 id2
3928 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3929 FROM performance_schema.data_locks
3930 WHERE object_name = 't3';
3931 index_name lock_type lock_mode lock_status lock_data
3932 NULL TABLE IX GRANTED NULL
3933 PRIMARY RECORD X GRANTED 1, 5
3934 PRIMARY RECORD X GRANTED supremum pseudo-record
3935 ROLLBACK;
3936 BEGIN;
3937 SELECT *
3938 FROM t3 FORCE INDEX (PRIMARY)
3939 WHERE id1=3 AND id2 <0
3940 ORDER BY id2 ASC
3941 FOR UPDATE;
3942 id1 id2
3943 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3944 FROM performance_schema.data_locks
3945 WHERE object_name = 't3';
3946 index_name lock_type lock_mode lock_status lock_data
3947 NULL TABLE IX GRANTED NULL
3948 PRIMARY RECORD X,GAP GRANTED 3, 1
3949 ROLLBACK;
3950 BEGIN;
3951 SELECT *
3952 FROM t3 FORCE INDEX (PRIMARY)
3953 WHERE id1 <0
3954 ORDER BY id1 DESC
3955 FOR UPDATE;
3956 id1 id2
3957 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3958 FROM performance_schema.data_locks
3959 WHERE object_name = 't3';
3960 index_name lock_type lock_mode lock_status lock_data
3961 NULL TABLE IX GRANTED NULL
3962 PRIMARY RECORD X GRANTED supremum pseudo-record
3963 ROLLBACK;
3964 BEGIN;
3965 SELECT *
3966 FROM t3 FORCE INDEX (PRIMARY)
3967 WHERE id1=3 AND id2 <0
3968 ORDER BY id2 DESC
3969 FOR UPDATE;
3970 id1 id2
3971 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3972 FROM performance_schema.data_locks
3973 WHERE object_name = 't3';
3974 index_name lock_type lock_mode lock_status lock_data
3975 NULL TABLE IX GRANTED NULL
3976 PRIMARY RECORD X,GAP GRANTED 3, 1
3977 ROLLBACK;
3978 BEGIN;
3979 SELECT *
3980 FROM t3 FORCE INDEX (PRIMARY)
3981 WHERE id1 <1
3982 ORDER BY id1 ASC
3983 FOR UPDATE;
3984 id1 id2
3985 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
3986 FROM performance_schema.data_locks
3987 WHERE object_name = 't3';
3988 index_name lock_type lock_mode lock_status lock_data
3989 NULL TABLE IX GRANTED NULL
3990 PRIMARY RECORD X GRANTED 1, 5
3991 PRIMARY RECORD X GRANTED supremum pseudo-record
3992 ROLLBACK;
3993 BEGIN;
3994 SELECT *
3995 FROM t3 FORCE INDEX (PRIMARY)
3996 WHERE id1=3 AND id2 <1
3997 ORDER BY id2 ASC
3998 FOR UPDATE;
3999 id1 id2
4000 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4001 FROM performance_schema.data_locks
4002 WHERE object_name = 't3';
4003 index_name lock_type lock_mode lock_status lock_data
4004 NULL TABLE IX GRANTED NULL
4005 PRIMARY RECORD X,GAP GRANTED 3, 1
4006 ROLLBACK;
4007 BEGIN;
4008 SELECT *
4009 FROM t3 FORCE INDEX (PRIMARY)
4010 WHERE id1 <1
4011 ORDER BY id1 DESC
4012 FOR UPDATE;
4013 id1 id2
4014 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4015 FROM performance_schema.data_locks
4016 WHERE object_name = 't3';
4017 index_name lock_type lock_mode lock_status lock_data
4018 NULL TABLE IX GRANTED NULL
4019 PRIMARY RECORD X GRANTED supremum pseudo-record
4020 ROLLBACK;
4021 BEGIN;
4022 SELECT *
4023 FROM t3 FORCE INDEX (PRIMARY)
4024 WHERE id1=3 AND id2 <1
4025 ORDER BY id2 DESC
4026 FOR UPDATE;
4027 id1 id2
4028 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4029 FROM performance_schema.data_locks
4030 WHERE object_name = 't3';
4031 index_name lock_type lock_mode lock_status lock_data
4032 NULL TABLE IX GRANTED NULL
4033 PRIMARY RECORD X,GAP GRANTED 3, 1
4034 ROLLBACK;
4035 BEGIN;
4036 SELECT *
4037 FROM t3 FORCE INDEX (PRIMARY)
4038 WHERE id1 <3
4039 ORDER BY id1 ASC
4040 FOR UPDATE;
4041 id1 id2
4042 1 5
4043 1 3
4044 1 1
4045 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4046 FROM performance_schema.data_locks
4047 WHERE object_name = 't3';
4048 index_name lock_type lock_mode lock_status lock_data
4049 NULL TABLE IX GRANTED NULL
4050 PRIMARY RECORD X GRANTED 1, 1
4051 PRIMARY RECORD X GRANTED 1, 3
4052 PRIMARY RECORD X GRANTED 1, 5
4053 PRIMARY RECORD X GRANTED 3, 5
4054 PRIMARY RECORD X GRANTED supremum pseudo-record
4055 ROLLBACK;
4056 BEGIN;
4057 SELECT *
4058 FROM t3 FORCE INDEX (PRIMARY)
4059 WHERE id1=3 AND id2 <3
4060 ORDER BY id2 ASC
4061 FOR UPDATE;
4062 id1 id2
4063 3 1
4064 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4065 FROM performance_schema.data_locks
4066 WHERE object_name = 't3';
4067 index_name lock_type lock_mode lock_status lock_data
4068 NULL TABLE IX GRANTED NULL
4069 PRIMARY RECORD X GRANTED 3, 1
4070 PRIMARY RECORD X,GAP GRANTED 3, 3
4071 ROLLBACK;
4072 BEGIN;
4073 SELECT *
4074 FROM t3 FORCE INDEX (PRIMARY)
4075 WHERE id1 <3
4076 ORDER BY id1 DESC
4077 FOR UPDATE;
4078 id1 id2
4079 1 1
4080 1 3
4081 1 5
4082 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4083 FROM performance_schema.data_locks
4084 WHERE object_name = 't3';
4085 index_name lock_type lock_mode lock_status lock_data
4086 NULL TABLE IX GRANTED NULL
4087 PRIMARY RECORD X GRANTED 1, 1
4088 PRIMARY RECORD X GRANTED 1, 3
4089 PRIMARY RECORD X GRANTED 1, 5
4090 PRIMARY RECORD X GRANTED supremum pseudo-record
4091 ROLLBACK;
4092 BEGIN;
4093 SELECT *
4094 FROM t3 FORCE INDEX (PRIMARY)
4095 WHERE id1=3 AND id2 <3
4096 ORDER BY id2 DESC
4097 FOR UPDATE;
4098 id1 id2
4099 3 1
4100 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4101 FROM performance_schema.data_locks
4102 WHERE object_name = 't3';
4103 index_name lock_type lock_mode lock_status lock_data
4104 NULL TABLE IX GRANTED NULL
4105 PRIMARY RECORD X GRANTED 3, 1
4106 PRIMARY RECORD X,GAP GRANTED 3, 3
4107 ROLLBACK;
4108 BEGIN;
4109 SELECT *
4110 FROM t3 FORCE INDEX (PRIMARY)
4111 WHERE id1 <=3
4112 ORDER BY id1 ASC
4113 FOR UPDATE;
4114 id1 id2
4115 1 5
4116 1 3
4117 1 1
4118 3 5
4119 3 3
4120 3 1
4121 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4122 FROM performance_schema.data_locks
4123 WHERE object_name = 't3';
4124 index_name lock_type lock_mode lock_status lock_data
4125 NULL TABLE IX GRANTED NULL
4126 PRIMARY RECORD X GRANTED 1, 1
4127 PRIMARY RECORD X GRANTED 1, 3
4128 PRIMARY RECORD X GRANTED 1, 5
4129 PRIMARY RECORD X GRANTED 3, 1
4130 PRIMARY RECORD X GRANTED 3, 3
4131 PRIMARY RECORD X GRANTED 3, 5
4132 PRIMARY RECORD X GRANTED 5, 5
4133 PRIMARY RECORD X GRANTED supremum pseudo-record
4134 ROLLBACK;
4135 BEGIN;
4136 SELECT *
4137 FROM t3 FORCE INDEX (PRIMARY)
4138 WHERE id1=3 AND id2 <=3
4139 ORDER BY id2 ASC
4140 FOR UPDATE;
4141 id1 id2
4142 3 1
4143 3 3
4144 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4145 FROM performance_schema.data_locks
4146 WHERE object_name = 't3';
4147 index_name lock_type lock_mode lock_status lock_data
4148 NULL TABLE IX GRANTED NULL
4149 PRIMARY RECORD X GRANTED 3, 1
4150 PRIMARY RECORD X GRANTED 3, 3
4151 ROLLBACK;
4152 BEGIN;
4153 SELECT *
4154 FROM t3 FORCE INDEX (PRIMARY)
4155 WHERE id1 <=3
4156 ORDER BY id1 DESC
4157 FOR UPDATE;
4158 id1 id2
4159 3 1
4160 3 3
4161 3 5
4162 1 1
4163 1 3
4164 1 5
4165 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4166 FROM performance_schema.data_locks
4167 WHERE object_name = 't3';
4168 index_name lock_type lock_mode lock_status lock_data
4169 NULL TABLE IX GRANTED NULL
4170 PRIMARY RECORD X GRANTED 1, 1
4171 PRIMARY RECORD X GRANTED 1, 3
4172 PRIMARY RECORD X GRANTED 1, 5
4173 PRIMARY RECORD X GRANTED 3, 1
4174 PRIMARY RECORD X GRANTED 3, 3
4175 PRIMARY RECORD X GRANTED 3, 5
4176 PRIMARY RECORD X GRANTED supremum pseudo-record
4177 ROLLBACK;
4178 BEGIN;
4179 SELECT *
4180 FROM t3 FORCE INDEX (PRIMARY)
4181 WHERE id1=3 AND id2 <=3
4182 ORDER BY id2 DESC
4183 FOR UPDATE;
4184 id1 id2
4185 3 3
4186 3 1
4187 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4188 FROM performance_schema.data_locks
4189 WHERE object_name = 't3';
4190 index_name lock_type lock_mode lock_status lock_data
4191 NULL TABLE IX GRANTED NULL
4192 PRIMARY RECORD X GRANTED 3, 1
4193 PRIMARY RECORD X GRANTED 3, 3
4194 ROLLBACK;
4195 BEGIN;
4196 SELECT *
4197 FROM t3 FORCE INDEX (PRIMARY)
4198 WHERE id1 <=4
4199 ORDER BY id1 ASC
4200 FOR UPDATE;
4201 id1 id2
4202 1 5
4203 1 3
4204 1 1
4205 3 5
4206 3 3
4207 3 1
4208 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4209 FROM performance_schema.data_locks
4210 WHERE object_name = 't3';
4211 index_name lock_type lock_mode lock_status lock_data
4212 NULL TABLE IX GRANTED NULL
4213 PRIMARY RECORD X GRANTED 1, 1
4214 PRIMARY RECORD X GRANTED 1, 3
4215 PRIMARY RECORD X GRANTED 1, 5
4216 PRIMARY RECORD X GRANTED 3, 1
4217 PRIMARY RECORD X GRANTED 3, 3
4218 PRIMARY RECORD X GRANTED 3, 5
4219 PRIMARY RECORD X GRANTED 5, 5
4220 PRIMARY RECORD X GRANTED supremum pseudo-record
4221 ROLLBACK;
4222 BEGIN;
4223 SELECT *
4224 FROM t3 FORCE INDEX (PRIMARY)
4225 WHERE id1=3 AND id2 <=4
4226 ORDER BY id2 ASC
4227 FOR UPDATE;
4228 id1 id2
4229 3 1
4230 3 3
4231 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4232 FROM performance_schema.data_locks
4233 WHERE object_name = 't3';
4234 index_name lock_type lock_mode lock_status lock_data
4235 NULL TABLE IX GRANTED NULL
4236 PRIMARY RECORD X GRANTED 3, 1
4237 PRIMARY RECORD X GRANTED 3, 3
4238 PRIMARY RECORD X,GAP GRANTED 3, 5
4239 ROLLBACK;
4240 BEGIN;
4241 SELECT *
4242 FROM t3 FORCE INDEX (PRIMARY)
4243 WHERE id1 <=4
4244 ORDER BY id1 DESC
4245 FOR UPDATE;
4246 id1 id2
4247 3 1
4248 3 3
4249 3 5
4250 1 1
4251 1 3
4252 1 5
4253 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4254 FROM performance_schema.data_locks
4255 WHERE object_name = 't3';
4256 index_name lock_type lock_mode lock_status lock_data
4257 NULL TABLE IX GRANTED NULL
4258 PRIMARY RECORD X GRANTED 1, 1
4259 PRIMARY RECORD X GRANTED 1, 3
4260 PRIMARY RECORD X GRANTED 1, 5
4261 PRIMARY RECORD X GRANTED 3, 1
4262 PRIMARY RECORD X GRANTED 3, 3
4263 PRIMARY RECORD X GRANTED 3, 5
4264 PRIMARY RECORD X GRANTED supremum pseudo-record
4265 ROLLBACK;
4266 BEGIN;
4267 SELECT *
4268 FROM t3 FORCE INDEX (PRIMARY)
4269 WHERE id1=3 AND id2 <=4
4270 ORDER BY id2 DESC
4271 FOR UPDATE;
4272 id1 id2
4273 3 3
4274 3 1
4275 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4276 FROM performance_schema.data_locks
4277 WHERE object_name = 't3';
4278 index_name lock_type lock_mode lock_status lock_data
4279 NULL TABLE IX GRANTED NULL
4280 PRIMARY RECORD X GRANTED 3, 1
4281 PRIMARY RECORD X GRANTED 3, 3
4282 PRIMARY RECORD X,GAP GRANTED 3, 5
4283 ROLLBACK;
4284 BEGIN;
4285 SELECT *
4286 FROM t3 FORCE INDEX (PRIMARY)
4287 WHERE id1 <5
4288 ORDER BY id1 ASC
4289 FOR UPDATE;
4290 id1 id2
4291 1 5
4292 1 3
4293 1 1
4294 3 5
4295 3 3
4296 3 1
4297 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4298 FROM performance_schema.data_locks
4299 WHERE object_name = 't3';
4300 index_name lock_type lock_mode lock_status lock_data
4301 NULL TABLE IX GRANTED NULL
4302 PRIMARY RECORD X GRANTED 1, 1
4303 PRIMARY RECORD X GRANTED 1, 3
4304 PRIMARY RECORD X GRANTED 1, 5
4305 PRIMARY RECORD X GRANTED 3, 1
4306 PRIMARY RECORD X GRANTED 3, 3
4307 PRIMARY RECORD X GRANTED 3, 5
4308 PRIMARY RECORD X GRANTED 5, 5
4309 PRIMARY RECORD X GRANTED supremum pseudo-record
4310 ROLLBACK;
4311 BEGIN;
4312 SELECT *
4313 FROM t3 FORCE INDEX (PRIMARY)
4314 WHERE id1=3 AND id2 <5
4315 ORDER BY id2 ASC
4316 FOR UPDATE;
4317 id1 id2
4318 3 1
4319 3 3
4320 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4321 FROM performance_schema.data_locks
4322 WHERE object_name = 't3';
4323 index_name lock_type lock_mode lock_status lock_data
4324 NULL TABLE IX GRANTED NULL
4325 PRIMARY RECORD X GRANTED 3, 1
4326 PRIMARY RECORD X GRANTED 3, 3
4327 PRIMARY RECORD X,GAP GRANTED 3, 5
4328 ROLLBACK;
4329 BEGIN;
4330 SELECT *
4331 FROM t3 FORCE INDEX (PRIMARY)
4332 WHERE id1 <5
4333 ORDER BY id1 DESC
4334 FOR UPDATE;
4335 id1 id2
4336 3 1
4337 3 3
4338 3 5
4339 1 1
4340 1 3
4341 1 5
4342 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4343 FROM performance_schema.data_locks
4344 WHERE object_name = 't3';
4345 index_name lock_type lock_mode lock_status lock_data
4346 NULL TABLE IX GRANTED NULL
4347 PRIMARY RECORD X GRANTED 1, 1
4348 PRIMARY RECORD X GRANTED 1, 3
4349 PRIMARY RECORD X GRANTED 1, 5
4350 PRIMARY RECORD X GRANTED 3, 1
4351 PRIMARY RECORD X GRANTED 3, 3
4352 PRIMARY RECORD X GRANTED 3, 5
4353 PRIMARY RECORD X GRANTED supremum pseudo-record
4354 ROLLBACK;
4355 BEGIN;
4356 SELECT *
4357 FROM t3 FORCE INDEX (PRIMARY)
4358 WHERE id1=3 AND id2 <5
4359 ORDER BY id2 DESC
4360 FOR UPDATE;
4361 id1 id2
4362 3 3
4363 3 1
4364 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4365 FROM performance_schema.data_locks
4366 WHERE object_name = 't3';
4367 index_name lock_type lock_mode lock_status lock_data
4368 NULL TABLE IX GRANTED NULL
4369 PRIMARY RECORD X GRANTED 3, 1
4370 PRIMARY RECORD X GRANTED 3, 3
4371 PRIMARY RECORD X,GAP GRANTED 3, 5
4372 ROLLBACK;
4373 BEGIN;
4374 SELECT *
4375 FROM t3 FORCE INDEX (PRIMARY)
4376 WHERE id1 <=5
4377 ORDER BY id1 ASC
4378 FOR UPDATE;
4379 id1 id2
4380 1 5
4381 1 3
4382 1 1
4383 3 5
4384 3 3
4385 3 1
4386 5 5
4387 5 3
4388 5 1
4389 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4390 FROM performance_schema.data_locks
4391 WHERE object_name = 't3';
4392 index_name lock_type lock_mode lock_status lock_data
4393 NULL TABLE IX GRANTED NULL
4394 PRIMARY RECORD X GRANTED 1, 1
4395 PRIMARY RECORD X GRANTED 1, 3
4396 PRIMARY RECORD X GRANTED 1, 5
4397 PRIMARY RECORD X GRANTED 3, 1
4398 PRIMARY RECORD X GRANTED 3, 3
4399 PRIMARY RECORD X GRANTED 3, 5
4400 PRIMARY RECORD X GRANTED 5, 1
4401 PRIMARY RECORD X GRANTED 5, 3
4402 PRIMARY RECORD X GRANTED 5, 5
4403 PRIMARY RECORD X GRANTED supremum pseudo-record
4404 ROLLBACK;
4405 BEGIN;
4406 SELECT *
4407 FROM t3 FORCE INDEX (PRIMARY)
4408 WHERE id1=3 AND id2 <=5
4409 ORDER BY id2 ASC
4410 FOR UPDATE;
4411 id1 id2
4412 3 1
4413 3 3
4414 3 5
4415 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4416 FROM performance_schema.data_locks
4417 WHERE object_name = 't3';
4418 index_name lock_type lock_mode lock_status lock_data
4419 NULL TABLE IX GRANTED NULL
4420 PRIMARY RECORD X GRANTED 3, 1
4421 PRIMARY RECORD X GRANTED 3, 3
4422 PRIMARY RECORD X GRANTED 3, 5
4423 ROLLBACK;
4424 BEGIN;
4425 SELECT *
4426 FROM t3 FORCE INDEX (PRIMARY)
4427 WHERE id1 <=5
4428 ORDER BY id1 DESC
4429 FOR UPDATE;
4430 id1 id2
4431 5 1
4432 5 3
4433 5 5
4434 3 1
4435 3 3
4436 3 5
4437 1 1
4438 1 3
4439 1 5
4440 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4441 FROM performance_schema.data_locks
4442 WHERE object_name = 't3';
4443 index_name lock_type lock_mode lock_status lock_data
4444 NULL TABLE IX GRANTED NULL
4445 PRIMARY RECORD X GRANTED 1, 1
4446 PRIMARY RECORD X GRANTED 1, 3
4447 PRIMARY RECORD X GRANTED 1, 5
4448 PRIMARY RECORD X GRANTED 3, 1
4449 PRIMARY RECORD X GRANTED 3, 3
4450 PRIMARY RECORD X GRANTED 3, 5
4451 PRIMARY RECORD X GRANTED 5, 1
4452 PRIMARY RECORD X GRANTED 5, 3
4453 PRIMARY RECORD X GRANTED 5, 5
4454 PRIMARY RECORD X GRANTED supremum pseudo-record
4455 ROLLBACK;
4456 BEGIN;
4457 SELECT *
4458 FROM t3 FORCE INDEX (PRIMARY)
4459 WHERE id1=3 AND id2 <=5
4460 ORDER BY id2 DESC
4461 FOR UPDATE;
4462 id1 id2
4463 3 5
4464 3 3
4465 3 1
4466 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4467 FROM performance_schema.data_locks
4468 WHERE object_name = 't3';
4469 index_name lock_type lock_mode lock_status lock_data
4470 NULL TABLE IX GRANTED NULL
4471 PRIMARY RECORD X GRANTED 3, 1
4472 PRIMARY RECORD X GRANTED 3, 3
4473 PRIMARY RECORD X GRANTED 3, 5
4474 ROLLBACK;
4475 BEGIN;
4476 SELECT *
4477 FROM t3 FORCE INDEX (PRIMARY)
4478 WHERE id1 >6
4479 ORDER BY id1 ASC
4480 FOR UPDATE;
4481 id1 id2
4482 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4483 FROM performance_schema.data_locks
4484 WHERE object_name = 't3';
4485 index_name lock_type lock_mode lock_status lock_data
4486 NULL TABLE IX GRANTED NULL
4487 PRIMARY RECORD X,GAP GRANTED 5, 1
4488 ROLLBACK;
4489 BEGIN;
4490 SELECT *
4491 FROM t3 FORCE INDEX (PRIMARY)
4492 WHERE id1=3 AND id2 >6
4493 ORDER BY id2 ASC
4494 FOR UPDATE;
4495 id1 id2
4496 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4497 FROM performance_schema.data_locks
4498 WHERE object_name = 't3';
4499 index_name lock_type lock_mode lock_status lock_data
4500 NULL TABLE IX GRANTED NULL
4501 PRIMARY RECORD X,GAP GRANTED 1, 1
4502 ROLLBACK;
4503 BEGIN;
4504 SELECT *
4505 FROM t3 FORCE INDEX (PRIMARY)
4506 WHERE id1 >6
4507 ORDER BY id1 DESC
4508 FOR UPDATE;
4509 id1 id2
4510 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4511 FROM performance_schema.data_locks
4512 WHERE object_name = 't3';
4513 index_name lock_type lock_mode lock_status lock_data
4514 NULL TABLE IX GRANTED NULL
4515 PRIMARY RECORD X,GAP GRANTED 5, 1
4516 ROLLBACK;
4517 BEGIN;
4518 SELECT *
4519 FROM t3 FORCE INDEX (PRIMARY)
4520 WHERE id1=3 AND id2 >6
4521 ORDER BY id2 DESC
4522 FOR UPDATE;
4523 id1 id2
4524 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4525 FROM performance_schema.data_locks
4526 WHERE object_name = 't3';
4527 index_name lock_type lock_mode lock_status lock_data
4528 NULL TABLE IX GRANTED NULL
4529 PRIMARY RECORD X,GAP GRANTED 1, 1
4530 ROLLBACK;
4531 BEGIN;
4532 SELECT *
4533 FROM t3 FORCE INDEX (PRIMARY)
4534 WHERE id1 >5
4535 ORDER BY id1 ASC
4536 FOR UPDATE;
4537 id1 id2
4538 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4539 FROM performance_schema.data_locks
4540 WHERE object_name = 't3';
4541 index_name lock_type lock_mode lock_status lock_data
4542 NULL TABLE IX GRANTED NULL
4543 PRIMARY RECORD X,GAP GRANTED 5, 1
4544 ROLLBACK;
4545 BEGIN;
4546 SELECT *
4547 FROM t3 FORCE INDEX (PRIMARY)
4548 WHERE id1=3 AND id2 >5
4549 ORDER BY id2 ASC
4550 FOR UPDATE;
4551 id1 id2
4552 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4553 FROM performance_schema.data_locks
4554 WHERE object_name = 't3';
4555 index_name lock_type lock_mode lock_status lock_data
4556 NULL TABLE IX GRANTED NULL
4557 PRIMARY RECORD X,GAP GRANTED 1, 1
4558 ROLLBACK;
4559 BEGIN;
4560 SELECT *
4561 FROM t3 FORCE INDEX (PRIMARY)
4562 WHERE id1 >5
4563 ORDER BY id1 DESC
4564 FOR UPDATE;
4565 id1 id2
4566 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4567 FROM performance_schema.data_locks
4568 WHERE object_name = 't3';
4569 index_name lock_type lock_mode lock_status lock_data
4570 NULL TABLE IX GRANTED NULL
4571 PRIMARY RECORD X,GAP GRANTED 5, 1
4572 ROLLBACK;
4573 BEGIN;
4574 SELECT *
4575 FROM t3 FORCE INDEX (PRIMARY)
4576 WHERE id1=3 AND id2 >5
4577 ORDER BY id2 DESC
4578 FOR UPDATE;
4579 id1 id2
4580 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4581 FROM performance_schema.data_locks
4582 WHERE object_name = 't3';
4583 index_name lock_type lock_mode lock_status lock_data
4584 NULL TABLE IX GRANTED NULL
4585 PRIMARY RECORD X,GAP GRANTED 1, 1
4586 ROLLBACK;
4587 BEGIN;
4588 SELECT *
4589 FROM t3 FORCE INDEX (PRIMARY)
4590 WHERE id1 >3
4591 ORDER BY id1 ASC
4592 FOR UPDATE;
4593 id1 id2
4594 5 5
4595 5 3
4596 5 1
4597 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4598 FROM performance_schema.data_locks
4599 WHERE object_name = 't3';
4600 index_name lock_type lock_mode lock_status lock_data
4601 NULL TABLE IX GRANTED NULL
4602 PRIMARY RECORD X GRANTED 5, 1
4603 PRIMARY RECORD X GRANTED 5, 3
4604 PRIMARY RECORD X GRANTED 5, 5
4605 PRIMARY RECORD X,GAP GRANTED 3, 1
4606 ROLLBACK;
4607 BEGIN;
4608 SELECT *
4609 FROM t3 FORCE INDEX (PRIMARY)
4610 WHERE id1=3 AND id2 >3
4611 ORDER BY id2 ASC
4612 FOR UPDATE;
4613 id1 id2
4614 3 5
4615 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4616 FROM performance_schema.data_locks
4617 WHERE object_name = 't3';
4618 index_name lock_type lock_mode lock_status lock_data
4619 NULL TABLE IX GRANTED NULL
4620 PRIMARY RECORD X GRANTED 3, 5
4621 PRIMARY RECORD X,GAP GRANTED 1, 1
4622 ROLLBACK;
4623 BEGIN;
4624 SELECT *
4625 FROM t3 FORCE INDEX (PRIMARY)
4626 WHERE id1 >3
4627 ORDER BY id1 DESC
4628 FOR UPDATE;
4629 id1 id2
4630 5 1
4631 5 3
4632 5 5
4633 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4634 FROM performance_schema.data_locks
4635 WHERE object_name = 't3';
4636 index_name lock_type lock_mode lock_status lock_data
4637 NULL TABLE IX GRANTED NULL
4638 PRIMARY RECORD X GRANTED 5, 1
4639 PRIMARY RECORD X GRANTED 5, 3
4640 PRIMARY RECORD X GRANTED 5, 5
4641 PRIMARY RECORD X,GAP GRANTED 3, 1
4642 ROLLBACK;
4643 BEGIN;
4644 SELECT *
4645 FROM t3 FORCE INDEX (PRIMARY)
4646 WHERE id1=3 AND id2 >3
4647 ORDER BY id2 DESC
4648 FOR UPDATE;
4649 id1 id2
4650 3 5
4651 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4652 FROM performance_schema.data_locks
4653 WHERE object_name = 't3';
4654 index_name lock_type lock_mode lock_status lock_data
4655 NULL TABLE IX GRANTED NULL
4656 PRIMARY RECORD X GRANTED 3, 5
4657 PRIMARY RECORD X,GAP GRANTED 1, 1
4658 ROLLBACK;
4659 BEGIN;
4660 SELECT *
4661 FROM t3 FORCE INDEX (PRIMARY)
4662 WHERE id1 >=3
4663 ORDER BY id1 ASC
4664 FOR UPDATE;
4665 id1 id2
4666 3 5
4667 3 3
4668 3 1
4669 5 5
4670 5 3
4671 5 1
4672 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4673 FROM performance_schema.data_locks
4674 WHERE object_name = 't3';
4675 index_name lock_type lock_mode lock_status lock_data
4676 NULL TABLE IX GRANTED NULL
4677 PRIMARY RECORD X GRANTED 3, 1
4678 PRIMARY RECORD X GRANTED 3, 3
4679 PRIMARY RECORD X GRANTED 3, 5
4680 PRIMARY RECORD X GRANTED 5, 1
4681 PRIMARY RECORD X GRANTED 5, 3
4682 PRIMARY RECORD X GRANTED 5, 5
4683 PRIMARY RECORD X,GAP GRANTED 1, 1
4684 ROLLBACK;
4685 BEGIN;
4686 SELECT *
4687 FROM t3 FORCE INDEX (PRIMARY)
4688 WHERE id1=3 AND id2 >=3
4689 ORDER BY id2 ASC
4690 FOR UPDATE;
4691 id1 id2
4692 3 3
4693 3 5
4694 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4695 FROM performance_schema.data_locks
4696 WHERE object_name = 't3';
4697 index_name lock_type lock_mode lock_status lock_data
4698 NULL TABLE IX GRANTED NULL
4699 PRIMARY RECORD X GRANTED 3, 5
4700 PRIMARY RECORD X,GAP GRANTED 1, 1
4701 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3, 3
4702 ROLLBACK;
4703 BEGIN;
4704 SELECT *
4705 FROM t3 FORCE INDEX (PRIMARY)
4706 WHERE id1 >=3
4707 ORDER BY id1 DESC
4708 FOR UPDATE;
4709 id1 id2
4710 5 1
4711 5 3
4712 5 5
4713 3 1
4714 3 3
4715 3 5
4716 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4717 FROM performance_schema.data_locks
4718 WHERE object_name = 't3';
4719 index_name lock_type lock_mode lock_status lock_data
4720 NULL TABLE IX GRANTED NULL
4721 PRIMARY RECORD X GRANTED 3, 1
4722 PRIMARY RECORD X GRANTED 3, 3
4723 PRIMARY RECORD X GRANTED 3, 5
4724 PRIMARY RECORD X GRANTED 5, 1
4725 PRIMARY RECORD X GRANTED 5, 3
4726 PRIMARY RECORD X GRANTED 5, 5
4727 PRIMARY RECORD X,GAP GRANTED 1, 1
4728 ROLLBACK;
4729 BEGIN;
4730 SELECT *
4731 FROM t3 FORCE INDEX (PRIMARY)
4732 WHERE id1=3 AND id2 >=3
4733 ORDER BY id2 DESC
4734 FOR UPDATE;
4735 id1 id2
4736 3 5
4737 3 3
4738 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4739 FROM performance_schema.data_locks
4740 WHERE object_name = 't3';
4741 index_name lock_type lock_mode lock_status lock_data
4742 NULL TABLE IX GRANTED NULL
4743 PRIMARY RECORD X GRANTED 3, 5
4744 PRIMARY RECORD X,GAP GRANTED 1, 1
4745 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3, 3
4746 ROLLBACK;
4747 BEGIN;
4748 SELECT *
4749 FROM t3 FORCE INDEX (PRIMARY)
4750 WHERE id1 >=2
4751 ORDER BY id1 ASC
4752 FOR UPDATE;
4753 id1 id2
4754 3 5
4755 3 3
4756 3 1
4757 5 5
4758 5 3
4759 5 1
4760 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4761 FROM performance_schema.data_locks
4762 WHERE object_name = 't3';
4763 index_name lock_type lock_mode lock_status lock_data
4764 NULL TABLE IX GRANTED NULL
4765 PRIMARY RECORD X GRANTED 3, 1
4766 PRIMARY RECORD X GRANTED 3, 3
4767 PRIMARY RECORD X GRANTED 3, 5
4768 PRIMARY RECORD X GRANTED 5, 1
4769 PRIMARY RECORD X GRANTED 5, 3
4770 PRIMARY RECORD X GRANTED 5, 5
4771 PRIMARY RECORD X,GAP GRANTED 1, 1
4772 ROLLBACK;
4773 BEGIN;
4774 SELECT *
4775 FROM t3 FORCE INDEX (PRIMARY)
4776 WHERE id1=3 AND id2 >=2
4777 ORDER BY id2 ASC
4778 FOR UPDATE;
4779 id1 id2
4780 3 3
4781 3 5
4782 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4783 FROM performance_schema.data_locks
4784 WHERE object_name = 't3';
4785 index_name lock_type lock_mode lock_status lock_data
4786 NULL TABLE IX GRANTED NULL
4787 PRIMARY RECORD X GRANTED 3, 3
4788 PRIMARY RECORD X GRANTED 3, 5
4789 PRIMARY RECORD X,GAP GRANTED 1, 1
4790 ROLLBACK;
4791 BEGIN;
4792 SELECT *
4793 FROM t3 FORCE INDEX (PRIMARY)
4794 WHERE id1 >=2
4795 ORDER BY id1 DESC
4796 FOR UPDATE;
4797 id1 id2
4798 5 1
4799 5 3
4800 5 5
4801 3 1
4802 3 3
4803 3 5
4804 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4805 FROM performance_schema.data_locks
4806 WHERE object_name = 't3';
4807 index_name lock_type lock_mode lock_status lock_data
4808 NULL TABLE IX GRANTED NULL
4809 PRIMARY RECORD X GRANTED 3, 1
4810 PRIMARY RECORD X GRANTED 3, 3
4811 PRIMARY RECORD X GRANTED 3, 5
4812 PRIMARY RECORD X GRANTED 5, 1
4813 PRIMARY RECORD X GRANTED 5, 3
4814 PRIMARY RECORD X GRANTED 5, 5
4815 PRIMARY RECORD X,GAP GRANTED 1, 1
4816 ROLLBACK;
4817 BEGIN;
4818 SELECT *
4819 FROM t3 FORCE INDEX (PRIMARY)
4820 WHERE id1=3 AND id2 >=2
4821 ORDER BY id2 DESC
4822 FOR UPDATE;
4823 id1 id2
4824 3 5
4825 3 3
4826 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4827 FROM performance_schema.data_locks
4828 WHERE object_name = 't3';
4829 index_name lock_type lock_mode lock_status lock_data
4830 NULL TABLE IX GRANTED NULL
4831 PRIMARY RECORD X GRANTED 3, 3
4832 PRIMARY RECORD X GRANTED 3, 5
4833 PRIMARY RECORD X,GAP GRANTED 1, 1
4834 ROLLBACK;
4835 BEGIN;
4836 SELECT *
4837 FROM t3 FORCE INDEX (PRIMARY)
4838 WHERE id1 >1
4839 ORDER BY id1 ASC
4840 FOR UPDATE;
4841 id1 id2
4842 3 5
4843 3 3
4844 3 1
4845 5 5
4846 5 3
4847 5 1
4848 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4849 FROM performance_schema.data_locks
4850 WHERE object_name = 't3';
4851 index_name lock_type lock_mode lock_status lock_data
4852 NULL TABLE IX GRANTED NULL
4853 PRIMARY RECORD X GRANTED 3, 1
4854 PRIMARY RECORD X GRANTED 3, 3
4855 PRIMARY RECORD X GRANTED 3, 5
4856 PRIMARY RECORD X GRANTED 5, 1
4857 PRIMARY RECORD X GRANTED 5, 3
4858 PRIMARY RECORD X GRANTED 5, 5
4859 PRIMARY RECORD X,GAP GRANTED 1, 1
4860 ROLLBACK;
4861 BEGIN;
4862 SELECT *
4863 FROM t3 FORCE INDEX (PRIMARY)
4864 WHERE id1=3 AND id2 >1
4865 ORDER BY id2 ASC
4866 FOR UPDATE;
4867 id1 id2
4868 3 3
4869 3 5
4870 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4871 FROM performance_schema.data_locks
4872 WHERE object_name = 't3';
4873 index_name lock_type lock_mode lock_status lock_data
4874 NULL TABLE IX GRANTED NULL
4875 PRIMARY RECORD X GRANTED 3, 3
4876 PRIMARY RECORD X GRANTED 3, 5
4877 PRIMARY RECORD X,GAP GRANTED 1, 1
4878 ROLLBACK;
4879 BEGIN;
4880 SELECT *
4881 FROM t3 FORCE INDEX (PRIMARY)
4882 WHERE id1 >1
4883 ORDER BY id1 DESC
4884 FOR UPDATE;
4885 id1 id2
4886 5 1
4887 5 3
4888 5 5
4889 3 1
4890 3 3
4891 3 5
4892 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4893 FROM performance_schema.data_locks
4894 WHERE object_name = 't3';
4895 index_name lock_type lock_mode lock_status lock_data
4896 NULL TABLE IX GRANTED NULL
4897 PRIMARY RECORD X GRANTED 3, 1
4898 PRIMARY RECORD X GRANTED 3, 3
4899 PRIMARY RECORD X GRANTED 3, 5
4900 PRIMARY RECORD X GRANTED 5, 1
4901 PRIMARY RECORD X GRANTED 5, 3
4902 PRIMARY RECORD X GRANTED 5, 5
4903 PRIMARY RECORD X,GAP GRANTED 1, 1
4904 ROLLBACK;
4905 BEGIN;
4906 SELECT *
4907 FROM t3 FORCE INDEX (PRIMARY)
4908 WHERE id1=3 AND id2 >1
4909 ORDER BY id2 DESC
4910 FOR UPDATE;
4911 id1 id2
4912 3 5
4913 3 3
4914 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4915 FROM performance_schema.data_locks
4916 WHERE object_name = 't3';
4917 index_name lock_type lock_mode lock_status lock_data
4918 NULL TABLE IX GRANTED NULL
4919 PRIMARY RECORD X GRANTED 3, 3
4920 PRIMARY RECORD X GRANTED 3, 5
4921 PRIMARY RECORD X,GAP GRANTED 1, 1
4922 ROLLBACK;
4923 BEGIN;
4924 SELECT *
4925 FROM t3 FORCE INDEX (PRIMARY)
4926 WHERE id1 >=1
4927 ORDER BY id1 ASC
4928 FOR UPDATE;
4929 id1 id2
4930 1 5
4931 1 3
4932 1 1
4933 3 5
4934 3 3
4935 3 1
4936 5 5
4937 5 3
4938 5 1
4939 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4940 FROM performance_schema.data_locks
4941 WHERE object_name = 't3';
4942 index_name lock_type lock_mode lock_status lock_data
4943 NULL TABLE IX GRANTED NULL
4944 PRIMARY RECORD X GRANTED 1, 1
4945 PRIMARY RECORD X GRANTED 1, 3
4946 PRIMARY RECORD X GRANTED 1, 5
4947 PRIMARY RECORD X GRANTED 3, 1
4948 PRIMARY RECORD X GRANTED 3, 3
4949 PRIMARY RECORD X GRANTED 3, 5
4950 PRIMARY RECORD X GRANTED 5, 1
4951 PRIMARY RECORD X GRANTED 5, 3
4952 PRIMARY RECORD X GRANTED 5, 5
4953 PRIMARY RECORD X GRANTED supremum pseudo-record
4954 ROLLBACK;
4955 BEGIN;
4956 SELECT *
4957 FROM t3 FORCE INDEX (PRIMARY)
4958 WHERE id1=3 AND id2 >=1
4959 ORDER BY id2 ASC
4960 FOR UPDATE;
4961 id1 id2
4962 3 1
4963 3 3
4964 3 5
4965 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4966 FROM performance_schema.data_locks
4967 WHERE object_name = 't3';
4968 index_name lock_type lock_mode lock_status lock_data
4969 NULL TABLE IX GRANTED NULL
4970 PRIMARY RECORD X GRANTED 3, 3
4971 PRIMARY RECORD X GRANTED 3, 5
4972 PRIMARY RECORD X,GAP GRANTED 1, 1
4973 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3, 1
4974 ROLLBACK;
4975 BEGIN;
4976 SELECT *
4977 FROM t3 FORCE INDEX (PRIMARY)
4978 WHERE id1 >=1
4979 ORDER BY id1 DESC
4980 FOR UPDATE;
4981 id1 id2
4982 5 1
4983 5 3
4984 5 5
4985 3 1
4986 3 3
4987 3 5
4988 1 1
4989 1 3
4990 1 5
4991 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
4992 FROM performance_schema.data_locks
4993 WHERE object_name = 't3';
4994 index_name lock_type lock_mode lock_status lock_data
4995 NULL TABLE IX GRANTED NULL
4996 PRIMARY RECORD X GRANTED 1, 1
4997 PRIMARY RECORD X GRANTED 1, 3
4998 PRIMARY RECORD X GRANTED 1, 5
4999 PRIMARY RECORD X GRANTED 3, 1
5000 PRIMARY RECORD X GRANTED 3, 3
5001 PRIMARY RECORD X GRANTED 3, 5
5002 PRIMARY RECORD X GRANTED 5, 1
5003 PRIMARY RECORD X GRANTED 5, 3
5004 PRIMARY RECORD X GRANTED 5, 5
5005 PRIMARY RECORD X GRANTED supremum pseudo-record
5006 ROLLBACK;
5007 BEGIN;
5008 SELECT *
5009 FROM t3 FORCE INDEX (PRIMARY)
5010 WHERE id1=3 AND id2 >=1
5011 ORDER BY id2 DESC
5012 FOR UPDATE;
5013 id1 id2
5014 3 5
5015 3 3
5016 3 1
5017 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5018 FROM performance_schema.data_locks
5019 WHERE object_name = 't3';
5020 index_name lock_type lock_mode lock_status lock_data
5021 NULL TABLE IX GRANTED NULL
5022 PRIMARY RECORD X GRANTED 3, 3
5023 PRIMARY RECORD X GRANTED 3, 5
5024 PRIMARY RECORD X,GAP GRANTED 1, 1
5025 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3, 1
5026 ROLLBACK;
5027 DROP TABLE t3;
5028 INSERT INTO t4 (id1,id2) VALUES
5029 (1,1),(1,3),(1,5),(3,1),(3,3),(3,5),(5,1),(5,3),(5,5);
5030 ANALYZE TABLE t4;
5031 Table Op Msg_type Msg_text
5032 test.t4 analyze status OK
5033 BEGIN;
5034 SELECT *
5035 FROM t4 FORCE INDEX (PRIMARY)
5036 WHERE id1 <0
5037 ORDER BY id1 ASC
5038 FOR UPDATE;
5039 id1 id2
5040 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5041 FROM performance_schema.data_locks
5042 WHERE object_name = 't4';
5043 index_name lock_type lock_mode lock_status lock_data
5044 NULL TABLE IX GRANTED NULL
5045 PRIMARY RECORD X GRANTED 1, 1
5046 PRIMARY RECORD X GRANTED supremum pseudo-record
5047 ROLLBACK;
5048 BEGIN;
5049 SELECT *
5050 FROM t4 FORCE INDEX (PRIMARY)
5051 WHERE id1=3 AND id2 <0
5052 ORDER BY id2 ASC
5053 FOR UPDATE;
5054 id1 id2
5055 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5056 FROM performance_schema.data_locks
5057 WHERE object_name = 't4';
5058 index_name lock_type lock_mode lock_status lock_data
5059 NULL TABLE IX GRANTED NULL
5060 PRIMARY RECORD X GRANTED 3, 1
5061 PRIMARY RECORD X,GAP GRANTED 1, 5
5062 ROLLBACK;
5063 BEGIN;
5064 SELECT *
5065 FROM t4 FORCE INDEX (PRIMARY)
5066 WHERE id1 <0
5067 ORDER BY id1 DESC
5068 FOR UPDATE;
5069 id1 id2
5070 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5071 FROM performance_schema.data_locks
5072 WHERE object_name = 't4';
5073 index_name lock_type lock_mode lock_status lock_data
5074 NULL TABLE IX GRANTED NULL
5075 PRIMARY RECORD X GRANTED supremum pseudo-record
5076 ROLLBACK;
5077 BEGIN;
5078 SELECT *
5079 FROM t4 FORCE INDEX (PRIMARY)
5080 WHERE id1=3 AND id2 <0
5081 ORDER BY id2 DESC
5082 FOR UPDATE;
5083 id1 id2
5084 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5085 FROM performance_schema.data_locks
5086 WHERE object_name = 't4';
5087 index_name lock_type lock_mode lock_status lock_data
5088 NULL TABLE IX GRANTED NULL
5089 PRIMARY RECORD X,GAP GRANTED 1, 5
5090 ROLLBACK;
5091 BEGIN;
5092 SELECT *
5093 FROM t4 FORCE INDEX (PRIMARY)
5094 WHERE id1 <1
5095 ORDER BY id1 ASC
5096 FOR UPDATE;
5097 id1 id2
5098 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5099 FROM performance_schema.data_locks
5100 WHERE object_name = 't4';
5101 index_name lock_type lock_mode lock_status lock_data
5102 NULL TABLE IX GRANTED NULL
5103 PRIMARY RECORD X GRANTED 1, 1
5104 PRIMARY RECORD X GRANTED supremum pseudo-record
5105 ROLLBACK;
5106 BEGIN;
5107 SELECT *
5108 FROM t4 FORCE INDEX (PRIMARY)
5109 WHERE id1=3 AND id2 <1
5110 ORDER BY id2 ASC
5111 FOR UPDATE;
5112 id1 id2
5113 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5114 FROM performance_schema.data_locks
5115 WHERE object_name = 't4';
5116 index_name lock_type lock_mode lock_status lock_data
5117 NULL TABLE IX GRANTED NULL
5118 PRIMARY RECORD X GRANTED 3, 1
5119 PRIMARY RECORD X,GAP GRANTED 1, 5
5120 ROLLBACK;
5121 BEGIN;
5122 SELECT *
5123 FROM t4 FORCE INDEX (PRIMARY)
5124 WHERE id1 <1
5125 ORDER BY id1 DESC
5126 FOR UPDATE;
5127 id1 id2
5128 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5129 FROM performance_schema.data_locks
5130 WHERE object_name = 't4';
5131 index_name lock_type lock_mode lock_status lock_data
5132 NULL TABLE IX GRANTED NULL
5133 PRIMARY RECORD X GRANTED supremum pseudo-record
5134 ROLLBACK;
5135 BEGIN;
5136 SELECT *
5137 FROM t4 FORCE INDEX (PRIMARY)
5138 WHERE id1=3 AND id2 <1
5139 ORDER BY id2 DESC
5140 FOR UPDATE;
5141 id1 id2
5142 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5143 FROM performance_schema.data_locks
5144 WHERE object_name = 't4';
5145 index_name lock_type lock_mode lock_status lock_data
5146 NULL TABLE IX GRANTED NULL
5147 PRIMARY RECORD X,GAP GRANTED 1, 5
5148 ROLLBACK;
5149 BEGIN;
5150 SELECT *
5151 FROM t4 FORCE INDEX (PRIMARY)
5152 WHERE id1 <3
5153 ORDER BY id1 ASC
5154 FOR UPDATE;
5155 id1 id2
5156 1 1
5157 1 3
5158 1 5
5159 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5160 FROM performance_schema.data_locks
5161 WHERE object_name = 't4';
5162 index_name lock_type lock_mode lock_status lock_data
5163 NULL TABLE IX GRANTED NULL
5164 PRIMARY RECORD X GRANTED 1, 1
5165 PRIMARY RECORD X GRANTED 1, 3
5166 PRIMARY RECORD X GRANTED 1, 5
5167 PRIMARY RECORD X GRANTED 3, 1
5168 PRIMARY RECORD X GRANTED supremum pseudo-record
5169 ROLLBACK;
5170 BEGIN;
5171 SELECT *
5172 FROM t4 FORCE INDEX (PRIMARY)
5173 WHERE id1=3 AND id2 <3
5174 ORDER BY id2 ASC
5175 FOR UPDATE;
5176 id1 id2
5177 3 1
5178 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5179 FROM performance_schema.data_locks
5180 WHERE object_name = 't4';
5181 index_name lock_type lock_mode lock_status lock_data
5182 NULL TABLE IX GRANTED NULL
5183 PRIMARY RECORD X GRANTED 3, 1
5184 PRIMARY RECORD X GRANTED 3, 3
5185 PRIMARY RECORD X,GAP GRANTED 1, 5
5186 ROLLBACK;
5187 BEGIN;
5188 SELECT *
5189 FROM t4 FORCE INDEX (PRIMARY)
5190 WHERE id1 <3
5191 ORDER BY id1 DESC
5192 FOR UPDATE;
5193 id1 id2
5194 1 5
5195 1 3
5196 1 1
5197 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5198 FROM performance_schema.data_locks
5199 WHERE object_name = 't4';
5200 index_name lock_type lock_mode lock_status lock_data
5201 NULL TABLE IX GRANTED NULL
5202 PRIMARY RECORD X GRANTED 1, 1
5203 PRIMARY RECORD X GRANTED 1, 3
5204 PRIMARY RECORD X GRANTED 1, 5
5205 PRIMARY RECORD X GRANTED supremum pseudo-record
5206 ROLLBACK;
5207 BEGIN;
5208 SELECT *
5209 FROM t4 FORCE INDEX (PRIMARY)
5210 WHERE id1=3 AND id2 <3
5211 ORDER BY id2 DESC
5212 FOR UPDATE;
5213 id1 id2
5214 3 1
5215 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5216 FROM performance_schema.data_locks
5217 WHERE object_name = 't4';
5218 index_name lock_type lock_mode lock_status lock_data
5219 NULL TABLE IX GRANTED NULL
5220 PRIMARY RECORD X GRANTED 3, 1
5221 PRIMARY RECORD X,GAP GRANTED 1, 5
5222 ROLLBACK;
5223 BEGIN;
5224 SELECT *
5225 FROM t4 FORCE INDEX (PRIMARY)
5226 WHERE id1 <=3
5227 ORDER BY id1 ASC
5228 FOR UPDATE;
5229 id1 id2
5230 1 1
5231 1 3
5232 1 5
5233 3 1
5234 3 3
5235 3 5
5236 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5237 FROM performance_schema.data_locks
5238 WHERE object_name = 't4';
5239 index_name lock_type lock_mode lock_status lock_data
5240 NULL TABLE IX GRANTED NULL
5241 PRIMARY RECORD X GRANTED 1, 1
5242 PRIMARY RECORD X GRANTED 1, 3
5243 PRIMARY RECORD X GRANTED 1, 5
5244 PRIMARY RECORD X GRANTED 3, 1
5245 PRIMARY RECORD X GRANTED 3, 3
5246 PRIMARY RECORD X GRANTED 3, 5
5247 PRIMARY RECORD X GRANTED 5, 1
5248 PRIMARY RECORD X GRANTED supremum pseudo-record
5249 ROLLBACK;
5250 BEGIN;
5251 SELECT *
5252 FROM t4 FORCE INDEX (PRIMARY)
5253 WHERE id1=3 AND id2 <=3
5254 ORDER BY id2 ASC
5255 FOR UPDATE;
5256 id1 id2
5257 3 1
5258 3 3
5259 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5260 FROM performance_schema.data_locks
5261 WHERE object_name = 't4';
5262 index_name lock_type lock_mode lock_status lock_data
5263 NULL TABLE IX GRANTED NULL
5264 PRIMARY RECORD X GRANTED 3, 1
5265 PRIMARY RECORD X GRANTED 3, 3
5266 PRIMARY RECORD X GRANTED 3, 5
5267 PRIMARY RECORD X,GAP GRANTED 1, 5
5268 ROLLBACK;
5269 BEGIN;
5270 SELECT *
5271 FROM t4 FORCE INDEX (PRIMARY)
5272 WHERE id1 <=3
5273 ORDER BY id1 DESC
5274 FOR UPDATE;
5275 id1 id2
5276 3 5
5277 3 3
5278 3 1
5279 1 5
5280 1 3
5281 1 1
5282 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5283 FROM performance_schema.data_locks
5284 WHERE object_name = 't4';
5285 index_name lock_type lock_mode lock_status lock_data
5286 NULL TABLE IX GRANTED NULL
5287 PRIMARY RECORD X GRANTED 1, 1
5288 PRIMARY RECORD X GRANTED 1, 3
5289 PRIMARY RECORD X GRANTED 1, 5
5290 PRIMARY RECORD X GRANTED 3, 1
5291 PRIMARY RECORD X GRANTED 3, 3
5292 PRIMARY RECORD X GRANTED 3, 5
5293 PRIMARY RECORD X GRANTED supremum pseudo-record
5294 ROLLBACK;
5295 BEGIN;
5296 SELECT *
5297 FROM t4 FORCE INDEX (PRIMARY)
5298 WHERE id1=3 AND id2 <=3
5299 ORDER BY id2 DESC
5300 FOR UPDATE;
5301 id1 id2
5302 3 3
5303 3 1
5304 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5305 FROM performance_schema.data_locks
5306 WHERE object_name = 't4';
5307 index_name lock_type lock_mode lock_status lock_data
5308 NULL TABLE IX GRANTED NULL
5309 PRIMARY RECORD X GRANTED 3, 1
5310 PRIMARY RECORD X,GAP GRANTED 1, 5
5311 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3, 3
5312 ROLLBACK;
5313 BEGIN;
5314 SELECT *
5315 FROM t4 FORCE INDEX (PRIMARY)
5316 WHERE id1 <=4
5317 ORDER BY id1 ASC
5318 FOR UPDATE;
5319 id1 id2
5320 1 1
5321 1 3
5322 1 5
5323 3 1
5324 3 3
5325 3 5
5326 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5327 FROM performance_schema.data_locks
5328 WHERE object_name = 't4';
5329 index_name lock_type lock_mode lock_status lock_data
5330 NULL TABLE IX GRANTED NULL
5331 PRIMARY RECORD X GRANTED 1, 1
5332 PRIMARY RECORD X GRANTED 1, 3
5333 PRIMARY RECORD X GRANTED 1, 5
5334 PRIMARY RECORD X GRANTED 3, 1
5335 PRIMARY RECORD X GRANTED 3, 3
5336 PRIMARY RECORD X GRANTED 3, 5
5337 PRIMARY RECORD X GRANTED 5, 1
5338 PRIMARY RECORD X GRANTED supremum pseudo-record
5339 ROLLBACK;
5340 BEGIN;
5341 SELECT *
5342 FROM t4 FORCE INDEX (PRIMARY)
5343 WHERE id1=3 AND id2 <=4
5344 ORDER BY id2 ASC
5345 FOR UPDATE;
5346 id1 id2
5347 3 1
5348 3 3
5349 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5350 FROM performance_schema.data_locks
5351 WHERE object_name = 't4';
5352 index_name lock_type lock_mode lock_status lock_data
5353 NULL TABLE IX GRANTED NULL
5354 PRIMARY RECORD X GRANTED 3, 1
5355 PRIMARY RECORD X GRANTED 3, 3
5356 PRIMARY RECORD X GRANTED 3, 5
5357 PRIMARY RECORD X,GAP GRANTED 1, 5
5358 ROLLBACK;
5359 BEGIN;
5360 SELECT *
5361 FROM t4 FORCE INDEX (PRIMARY)
5362 WHERE id1 <=4
5363 ORDER BY id1 DESC
5364 FOR UPDATE;
5365 id1 id2
5366 3 5
5367 3 3
5368 3 1
5369 1 5
5370 1 3
5371 1 1
5372 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5373 FROM performance_schema.data_locks
5374 WHERE object_name = 't4';
5375 index_name lock_type lock_mode lock_status lock_data
5376 NULL TABLE IX GRANTED NULL
5377 PRIMARY RECORD X GRANTED 1, 1
5378 PRIMARY RECORD X GRANTED 1, 3
5379 PRIMARY RECORD X GRANTED 1, 5
5380 PRIMARY RECORD X GRANTED 3, 1
5381 PRIMARY RECORD X GRANTED 3, 3
5382 PRIMARY RECORD X GRANTED 3, 5
5383 PRIMARY RECORD X GRANTED supremum pseudo-record
5384 ROLLBACK;
5385 BEGIN;
5386 SELECT *
5387 FROM t4 FORCE INDEX (PRIMARY)
5388 WHERE id1=3 AND id2 <=4
5389 ORDER BY id2 DESC
5390 FOR UPDATE;
5391 id1 id2
5392 3 3
5393 3 1
5394 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5395 FROM performance_schema.data_locks
5396 WHERE object_name = 't4';
5397 index_name lock_type lock_mode lock_status lock_data
5398 NULL TABLE IX GRANTED NULL
5399 PRIMARY RECORD X GRANTED 3, 1
5400 PRIMARY RECORD X GRANTED 3, 3
5401 PRIMARY RECORD X,GAP GRANTED 1, 5
5402 ROLLBACK;
5403 BEGIN;
5404 SELECT *
5405 FROM t4 FORCE INDEX (PRIMARY)
5406 WHERE id1 <5
5407 ORDER BY id1 ASC
5408 FOR UPDATE;
5409 id1 id2
5410 1 1
5411 1 3
5412 1 5
5413 3 1
5414 3 3
5415 3 5
5416 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5417 FROM performance_schema.data_locks
5418 WHERE object_name = 't4';
5419 index_name lock_type lock_mode lock_status lock_data
5420 NULL TABLE IX GRANTED NULL
5421 PRIMARY RECORD X GRANTED 1, 1
5422 PRIMARY RECORD X GRANTED 1, 3
5423 PRIMARY RECORD X GRANTED 1, 5
5424 PRIMARY RECORD X GRANTED 3, 1
5425 PRIMARY RECORD X GRANTED 3, 3
5426 PRIMARY RECORD X GRANTED 3, 5
5427 PRIMARY RECORD X GRANTED 5, 1
5428 PRIMARY RECORD X GRANTED supremum pseudo-record
5429 ROLLBACK;
5430 BEGIN;
5431 SELECT *
5432 FROM t4 FORCE INDEX (PRIMARY)
5433 WHERE id1=3 AND id2 <5
5434 ORDER BY id2 ASC
5435 FOR UPDATE;
5436 id1 id2
5437 3 1
5438 3 3
5439 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5440 FROM performance_schema.data_locks
5441 WHERE object_name = 't4';
5442 index_name lock_type lock_mode lock_status lock_data
5443 NULL TABLE IX GRANTED NULL
5444 PRIMARY RECORD X GRANTED 3, 1
5445 PRIMARY RECORD X GRANTED 3, 3
5446 PRIMARY RECORD X GRANTED 3, 5
5447 PRIMARY RECORD X,GAP GRANTED 1, 5
5448 ROLLBACK;
5449 BEGIN;
5450 SELECT *
5451 FROM t4 FORCE INDEX (PRIMARY)
5452 WHERE id1 <5
5453 ORDER BY id1 DESC
5454 FOR UPDATE;
5455 id1 id2
5456 3 5
5457 3 3
5458 3 1
5459 1 5
5460 1 3
5461 1 1
5462 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5463 FROM performance_schema.data_locks
5464 WHERE object_name = 't4';
5465 index_name lock_type lock_mode lock_status lock_data
5466 NULL TABLE IX GRANTED NULL
5467 PRIMARY RECORD X GRANTED 1, 1
5468 PRIMARY RECORD X GRANTED 1, 3
5469 PRIMARY RECORD X GRANTED 1, 5
5470 PRIMARY RECORD X GRANTED 3, 1
5471 PRIMARY RECORD X GRANTED 3, 3
5472 PRIMARY RECORD X GRANTED 3, 5
5473 PRIMARY RECORD X GRANTED supremum pseudo-record
5474 ROLLBACK;
5475 BEGIN;
5476 SELECT *
5477 FROM t4 FORCE INDEX (PRIMARY)
5478 WHERE id1=3 AND id2 <5
5479 ORDER BY id2 DESC
5480 FOR UPDATE;
5481 id1 id2
5482 3 3
5483 3 1
5484 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5485 FROM performance_schema.data_locks
5486 WHERE object_name = 't4';
5487 index_name lock_type lock_mode lock_status lock_data
5488 NULL TABLE IX GRANTED NULL
5489 PRIMARY RECORD X GRANTED 3, 1
5490 PRIMARY RECORD X GRANTED 3, 3
5491 PRIMARY RECORD X,GAP GRANTED 1, 5
5492 ROLLBACK;
5493 BEGIN;
5494 SELECT *
5495 FROM t4 FORCE INDEX (PRIMARY)
5496 WHERE id1 <=5
5497 ORDER BY id1 ASC
5498 FOR UPDATE;
5499 id1 id2
5500 1 1
5501 1 3
5502 1 5
5503 3 1
5504 3 3
5505 3 5
5506 5 1
5507 5 3
5508 5 5
5509 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5510 FROM performance_schema.data_locks
5511 WHERE object_name = 't4';
5512 index_name lock_type lock_mode lock_status lock_data
5513 NULL TABLE IX GRANTED NULL
5514 PRIMARY RECORD X GRANTED 1, 1
5515 PRIMARY RECORD X GRANTED 1, 3
5516 PRIMARY RECORD X GRANTED 1, 5
5517 PRIMARY RECORD X GRANTED 3, 1
5518 PRIMARY RECORD X GRANTED 3, 3
5519 PRIMARY RECORD X GRANTED 3, 5
5520 PRIMARY RECORD X GRANTED 5, 1
5521 PRIMARY RECORD X GRANTED 5, 3
5522 PRIMARY RECORD X GRANTED 5, 5
5523 PRIMARY RECORD X GRANTED supremum pseudo-record
5524 ROLLBACK;
5525 BEGIN;
5526 SELECT *
5527 FROM t4 FORCE INDEX (PRIMARY)
5528 WHERE id1=3 AND id2 <=5
5529 ORDER BY id2 ASC
5530 FOR UPDATE;
5531 id1 id2
5532 3 1
5533 3 3
5534 3 5
5535 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5536 FROM performance_schema.data_locks
5537 WHERE object_name = 't4';
5538 index_name lock_type lock_mode lock_status lock_data
5539 NULL TABLE IX GRANTED NULL
5540 PRIMARY RECORD X GRANTED 3, 1
5541 PRIMARY RECORD X GRANTED 3, 3
5542 PRIMARY RECORD X GRANTED 3, 5
5543 PRIMARY RECORD X GRANTED 5, 1
5544 PRIMARY RECORD X,GAP GRANTED 1, 5
5545 ROLLBACK;
5546 BEGIN;
5547 SELECT *
5548 FROM t4 FORCE INDEX (PRIMARY)
5549 WHERE id1 <=5
5550 ORDER BY id1 DESC
5551 FOR UPDATE;
5552 id1 id2
5553 5 5
5554 5 3
5555 5 1
5556 3 5
5557 3 3
5558 3 1
5559 1 5
5560 1 3
5561 1 1
5562 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5563 FROM performance_schema.data_locks
5564 WHERE object_name = 't4';
5565 index_name lock_type lock_mode lock_status lock_data
5566 NULL TABLE IX GRANTED NULL
5567 PRIMARY RECORD X GRANTED 1, 1
5568 PRIMARY RECORD X GRANTED 1, 3
5569 PRIMARY RECORD X GRANTED 1, 5
5570 PRIMARY RECORD X GRANTED 3, 1
5571 PRIMARY RECORD X GRANTED 3, 3
5572 PRIMARY RECORD X GRANTED 3, 5
5573 PRIMARY RECORD X GRANTED 5, 1
5574 PRIMARY RECORD X GRANTED 5, 3
5575 PRIMARY RECORD X GRANTED 5, 5
5576 PRIMARY RECORD X GRANTED supremum pseudo-record
5577 ROLLBACK;
5578 BEGIN;
5579 SELECT *
5580 FROM t4 FORCE INDEX (PRIMARY)
5581 WHERE id1=3 AND id2 <=5
5582 ORDER BY id2 DESC
5583 FOR UPDATE;
5584 id1 id2
5585 3 5
5586 3 3
5587 3 1
5588 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5589 FROM performance_schema.data_locks
5590 WHERE object_name = 't4';
5591 index_name lock_type lock_mode lock_status lock_data
5592 NULL TABLE IX GRANTED NULL
5593 PRIMARY RECORD X GRANTED 3, 1
5594 PRIMARY RECORD X GRANTED 3, 3
5595 PRIMARY RECORD X,GAP GRANTED 1, 5
5596 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3, 5
5597 ROLLBACK;
5598 BEGIN;
5599 SELECT *
5600 FROM t4 FORCE INDEX (PRIMARY)
5601 WHERE id1 >6
5602 ORDER BY id1 ASC
5603 FOR UPDATE;
5604 id1 id2
5605 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5606 FROM performance_schema.data_locks
5607 WHERE object_name = 't4';
5608 index_name lock_type lock_mode lock_status lock_data
5609 NULL TABLE IX GRANTED NULL
5610 PRIMARY RECORD X,GAP GRANTED 5, 5
5611 ROLLBACK;
5612 BEGIN;
5613 SELECT *
5614 FROM t4 FORCE INDEX (PRIMARY)
5615 WHERE id1=3 AND id2 >6
5616 ORDER BY id2 ASC
5617 FOR UPDATE;
5618 id1 id2
5619 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5620 FROM performance_schema.data_locks
5621 WHERE object_name = 't4';
5622 index_name lock_type lock_mode lock_status lock_data
5623 NULL TABLE IX GRANTED NULL
5624 PRIMARY RECORD X GRANTED 5, 1
5625 PRIMARY RECORD X,GAP GRANTED 3, 5
5626 ROLLBACK;
5627 BEGIN;
5628 SELECT *
5629 FROM t4 FORCE INDEX (PRIMARY)
5630 WHERE id1 >6
5631 ORDER BY id1 DESC
5632 FOR UPDATE;
5633 id1 id2
5634 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5635 FROM performance_schema.data_locks
5636 WHERE object_name = 't4';
5637 index_name lock_type lock_mode lock_status lock_data
5638 NULL TABLE IX GRANTED NULL
5639 PRIMARY RECORD X,GAP GRANTED 5, 5
5640 ROLLBACK;
5641 BEGIN;
5642 SELECT *
5643 FROM t4 FORCE INDEX (PRIMARY)
5644 WHERE id1=3 AND id2 >6
5645 ORDER BY id2 DESC
5646 FOR UPDATE;
5647 id1 id2
5648 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5649 FROM performance_schema.data_locks
5650 WHERE object_name = 't4';
5651 index_name lock_type lock_mode lock_status lock_data
5652 NULL TABLE IX GRANTED NULL
5653 PRIMARY RECORD X,GAP GRANTED 3, 5
5654 ROLLBACK;
5655 BEGIN;
5656 SELECT *
5657 FROM t4 FORCE INDEX (PRIMARY)
5658 WHERE id1 >5
5659 ORDER BY id1 ASC
5660 FOR UPDATE;
5661 id1 id2
5662 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5663 FROM performance_schema.data_locks
5664 WHERE object_name = 't4';
5665 index_name lock_type lock_mode lock_status lock_data
5666 NULL TABLE IX GRANTED NULL
5667 PRIMARY RECORD X,GAP GRANTED 5, 5
5668 ROLLBACK;
5669 BEGIN;
5670 SELECT *
5671 FROM t4 FORCE INDEX (PRIMARY)
5672 WHERE id1=3 AND id2 >5
5673 ORDER BY id2 ASC
5674 FOR UPDATE;
5675 id1 id2
5676 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5677 FROM performance_schema.data_locks
5678 WHERE object_name = 't4';
5679 index_name lock_type lock_mode lock_status lock_data
5680 NULL TABLE IX GRANTED NULL
5681 PRIMARY RECORD X GRANTED 5, 1
5682 PRIMARY RECORD X,GAP GRANTED 3, 5
5683 ROLLBACK;
5684 BEGIN;
5685 SELECT *
5686 FROM t4 FORCE INDEX (PRIMARY)
5687 WHERE id1 >5
5688 ORDER BY id1 DESC
5689 FOR UPDATE;
5690 id1 id2
5691 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5692 FROM performance_schema.data_locks
5693 WHERE object_name = 't4';
5694 index_name lock_type lock_mode lock_status lock_data
5695 NULL TABLE IX GRANTED NULL
5696 PRIMARY RECORD X,GAP GRANTED 5, 5
5697 ROLLBACK;
5698 BEGIN;
5699 SELECT *
5700 FROM t4 FORCE INDEX (PRIMARY)
5701 WHERE id1=3 AND id2 >5
5702 ORDER BY id2 DESC
5703 FOR UPDATE;
5704 id1 id2
5705 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5706 FROM performance_schema.data_locks
5707 WHERE object_name = 't4';
5708 index_name lock_type lock_mode lock_status lock_data
5709 NULL TABLE IX GRANTED NULL
5710 PRIMARY RECORD X,GAP GRANTED 3, 5
5711 ROLLBACK;
5712 BEGIN;
5713 SELECT *
5714 FROM t4 FORCE INDEX (PRIMARY)
5715 WHERE id1 >3
5716 ORDER BY id1 ASC
5717 FOR UPDATE;
5718 id1 id2
5719 5 1
5720 5 3
5721 5 5
5722 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5723 FROM performance_schema.data_locks
5724 WHERE object_name = 't4';
5725 index_name lock_type lock_mode lock_status lock_data
5726 NULL TABLE IX GRANTED NULL
5727 PRIMARY RECORD X GRANTED 5, 1
5728 PRIMARY RECORD X GRANTED 5, 3
5729 PRIMARY RECORD X GRANTED 5, 5
5730 PRIMARY RECORD X,GAP GRANTED 3, 5
5731 ROLLBACK;
5732 BEGIN;
5733 SELECT *
5734 FROM t4 FORCE INDEX (PRIMARY)
5735 WHERE id1=3 AND id2 >3
5736 ORDER BY id2 ASC
5737 FOR UPDATE;
5738 id1 id2
5739 3 5
5740 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5741 FROM performance_schema.data_locks
5742 WHERE object_name = 't4';
5743 index_name lock_type lock_mode lock_status lock_data
5744 NULL TABLE IX GRANTED NULL
5745 PRIMARY RECORD X GRANTED 3, 5
5746 PRIMARY RECORD X GRANTED 5, 1
5747 PRIMARY RECORD X,GAP GRANTED 3, 3
5748 ROLLBACK;
5749 BEGIN;
5750 SELECT *
5751 FROM t4 FORCE INDEX (PRIMARY)
5752 WHERE id1 >3
5753 ORDER BY id1 DESC
5754 FOR UPDATE;
5755 id1 id2
5756 5 5
5757 5 3
5758 5 1
5759 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5760 FROM performance_schema.data_locks
5761 WHERE object_name = 't4';
5762 index_name lock_type lock_mode lock_status lock_data
5763 NULL TABLE IX GRANTED NULL
5764 PRIMARY RECORD X GRANTED 5, 1
5765 PRIMARY RECORD X GRANTED 5, 3
5766 PRIMARY RECORD X GRANTED 5, 5
5767 PRIMARY RECORD X,GAP GRANTED 3, 5
5768 ROLLBACK;
5769 BEGIN;
5770 SELECT *
5771 FROM t4 FORCE INDEX (PRIMARY)
5772 WHERE id1=3 AND id2 >3
5773 ORDER BY id2 DESC
5774 FOR UPDATE;
5775 id1 id2
5776 3 5
5777 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5778 FROM performance_schema.data_locks
5779 WHERE object_name = 't4';
5780 index_name lock_type lock_mode lock_status lock_data
5781 NULL TABLE IX GRANTED NULL
5782 PRIMARY RECORD X GRANTED 3, 5
5783 PRIMARY RECORD X,GAP GRANTED 3, 3
5784 ROLLBACK;
5785 BEGIN;
5786 SELECT *
5787 FROM t4 FORCE INDEX (PRIMARY)
5788 WHERE id1 >=3
5789 ORDER BY id1 ASC
5790 FOR UPDATE;
5791 id1 id2
5792 3 1
5793 3 3
5794 3 5
5795 5 1
5796 5 3
5797 5 5
5798 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5799 FROM performance_schema.data_locks
5800 WHERE object_name = 't4';
5801 index_name lock_type lock_mode lock_status lock_data
5802 NULL TABLE IX GRANTED NULL
5803 PRIMARY RECORD X GRANTED 3, 1
5804 PRIMARY RECORD X GRANTED 3, 3
5805 PRIMARY RECORD X GRANTED 3, 5
5806 PRIMARY RECORD X GRANTED 5, 1
5807 PRIMARY RECORD X GRANTED 5, 3
5808 PRIMARY RECORD X GRANTED 5, 5
5809 PRIMARY RECORD X,GAP GRANTED 1, 5
5810 ROLLBACK;
5811 BEGIN;
5812 SELECT *
5813 FROM t4 FORCE INDEX (PRIMARY)
5814 WHERE id1=3 AND id2 >=3
5815 ORDER BY id2 ASC
5816 FOR UPDATE;
5817 id1 id2
5818 3 3
5819 3 5
5820 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5821 FROM performance_schema.data_locks
5822 WHERE object_name = 't4';
5823 index_name lock_type lock_mode lock_status lock_data
5824 NULL TABLE IX GRANTED NULL
5825 PRIMARY RECORD X GRANTED 3, 3
5826 PRIMARY RECORD X GRANTED 3, 5
5827 PRIMARY RECORD X GRANTED 5, 1
5828 PRIMARY RECORD X,GAP GRANTED 3, 1
5829 ROLLBACK;
5830 BEGIN;
5831 SELECT *
5832 FROM t4 FORCE INDEX (PRIMARY)
5833 WHERE id1 >=3
5834 ORDER BY id1 DESC
5835 FOR UPDATE;
5836 id1 id2
5837 5 5
5838 5 3
5839 5 1
5840 3 5
5841 3 3
5842 3 1
5843 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5844 FROM performance_schema.data_locks
5845 WHERE object_name = 't4';
5846 index_name lock_type lock_mode lock_status lock_data
5847 NULL TABLE IX GRANTED NULL
5848 PRIMARY RECORD X GRANTED 3, 1
5849 PRIMARY RECORD X GRANTED 3, 3
5850 PRIMARY RECORD X GRANTED 3, 5
5851 PRIMARY RECORD X GRANTED 5, 1
5852 PRIMARY RECORD X GRANTED 5, 3
5853 PRIMARY RECORD X GRANTED 5, 5
5854 PRIMARY RECORD X,GAP GRANTED 1, 5
5855 ROLLBACK;
5856 BEGIN;
5857 SELECT *
5858 FROM t4 FORCE INDEX (PRIMARY)
5859 WHERE id1=3 AND id2 >=3
5860 ORDER BY id2 DESC
5861 FOR UPDATE;
5862 id1 id2
5863 3 5
5864 3 3
5865 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5866 FROM performance_schema.data_locks
5867 WHERE object_name = 't4';
5868 index_name lock_type lock_mode lock_status lock_data
5869 NULL TABLE IX GRANTED NULL
5870 PRIMARY RECORD X GRANTED 3, 3
5871 PRIMARY RECORD X GRANTED 3, 5
5872 ROLLBACK;
5873 BEGIN;
5874 SELECT *
5875 FROM t4 FORCE INDEX (PRIMARY)
5876 WHERE id1 >=2
5877 ORDER BY id1 ASC
5878 FOR UPDATE;
5879 id1 id2
5880 3 1
5881 3 3
5882 3 5
5883 5 1
5884 5 3
5885 5 5
5886 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5887 FROM performance_schema.data_locks
5888 WHERE object_name = 't4';
5889 index_name lock_type lock_mode lock_status lock_data
5890 NULL TABLE IX GRANTED NULL
5891 PRIMARY RECORD X GRANTED 3, 1
5892 PRIMARY RECORD X GRANTED 3, 3
5893 PRIMARY RECORD X GRANTED 3, 5
5894 PRIMARY RECORD X GRANTED 5, 1
5895 PRIMARY RECORD X GRANTED 5, 3
5896 PRIMARY RECORD X GRANTED 5, 5
5897 PRIMARY RECORD X,GAP GRANTED 1, 5
5898 ROLLBACK;
5899 BEGIN;
5900 SELECT *
5901 FROM t4 FORCE INDEX (PRIMARY)
5902 WHERE id1=3 AND id2 >=2
5903 ORDER BY id2 ASC
5904 FOR UPDATE;
5905 id1 id2
5906 3 3
5907 3 5
5908 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5909 FROM performance_schema.data_locks
5910 WHERE object_name = 't4';
5911 index_name lock_type lock_mode lock_status lock_data
5912 NULL TABLE IX GRANTED NULL
5913 PRIMARY RECORD X GRANTED 3, 3
5914 PRIMARY RECORD X GRANTED 3, 5
5915 PRIMARY RECORD X GRANTED 5, 1
5916 PRIMARY RECORD X,GAP GRANTED 3, 1
5917 ROLLBACK;
5918 BEGIN;
5919 SELECT *
5920 FROM t4 FORCE INDEX (PRIMARY)
5921 WHERE id1 >=2
5922 ORDER BY id1 DESC
5923 FOR UPDATE;
5924 id1 id2
5925 5 5
5926 5 3
5927 5 1
5928 3 5
5929 3 3
5930 3 1
5931 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5932 FROM performance_schema.data_locks
5933 WHERE object_name = 't4';
5934 index_name lock_type lock_mode lock_status lock_data
5935 NULL TABLE IX GRANTED NULL
5936 PRIMARY RECORD X GRANTED 3, 1
5937 PRIMARY RECORD X GRANTED 3, 3
5938 PRIMARY RECORD X GRANTED 3, 5
5939 PRIMARY RECORD X GRANTED 5, 1
5940 PRIMARY RECORD X GRANTED 5, 3
5941 PRIMARY RECORD X GRANTED 5, 5
5942 PRIMARY RECORD X,GAP GRANTED 1, 5
5943 ROLLBACK;
5944 BEGIN;
5945 SELECT *
5946 FROM t4 FORCE INDEX (PRIMARY)
5947 WHERE id1=3 AND id2 >=2
5948 ORDER BY id2 DESC
5949 FOR UPDATE;
5950 id1 id2
5951 3 5
5952 3 3
5953 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5954 FROM performance_schema.data_locks
5955 WHERE object_name = 't4';
5956 index_name lock_type lock_mode lock_status lock_data
5957 NULL TABLE IX GRANTED NULL
5958 PRIMARY RECORD X GRANTED 3, 3
5959 PRIMARY RECORD X GRANTED 3, 5
5960 PRIMARY RECORD X,GAP GRANTED 3, 1
5961 ROLLBACK;
5962 BEGIN;
5963 SELECT *
5964 FROM t4 FORCE INDEX (PRIMARY)
5965 WHERE id1 >1
5966 ORDER BY id1 ASC
5967 FOR UPDATE;
5968 id1 id2
5969 3 1
5970 3 3
5971 3 5
5972 5 1
5973 5 3
5974 5 5
5975 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5976 FROM performance_schema.data_locks
5977 WHERE object_name = 't4';
5978 index_name lock_type lock_mode lock_status lock_data
5979 NULL TABLE IX GRANTED NULL
5980 PRIMARY RECORD X GRANTED 3, 1
5981 PRIMARY RECORD X GRANTED 3, 3
5982 PRIMARY RECORD X GRANTED 3, 5
5983 PRIMARY RECORD X GRANTED 5, 1
5984 PRIMARY RECORD X GRANTED 5, 3
5985 PRIMARY RECORD X GRANTED 5, 5
5986 PRIMARY RECORD X,GAP GRANTED 1, 5
5987 ROLLBACK;
5988 BEGIN;
5989 SELECT *
5990 FROM t4 FORCE INDEX (PRIMARY)
5991 WHERE id1=3 AND id2 >1
5992 ORDER BY id2 ASC
5993 FOR UPDATE;
5994 id1 id2
5995 3 3
5996 3 5
5997 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
5998 FROM performance_schema.data_locks
5999 WHERE object_name = 't4';
6000 index_name lock_type lock_mode lock_status lock_data
6001 NULL TABLE IX GRANTED NULL
6002 PRIMARY RECORD X GRANTED 3, 3
6003 PRIMARY RECORD X GRANTED 3, 5
6004 PRIMARY RECORD X GRANTED 5, 1
6005 PRIMARY RECORD X,GAP GRANTED 3, 1
6006 ROLLBACK;
6007 BEGIN;
6008 SELECT *
6009 FROM t4 FORCE INDEX (PRIMARY)
6010 WHERE id1 >1
6011 ORDER BY id1 DESC
6012 FOR UPDATE;
6013 id1 id2
6014 5 5
6015 5 3
6016 5 1
6017 3 5
6018 3 3
6019 3 1
6020 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6021 FROM performance_schema.data_locks
6022 WHERE object_name = 't4';
6023 index_name lock_type lock_mode lock_status lock_data
6024 NULL TABLE IX GRANTED NULL
6025 PRIMARY RECORD X GRANTED 3, 1
6026 PRIMARY RECORD X GRANTED 3, 3
6027 PRIMARY RECORD X GRANTED 3, 5
6028 PRIMARY RECORD X GRANTED 5, 1
6029 PRIMARY RECORD X GRANTED 5, 3
6030 PRIMARY RECORD X GRANTED 5, 5
6031 PRIMARY RECORD X,GAP GRANTED 1, 5
6032 ROLLBACK;
6033 BEGIN;
6034 SELECT *
6035 FROM t4 FORCE INDEX (PRIMARY)
6036 WHERE id1=3 AND id2 >1
6037 ORDER BY id2 DESC
6038 FOR UPDATE;
6039 id1 id2
6040 3 5
6041 3 3
6042 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6043 FROM performance_schema.data_locks
6044 WHERE object_name = 't4';
6045 index_name lock_type lock_mode lock_status lock_data
6046 NULL TABLE IX GRANTED NULL
6047 PRIMARY RECORD X GRANTED 3, 3
6048 PRIMARY RECORD X GRANTED 3, 5
6049 PRIMARY RECORD X,GAP GRANTED 3, 1
6050 ROLLBACK;
6051 BEGIN;
6052 SELECT *
6053 FROM t4 FORCE INDEX (PRIMARY)
6054 WHERE id1 >=1
6055 ORDER BY id1 ASC
6056 FOR UPDATE;
6057 id1 id2
6058 1 1
6059 1 3
6060 1 5
6061 3 1
6062 3 3
6063 3 5
6064 5 1
6065 5 3
6066 5 5
6067 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6068 FROM performance_schema.data_locks
6069 WHERE object_name = 't4';
6070 index_name lock_type lock_mode lock_status lock_data
6071 NULL TABLE IX GRANTED NULL
6072 PRIMARY RECORD X GRANTED 1, 1
6073 PRIMARY RECORD X GRANTED 1, 3
6074 PRIMARY RECORD X GRANTED 1, 5
6075 PRIMARY RECORD X GRANTED 3, 1
6076 PRIMARY RECORD X GRANTED 3, 3
6077 PRIMARY RECORD X GRANTED 3, 5
6078 PRIMARY RECORD X GRANTED 5, 1
6079 PRIMARY RECORD X GRANTED 5, 3
6080 PRIMARY RECORD X GRANTED 5, 5
6081 PRIMARY RECORD X GRANTED supremum pseudo-record
6082 ROLLBACK;
6083 BEGIN;
6084 SELECT *
6085 FROM t4 FORCE INDEX (PRIMARY)
6086 WHERE id1=3 AND id2 >=1
6087 ORDER BY id2 ASC
6088 FOR UPDATE;
6089 id1 id2
6090 3 1
6091 3 3
6092 3 5
6093 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6094 FROM performance_schema.data_locks
6095 WHERE object_name = 't4';
6096 index_name lock_type lock_mode lock_status lock_data
6097 NULL TABLE IX GRANTED NULL
6098 PRIMARY RECORD X GRANTED 3, 1
6099 PRIMARY RECORD X GRANTED 3, 3
6100 PRIMARY RECORD X GRANTED 3, 5
6101 PRIMARY RECORD X GRANTED 5, 1
6102 PRIMARY RECORD X,GAP GRANTED 1, 5
6103 ROLLBACK;
6104 BEGIN;
6105 SELECT *
6106 FROM t4 FORCE INDEX (PRIMARY)
6107 WHERE id1 >=1
6108 ORDER BY id1 DESC
6109 FOR UPDATE;
6110 id1 id2
6111 5 5
6112 5 3
6113 5 1
6114 3 5
6115 3 3
6116 3 1
6117 1 5
6118 1 3
6119 1 1
6120 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6121 FROM performance_schema.data_locks
6122 WHERE object_name = 't4';
6123 index_name lock_type lock_mode lock_status lock_data
6124 NULL TABLE IX GRANTED NULL
6125 PRIMARY RECORD X GRANTED 1, 1
6126 PRIMARY RECORD X GRANTED 1, 3
6127 PRIMARY RECORD X GRANTED 1, 5
6128 PRIMARY RECORD X GRANTED 3, 1
6129 PRIMARY RECORD X GRANTED 3, 3
6130 PRIMARY RECORD X GRANTED 3, 5
6131 PRIMARY RECORD X GRANTED 5, 1
6132 PRIMARY RECORD X GRANTED 5, 3
6133 PRIMARY RECORD X GRANTED 5, 5
6134 PRIMARY RECORD X GRANTED supremum pseudo-record
6135 ROLLBACK;
6136 BEGIN;
6137 SELECT *
6138 FROM t4 FORCE INDEX (PRIMARY)
6139 WHERE id1=3 AND id2 >=1
6140 ORDER BY id2 DESC
6141 FOR UPDATE;
6142 id1 id2
6143 3 5
6144 3 3
6145 3 1
6146 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6147 FROM performance_schema.data_locks
6148 WHERE object_name = 't4';
6149 index_name lock_type lock_mode lock_status lock_data
6150 NULL TABLE IX GRANTED NULL
6151 PRIMARY RECORD X GRANTED 3, 1
6152 PRIMARY RECORD X GRANTED 3, 3
6153 PRIMARY RECORD X GRANTED 3, 5
6154 ROLLBACK;
6155 DROP TABLE t4;
6156 CREATE TABLE t1 (
6157 id VARCHAR(100) NOT NULL,
6158 PRIMARY KEY (id(1) ASC)
6159 ) ENGINE=InnoDB;
6160 CREATE TABLE t2 (
6161 id VARCHAR(100) NOT NULL,
6162 PRIMARY KEY (id(1) DESC)
6163 ) ENGINE=InnoDB;
6164 SET @conditions = CONCAT(
6165 '<="c" <="d" <"e" <"ee" <="ee" <="ec" <="ef" ',
6166 '>="g" >="f" >"e" >"ee" >="ee" >="ef" >="ec"'
6167 );
6168 INSERT INTO t1
6169 VALUES ("aa"), ("bb"), ("cc"), ("ee"), ("gg"), ("hh"), ("ii");
6170 ANALYZE TABLE t1;
6171 Table Op Msg_type Msg_text
6172 test.t1 analyze status OK
6173 BEGIN;
6174 SELECT *
6175 FROM t1 FORCE INDEX (PRIMARY)
6176 WHERE id <="c"
6177 ORDER BY id ASC
6178 FOR UPDATE;
6179 id
6180 aa
6181 bb
6182 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6183 FROM performance_schema.data_locks
6184 WHERE object_name = 't1';
6185 index_name lock_type lock_mode lock_status lock_data
6186 NULL TABLE IX GRANTED NULL
6187 PRIMARY RECORD X GRANTED 'a'
6188 PRIMARY RECORD X GRANTED 'b'
6189 PRIMARY RECORD X GRANTED 'c'
6190 ROLLBACK;
6191 BEGIN;
6192 SELECT *
6193 FROM t1 FORCE INDEX (PRIMARY)
6194 WHERE id <="c"
6195 ORDER BY id DESC
6196 FOR UPDATE;
6197 id
6198 bb
6199 aa
6200 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6201 FROM performance_schema.data_locks
6202 WHERE object_name = 't1';
6203 index_name lock_type lock_mode lock_status lock_data
6204 NULL TABLE IX GRANTED NULL
6205 PRIMARY RECORD X GRANTED 'a'
6206 PRIMARY RECORD X GRANTED 'b'
6207 PRIMARY RECORD X GRANTED 'c'
6208 ROLLBACK;
6209 BEGIN;
6210 SELECT *
6211 FROM t1 FORCE INDEX (PRIMARY)
6212 WHERE id <="d"
6213 ORDER BY id ASC
6214 FOR UPDATE;
6215 id
6216 aa
6217 bb
6218 cc
6219 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6220 FROM performance_schema.data_locks
6221 WHERE object_name = 't1';
6222 index_name lock_type lock_mode lock_status lock_data
6223 NULL TABLE IX GRANTED NULL
6224 PRIMARY RECORD X GRANTED 'a'
6225 PRIMARY RECORD X GRANTED 'b'
6226 PRIMARY RECORD X GRANTED 'c'
6227 PRIMARY RECORD X,GAP GRANTED 'e'
6228 ROLLBACK;
6229 BEGIN;
6230 SELECT *
6231 FROM t1 FORCE INDEX (PRIMARY)
6232 WHERE id <="d"
6233 ORDER BY id DESC
6234 FOR UPDATE;
6235 id
6236 cc
6237 bb
6238 aa
6239 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6240 FROM performance_schema.data_locks
6241 WHERE object_name = 't1';
6242 index_name lock_type lock_mode lock_status lock_data
6243 NULL TABLE IX GRANTED NULL
6244 PRIMARY RECORD X GRANTED 'a'
6245 PRIMARY RECORD X GRANTED 'b'
6246 PRIMARY RECORD X GRANTED 'c'
6247 PRIMARY RECORD X,GAP GRANTED 'e'
6248 ROLLBACK;
6249 BEGIN;
6250 SELECT *
6251 FROM t1 FORCE INDEX (PRIMARY)
6252 WHERE id <"e"
6253 ORDER BY id ASC
6254 FOR UPDATE;
6255 id
6256 aa
6257 bb
6258 cc
6259 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6260 FROM performance_schema.data_locks
6261 WHERE object_name = 't1';
6262 index_name lock_type lock_mode lock_status lock_data
6263 NULL TABLE IX GRANTED NULL
6264 PRIMARY RECORD X GRANTED 'a'
6265 PRIMARY RECORD X GRANTED 'b'
6266 PRIMARY RECORD X GRANTED 'c'
6267 PRIMARY RECORD X GRANTED 'e'
6268 ROLLBACK;
6269 BEGIN;
6270 SELECT *
6271 FROM t1 FORCE INDEX (PRIMARY)
6272 WHERE id <"e"
6273 ORDER BY id DESC
6274 FOR UPDATE;
6275 id
6276 cc
6277 bb
6278 aa
6279 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6280 FROM performance_schema.data_locks
6281 WHERE object_name = 't1';
6282 index_name lock_type lock_mode lock_status lock_data
6283 NULL TABLE IX GRANTED NULL
6284 PRIMARY RECORD X GRANTED 'a'
6285 PRIMARY RECORD X GRANTED 'b'
6286 PRIMARY RECORD X GRANTED 'c'
6287 PRIMARY RECORD X GRANTED 'e'
6288 ROLLBACK;
6289 BEGIN;
6290 SELECT *
6291 FROM t1 FORCE INDEX (PRIMARY)
6292 WHERE id <"ee"
6293 ORDER BY id ASC
6294 FOR UPDATE;
6295 id
6296 aa
6297 bb
6298 cc
6299 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6300 FROM performance_schema.data_locks
6301 WHERE object_name = 't1';
6302 index_name lock_type lock_mode lock_status lock_data
6303 NULL TABLE IX GRANTED NULL
6304 PRIMARY RECORD X GRANTED 'a'
6305 PRIMARY RECORD X GRANTED 'b'
6306 PRIMARY RECORD X GRANTED 'c'
6307 PRIMARY RECORD X GRANTED 'e'
6308 ROLLBACK;
6309 BEGIN;
6310 SELECT *
6311 FROM t1 FORCE INDEX (PRIMARY)
6312 WHERE id <"ee"
6313 ORDER BY id DESC
6314 FOR UPDATE;
6315 id
6316 cc
6317 bb
6318 aa
6319 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6320 FROM performance_schema.data_locks
6321 WHERE object_name = 't1';
6322 index_name lock_type lock_mode lock_status lock_data
6323 NULL TABLE IX GRANTED NULL
6324 PRIMARY RECORD X GRANTED 'a'
6325 PRIMARY RECORD X GRANTED 'b'
6326 PRIMARY RECORD X GRANTED 'c'
6327 PRIMARY RECORD X GRANTED 'e'
6328 ROLLBACK;
6329 BEGIN;
6330 SELECT *
6331 FROM t1 FORCE INDEX (PRIMARY)
6332 WHERE id <="ee"
6333 ORDER BY id ASC
6334 FOR UPDATE;
6335 id
6336 aa
6337 bb
6338 cc
6339 ee
6340 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6341 FROM performance_schema.data_locks
6342 WHERE object_name = 't1';
6343 index_name lock_type lock_mode lock_status lock_data
6344 NULL TABLE IX GRANTED NULL
6345 PRIMARY RECORD X GRANTED 'a'
6346 PRIMARY RECORD X GRANTED 'b'
6347 PRIMARY RECORD X GRANTED 'c'
6348 PRIMARY RECORD X GRANTED 'e'
6349 ROLLBACK;
6350 BEGIN;
6351 SELECT *
6352 FROM t1 FORCE INDEX (PRIMARY)
6353 WHERE id <="ee"
6354 ORDER BY id DESC
6355 FOR UPDATE;
6356 id
6357 ee
6358 cc
6359 bb
6360 aa
6361 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6362 FROM performance_schema.data_locks
6363 WHERE object_name = 't1';
6364 index_name lock_type lock_mode lock_status lock_data
6365 NULL TABLE IX GRANTED NULL
6366 PRIMARY RECORD X GRANTED 'a'
6367 PRIMARY RECORD X GRANTED 'b'
6368 PRIMARY RECORD X GRANTED 'c'
6369 PRIMARY RECORD X GRANTED 'e'
6370 ROLLBACK;
6371 BEGIN;
6372 SELECT *
6373 FROM t1 FORCE INDEX (PRIMARY)
6374 WHERE id <="ec"
6375 ORDER BY id ASC
6376 FOR UPDATE;
6377 id
6378 aa
6379 bb
6380 cc
6381 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6382 FROM performance_schema.data_locks
6383 WHERE object_name = 't1';
6384 index_name lock_type lock_mode lock_status lock_data
6385 NULL TABLE IX GRANTED NULL
6386 PRIMARY RECORD X GRANTED 'a'
6387 PRIMARY RECORD X GRANTED 'b'
6388 PRIMARY RECORD X GRANTED 'c'
6389 PRIMARY RECORD X GRANTED 'e'
6390 ROLLBACK;
6391 BEGIN;
6392 SELECT *
6393 FROM t1 FORCE INDEX (PRIMARY)
6394 WHERE id <="ec"
6395 ORDER BY id DESC
6396 FOR UPDATE;
6397 id
6398 cc
6399 bb
6400 aa
6401 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6402 FROM performance_schema.data_locks
6403 WHERE object_name = 't1';
6404 index_name lock_type lock_mode lock_status lock_data
6405 NULL TABLE IX GRANTED NULL
6406 PRIMARY RECORD X GRANTED 'a'
6407 PRIMARY RECORD X GRANTED 'b'
6408 PRIMARY RECORD X GRANTED 'c'
6409 PRIMARY RECORD X GRANTED 'e'
6410 ROLLBACK;
6411 BEGIN;
6412 SELECT *
6413 FROM t1 FORCE INDEX (PRIMARY)
6414 WHERE id <="ef"
6415 ORDER BY id ASC
6416 FOR UPDATE;
6417 id
6418 aa
6419 bb
6420 cc
6421 ee
6422 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6423 FROM performance_schema.data_locks
6424 WHERE object_name = 't1';
6425 index_name lock_type lock_mode lock_status lock_data
6426 NULL TABLE IX GRANTED NULL
6427 PRIMARY RECORD X GRANTED 'a'
6428 PRIMARY RECORD X GRANTED 'b'
6429 PRIMARY RECORD X GRANTED 'c'
6430 PRIMARY RECORD X GRANTED 'e'
6431 ROLLBACK;
6432 BEGIN;
6433 SELECT *
6434 FROM t1 FORCE INDEX (PRIMARY)
6435 WHERE id <="ef"
6436 ORDER BY id DESC
6437 FOR UPDATE;
6438 id
6439 ee
6440 cc
6441 bb
6442 aa
6443 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6444 FROM performance_schema.data_locks
6445 WHERE object_name = 't1';
6446 index_name lock_type lock_mode lock_status lock_data
6447 NULL TABLE IX GRANTED NULL
6448 PRIMARY RECORD X GRANTED 'a'
6449 PRIMARY RECORD X GRANTED 'b'
6450 PRIMARY RECORD X GRANTED 'c'
6451 PRIMARY RECORD X GRANTED 'e'
6452 ROLLBACK;
6453 BEGIN;
6454 SELECT *
6455 FROM t1 FORCE INDEX (PRIMARY)
6456 WHERE id >="g"
6457 ORDER BY id ASC
6458 FOR UPDATE;
6459 id
6460 gg
6461 hh
6462 ii
6463 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6464 FROM performance_schema.data_locks
6465 WHERE object_name = 't1';
6466 index_name lock_type lock_mode lock_status lock_data
6467 NULL TABLE IX GRANTED NULL
6468 PRIMARY RECORD X GRANTED 'h'
6469 PRIMARY RECORD X GRANTED 'i'
6470 PRIMARY RECORD X GRANTED supremum pseudo-record
6471 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'g'
6472 ROLLBACK;
6473 BEGIN;
6474 SELECT *
6475 FROM t1 FORCE INDEX (PRIMARY)
6476 WHERE id >="g"
6477 ORDER BY id DESC
6478 FOR UPDATE;
6479 id
6480 ii
6481 hh
6482 gg
6483 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6484 FROM performance_schema.data_locks
6485 WHERE object_name = 't1';
6486 index_name lock_type lock_mode lock_status lock_data
6487 NULL TABLE IX GRANTED NULL
6488 PRIMARY RECORD X GRANTED 'h'
6489 PRIMARY RECORD X GRANTED 'i'
6490 PRIMARY RECORD X GRANTED supremum pseudo-record
6491 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'g'
6492 ROLLBACK;
6493 BEGIN;
6494 SELECT *
6495 FROM t1 FORCE INDEX (PRIMARY)
6496 WHERE id >="f"
6497 ORDER BY id ASC
6498 FOR UPDATE;
6499 id
6500 gg
6501 hh
6502 ii
6503 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6504 FROM performance_schema.data_locks
6505 WHERE object_name = 't1';
6506 index_name lock_type lock_mode lock_status lock_data
6507 NULL TABLE IX GRANTED NULL
6508 PRIMARY RECORD X GRANTED 'g'
6509 PRIMARY RECORD X GRANTED 'h'
6510 PRIMARY RECORD X GRANTED 'i'
6511 PRIMARY RECORD X GRANTED supremum pseudo-record
6512 ROLLBACK;
6513 BEGIN;
6514 SELECT *
6515 FROM t1 FORCE INDEX (PRIMARY)
6516 WHERE id >="f"
6517 ORDER BY id DESC
6518 FOR UPDATE;
6519 id
6520 ii
6521 hh
6522 gg
6523 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6524 FROM performance_schema.data_locks
6525 WHERE object_name = 't1';
6526 index_name lock_type lock_mode lock_status lock_data
6527 NULL TABLE IX GRANTED NULL
6528 PRIMARY RECORD X GRANTED 'g'
6529 PRIMARY RECORD X GRANTED 'h'
6530 PRIMARY RECORD X GRANTED 'i'
6531 PRIMARY RECORD X GRANTED supremum pseudo-record
6532 ROLLBACK;
6533 BEGIN;
6534 SELECT *
6535 FROM t1 FORCE INDEX (PRIMARY)
6536 WHERE id >"e"
6537 ORDER BY id ASC
6538 FOR UPDATE;
6539 id
6540 ee
6541 gg
6542 hh
6543 ii
6544 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6545 FROM performance_schema.data_locks
6546 WHERE object_name = 't1';
6547 index_name lock_type lock_mode lock_status lock_data
6548 NULL TABLE IX GRANTED NULL
6549 PRIMARY RECORD X GRANTED 'g'
6550 PRIMARY RECORD X GRANTED 'h'
6551 PRIMARY RECORD X GRANTED 'i'
6552 PRIMARY RECORD X GRANTED supremum pseudo-record
6553 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6554 ROLLBACK;
6555 BEGIN;
6556 SELECT *
6557 FROM t1 FORCE INDEX (PRIMARY)
6558 WHERE id >"e"
6559 ORDER BY id DESC
6560 FOR UPDATE;
6561 id
6562 ii
6563 hh
6564 gg
6565 ee
6566 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6567 FROM performance_schema.data_locks
6568 WHERE object_name = 't1';
6569 index_name lock_type lock_mode lock_status lock_data
6570 NULL TABLE IX GRANTED NULL
6571 PRIMARY RECORD X GRANTED 'g'
6572 PRIMARY RECORD X GRANTED 'h'
6573 PRIMARY RECORD X GRANTED 'i'
6574 PRIMARY RECORD X GRANTED supremum pseudo-record
6575 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6576 ROLLBACK;
6577 BEGIN;
6578 SELECT *
6579 FROM t1 FORCE INDEX (PRIMARY)
6580 WHERE id >"ee"
6581 ORDER BY id ASC
6582 FOR UPDATE;
6583 id
6584 gg
6585 hh
6586 ii
6587 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6588 FROM performance_schema.data_locks
6589 WHERE object_name = 't1';
6590 index_name lock_type lock_mode lock_status lock_data
6591 NULL TABLE IX GRANTED NULL
6592 PRIMARY RECORD X GRANTED 'g'
6593 PRIMARY RECORD X GRANTED 'h'
6594 PRIMARY RECORD X GRANTED 'i'
6595 PRIMARY RECORD X GRANTED supremum pseudo-record
6596 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6597 ROLLBACK;
6598 BEGIN;
6599 SELECT *
6600 FROM t1 FORCE INDEX (PRIMARY)
6601 WHERE id >"ee"
6602 ORDER BY id DESC
6603 FOR UPDATE;
6604 id
6605 ii
6606 hh
6607 gg
6608 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6609 FROM performance_schema.data_locks
6610 WHERE object_name = 't1';
6611 index_name lock_type lock_mode lock_status lock_data
6612 NULL TABLE IX GRANTED NULL
6613 PRIMARY RECORD X GRANTED 'g'
6614 PRIMARY RECORD X GRANTED 'h'
6615 PRIMARY RECORD X GRANTED 'i'
6616 PRIMARY RECORD X GRANTED supremum pseudo-record
6617 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6618 ROLLBACK;
6619 BEGIN;
6620 SELECT *
6621 FROM t1 FORCE INDEX (PRIMARY)
6622 WHERE id >="ee"
6623 ORDER BY id ASC
6624 FOR UPDATE;
6625 id
6626 ee
6627 gg
6628 hh
6629 ii
6630 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6631 FROM performance_schema.data_locks
6632 WHERE object_name = 't1';
6633 index_name lock_type lock_mode lock_status lock_data
6634 NULL TABLE IX GRANTED NULL
6635 PRIMARY RECORD X GRANTED 'g'
6636 PRIMARY RECORD X GRANTED 'h'
6637 PRIMARY RECORD X GRANTED 'i'
6638 PRIMARY RECORD X GRANTED supremum pseudo-record
6639 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6640 ROLLBACK;
6641 BEGIN;
6642 SELECT *
6643 FROM t1 FORCE INDEX (PRIMARY)
6644 WHERE id >="ee"
6645 ORDER BY id DESC
6646 FOR UPDATE;
6647 id
6648 ii
6649 hh
6650 gg
6651 ee
6652 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6653 FROM performance_schema.data_locks
6654 WHERE object_name = 't1';
6655 index_name lock_type lock_mode lock_status lock_data
6656 NULL TABLE IX GRANTED NULL
6657 PRIMARY RECORD X GRANTED 'g'
6658 PRIMARY RECORD X GRANTED 'h'
6659 PRIMARY RECORD X GRANTED 'i'
6660 PRIMARY RECORD X GRANTED supremum pseudo-record
6661 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6662 ROLLBACK;
6663 BEGIN;
6664 SELECT *
6665 FROM t1 FORCE INDEX (PRIMARY)
6666 WHERE id >="ef"
6667 ORDER BY id ASC
6668 FOR UPDATE;
6669 id
6670 gg
6671 hh
6672 ii
6673 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6674 FROM performance_schema.data_locks
6675 WHERE object_name = 't1';
6676 index_name lock_type lock_mode lock_status lock_data
6677 NULL TABLE IX GRANTED NULL
6678 PRIMARY RECORD X GRANTED 'g'
6679 PRIMARY RECORD X GRANTED 'h'
6680 PRIMARY RECORD X GRANTED 'i'
6681 PRIMARY RECORD X GRANTED supremum pseudo-record
6682 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6683 ROLLBACK;
6684 BEGIN;
6685 SELECT *
6686 FROM t1 FORCE INDEX (PRIMARY)
6687 WHERE id >="ef"
6688 ORDER BY id DESC
6689 FOR UPDATE;
6690 id
6691 ii
6692 hh
6693 gg
6694 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6695 FROM performance_schema.data_locks
6696 WHERE object_name = 't1';
6697 index_name lock_type lock_mode lock_status lock_data
6698 NULL TABLE IX GRANTED NULL
6699 PRIMARY RECORD X GRANTED 'g'
6700 PRIMARY RECORD X GRANTED 'h'
6701 PRIMARY RECORD X GRANTED 'i'
6702 PRIMARY RECORD X GRANTED supremum pseudo-record
6703 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6704 ROLLBACK;
6705 BEGIN;
6706 SELECT *
6707 FROM t1 FORCE INDEX (PRIMARY)
6708 WHERE id >="ec"
6709 ORDER BY id ASC
6710 FOR UPDATE;
6711 id
6712 ee
6713 gg
6714 hh
6715 ii
6716 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6717 FROM performance_schema.data_locks
6718 WHERE object_name = 't1';
6719 index_name lock_type lock_mode lock_status lock_data
6720 NULL TABLE IX GRANTED NULL
6721 PRIMARY RECORD X GRANTED 'g'
6722 PRIMARY RECORD X GRANTED 'h'
6723 PRIMARY RECORD X GRANTED 'i'
6724 PRIMARY RECORD X GRANTED supremum pseudo-record
6725 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6726 ROLLBACK;
6727 BEGIN;
6728 SELECT *
6729 FROM t1 FORCE INDEX (PRIMARY)
6730 WHERE id >="ec"
6731 ORDER BY id DESC
6732 FOR UPDATE;
6733 id
6734 ii
6735 hh
6736 gg
6737 ee
6738 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6739 FROM performance_schema.data_locks
6740 WHERE object_name = 't1';
6741 index_name lock_type lock_mode lock_status lock_data
6742 NULL TABLE IX GRANTED NULL
6743 PRIMARY RECORD X GRANTED 'g'
6744 PRIMARY RECORD X GRANTED 'h'
6745 PRIMARY RECORD X GRANTED 'i'
6746 PRIMARY RECORD X GRANTED supremum pseudo-record
6747 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6748 ROLLBACK;
6749 DROP TABLE t1;
6750 INSERT INTO t2
6751 VALUES ("aa"), ("bb"), ("cc"), ("ee"), ("gg"), ("hh"), ("ii");
6752 ANALYZE TABLE t2;
6753 Table Op Msg_type Msg_text
6754 test.t2 analyze status OK
6755 BEGIN;
6756 SELECT *
6757 FROM t2 FORCE INDEX (PRIMARY)
6758 WHERE id <="c"
6759 ORDER BY id ASC
6760 FOR UPDATE;
6761 id
6762 aa
6763 bb
6764 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6765 FROM performance_schema.data_locks
6766 WHERE object_name = 't2';
6767 index_name lock_type lock_mode lock_status lock_data
6768 NULL TABLE IX GRANTED NULL
6769 PRIMARY RECORD X GRANTED 'a'
6770 PRIMARY RECORD X GRANTED 'b'
6771 PRIMARY RECORD X GRANTED supremum pseudo-record
6772 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'c'
6773 ROLLBACK;
6774 BEGIN;
6775 SELECT *
6776 FROM t2 FORCE INDEX (PRIMARY)
6777 WHERE id <="c"
6778 ORDER BY id DESC
6779 FOR UPDATE;
6780 id
6781 bb
6782 aa
6783 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6784 FROM performance_schema.data_locks
6785 WHERE object_name = 't2';
6786 index_name lock_type lock_mode lock_status lock_data
6787 NULL TABLE IX GRANTED NULL
6788 PRIMARY RECORD X GRANTED 'a'
6789 PRIMARY RECORD X GRANTED 'b'
6790 PRIMARY RECORD X GRANTED supremum pseudo-record
6791 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'c'
6792 ROLLBACK;
6793 BEGIN;
6794 SELECT *
6795 FROM t2 FORCE INDEX (PRIMARY)
6796 WHERE id <="d"
6797 ORDER BY id ASC
6798 FOR UPDATE;
6799 id
6800 aa
6801 bb
6802 cc
6803 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6804 FROM performance_schema.data_locks
6805 WHERE object_name = 't2';
6806 index_name lock_type lock_mode lock_status lock_data
6807 NULL TABLE IX GRANTED NULL
6808 PRIMARY RECORD X GRANTED 'a'
6809 PRIMARY RECORD X GRANTED 'b'
6810 PRIMARY RECORD X GRANTED 'c'
6811 PRIMARY RECORD X GRANTED supremum pseudo-record
6812 ROLLBACK;
6813 BEGIN;
6814 SELECT *
6815 FROM t2 FORCE INDEX (PRIMARY)
6816 WHERE id <="d"
6817 ORDER BY id DESC
6818 FOR UPDATE;
6819 id
6820 cc
6821 bb
6822 aa
6823 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6824 FROM performance_schema.data_locks
6825 WHERE object_name = 't2';
6826 index_name lock_type lock_mode lock_status lock_data
6827 NULL TABLE IX GRANTED NULL
6828 PRIMARY RECORD X GRANTED 'a'
6829 PRIMARY RECORD X GRANTED 'b'
6830 PRIMARY RECORD X GRANTED 'c'
6831 PRIMARY RECORD X GRANTED supremum pseudo-record
6832 ROLLBACK;
6833 BEGIN;
6834 SELECT *
6835 FROM t2 FORCE INDEX (PRIMARY)
6836 WHERE id <"e"
6837 ORDER BY id ASC
6838 FOR UPDATE;
6839 id
6840 aa
6841 bb
6842 cc
6843 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6844 FROM performance_schema.data_locks
6845 WHERE object_name = 't2';
6846 index_name lock_type lock_mode lock_status lock_data
6847 NULL TABLE IX GRANTED NULL
6848 PRIMARY RECORD X GRANTED 'a'
6849 PRIMARY RECORD X GRANTED 'b'
6850 PRIMARY RECORD X GRANTED 'c'
6851 PRIMARY RECORD X GRANTED supremum pseudo-record
6852 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6853 ROLLBACK;
6854 BEGIN;
6855 SELECT *
6856 FROM t2 FORCE INDEX (PRIMARY)
6857 WHERE id <"e"
6858 ORDER BY id DESC
6859 FOR UPDATE;
6860 id
6861 cc
6862 bb
6863 aa
6864 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6865 FROM performance_schema.data_locks
6866 WHERE object_name = 't2';
6867 index_name lock_type lock_mode lock_status lock_data
6868 NULL TABLE IX GRANTED NULL
6869 PRIMARY RECORD X GRANTED 'a'
6870 PRIMARY RECORD X GRANTED 'b'
6871 PRIMARY RECORD X GRANTED 'c'
6872 PRIMARY RECORD X GRANTED supremum pseudo-record
6873 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6874 ROLLBACK;
6875 BEGIN;
6876 SELECT *
6877 FROM t2 FORCE INDEX (PRIMARY)
6878 WHERE id <"ee"
6879 ORDER BY id ASC
6880 FOR UPDATE;
6881 id
6882 aa
6883 bb
6884 cc
6885 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6886 FROM performance_schema.data_locks
6887 WHERE object_name = 't2';
6888 index_name lock_type lock_mode lock_status lock_data
6889 NULL TABLE IX GRANTED NULL
6890 PRIMARY RECORD X GRANTED 'a'
6891 PRIMARY RECORD X GRANTED 'b'
6892 PRIMARY RECORD X GRANTED 'c'
6893 PRIMARY RECORD X GRANTED supremum pseudo-record
6894 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6895 ROLLBACK;
6896 BEGIN;
6897 SELECT *
6898 FROM t2 FORCE INDEX (PRIMARY)
6899 WHERE id <"ee"
6900 ORDER BY id DESC
6901 FOR UPDATE;
6902 id
6903 cc
6904 bb
6905 aa
6906 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6907 FROM performance_schema.data_locks
6908 WHERE object_name = 't2';
6909 index_name lock_type lock_mode lock_status lock_data
6910 NULL TABLE IX GRANTED NULL
6911 PRIMARY RECORD X GRANTED 'a'
6912 PRIMARY RECORD X GRANTED 'b'
6913 PRIMARY RECORD X GRANTED 'c'
6914 PRIMARY RECORD X GRANTED supremum pseudo-record
6915 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6916 ROLLBACK;
6917 BEGIN;
6918 SELECT *
6919 FROM t2 FORCE INDEX (PRIMARY)
6920 WHERE id <="ee"
6921 ORDER BY id ASC
6922 FOR UPDATE;
6923 id
6924 aa
6925 bb
6926 cc
6927 ee
6928 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6929 FROM performance_schema.data_locks
6930 WHERE object_name = 't2';
6931 index_name lock_type lock_mode lock_status lock_data
6932 NULL TABLE IX GRANTED NULL
6933 PRIMARY RECORD X GRANTED 'a'
6934 PRIMARY RECORD X GRANTED 'b'
6935 PRIMARY RECORD X GRANTED 'c'
6936 PRIMARY RECORD X GRANTED supremum pseudo-record
6937 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6938 ROLLBACK;
6939 BEGIN;
6940 SELECT *
6941 FROM t2 FORCE INDEX (PRIMARY)
6942 WHERE id <="ee"
6943 ORDER BY id DESC
6944 FOR UPDATE;
6945 id
6946 ee
6947 cc
6948 bb
6949 aa
6950 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6951 FROM performance_schema.data_locks
6952 WHERE object_name = 't2';
6953 index_name lock_type lock_mode lock_status lock_data
6954 NULL TABLE IX GRANTED NULL
6955 PRIMARY RECORD X GRANTED 'a'
6956 PRIMARY RECORD X GRANTED 'b'
6957 PRIMARY RECORD X GRANTED 'c'
6958 PRIMARY RECORD X GRANTED supremum pseudo-record
6959 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6960 ROLLBACK;
6961 BEGIN;
6962 SELECT *
6963 FROM t2 FORCE INDEX (PRIMARY)
6964 WHERE id <="ec"
6965 ORDER BY id ASC
6966 FOR UPDATE;
6967 id
6968 aa
6969 bb
6970 cc
6971 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6972 FROM performance_schema.data_locks
6973 WHERE object_name = 't2';
6974 index_name lock_type lock_mode lock_status lock_data
6975 NULL TABLE IX GRANTED NULL
6976 PRIMARY RECORD X GRANTED 'a'
6977 PRIMARY RECORD X GRANTED 'b'
6978 PRIMARY RECORD X GRANTED 'c'
6979 PRIMARY RECORD X GRANTED supremum pseudo-record
6980 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
6981 ROLLBACK;
6982 BEGIN;
6983 SELECT *
6984 FROM t2 FORCE INDEX (PRIMARY)
6985 WHERE id <="ec"
6986 ORDER BY id DESC
6987 FOR UPDATE;
6988 id
6989 cc
6990 bb
6991 aa
6992 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
6993 FROM performance_schema.data_locks
6994 WHERE object_name = 't2';
6995 index_name lock_type lock_mode lock_status lock_data
6996 NULL TABLE IX GRANTED NULL
6997 PRIMARY RECORD X GRANTED 'a'
6998 PRIMARY RECORD X GRANTED 'b'
6999 PRIMARY RECORD X GRANTED 'c'
7000 PRIMARY RECORD X GRANTED supremum pseudo-record
7001 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
7002 ROLLBACK;
7003 BEGIN;
7004 SELECT *
7005 FROM t2 FORCE INDEX (PRIMARY)
7006 WHERE id <="ef"
7007 ORDER BY id ASC
7008 FOR UPDATE;
7009 id
7010 aa
7011 bb
7012 cc
7013 ee
7014 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7015 FROM performance_schema.data_locks
7016 WHERE object_name = 't2';
7017 index_name lock_type lock_mode lock_status lock_data
7018 NULL TABLE IX GRANTED NULL
7019 PRIMARY RECORD X GRANTED 'a'
7020 PRIMARY RECORD X GRANTED 'b'
7021 PRIMARY RECORD X GRANTED 'c'
7022 PRIMARY RECORD X GRANTED supremum pseudo-record
7023 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
7024 ROLLBACK;
7025 BEGIN;
7026 SELECT *
7027 FROM t2 FORCE INDEX (PRIMARY)
7028 WHERE id <="ef"
7029 ORDER BY id DESC
7030 FOR UPDATE;
7031 id
7032 ee
7033 cc
7034 bb
7035 aa
7036 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7037 FROM performance_schema.data_locks
7038 WHERE object_name = 't2';
7039 index_name lock_type lock_mode lock_status lock_data
7040 NULL TABLE IX GRANTED NULL
7041 PRIMARY RECORD X GRANTED 'a'
7042 PRIMARY RECORD X GRANTED 'b'
7043 PRIMARY RECORD X GRANTED 'c'
7044 PRIMARY RECORD X GRANTED supremum pseudo-record
7045 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'e'
7046 ROLLBACK;
7047 BEGIN;
7048 SELECT *
7049 FROM t2 FORCE INDEX (PRIMARY)
7050 WHERE id >="g"
7051 ORDER BY id ASC
7052 FOR UPDATE;
7053 id
7054 gg
7055 hh
7056 ii
7057 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7058 FROM performance_schema.data_locks
7059 WHERE object_name = 't2';
7060 index_name lock_type lock_mode lock_status lock_data
7061 NULL TABLE IX GRANTED NULL
7062 PRIMARY RECORD X GRANTED 'g'
7063 PRIMARY RECORD X GRANTED 'h'
7064 PRIMARY RECORD X GRANTED 'i'
7065 ROLLBACK;
7066 BEGIN;
7067 SELECT *
7068 FROM t2 FORCE INDEX (PRIMARY)
7069 WHERE id >="g"
7070 ORDER BY id DESC
7071 FOR UPDATE;
7072 id
7073 ii
7074 hh
7075 gg
7076 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7077 FROM performance_schema.data_locks
7078 WHERE object_name = 't2';
7079 index_name lock_type lock_mode lock_status lock_data
7080 NULL TABLE IX GRANTED NULL
7081 PRIMARY RECORD X GRANTED 'g'
7082 PRIMARY RECORD X GRANTED 'h'
7083 PRIMARY RECORD X GRANTED 'i'
7084 ROLLBACK;
7085 BEGIN;
7086 SELECT *
7087 FROM t2 FORCE INDEX (PRIMARY)
7088 WHERE id >="f"
7089 ORDER BY id ASC
7090 FOR UPDATE;
7091 id
7092 gg
7093 hh
7094 ii
7095 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7096 FROM performance_schema.data_locks
7097 WHERE object_name = 't2';
7098 index_name lock_type lock_mode lock_status lock_data
7099 NULL TABLE IX GRANTED NULL
7100 PRIMARY RECORD X GRANTED 'g'
7101 PRIMARY RECORD X GRANTED 'h'
7102 PRIMARY RECORD X GRANTED 'i'
7103 PRIMARY RECORD X,GAP GRANTED 'e'
7104 ROLLBACK;
7105 BEGIN;
7106 SELECT *
7107 FROM t2 FORCE INDEX (PRIMARY)
7108 WHERE id >="f"
7109 ORDER BY id DESC
7110 FOR UPDATE;
7111 id
7112 ii
7113 hh
7114 gg
7115 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7116 FROM performance_schema.data_locks
7117 WHERE object_name = 't2';
7118 index_name lock_type lock_mode lock_status lock_data
7119 NULL TABLE IX GRANTED NULL
7120 PRIMARY RECORD X GRANTED 'g'
7121 PRIMARY RECORD X GRANTED 'h'
7122 PRIMARY RECORD X GRANTED 'i'
7123 PRIMARY RECORD X,GAP GRANTED 'e'
7124 ROLLBACK;
7125 BEGIN;
7126 SELECT *
7127 FROM t2 FORCE INDEX (PRIMARY)
7128 WHERE id >"e"
7129 ORDER BY id ASC
7130 FOR UPDATE;
7131 id
7132 ee
7133 gg
7134 hh
7135 ii
7136 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7137 FROM performance_schema.data_locks
7138 WHERE object_name = 't2';
7139 index_name lock_type lock_mode lock_status lock_data
7140 NULL TABLE IX GRANTED NULL
7141 PRIMARY RECORD X GRANTED 'e'
7142 PRIMARY RECORD X GRANTED 'g'
7143 PRIMARY RECORD X GRANTED 'h'
7144 PRIMARY RECORD X GRANTED 'i'
7145 ROLLBACK;
7146 BEGIN;
7147 SELECT *
7148 FROM t2 FORCE INDEX (PRIMARY)
7149 WHERE id >"e"
7150 ORDER BY id DESC
7151 FOR UPDATE;
7152 id
7153 ii
7154 hh
7155 gg
7156 ee
7157 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7158 FROM performance_schema.data_locks
7159 WHERE object_name = 't2';
7160 index_name lock_type lock_mode lock_status lock_data
7161 NULL TABLE IX GRANTED NULL
7162 PRIMARY RECORD X GRANTED 'e'
7163 PRIMARY RECORD X GRANTED 'g'
7164 PRIMARY RECORD X GRANTED 'h'
7165 PRIMARY RECORD X GRANTED 'i'
7166 ROLLBACK;
7167 BEGIN;
7168 SELECT *
7169 FROM t2 FORCE INDEX (PRIMARY)
7170 WHERE id >"ee"
7171 ORDER BY id ASC
7172 FOR UPDATE;
7173 id
7174 gg
7175 hh
7176 ii
7177 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7178 FROM performance_schema.data_locks
7179 WHERE object_name = 't2';
7180 index_name lock_type lock_mode lock_status lock_data
7181 NULL TABLE IX GRANTED NULL
7182 PRIMARY RECORD X GRANTED 'e'
7183 PRIMARY RECORD X GRANTED 'g'
7184 PRIMARY RECORD X GRANTED 'h'
7185 PRIMARY RECORD X GRANTED 'i'
7186 ROLLBACK;
7187 BEGIN;
7188 SELECT *
7189 FROM t2 FORCE INDEX (PRIMARY)
7190 WHERE id >"ee"
7191 ORDER BY id DESC
7192 FOR UPDATE;
7193 id
7194 ii
7195 hh
7196 gg
7197 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7198 FROM performance_schema.data_locks
7199 WHERE object_name = 't2';
7200 index_name lock_type lock_mode lock_status lock_data
7201 NULL TABLE IX GRANTED NULL
7202 PRIMARY RECORD X GRANTED 'e'
7203 PRIMARY RECORD X GRANTED 'g'
7204 PRIMARY RECORD X GRANTED 'h'
7205 PRIMARY RECORD X GRANTED 'i'
7206 ROLLBACK;
7207 BEGIN;
7208 SELECT *
7209 FROM t2 FORCE INDEX (PRIMARY)
7210 WHERE id >="ee"
7211 ORDER BY id ASC
7212 FOR UPDATE;
7213 id
7214 ee
7215 gg
7216 hh
7217 ii
7218 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7219 FROM performance_schema.data_locks
7220 WHERE object_name = 't2';
7221 index_name lock_type lock_mode lock_status lock_data
7222 NULL TABLE IX GRANTED NULL
7223 PRIMARY RECORD X GRANTED 'e'
7224 PRIMARY RECORD X GRANTED 'g'
7225 PRIMARY RECORD X GRANTED 'h'
7226 PRIMARY RECORD X GRANTED 'i'
7227 ROLLBACK;
7228 BEGIN;
7229 SELECT *
7230 FROM t2 FORCE INDEX (PRIMARY)
7231 WHERE id >="ee"
7232 ORDER BY id DESC
7233 FOR UPDATE;
7234 id
7235 ii
7236 hh
7237 gg
7238 ee
7239 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7240 FROM performance_schema.data_locks
7241 WHERE object_name = 't2';
7242 index_name lock_type lock_mode lock_status lock_data
7243 NULL TABLE IX GRANTED NULL
7244 PRIMARY RECORD X GRANTED 'e'
7245 PRIMARY RECORD X GRANTED 'g'
7246 PRIMARY RECORD X GRANTED 'h'
7247 PRIMARY RECORD X GRANTED 'i'
7248 ROLLBACK;
7249 BEGIN;
7250 SELECT *
7251 FROM t2 FORCE INDEX (PRIMARY)
7252 WHERE id >="ef"
7253 ORDER BY id ASC
7254 FOR UPDATE;
7255 id
7256 gg
7257 hh
7258 ii
7259 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7260 FROM performance_schema.data_locks
7261 WHERE object_name = 't2';
7262 index_name lock_type lock_mode lock_status lock_data
7263 NULL TABLE IX GRANTED NULL
7264 PRIMARY RECORD X GRANTED 'e'
7265 PRIMARY RECORD X GRANTED 'g'
7266 PRIMARY RECORD X GRANTED 'h'
7267 PRIMARY RECORD X GRANTED 'i'
7268 ROLLBACK;
7269 BEGIN;
7270 SELECT *
7271 FROM t2 FORCE INDEX (PRIMARY)
7272 WHERE id >="ef"
7273 ORDER BY id DESC
7274 FOR UPDATE;
7275 id
7276 ii
7277 hh
7278 gg
7279 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7280 FROM performance_schema.data_locks
7281 WHERE object_name = 't2';
7282 index_name lock_type lock_mode lock_status lock_data
7283 NULL TABLE IX GRANTED NULL
7284 PRIMARY RECORD X GRANTED 'e'
7285 PRIMARY RECORD X GRANTED 'g'
7286 PRIMARY RECORD X GRANTED 'h'
7287 PRIMARY RECORD X GRANTED 'i'
7288 ROLLBACK;
7289 BEGIN;
7290 SELECT *
7291 FROM t2 FORCE INDEX (PRIMARY)
7292 WHERE id >="ec"
7293 ORDER BY id ASC
7294 FOR UPDATE;
7295 id
7296 ee
7297 gg
7298 hh
7299 ii
7300 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7301 FROM performance_schema.data_locks
7302 WHERE object_name = 't2';
7303 index_name lock_type lock_mode lock_status lock_data
7304 NULL TABLE IX GRANTED NULL
7305 PRIMARY RECORD X GRANTED 'e'
7306 PRIMARY RECORD X GRANTED 'g'
7307 PRIMARY RECORD X GRANTED 'h'
7308 PRIMARY RECORD X GRANTED 'i'
7309 ROLLBACK;
7310 BEGIN;
7311 SELECT *
7312 FROM t2 FORCE INDEX (PRIMARY)
7313 WHERE id >="ec"
7314 ORDER BY id DESC
7315 FOR UPDATE;
7316 id
7317 ii
7318 hh
7319 gg
7320 ee
7321 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7322 FROM performance_schema.data_locks
7323 WHERE object_name = 't2';
7324 index_name lock_type lock_mode lock_status lock_data
7325 NULL TABLE IX GRANTED NULL
7326 PRIMARY RECORD X GRANTED 'e'
7327 PRIMARY RECORD X GRANTED 'g'
7328 PRIMARY RECORD X GRANTED 'h'
7329 PRIMARY RECORD X GRANTED 'i'
7330 ROLLBACK;
7331 DROP TABLE t2;
7332 CREATE TABLE t1 (
7333 id VARCHAR(100) NOT NULL,
7334 PRIMARY KEY (id(2) ASC)
7335 ) ENGINE=InnoDB;
7336 CREATE TABLE t2 (
7337 id VARCHAR(100) NOT NULL,
7338 PRIMARY KEY (id(2) DESC)
7339 ) ENGINE=InnoDB;
7340 SET @conditions = CONCAT(
7341 '<="c" <="d" <"e" <"ee" <="ee" <="ec" <="ef" ',
7342 '>="g" >="f" >"e" >"ee" >="ee" >="ef" >="ec"'
7343 );
7344 INSERT INTO t1
7345 VALUES ("aaa"), ("bbb"), ("ccc"), ("eee"), ("ggg"), ("hhh"), ("iii");
7346 ANALYZE TABLE t1;
7347 Table Op Msg_type Msg_text
7348 test.t1 analyze status OK
7349 BEGIN;
7350 SELECT *
7351 FROM t1 FORCE INDEX (PRIMARY)
7352 WHERE id <="c"
7353 ORDER BY id ASC
7354 FOR UPDATE;
7355 id
7356 aaa
7357 bbb
7358 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7359 FROM performance_schema.data_locks
7360 WHERE object_name = 't1';
7361 index_name lock_type lock_mode lock_status lock_data
7362 NULL TABLE IX GRANTED NULL
7363 PRIMARY RECORD X GRANTED 'aa'
7364 PRIMARY RECORD X GRANTED 'bb'
7365 PRIMARY RECORD X,GAP GRANTED 'cc'
7366 ROLLBACK;
7367 BEGIN;
7368 SELECT *
7369 FROM t1 FORCE INDEX (PRIMARY)
7370 WHERE id <="c"
7371 ORDER BY id DESC
7372 FOR UPDATE;
7373 id
7374 bbb
7375 aaa
7376 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7377 FROM performance_schema.data_locks
7378 WHERE object_name = 't1';
7379 index_name lock_type lock_mode lock_status lock_data
7380 NULL TABLE IX GRANTED NULL
7381 PRIMARY RECORD X GRANTED 'aa'
7382 PRIMARY RECORD X GRANTED 'bb'
7383 PRIMARY RECORD X,GAP GRANTED 'cc'
7384 ROLLBACK;
7385 BEGIN;
7386 SELECT *
7387 FROM t1 FORCE INDEX (PRIMARY)
7388 WHERE id <="d"
7389 ORDER BY id ASC
7390 FOR UPDATE;
7391 id
7392 aaa
7393 bbb
7394 ccc
7395 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7396 FROM performance_schema.data_locks
7397 WHERE object_name = 't1';
7398 index_name lock_type lock_mode lock_status lock_data
7399 NULL TABLE IX GRANTED NULL
7400 PRIMARY RECORD X GRANTED 'aa'
7401 PRIMARY RECORD X GRANTED 'bb'
7402 PRIMARY RECORD X GRANTED 'cc'
7403 PRIMARY RECORD X,GAP GRANTED 'ee'
7404 ROLLBACK;
7405 BEGIN;
7406 SELECT *
7407 FROM t1 FORCE INDEX (PRIMARY)
7408 WHERE id <="d"
7409 ORDER BY id DESC
7410 FOR UPDATE;
7411 id
7412 ccc
7413 bbb
7414 aaa
7415 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7416 FROM performance_schema.data_locks
7417 WHERE object_name = 't1';
7418 index_name lock_type lock_mode lock_status lock_data
7419 NULL TABLE IX GRANTED NULL
7420 PRIMARY RECORD X GRANTED 'aa'
7421 PRIMARY RECORD X GRANTED 'bb'
7422 PRIMARY RECORD X GRANTED 'cc'
7423 PRIMARY RECORD X,GAP GRANTED 'ee'
7424 ROLLBACK;
7425 BEGIN;
7426 SELECT *
7427 FROM t1 FORCE INDEX (PRIMARY)
7428 WHERE id <"e"
7429 ORDER BY id ASC
7430 FOR UPDATE;
7431 id
7432 aaa
7433 bbb
7434 ccc
7435 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7436 FROM performance_schema.data_locks
7437 WHERE object_name = 't1';
7438 index_name lock_type lock_mode lock_status lock_data
7439 NULL TABLE IX GRANTED NULL
7440 PRIMARY RECORD X GRANTED 'aa'
7441 PRIMARY RECORD X GRANTED 'bb'
7442 PRIMARY RECORD X GRANTED 'cc'
7443 PRIMARY RECORD X,GAP GRANTED 'ee'
7444 ROLLBACK;
7445 BEGIN;
7446 SELECT *
7447 FROM t1 FORCE INDEX (PRIMARY)
7448 WHERE id <"e"
7449 ORDER BY id DESC
7450 FOR UPDATE;
7451 id
7452 ccc
7453 bbb
7454 aaa
7455 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7456 FROM performance_schema.data_locks
7457 WHERE object_name = 't1';
7458 index_name lock_type lock_mode lock_status lock_data
7459 NULL TABLE IX GRANTED NULL
7460 PRIMARY RECORD X GRANTED 'aa'
7461 PRIMARY RECORD X GRANTED 'bb'
7462 PRIMARY RECORD X GRANTED 'cc'
7463 PRIMARY RECORD X,GAP GRANTED 'ee'
7464 ROLLBACK;
7465 BEGIN;
7466 SELECT *
7467 FROM t1 FORCE INDEX (PRIMARY)
7468 WHERE id <"ee"
7469 ORDER BY id ASC
7470 FOR UPDATE;
7471 id
7472 aaa
7473 bbb
7474 ccc
7475 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7476 FROM performance_schema.data_locks
7477 WHERE object_name = 't1';
7478 index_name lock_type lock_mode lock_status lock_data
7479 NULL TABLE IX GRANTED NULL
7480 PRIMARY RECORD X GRANTED 'aa'
7481 PRIMARY RECORD X GRANTED 'bb'
7482 PRIMARY RECORD X GRANTED 'cc'
7483 PRIMARY RECORD X GRANTED 'ee'
7484 ROLLBACK;
7485 BEGIN;
7486 SELECT *
7487 FROM t1 FORCE INDEX (PRIMARY)
7488 WHERE id <"ee"
7489 ORDER BY id DESC
7490 FOR UPDATE;
7491 id
7492 ccc
7493 bbb
7494 aaa
7495 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7496 FROM performance_schema.data_locks
7497 WHERE object_name = 't1';
7498 index_name lock_type lock_mode lock_status lock_data
7499 NULL TABLE IX GRANTED NULL
7500 PRIMARY RECORD X GRANTED 'aa'
7501 PRIMARY RECORD X GRANTED 'bb'
7502 PRIMARY RECORD X GRANTED 'cc'
7503 PRIMARY RECORD X GRANTED 'ee'
7504 ROLLBACK;
7505 BEGIN;
7506 SELECT *
7507 FROM t1 FORCE INDEX (PRIMARY)
7508 WHERE id <="ee"
7509 ORDER BY id ASC
7510 FOR UPDATE;
7511 id
7512 aaa
7513 bbb
7514 ccc
7515 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7516 FROM performance_schema.data_locks
7517 WHERE object_name = 't1';
7518 index_name lock_type lock_mode lock_status lock_data
7519 NULL TABLE IX GRANTED NULL
7520 PRIMARY RECORD X GRANTED 'aa'
7521 PRIMARY RECORD X GRANTED 'bb'
7522 PRIMARY RECORD X GRANTED 'cc'
7523 PRIMARY RECORD X GRANTED 'ee'
7524 ROLLBACK;
7525 BEGIN;
7526 SELECT *
7527 FROM t1 FORCE INDEX (PRIMARY)
7528 WHERE id <="ee"
7529 ORDER BY id DESC
7530 FOR UPDATE;
7531 id
7532 ccc
7533 bbb
7534 aaa
7535 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7536 FROM performance_schema.data_locks
7537 WHERE object_name = 't1';
7538 index_name lock_type lock_mode lock_status lock_data
7539 NULL TABLE IX GRANTED NULL
7540 PRIMARY RECORD X GRANTED 'aa'
7541 PRIMARY RECORD X GRANTED 'bb'
7542 PRIMARY RECORD X GRANTED 'cc'
7543 PRIMARY RECORD X GRANTED 'ee'
7544 ROLLBACK;
7545 BEGIN;
7546 SELECT *
7547 FROM t1 FORCE INDEX (PRIMARY)
7548 WHERE id <="ec"
7549 ORDER BY id ASC
7550 FOR UPDATE;
7551 id
7552 aaa
7553 bbb
7554 ccc
7555 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7556 FROM performance_schema.data_locks
7557 WHERE object_name = 't1';
7558 index_name lock_type lock_mode lock_status lock_data
7559 NULL TABLE IX GRANTED NULL
7560 PRIMARY RECORD X GRANTED 'aa'
7561 PRIMARY RECORD X GRANTED 'bb'
7562 PRIMARY RECORD X GRANTED 'cc'
7563 PRIMARY RECORD X,GAP GRANTED 'ee'
7564 ROLLBACK;
7565 BEGIN;
7566 SELECT *
7567 FROM t1 FORCE INDEX (PRIMARY)
7568 WHERE id <="ec"
7569 ORDER BY id DESC
7570 FOR UPDATE;
7571 id
7572 ccc
7573 bbb
7574 aaa
7575 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7576 FROM performance_schema.data_locks
7577 WHERE object_name = 't1';
7578 index_name lock_type lock_mode lock_status lock_data
7579 NULL TABLE IX GRANTED NULL
7580 PRIMARY RECORD X GRANTED 'aa'
7581 PRIMARY RECORD X GRANTED 'bb'
7582 PRIMARY RECORD X GRANTED 'cc'
7583 PRIMARY RECORD X,GAP GRANTED 'ee'
7584 ROLLBACK;
7585 BEGIN;
7586 SELECT *
7587 FROM t1 FORCE INDEX (PRIMARY)
7588 WHERE id <="ef"
7589 ORDER BY id ASC
7590 FOR UPDATE;
7591 id
7592 aaa
7593 bbb
7594 ccc
7595 eee
7596 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7597 FROM performance_schema.data_locks
7598 WHERE object_name = 't1';
7599 index_name lock_type lock_mode lock_status lock_data
7600 NULL TABLE IX GRANTED NULL
7601 PRIMARY RECORD X GRANTED 'aa'
7602 PRIMARY RECORD X GRANTED 'bb'
7603 PRIMARY RECORD X GRANTED 'cc'
7604 PRIMARY RECORD X GRANTED 'ee'
7605 PRIMARY RECORD X,GAP GRANTED 'gg'
7606 ROLLBACK;
7607 BEGIN;
7608 SELECT *
7609 FROM t1 FORCE INDEX (PRIMARY)
7610 WHERE id <="ef"
7611 ORDER BY id DESC
7612 FOR UPDATE;
7613 id
7614 eee
7615 ccc
7616 bbb
7617 aaa
7618 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7619 FROM performance_schema.data_locks
7620 WHERE object_name = 't1';
7621 index_name lock_type lock_mode lock_status lock_data
7622 NULL TABLE IX GRANTED NULL
7623 PRIMARY RECORD X GRANTED 'aa'
7624 PRIMARY RECORD X GRANTED 'bb'
7625 PRIMARY RECORD X GRANTED 'cc'
7626 PRIMARY RECORD X GRANTED 'ee'
7627 PRIMARY RECORD X,GAP GRANTED 'gg'
7628 ROLLBACK;
7629 BEGIN;
7630 SELECT *
7631 FROM t1 FORCE INDEX (PRIMARY)
7632 WHERE id >="g"
7633 ORDER BY id ASC
7634 FOR UPDATE;
7635 id
7636 ggg
7637 hhh
7638 iii
7639 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7640 FROM performance_schema.data_locks
7641 WHERE object_name = 't1';
7642 index_name lock_type lock_mode lock_status lock_data
7643 NULL TABLE IX GRANTED NULL
7644 PRIMARY RECORD X GRANTED 'gg'
7645 PRIMARY RECORD X GRANTED 'hh'
7646 PRIMARY RECORD X GRANTED 'ii'
7647 PRIMARY RECORD X GRANTED supremum pseudo-record
7648 ROLLBACK;
7649 BEGIN;
7650 SELECT *
7651 FROM t1 FORCE INDEX (PRIMARY)
7652 WHERE id >="g"
7653 ORDER BY id DESC
7654 FOR UPDATE;
7655 id
7656 iii
7657 hhh
7658 ggg
7659 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7660 FROM performance_schema.data_locks
7661 WHERE object_name = 't1';
7662 index_name lock_type lock_mode lock_status lock_data
7663 NULL TABLE IX GRANTED NULL
7664 PRIMARY RECORD X GRANTED 'gg'
7665 PRIMARY RECORD X GRANTED 'hh'
7666 PRIMARY RECORD X GRANTED 'ii'
7667 PRIMARY RECORD X GRANTED supremum pseudo-record
7668 ROLLBACK;
7669 BEGIN;
7670 SELECT *
7671 FROM t1 FORCE INDEX (PRIMARY)
7672 WHERE id >="f"
7673 ORDER BY id ASC
7674 FOR UPDATE;
7675 id
7676 ggg
7677 hhh
7678 iii
7679 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7680 FROM performance_schema.data_locks
7681 WHERE object_name = 't1';
7682 index_name lock_type lock_mode lock_status lock_data
7683 NULL TABLE IX GRANTED NULL
7684 PRIMARY RECORD X GRANTED 'gg'
7685 PRIMARY RECORD X GRANTED 'hh'
7686 PRIMARY RECORD X GRANTED 'ii'
7687 PRIMARY RECORD X GRANTED supremum pseudo-record
7688 ROLLBACK;
7689 BEGIN;
7690 SELECT *
7691 FROM t1 FORCE INDEX (PRIMARY)
7692 WHERE id >="f"
7693 ORDER BY id DESC
7694 FOR UPDATE;
7695 id
7696 iii
7697 hhh
7698 ggg
7699 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7700 FROM performance_schema.data_locks
7701 WHERE object_name = 't1';
7702 index_name lock_type lock_mode lock_status lock_data
7703 NULL TABLE IX GRANTED NULL
7704 PRIMARY RECORD X GRANTED 'gg'
7705 PRIMARY RECORD X GRANTED 'hh'
7706 PRIMARY RECORD X GRANTED 'ii'
7707 PRIMARY RECORD X GRANTED supremum pseudo-record
7708 ROLLBACK;
7709 BEGIN;
7710 SELECT *
7711 FROM t1 FORCE INDEX (PRIMARY)
7712 WHERE id >"e"
7713 ORDER BY id ASC
7714 FOR UPDATE;
7715 id
7716 eee
7717 ggg
7718 hhh
7719 iii
7720 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7721 FROM performance_schema.data_locks
7722 WHERE object_name = 't1';
7723 index_name lock_type lock_mode lock_status lock_data
7724 NULL TABLE IX GRANTED NULL
7725 PRIMARY RECORD X GRANTED 'ee'
7726 PRIMARY RECORD X GRANTED 'gg'
7727 PRIMARY RECORD X GRANTED 'hh'
7728 PRIMARY RECORD X GRANTED 'ii'
7729 PRIMARY RECORD X GRANTED supremum pseudo-record
7730 ROLLBACK;
7731 BEGIN;
7732 SELECT *
7733 FROM t1 FORCE INDEX (PRIMARY)
7734 WHERE id >"e"
7735 ORDER BY id DESC
7736 FOR UPDATE;
7737 id
7738 iii
7739 hhh
7740 ggg
7741 eee
7742 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7743 FROM performance_schema.data_locks
7744 WHERE object_name = 't1';
7745 index_name lock_type lock_mode lock_status lock_data
7746 NULL TABLE IX GRANTED NULL
7747 PRIMARY RECORD X GRANTED 'ee'
7748 PRIMARY RECORD X GRANTED 'gg'
7749 PRIMARY RECORD X GRANTED 'hh'
7750 PRIMARY RECORD X GRANTED 'ii'
7751 PRIMARY RECORD X GRANTED supremum pseudo-record
7752 ROLLBACK;
7753 BEGIN;
7754 SELECT *
7755 FROM t1 FORCE INDEX (PRIMARY)
7756 WHERE id >"ee"
7757 ORDER BY id ASC
7758 FOR UPDATE;
7759 id
7760 eee
7761 ggg
7762 hhh
7763 iii
7764 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7765 FROM performance_schema.data_locks
7766 WHERE object_name = 't1';
7767 index_name lock_type lock_mode lock_status lock_data
7768 NULL TABLE IX GRANTED NULL
7769 PRIMARY RECORD X GRANTED 'gg'
7770 PRIMARY RECORD X GRANTED 'hh'
7771 PRIMARY RECORD X GRANTED 'ii'
7772 PRIMARY RECORD X GRANTED supremum pseudo-record
7773 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'ee'
7774 ROLLBACK;
7775 BEGIN;
7776 SELECT *
7777 FROM t1 FORCE INDEX (PRIMARY)
7778 WHERE id >"ee"
7779 ORDER BY id DESC
7780 FOR UPDATE;
7781 id
7782 iii
7783 hhh
7784 ggg
7785 eee
7786 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7787 FROM performance_schema.data_locks
7788 WHERE object_name = 't1';
7789 index_name lock_type lock_mode lock_status lock_data
7790 NULL TABLE IX GRANTED NULL
7791 PRIMARY RECORD X GRANTED 'gg'
7792 PRIMARY RECORD X GRANTED 'hh'
7793 PRIMARY RECORD X GRANTED 'ii'
7794 PRIMARY RECORD X GRANTED supremum pseudo-record
7795 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'ee'
7796 ROLLBACK;
7797 BEGIN;
7798 SELECT *
7799 FROM t1 FORCE INDEX (PRIMARY)
7800 WHERE id >="ee"
7801 ORDER BY id ASC
7802 FOR UPDATE;
7803 id
7804 eee
7805 ggg
7806 hhh
7807 iii
7808 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7809 FROM performance_schema.data_locks
7810 WHERE object_name = 't1';
7811 index_name lock_type lock_mode lock_status lock_data
7812 NULL TABLE IX GRANTED NULL
7813 PRIMARY RECORD X GRANTED 'gg'
7814 PRIMARY RECORD X GRANTED 'hh'
7815 PRIMARY RECORD X GRANTED 'ii'
7816 PRIMARY RECORD X GRANTED supremum pseudo-record
7817 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'ee'
7818 ROLLBACK;
7819 BEGIN;
7820 SELECT *
7821 FROM t1 FORCE INDEX (PRIMARY)
7822 WHERE id >="ee"
7823 ORDER BY id DESC
7824 FOR UPDATE;
7825 id
7826 iii
7827 hhh
7828 ggg
7829 eee
7830 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7831 FROM performance_schema.data_locks
7832 WHERE object_name = 't1';
7833 index_name lock_type lock_mode lock_status lock_data
7834 NULL TABLE IX GRANTED NULL
7835 PRIMARY RECORD X GRANTED 'gg'
7836 PRIMARY RECORD X GRANTED 'hh'
7837 PRIMARY RECORD X GRANTED 'ii'
7838 PRIMARY RECORD X GRANTED supremum pseudo-record
7839 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'ee'
7840 ROLLBACK;
7841 BEGIN;
7842 SELECT *
7843 FROM t1 FORCE INDEX (PRIMARY)
7844 WHERE id >="ef"
7845 ORDER BY id ASC
7846 FOR UPDATE;
7847 id
7848 ggg
7849 hhh
7850 iii
7851 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7852 FROM performance_schema.data_locks
7853 WHERE object_name = 't1';
7854 index_name lock_type lock_mode lock_status lock_data
7855 NULL TABLE IX GRANTED NULL
7856 PRIMARY RECORD X GRANTED 'gg'
7857 PRIMARY RECORD X GRANTED 'hh'
7858 PRIMARY RECORD X GRANTED 'ii'
7859 PRIMARY RECORD X GRANTED supremum pseudo-record
7860 ROLLBACK;
7861 BEGIN;
7862 SELECT *
7863 FROM t1 FORCE INDEX (PRIMARY)
7864 WHERE id >="ef"
7865 ORDER BY id DESC
7866 FOR UPDATE;
7867 id
7868 iii
7869 hhh
7870 ggg
7871 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7872 FROM performance_schema.data_locks
7873 WHERE object_name = 't1';
7874 index_name lock_type lock_mode lock_status lock_data
7875 NULL TABLE IX GRANTED NULL
7876 PRIMARY RECORD X GRANTED 'gg'
7877 PRIMARY RECORD X GRANTED 'hh'
7878 PRIMARY RECORD X GRANTED 'ii'
7879 PRIMARY RECORD X GRANTED supremum pseudo-record
7880 ROLLBACK;
7881 BEGIN;
7882 SELECT *
7883 FROM t1 FORCE INDEX (PRIMARY)
7884 WHERE id >="ec"
7885 ORDER BY id ASC
7886 FOR UPDATE;
7887 id
7888 eee
7889 ggg
7890 hhh
7891 iii
7892 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7893 FROM performance_schema.data_locks
7894 WHERE object_name = 't1';
7895 index_name lock_type lock_mode lock_status lock_data
7896 NULL TABLE IX GRANTED NULL
7897 PRIMARY RECORD X GRANTED 'ee'
7898 PRIMARY RECORD X GRANTED 'gg'
7899 PRIMARY RECORD X GRANTED 'hh'
7900 PRIMARY RECORD X GRANTED 'ii'
7901 PRIMARY RECORD X GRANTED supremum pseudo-record
7902 ROLLBACK;
7903 BEGIN;
7904 SELECT *
7905 FROM t1 FORCE INDEX (PRIMARY)
7906 WHERE id >="ec"
7907 ORDER BY id DESC
7908 FOR UPDATE;
7909 id
7910 iii
7911 hhh
7912 ggg
7913 eee
7914 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7915 FROM performance_schema.data_locks
7916 WHERE object_name = 't1';
7917 index_name lock_type lock_mode lock_status lock_data
7918 NULL TABLE IX GRANTED NULL
7919 PRIMARY RECORD X GRANTED 'ee'
7920 PRIMARY RECORD X GRANTED 'gg'
7921 PRIMARY RECORD X GRANTED 'hh'
7922 PRIMARY RECORD X GRANTED 'ii'
7923 PRIMARY RECORD X GRANTED supremum pseudo-record
7924 ROLLBACK;
7925 DROP TABLE t1;
7926 INSERT INTO t2
7927 VALUES ("aaa"), ("bbb"), ("ccc"), ("eee"), ("ggg"), ("hhh"), ("iii");
7928 ANALYZE TABLE t2;
7929 Table Op Msg_type Msg_text
7930 test.t2 analyze status OK
7931 BEGIN;
7932 SELECT *
7933 FROM t2 FORCE INDEX (PRIMARY)
7934 WHERE id <="c"
7935 ORDER BY id ASC
7936 FOR UPDATE;
7937 id
7938 aaa
7939 bbb
7940 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7941 FROM performance_schema.data_locks
7942 WHERE object_name = 't2';
7943 index_name lock_type lock_mode lock_status lock_data
7944 NULL TABLE IX GRANTED NULL
7945 PRIMARY RECORD X GRANTED 'aa'
7946 PRIMARY RECORD X GRANTED 'bb'
7947 PRIMARY RECORD X GRANTED supremum pseudo-record
7948 ROLLBACK;
7949 BEGIN;
7950 SELECT *
7951 FROM t2 FORCE INDEX (PRIMARY)
7952 WHERE id <="c"
7953 ORDER BY id DESC
7954 FOR UPDATE;
7955 id
7956 bbb
7957 aaa
7958 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7959 FROM performance_schema.data_locks
7960 WHERE object_name = 't2';
7961 index_name lock_type lock_mode lock_status lock_data
7962 NULL TABLE IX GRANTED NULL
7963 PRIMARY RECORD X GRANTED 'aa'
7964 PRIMARY RECORD X GRANTED 'bb'
7965 PRIMARY RECORD X GRANTED supremum pseudo-record
7966 ROLLBACK;
7967 BEGIN;
7968 SELECT *
7969 FROM t2 FORCE INDEX (PRIMARY)
7970 WHERE id <="d"
7971 ORDER BY id ASC
7972 FOR UPDATE;
7973 id
7974 aaa
7975 bbb
7976 ccc
7977 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7978 FROM performance_schema.data_locks
7979 WHERE object_name = 't2';
7980 index_name lock_type lock_mode lock_status lock_data
7981 NULL TABLE IX GRANTED NULL
7982 PRIMARY RECORD X GRANTED 'aa'
7983 PRIMARY RECORD X GRANTED 'bb'
7984 PRIMARY RECORD X GRANTED 'cc'
7985 PRIMARY RECORD X GRANTED supremum pseudo-record
7986 ROLLBACK;
7987 BEGIN;
7988 SELECT *
7989 FROM t2 FORCE INDEX (PRIMARY)
7990 WHERE id <="d"
7991 ORDER BY id DESC
7992 FOR UPDATE;
7993 id
7994 ccc
7995 bbb
7996 aaa
7997 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
7998 FROM performance_schema.data_locks
7999 WHERE object_name = 't2';
8000 index_name lock_type lock_mode lock_status lock_data
8001 NULL TABLE IX GRANTED NULL
8002 PRIMARY RECORD X GRANTED 'aa'
8003 PRIMARY RECORD X GRANTED 'bb'
8004 PRIMARY RECORD X GRANTED 'cc'
8005 PRIMARY RECORD X GRANTED supremum pseudo-record
8006 ROLLBACK;
8007 BEGIN;
8008 SELECT *
8009 FROM t2 FORCE INDEX (PRIMARY)
8010 WHERE id <"e"
8011 ORDER BY id ASC
8012 FOR UPDATE;
8013 id
8014 aaa
8015 bbb
8016 ccc
8017 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8018 FROM performance_schema.data_locks
8019 WHERE object_name = 't2';
8020 index_name lock_type lock_mode lock_status lock_data
8021 NULL TABLE IX GRANTED NULL
8022 PRIMARY RECORD X GRANTED 'aa'
8023 PRIMARY RECORD X GRANTED 'bb'
8024 PRIMARY RECORD X GRANTED 'cc'
8025 PRIMARY RECORD X GRANTED supremum pseudo-record
8026 ROLLBACK;
8027 BEGIN;
8028 SELECT *
8029 FROM t2 FORCE INDEX (PRIMARY)
8030 WHERE id <"e"
8031 ORDER BY id DESC
8032 FOR UPDATE;
8033 id
8034 ccc
8035 bbb
8036 aaa
8037 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8038 FROM performance_schema.data_locks
8039 WHERE object_name = 't2';
8040 index_name lock_type lock_mode lock_status lock_data
8041 NULL TABLE IX GRANTED NULL
8042 PRIMARY RECORD X GRANTED 'aa'
8043 PRIMARY RECORD X GRANTED 'bb'
8044 PRIMARY RECORD X GRANTED 'cc'
8045 PRIMARY RECORD X GRANTED supremum pseudo-record
8046 ROLLBACK;
8047 BEGIN;
8048 SELECT *
8049 FROM t2 FORCE INDEX (PRIMARY)
8050 WHERE id <"ee"
8051 ORDER BY id ASC
8052 FOR UPDATE;
8053 id
8054 aaa
8055 bbb
8056 ccc
8057 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8058 FROM performance_schema.data_locks
8059 WHERE object_name = 't2';
8060 index_name lock_type lock_mode lock_status lock_data
8061 NULL TABLE IX GRANTED NULL
8062 PRIMARY RECORD X GRANTED 'aa'
8063 PRIMARY RECORD X GRANTED 'bb'
8064 PRIMARY RECORD X GRANTED 'cc'
8065 PRIMARY RECORD X GRANTED supremum pseudo-record
8066 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'ee'
8067 ROLLBACK;
8068 BEGIN;
8069 SELECT *
8070 FROM t2 FORCE INDEX (PRIMARY)
8071 WHERE id <"ee"
8072 ORDER BY id DESC
8073 FOR UPDATE;
8074 id
8075 ccc
8076 bbb
8077 aaa
8078 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8079 FROM performance_schema.data_locks
8080 WHERE object_name = 't2';
8081 index_name lock_type lock_mode lock_status lock_data
8082 NULL TABLE IX GRANTED NULL
8083 PRIMARY RECORD X GRANTED 'aa'
8084 PRIMARY RECORD X GRANTED 'bb'
8085 PRIMARY RECORD X GRANTED 'cc'
8086 PRIMARY RECORD X GRANTED supremum pseudo-record
8087 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'ee'
8088 ROLLBACK;
8089 BEGIN;
8090 SELECT *
8091 FROM t2 FORCE INDEX (PRIMARY)
8092 WHERE id <="ee"
8093 ORDER BY id ASC
8094 FOR UPDATE;
8095 id
8096 aaa
8097 bbb
8098 ccc
8099 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8100 FROM performance_schema.data_locks
8101 WHERE object_name = 't2';
8102 index_name lock_type lock_mode lock_status lock_data
8103 NULL TABLE IX GRANTED NULL
8104 PRIMARY RECORD X GRANTED 'aa'
8105 PRIMARY RECORD X GRANTED 'bb'
8106 PRIMARY RECORD X GRANTED 'cc'
8107 PRIMARY RECORD X GRANTED supremum pseudo-record
8108 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'ee'
8109 ROLLBACK;
8110 BEGIN;
8111 SELECT *
8112 FROM t2 FORCE INDEX (PRIMARY)
8113 WHERE id <="ee"
8114 ORDER BY id DESC
8115 FOR UPDATE;
8116 id
8117 ccc
8118 bbb
8119 aaa
8120 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8121 FROM performance_schema.data_locks
8122 WHERE object_name = 't2';
8123 index_name lock_type lock_mode lock_status lock_data
8124 NULL TABLE IX GRANTED NULL
8125 PRIMARY RECORD X GRANTED 'aa'
8126 PRIMARY RECORD X GRANTED 'bb'
8127 PRIMARY RECORD X GRANTED 'cc'
8128 PRIMARY RECORD X GRANTED supremum pseudo-record
8129 PRIMARY RECORD X,REC_NOT_GAP GRANTED 'ee'
8130 ROLLBACK;
8131 BEGIN;
8132 SELECT *
8133 FROM t2 FORCE INDEX (PRIMARY)
8134 WHERE id <="ec"
8135 ORDER BY id ASC
8136 FOR UPDATE;
8137 id
8138 aaa
8139 bbb
8140 ccc
8141 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8142 FROM performance_schema.data_locks
8143 WHERE object_name = 't2';
8144 index_name lock_type lock_mode lock_status lock_data
8145 NULL TABLE IX GRANTED NULL
8146 PRIMARY RECORD X GRANTED 'aa'
8147 PRIMARY RECORD X GRANTED 'bb'
8148 PRIMARY RECORD X GRANTED 'cc'
8149 PRIMARY RECORD X GRANTED supremum pseudo-record
8150 ROLLBACK;
8151 BEGIN;
8152 SELECT *
8153 FROM t2 FORCE INDEX (PRIMARY)
8154 WHERE id <="ec"
8155 ORDER BY id DESC
8156 FOR UPDATE;
8157 id
8158 ccc
8159 bbb
8160 aaa
8161 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8162 FROM performance_schema.data_locks
8163 WHERE object_name = 't2';
8164 index_name lock_type lock_mode lock_status lock_data
8165 NULL TABLE IX GRANTED NULL
8166 PRIMARY RECORD X GRANTED 'aa'
8167 PRIMARY RECORD X GRANTED 'bb'
8168 PRIMARY RECORD X GRANTED 'cc'
8169 PRIMARY RECORD X GRANTED supremum pseudo-record
8170 ROLLBACK;
8171 BEGIN;
8172 SELECT *
8173 FROM t2 FORCE INDEX (PRIMARY)
8174 WHERE id <="ef"
8175 ORDER BY id ASC
8176 FOR UPDATE;
8177 id
8178 aaa
8179 bbb
8180 ccc
8181 eee
8182 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8183 FROM performance_schema.data_locks
8184 WHERE object_name = 't2';
8185 index_name lock_type lock_mode lock_status lock_data
8186 NULL TABLE IX GRANTED NULL
8187 PRIMARY RECORD X GRANTED 'aa'
8188 PRIMARY RECORD X GRANTED 'bb'
8189 PRIMARY RECORD X GRANTED 'cc'
8190 PRIMARY RECORD X GRANTED 'ee'
8191 PRIMARY RECORD X GRANTED supremum pseudo-record
8192 ROLLBACK;
8193 BEGIN;
8194 SELECT *
8195 FROM t2 FORCE INDEX (PRIMARY)
8196 WHERE id <="ef"
8197 ORDER BY id DESC
8198 FOR UPDATE;
8199 id
8200 eee
8201 ccc
8202 bbb
8203 aaa
8204 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8205 FROM performance_schema.data_locks
8206 WHERE object_name = 't2';
8207 index_name lock_type lock_mode lock_status lock_data
8208 NULL TABLE IX GRANTED NULL
8209 PRIMARY RECORD X GRANTED 'aa'
8210 PRIMARY RECORD X GRANTED 'bb'
8211 PRIMARY RECORD X GRANTED 'cc'
8212 PRIMARY RECORD X GRANTED 'ee'
8213 PRIMARY RECORD X GRANTED supremum pseudo-record
8214 ROLLBACK;
8215 BEGIN;
8216 SELECT *
8217 FROM t2 FORCE INDEX (PRIMARY)
8218 WHERE id >="g"
8219 ORDER BY id ASC
8220 FOR UPDATE;
8221 id
8222 ggg
8223 hhh
8224 iii
8225 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8226 FROM performance_schema.data_locks
8227 WHERE object_name = 't2';
8228 index_name lock_type lock_mode lock_status lock_data
8229 NULL TABLE IX GRANTED NULL
8230 PRIMARY RECORD X GRANTED 'gg'
8231 PRIMARY RECORD X GRANTED 'hh'
8232 PRIMARY RECORD X GRANTED 'ii'
8233 PRIMARY RECORD X,GAP GRANTED 'ee'
8234 ROLLBACK;
8235 BEGIN;
8236 SELECT *
8237 FROM t2 FORCE INDEX (PRIMARY)
8238 WHERE id >="g"
8239 ORDER BY id DESC
8240 FOR UPDATE;
8241 id
8242 iii
8243 hhh
8244 ggg
8245 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8246 FROM performance_schema.data_locks
8247 WHERE object_name = 't2';
8248 index_name lock_type lock_mode lock_status lock_data
8249 NULL TABLE IX GRANTED NULL
8250 PRIMARY RECORD X GRANTED 'gg'
8251 PRIMARY RECORD X GRANTED 'hh'
8252 PRIMARY RECORD X GRANTED 'ii'
8253 PRIMARY RECORD X,GAP GRANTED 'ee'
8254 ROLLBACK;
8255 BEGIN;
8256 SELECT *
8257 FROM t2 FORCE INDEX (PRIMARY)
8258 WHERE id >="f"
8259 ORDER BY id ASC
8260 FOR UPDATE;
8261 id
8262 ggg
8263 hhh
8264 iii
8265 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8266 FROM performance_schema.data_locks
8267 WHERE object_name = 't2';
8268 index_name lock_type lock_mode lock_status lock_data
8269 NULL TABLE IX GRANTED NULL
8270 PRIMARY RECORD X GRANTED 'gg'
8271 PRIMARY RECORD X GRANTED 'hh'
8272 PRIMARY RECORD X GRANTED 'ii'
8273 PRIMARY RECORD X,GAP GRANTED 'ee'
8274 ROLLBACK;
8275 BEGIN;
8276 SELECT *
8277 FROM t2 FORCE INDEX (PRIMARY)
8278 WHERE id >="f"
8279 ORDER BY id DESC
8280 FOR UPDATE;
8281 id
8282 iii
8283 hhh
8284 ggg
8285 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8286 FROM performance_schema.data_locks
8287 WHERE object_name = 't2';
8288 index_name lock_type lock_mode lock_status lock_data
8289 NULL TABLE IX GRANTED NULL
8290 PRIMARY RECORD X GRANTED 'gg'
8291 PRIMARY RECORD X GRANTED 'hh'
8292 PRIMARY RECORD X GRANTED 'ii'
8293 PRIMARY RECORD X,GAP GRANTED 'ee'
8294 ROLLBACK;
8295 BEGIN;
8296 SELECT *
8297 FROM t2 FORCE INDEX (PRIMARY)
8298 WHERE id >"e"
8299 ORDER BY id ASC
8300 FOR UPDATE;
8301 id
8302 eee
8303 ggg
8304 hhh
8305 iii
8306 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8307 FROM performance_schema.data_locks
8308 WHERE object_name = 't2';
8309 index_name lock_type lock_mode lock_status lock_data
8310 NULL TABLE IX GRANTED NULL
8311 PRIMARY RECORD X GRANTED 'ee'
8312 PRIMARY RECORD X GRANTED 'gg'
8313 PRIMARY RECORD X GRANTED 'hh'
8314 PRIMARY RECORD X GRANTED 'ii'
8315 PRIMARY RECORD X,GAP GRANTED 'cc'
8316 ROLLBACK;
8317 BEGIN;
8318 SELECT *
8319 FROM t2 FORCE INDEX (PRIMARY)
8320 WHERE id >"e"
8321 ORDER BY id DESC
8322 FOR UPDATE;
8323 id
8324 iii
8325 hhh
8326 ggg
8327 eee
8328 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8329 FROM performance_schema.data_locks
8330 WHERE object_name = 't2';
8331 index_name lock_type lock_mode lock_status lock_data
8332 NULL TABLE IX GRANTED NULL
8333 PRIMARY RECORD X GRANTED 'ee'
8334 PRIMARY RECORD X GRANTED 'gg'
8335 PRIMARY RECORD X GRANTED 'hh'
8336 PRIMARY RECORD X GRANTED 'ii'
8337 PRIMARY RECORD X,GAP GRANTED 'cc'
8338 ROLLBACK;
8339 BEGIN;
8340 SELECT *
8341 FROM t2 FORCE INDEX (PRIMARY)
8342 WHERE id >"ee"
8343 ORDER BY id ASC
8344 FOR UPDATE;
8345 id
8346 eee
8347 ggg
8348 hhh
8349 iii
8350 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8351 FROM performance_schema.data_locks
8352 WHERE object_name = 't2';
8353 index_name lock_type lock_mode lock_status lock_data
8354 NULL TABLE IX GRANTED NULL
8355 PRIMARY RECORD X GRANTED 'ee'
8356 PRIMARY RECORD X GRANTED 'gg'
8357 PRIMARY RECORD X GRANTED 'hh'
8358 PRIMARY RECORD X GRANTED 'ii'
8359 ROLLBACK;
8360 BEGIN;
8361 SELECT *
8362 FROM t2 FORCE INDEX (PRIMARY)
8363 WHERE id >"ee"
8364 ORDER BY id DESC
8365 FOR UPDATE;
8366 id
8367 iii
8368 hhh
8369 ggg
8370 eee
8371 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8372 FROM performance_schema.data_locks
8373 WHERE object_name = 't2';
8374 index_name lock_type lock_mode lock_status lock_data
8375 NULL TABLE IX GRANTED NULL
8376 PRIMARY RECORD X GRANTED 'ee'
8377 PRIMARY RECORD X GRANTED 'gg'
8378 PRIMARY RECORD X GRANTED 'hh'
8379 PRIMARY RECORD X GRANTED 'ii'
8380 ROLLBACK;
8381 BEGIN;
8382 SELECT *
8383 FROM t2 FORCE INDEX (PRIMARY)
8384 WHERE id >="ee"
8385 ORDER BY id ASC
8386 FOR UPDATE;
8387 id
8388 eee
8389 ggg
8390 hhh
8391 iii
8392 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8393 FROM performance_schema.data_locks
8394 WHERE object_name = 't2';
8395 index_name lock_type lock_mode lock_status lock_data
8396 NULL TABLE IX GRANTED NULL
8397 PRIMARY RECORD X GRANTED 'ee'
8398 PRIMARY RECORD X GRANTED 'gg'
8399 PRIMARY RECORD X GRANTED 'hh'
8400 PRIMARY RECORD X GRANTED 'ii'
8401 ROLLBACK;
8402 BEGIN;
8403 SELECT *
8404 FROM t2 FORCE INDEX (PRIMARY)
8405 WHERE id >="ee"
8406 ORDER BY id DESC
8407 FOR UPDATE;
8408 id
8409 iii
8410 hhh
8411 ggg
8412 eee
8413 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8414 FROM performance_schema.data_locks
8415 WHERE object_name = 't2';
8416 index_name lock_type lock_mode lock_status lock_data
8417 NULL TABLE IX GRANTED NULL
8418 PRIMARY RECORD X GRANTED 'ee'
8419 PRIMARY RECORD X GRANTED 'gg'
8420 PRIMARY RECORD X GRANTED 'hh'
8421 PRIMARY RECORD X GRANTED 'ii'
8422 ROLLBACK;
8423 BEGIN;
8424 SELECT *
8425 FROM t2 FORCE INDEX (PRIMARY)
8426 WHERE id >="ef"
8427 ORDER BY id ASC
8428 FOR UPDATE;
8429 id
8430 ggg
8431 hhh
8432 iii
8433 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8434 FROM performance_schema.data_locks
8435 WHERE object_name = 't2';
8436 index_name lock_type lock_mode lock_status lock_data
8437 NULL TABLE IX GRANTED NULL
8438 PRIMARY RECORD X GRANTED 'gg'
8439 PRIMARY RECORD X GRANTED 'hh'
8440 PRIMARY RECORD X GRANTED 'ii'
8441 PRIMARY RECORD X,GAP GRANTED 'ee'
8442 ROLLBACK;
8443 BEGIN;
8444 SELECT *
8445 FROM t2 FORCE INDEX (PRIMARY)
8446 WHERE id >="ef"
8447 ORDER BY id DESC
8448 FOR UPDATE;
8449 id
8450 iii
8451 hhh
8452 ggg
8453 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8454 FROM performance_schema.data_locks
8455 WHERE object_name = 't2';
8456 index_name lock_type lock_mode lock_status lock_data
8457 NULL TABLE IX GRANTED NULL
8458 PRIMARY RECORD X GRANTED 'gg'
8459 PRIMARY RECORD X GRANTED 'hh'
8460 PRIMARY RECORD X GRANTED 'ii'
8461 PRIMARY RECORD X,GAP GRANTED 'ee'
8462 ROLLBACK;
8463 BEGIN;
8464 SELECT *
8465 FROM t2 FORCE INDEX (PRIMARY)
8466 WHERE id >="ec"
8467 ORDER BY id ASC
8468 FOR UPDATE;
8469 id
8470 eee
8471 ggg
8472 hhh
8473 iii
8474 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8475 FROM performance_schema.data_locks
8476 WHERE object_name = 't2';
8477 index_name lock_type lock_mode lock_status lock_data
8478 NULL TABLE IX GRANTED NULL
8479 PRIMARY RECORD X GRANTED 'ee'
8480 PRIMARY RECORD X GRANTED 'gg'
8481 PRIMARY RECORD X GRANTED 'hh'
8482 PRIMARY RECORD X GRANTED 'ii'
8483 PRIMARY RECORD X,GAP GRANTED 'cc'
8484 ROLLBACK;
8485 BEGIN;
8486 SELECT *
8487 FROM t2 FORCE INDEX (PRIMARY)
8488 WHERE id >="ec"
8489 ORDER BY id DESC
8490 FOR UPDATE;
8491 id
8492 iii
8493 hhh
8494 ggg
8495 eee
8496 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
8497 FROM performance_schema.data_locks
8498 WHERE object_name = 't2';
8499 index_name lock_type lock_mode lock_status lock_data
8500 NULL TABLE IX GRANTED NULL
8501 PRIMARY RECORD X GRANTED 'ee'
8502 PRIMARY RECORD X GRANTED 'gg'
8503 PRIMARY RECORD X GRANTED 'hh'
8504 PRIMARY RECORD X GRANTED 'ii'
8505 PRIMARY RECORD X,GAP GRANTED 'cc'
8506 ROLLBACK;
8507 DROP TABLE t2;
8508 CREATE TABLE t1 (
8509 id INT NOT NULL,
8510 PRIMARY KEY (id ASC)
8511 ) ENGINE=InnoDB;
8512 INSERT INTO t1 VALUES (1), (3), (4), (5), (6), (7), (9);
8513 ANALYZE TABLE t1;
8514 Table Op Msg_type Msg_text
8515 test.t1 analyze status OK
8516 BEGIN;
8517 SELECT * FROM t1 WHERE id=7 FOR UPDATE;
8518 id
8519 7
8520 BEGIN;
8521 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL con2_will_wait';
8522 SELECT * FROM t1 FORCE INDEX (PRIMARY) WHERE id<=7 FOR UPDATE;;
8523 SET DEBUG_SYNC='now WAIT_FOR con2_will_wait';
8524 ROLLBACK;
8525 id
8526 1
8527 3
8528 4
8529 5
8530 6
8531 7
8532 DROP TABLE t1;
8533 CREATE TABLE t1 (
8534 id INT NOT NULL,
8535 PRIMARY KEY (id ASC)
8536 ) ENGINE=InnoDB;
8537 INSERT INTO t1 VALUES (1), (3), (4), (5), (6), (7), (9);
8538 ANALYZE TABLE t1;
8539 Table Op Msg_type Msg_text
8540 test.t1 analyze status OK
8541 SET GLOBAL innodb_purge_stop_now = ON;
8542 DELETE FROM t1 WHERE id=7;
8543 BEGIN;
8544 SELECT * FROM t1 FORCE INDEX (PRIMARY) WHERE id<=7 FOR UPDATE;
8545 id
8546 1
8547 3
8548 4
8549 5
8550 6
8551 SELECT index_name, lock_type, lock_mode, lock_status, lock_data
8552 FROM performance_schema.data_locks
8553 WHERE object_name='t1';
8554 index_name lock_type lock_mode lock_status lock_data
8555 NULL TABLE IX GRANTED NULL
8556 PRIMARY RECORD X GRANTED 1
8557 PRIMARY RECORD X GRANTED 3
8558 PRIMARY RECORD X GRANTED 4
8559 PRIMARY RECORD X GRANTED 5
8560 PRIMARY RECORD X GRANTED 6
8561 PRIMARY RECORD X GRANTED 7
8562 ROLLBACK;
8563 SET GLOBAL innodb_purge_run_now = ON;
8564 DROP TABLE t1;
8565 CREATE TABLE t1 (
8566 id INT NOT NULL,
8567 PRIMARY KEY (id ASC)
8568 ) ENGINE=InnoDB;
8569 INSERT INTO t1 VALUES (1), (3), (4), (5), (6), (7), (9);
8570 ANALYZE TABLE t1;
8571 Table Op Msg_type Msg_text
8572 test.t1 analyze status OK
8573 SET GLOBAL innodb_purge_stop_now = ON;
8574 DELETE FROM t1 WHERE id=7;
8575 BEGIN;
8576 SELECT * FROM t1 WHERE id=7 FOR UPDATE;
8577 id
8578 BEGIN;
8579 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL con2_will_wait';
8580 SELECT * FROM t1 FORCE INDEX (PRIMARY) WHERE id<=7 FOR UPDATE;;
8581 SET DEBUG_SYNC='now WAIT_FOR con2_will_wait';
8582 ROLLBACK;
8583 id
8584 1
8585 3
8586 4
8587 5
8588 6
8589 SET GLOBAL innodb_purge_run_now = ON;
8590 DROP TABLE t1;
8591 CREATE TABLE t1 (
8592 id INT NOT NULL,
8593 PRIMARY KEY (id ASC)
8594 ) ENGINE=InnoDB;
8595 INSERT INTO t1 VALUES (1), (3), (4), (5), (6), (7), (9);
8596 ANALYZE TABLE t1;
8597 Table Op Msg_type Msg_text
8598 test.t1 analyze status OK
8599 SET GLOBAL innodb_purge_stop_now = ON;
8600 DELETE FROM t1 WHERE id=7;
8601 BEGIN;
8602 INSERT INTO t1 VALUES (7);
8603 BEGIN;
8604 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL con2_will_wait';
8605 SELECT * FROM t1 FORCE INDEX (PRIMARY) WHERE id<=7 FOR UPDATE;;
8606 SET DEBUG_SYNC='now WAIT_FOR con2_will_wait';
8607 ROLLBACK;
8608 id
8609 1
8610 3
8611 4
8612 5
8613 6
8614 SET GLOBAL innodb_purge_run_now = ON;
8615 DROP TABLE t1;
8616 CREATE TABLE t1 (
8617 id INT NOT NULL,
8618 PRIMARY KEY (id ASC)
8619 ) ENGINE=InnoDB;
8620 INSERT INTO t1 VALUES (1), (3), (4), (5), (6), (7), (9);
8621 ANALYZE TABLE t1;
8622 Table Op Msg_type Msg_text
8623 test.t1 analyze status OK
8624 SET GLOBAL innodb_purge_stop_now = ON;
8625 DELETE FROM t1 WHERE id=7;
8626 BEGIN;
8627 INSERT INTO t1 VALUES (7);
8628 BEGIN;
8629 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL con2_will_wait';
8630 SELECT * FROM t1 FORCE INDEX (PRIMARY) WHERE id<=7 FOR UPDATE;;
8631 SET DEBUG_SYNC='now WAIT_FOR con2_will_wait';
8632 COMMIT;
8633 id
8634 1
8635 3
8636 4
8637 5
8638 6
8639 7
8640 SET GLOBAL innodb_purge_run_now = ON;
8641 DROP TABLE t1;
8642 CREATE TABLE t1 (
8643 id INT NOT NULL,
8644 val INT,
8645 PRIMARY KEY (id ASC)
8646 ) ENGINE=InnoDB;
8647 INSERT INTO t1 (id,val) VALUES (1,1),(2,2) ,(3,3), (4,4), (5,5), (6,6), (9,9);
8648 BEGIN;
8649 DELETE FROM t1 WHERE id=6;
8650 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
8651 BEGIN;
8652 SET DEBUG_SYNC='
8653 semi_consistent_read_would_wait
8654 SIGNAL con2_would_wait
8655 WAIT_FOR con2_can_peek';
8656 SET DEBUG_SYNC='
8657 row_search_for_mysql_before_return
8658 SIGNAL con2_returns_row
8659 WAIT_FOR con2_can_return_row
8660 EXECUTE 6';
8661 UPDATE t1 SET val=13 WHERE id<=6;
8662 Expecting row number 1
8663 SET DEBUG_SYNC='now WAIT_FOR con2_returns_row';
8664 SET DEBUG_SYNC='now SIGNAL con2_can_return_row';
8665 Expecting row number 2
8666 SET DEBUG_SYNC='now WAIT_FOR con2_returns_row';
8667 SET DEBUG_SYNC='now SIGNAL con2_can_return_row';
8668 Expecting row number 3
8669 SET DEBUG_SYNC='now WAIT_FOR con2_returns_row';
8670 SET DEBUG_SYNC='now SIGNAL con2_can_return_row';
8671 Expecting row number 4
8672 SET DEBUG_SYNC='now WAIT_FOR con2_returns_row';
8673 SET DEBUG_SYNC='now SIGNAL con2_can_return_row';
8674 Expecting row number 5
8675 SET DEBUG_SYNC='now WAIT_FOR con2_returns_row';
8676 SET DEBUG_SYNC='now SIGNAL con2_can_return_row';
8677 SET DEBUG_SYNC='now WAIT_FOR con2_would_wait';
8678 SELECT index_name, lock_type, lock_mode, lock_status, lock_data
8679 FROM performance_schema.data_locks
8680 WHERE object_name='t1';
8681 index_name lock_type lock_mode lock_status lock_data
8682 NULL TABLE IX GRANTED NULL
8683 NULL TABLE IX GRANTED NULL
8684 PRIMARY RECORD X,REC_NOT_GAP GRANTED 1
8685 PRIMARY RECORD X,REC_NOT_GAP GRANTED 2
8686 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3
8687 PRIMARY RECORD X,REC_NOT_GAP GRANTED 4
8688 PRIMARY RECORD X,REC_NOT_GAP GRANTED 5
8689 PRIMARY RECORD X,REC_NOT_GAP GRANTED 6
8690 SET DEBUG_SYNC='now SIGNAL con2_can_peek';
8691 SET DEBUG_SYNC='now WAIT_FOR con2_returns_row';
8692 SELECT index_name, lock_type, lock_mode, lock_status, lock_data
8693 FROM performance_schema.data_locks
8694 WHERE object_name='t1';
8695 index_name lock_type lock_mode lock_status lock_data
8696 NULL TABLE IX GRANTED NULL
8697 NULL TABLE IX GRANTED NULL
8698 PRIMARY RECORD X,REC_NOT_GAP GRANTED 1
8699 PRIMARY RECORD X,REC_NOT_GAP GRANTED 2
8700 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3
8701 PRIMARY RECORD X,REC_NOT_GAP GRANTED 4
8702 PRIMARY RECORD X,REC_NOT_GAP GRANTED 5
8703 PRIMARY RECORD X,REC_NOT_GAP GRANTED 6
8704 COMMIT;
8705 SELECT index_name, lock_type, lock_mode, lock_status, lock_data
8706 FROM performance_schema.data_locks
8707 WHERE object_name='t1';
8708 index_name lock_type lock_mode lock_status lock_data
8709 NULL TABLE IX GRANTED NULL
8710 PRIMARY RECORD X,REC_NOT_GAP GRANTED 1
8711 PRIMARY RECORD X,REC_NOT_GAP GRANTED 2
8712 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3
8713 PRIMARY RECORD X,REC_NOT_GAP GRANTED 4
8714 PRIMARY RECORD X,REC_NOT_GAP GRANTED 5
8715 SET DEBUG_SYNC='now SIGNAL con2_can_return_row';
8716 SELECT index_name, lock_type, lock_mode, lock_status, lock_data
8717 FROM performance_schema.data_locks
8718 WHERE object_name='t1';
8719 index_name lock_type lock_mode lock_status lock_data
8720 NULL TABLE IX GRANTED NULL
8721 PRIMARY RECORD X,REC_NOT_GAP GRANTED 1
8722 PRIMARY RECORD X,REC_NOT_GAP GRANTED 2
8723 PRIMARY RECORD X,REC_NOT_GAP GRANTED 3
8724 PRIMARY RECORD X,REC_NOT_GAP GRANTED 4
8725 PRIMARY RECORD X,REC_NOT_GAP GRANTED 5
8726 ROLLBACK;
8727 DROP TABLE t1;
8728 #
8729 # Bug #30112238 - [INNODB] ASSERTION FAILURE: ROW0SEL.CC.*DIRECTION != 0
8730 #
8731 CREATE TABLE t1 (
8732 id INT PRIMARY KEY
8733 );
8734 INSERT INTO t1 (id) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9);
8735 ANALYZE TABLE t1;
8736 Table Op Msg_type Msg_text
8737 test.t1 analyze status OK
8738 BEGIN;
8739 SELECT * FROM t1;
8740 id
8741 1
8742 2
8743 3
8744 4
8745 5
8746 6
8747 7
8748 8
8749 9
8750 DELETE FROM t1 WHERE id<=5;
8751 BEGIN;
8752 SELECT index_name, lock_type, lock_mode, lock_status, lock_data FROM performance_schema.data_locks WHERE object_name='t1';
8753 index_name lock_type lock_mode lock_status lock_data
8754 SELECT id FROM t1 FORCE INDEX (PRIMARY) WHERE id<=5 FOR UPDATE;
8755 id
8756 SELECT index_name, lock_type, lock_mode, lock_status, lock_data FROM performance_schema.data_locks WHERE object_name='t1';
8757 index_name lock_type lock_mode lock_status lock_data
8758 NULL TABLE IX GRANTED NULL
8759 PRIMARY RECORD X GRANTED 1
8760 PRIMARY RECORD X GRANTED 2
8761 PRIMARY RECORD X GRANTED 3
8762 PRIMARY RECORD X GRANTED 4
8763 PRIMARY RECORD X GRANTED 5
8764 COMMIT;
8765 DROP TABLE t1;