Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-2768

LP:604923 - RQG: UPDATEs report different affected_rows with non-default myisam-block-size

        Details

        • Type: Bug
        • Status: Closed
        • Resolution: Not a Bug
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          Description

          In MariaDB 5.2 (and not in 5.3 or MySQL), the last UPDATE from the sequence below returns a different number of affected_rows if executed with a non-default myisam-block-size.

          To reproduce:

          1. Record a .result file using the default myisam-block-size.

          perl mysql-test-run.pl --no-check-testcases --record t/affected_rows.test

          2. Run the test using a non-default value

          perl mysql-test-run.pl -no-check-testcases --mysqld=-myisam-block-size=8K t/affected_rows.test

          you will get something along those lines:

          CURRENT_TEST: main.affected_rows
          — /home/philips/bzr/5.2/mysql-test/r/affected_rows.result 2010-07-13 01:13:40.180143078 -0700
          +++ /home/philips/bzr/5.2/mysql-test/r/affected_rows.reject 2010-07-13 01:14:04.053070435 -0700
          @@ -554,4 +554,4 @@
          ...
          -affected rows: 1
          +affected rows: 0

          mysqltest: Result content mismatch

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                philipstoev Philip Stoev added a comment -

                Re: RQG: UPDATEs report different affected_rows with non-default myisam-block-size
                --disable_abort_on_error
                CREATE TABLE `table10_myisam_int_autoinc` ( `col_int` int, `col_char_12` char(12), `col_char_12_key` char(12), pk integer auto_increment, `col_int_key` int, /Indices/ key (`col_char_12_key` ), primary key (pk), key (`col_int_key` ));
                INSERT /*! IGNORE */ INTO table10_myisam_int_autoinc VALUES (4, 'if', 'that', NULL, -474021888) , (1, 'we', 'she', NULL, NULL) , (NULL, 'okay', 'xowgqqxe', NULL, -154927104) , (-2097610752, 'it\'s', 'from', NULL, -2114322432) , (NULL, 'd', 'for', NULL, NULL) , (7, 'yxow', 'o', NULL, NULL) , (-1583284224, 'did', 'the', NULL, 183173120) , (-850395136, 'l', 'i', NULL, NULL) , (6, 'a', 'tell', NULL, 2) , (1, 'm', 'eyxowg', NULL, 2);
                CREATE TABLE `table10_myisam_key_pk_parts_2_int_autoinc` ( pk integer auto_increment, `col_int_key` int, `col_char_12` char(12), `col_int` int, `col_char_12_key` char(12), /Indices/ primary key (pk), key (`col_int_key` ), key (`col_char_12_key` )) /*!50100 PARTITION BY key (pk) partitions 2 */;
                INSERT /*! IGNORE */ INTO table10_myisam_key_pk_parts_2_int_autoinc VALUES (NULL, 1, 'deyxowg', 4, 'i') , (NULL, NULL, 'that', 5, 'm') , (NULL, -1576271872, 'I\'ll', 7, 'udey') , (NULL, 1104019456, 'u', 1067188224, 'vu') , (NULL, 7, 't', -412811264, 'g') , (NULL, 4, 'm', -1147731968, 'ovudey') , (NULL, NULL, 'get', 1076953088, 'jovudeyx') , (NULL, NULL, 'sjovud', 1862205440, 'zsjovudeyx') , (NULL, 685899776, 'x', 9, 'mean') , (NULL, NULL, 'p', 9, 'mean');
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LIMIT 7;
                DELETE LOW_PRIORITY IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12_key` LIMIT 1;
                UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 'q' LIMIT 7;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_int_key` BETWEEN 2 AND 5 ORDER BY X . `col_char_12_key` LIMIT 8;
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X WHERE X . `col_int_key` BETWEEN 60 AND 1379074048 LIMIT 7;
                DELETE LOW_PRIORITY FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_int_key` IN ( 3316056064 , 9 , 9 , 7 , 'a' ) LIMIT 3;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` , `col_char_12_key` ) VALUES ( 3480551424 , 4061462528 ) , ( 2 , 22 );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_int_autoinc` ( `col_int_key` , `col_char_12_key` ) VALUES ( 950927360 , 'i' ) , ( 'p' , 94 );
                UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 'y' LIMIT 8;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 7 WHERE X . `col_char_12_key` < 9 LIMIT 5;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` , `col_char_12` ) VALUES ( 0 , 6 ) , ( 's' , 58 );
                UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 3944939520 WHERE X . `col_char_12_key` BETWEEN 1 AND 8 LIMIT 5;
                UPDATE LOW_PRIORITY IGNORE `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 'n' WHERE X . `col_int_key` BETWEEN 45 AND 4100521984 LIMIT 7;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X ORDER BY X . `col_int_key` LIMIT 5;
                UPDATE LOW_PRIORITY IGNORE `table10_myisam_int_autoinc` AS X SET `col_int_key` = 171 WHERE X . `col_int_key` BETWEEN 220 AND 2552889344 LIMIT 7;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                DELETE LOW_PRIORITY FROM `table10_myisam_int_autoinc` WHERE `col_int_key` BETWEEN 2 AND 5 LIMIT 4;
                DELETE LOW_PRIORITY FROM `table10_myisam_int_autoinc` LIMIT 4;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` IN ( 2583429120 , 3574792192 , 4089511936 , 7 , 's' ) LIMIT 5;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                UPDATE LOW_PRIORITY IGNORE `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 'j' WHERE X . `col_char_12_key` < 7 LIMIT 8;
                DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_int_autoinc` LIMIT 4;
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_int_key` BETWEEN 1 AND 3025797120 ORDER BY X . `col_int_key` LIMIT 7;
                UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 37 WHERE X . `col_int_key` < 3396468736 LIMIT 7;
                DELETE LOW_PRIORITY QUICK FROM `table10_myisam_int_autoinc` LIMIT 2;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_int` ) VALUES ( 'g' , 1659043840 ) , ( 4 , 121 );
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                REPLACE LOW_PRIORITY INTO `table10_myisam_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                DELETE LOW_PRIORITY IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12_key` LIMIT 3;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_char_12` ) VALUES ( 19 , 'u' ) , ( 250 , 'e' );
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` , `col_char_12_key` ) VALUES ( 'r' , 1978204160 ) , ( 3794337792 , 3040608256 );
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` , `col_int_key` ) VALUES ( 200 , 24 ) , ( 22 , 117 );
                UPDATE LOW_PRIORITY `table10_myisam_int_autoinc` AS X SET `col_char_12_key` = 'c' WHERE X . `col_int_key` IN ( 171 , 1 , 5 , 796983296 , 'd' ) LIMIT 7;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_int_key` FROM `table10_myisam_int_autoinc` AS X LIMIT 5;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LIMIT 5;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_int` ) VALUES ( 't' , 'e' ) , ( 'n' , 'w' );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                REPLACE LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_int_key` ) SELECT X . `col_int_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_int_key` < 2644312064 ORDER BY X . `col_char_12_key` LIMIT 8;
                DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_int_key` LIMIT 4;
                INSERT LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_int_key` ) LIMIT 7;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` , `col_int_key` ) VALUES ( 'n' , 8 ) , ( 7 , 2 );
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` , `col_int_key` ) VALUES ( 'y' , 'n' ) , ( 4 , 'x' );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_char_12_key` < 1 ORDER BY X . `col_char_12_key` LIMIT 7;
                UPDATE LOW_PRIORITY IGNORE `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 'i' LIMIT 6;
                UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 24 WHERE X . `col_int_key` IN ( 1522270208 , 1000603648 , 821886976 , 'a' , 4 ) LIMIT 6;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_char_12` ) VALUES ( 6 , 'h' ) , ( 1 , 137 );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_char_12_key` IN ( 174 , 7 , 9 , 3553165312 , 0 ) ORDER BY X . `col_int_key` LIMIT 7;
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` , `col_int` ) VALUES ( 4235264000 , 'w' ) , ( 174 , 173 );
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 8 WHERE X . `col_int_key` BETWEEN 2 AND 5 LIMIT 6;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                DELETE LOW_PRIORITY FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_int_key` = 'w' LIMIT 2;
                UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 5 WHERE X . `col_char_12_key` < 217 LIMIT 8;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_int_autoinc` ( `col_int_key` , `col_int` ) VALUES ( 'v' , 4162453504 ) , ( 'n' , 3 );
                UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 236 WHERE X . `col_int_key` < 3 LIMIT 6;
                REPLACE LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_char_12_key` , `col_int` ) VALUES ( 65 , 9 ) , ( 254 , 'k' );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_int_key` ) VALUES ( 5 , 0 ) , ( 'z' , 3204382720 );
                UPDATE LOW_PRIORITY `table10_myisam_int_autoinc` AS X SET `col_int_key` = 3279224832 WHERE X . `col_int_key` IN ( 37 , 'd' , 'b' , 'l' , 3 ) LIMIT 5;
                UPDATE LOW_PRIORITY `table10_myisam_int_autoinc` AS X SET `col_char_12_key` = 'n' WHERE X . `col_char_12_key` < 'j' LIMIT 7;
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_char_12_key` IN ( 60227584 , 2570125312 , 'n' , 'v' , 'z' ) ORDER BY X . `col_int_key` LIMIT 7;
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_int_autoinc` LIMIT 4;
                INSERT LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_int_key` < 2491613184 LIMIT 6;
                UPDATE LOW_PRIORITY `table10_myisam_int_autoinc` AS X SET `col_int_key` = 'f' WHERE X . `col_int_key` BETWEEN 52 AND 3790143488 LIMIT 6;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_int_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_char_12_key` < 'c' ORDER BY X . `col_char_12_key` LIMIT 5;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_char_12_key` ) ORDER BY X . `col_char_12_key` LIMIT 5;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_int_key` < 3961323520 LIMIT 6;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` , `col_char_12` ) VALUES ( 253 , 162 ) , ( 3075801088 , 1 );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_char_12_key` ) ORDER BY X . `col_char_12_key` LIMIT 5;
                DELETE LOW_PRIORITY FROM `table10_myisam_int_autoinc` ORDER BY `col_int_key` LIMIT 1;
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                UPDATE LOW_PRIORITY IGNORE `table10_myisam_int_autoinc` AS X SET `col_int_key` = 1534525440 WHERE X . `col_int_key` < 453181440 LIMIT 6;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                DELETE LOW_PRIORITY QUICK FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_char_12_key` BETWEEN 3 AND 8 LIMIT 3;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_char_12` ) VALUES ( 'u' , 116 ) , ( 128 , 'w' );
                UPDATE LOW_PRIORITY IGNORE `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 5 WHERE X . `col_char_12_key` < 135 LIMIT 8;
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                UPDATE LOW_PRIORITY IGNORE `table10_myisam_int_autoinc` AS X SET `col_char_12_key` = 112197632 WHERE X . `col_int_key` BETWEEN 5 AND 2627207168 LIMIT 8;
                UPDATE LOW_PRIORITY IGNORE `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 'x' WHERE X . `col_char_12_key` BETWEEN 3 AND 7 LIMIT 8;
                UPDATE LOW_PRIORITY IGNORE `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 'd' LIMIT 6;
                DELETE LOW_PRIORITY QUICK FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_int_key` BETWEEN 4 AND 6 LIMIT 2;
                UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 101 WHERE X . `col_char_12_key` < 759889920 LIMIT 7;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` , `col_char_12` ) VALUES ( 228 , 2337406976 ) , ( 5 , 3702194176 );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12_key` LIMIT 2;
                DELETE LOW_PRIORITY QUICK FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12_key` LIMIT 2;
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` IN ( 2555248640 , 3900571648 , 2243821568 , 'i' , 2310799360 ) LIMIT 5;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X WHERE X . `col_char_12_key` IN ( 'e' , 0 , 2 , 5 , 642646016 ) LIMIT 8;
                DELETE LOW_PRIORITY QUICK FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12_key` LIMIT 4;
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_int_key` IN ( 'v' , 'd' , 'v' , 142 , 1809121280 ) LIMIT 7;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` BETWEEN 215 AND 1962999808 LIMIT 5;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_int_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_int_key` < 3722051584 ORDER BY X . `col_char_12_key` LIMIT 8;
                REPLACE LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_char_12_key` , `col_int_key` ) VALUES ( 2 , 'n' ) , ( 'j' , 0 );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` , `col_char_12` ) VALUES ( 1029767168 , 63 ) , ( 's' , 40 );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_int_key` ) VALUES ( 'e' , 'y' ) , ( 201 , 'g' );
                UPDATE LOW_PRIORITY IGNORE `table10_myisam_int_autoinc` AS X SET `col_char_12_key` = 1 WHERE X . `col_char_12_key` BETWEEN 145 AND 3582656512 LIMIT 8;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` , `col_int_key` ) VALUES ( 3 , 3132096512 ) , ( 'i' , 0 );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LIMIT 8;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_int` ) VALUES ( 4 , 7 ) , ( 1 , 'n' );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_char_12_key` < 1336147968 LIMIT 5;
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_char_12_key` < 191 LIMIT 7;
                UPDATE LOW_PRIORITY `table10_myisam_int_autoinc` AS X SET `col_int_key` = 206 LIMIT 6;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_int_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_char_12_key` < 'n' ORDER BY X . `col_int_key` LIMIT 5;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` IN ( 'f' , 'k' , 0 , 3148611584 , 2080899072 ) LIMIT 7;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_int_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_int_key` < 220 ORDER BY X . `col_char_12_key` LIMIT 6;
                DELETE LOW_PRIORITY IGNORE FROM `table10_myisam_int_autoinc` WHERE `col_char_12_key` IN ( 844234752 , 'z' , 'i' , 2 , 159 ) LIMIT 3;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X ORDER BY X . `col_int_key` LIMIT 8;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X WHERE X . `col_char_12_key` IN ( 1819541504 , 4 , 'm' , 0 , 8 ) ORDER BY X . `col_char_12_key` LIMIT 8;
                DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_int_key` BETWEEN 1 AND 7 ORDER BY `col_char_12_key` LIMIT 4;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_char_12_key` ) ORDER BY X . `col_char_12_key` LIMIT 6;
                DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_int_key` IN ( 4 , 't' , 6 , 7 , 'p' ) LIMIT 3;
                DELETE LOW_PRIORITY IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_int_key` IN ( 493355008 , 'l' , 13 , 8 , 4052156416 ) ORDER BY `col_int_key` LIMIT 4;
                DELETE LOW_PRIORITY FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_char_12_key` BETWEEN 2 AND 6 LIMIT 3;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` , `col_char_12_key` ) VALUES ( 'i' , 3414228992 ) , ( 'c' , 'h' );
                UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 0 LIMIT 6;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` IN ( 7 , 'l' , 'l' , 6 , 'r' ) LIMIT 5;
                UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 217 WHERE X . `col_char_12_key` < 7 LIMIT 7;
                DELETE LOW_PRIORITY QUICK FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12_key` LIMIT 4;
                REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_int_key` LIMIT 4;
                INSERT LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_int_key` , `col_int` ) VALUES ( 71 , 'l' ) , ( 782368768 , 2282487808 );
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_int_key` BETWEEN 17 AND 1885798400 LIMIT 8;
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` , `col_char_12` ) VALUES ( 3 , 7 ) , ( 124 , 'u' );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_int_key` ) VALUES ( 707919872 , 2936012800 ) , ( 883359744 , 249 );
                INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` , `col_char_12_key` ) VALUES ( 236 , 'm' ) , ( 'l' , 9 );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL);
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` , `col_int_key` ) VALUES ( 't' , 150 ) , ( 0 , 1 );
                INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` , `col_char_12_key` ) VALUES ( 56 , 'g' ) , ( 67 , 'a' );
                DELETE LOW_PRIORITY QUICK FROM `table10_myisam_key_pk_parts_2_int_autoinc` LIMIT 4;
                REPLACE LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` < 1743323136 ORDER BY X . `col_char_12_key` LIMIT 8;
                --enable_result_log
                --enable_info
                UPDATE LOW_PRIORITY IGNORE `table10_myisam_int_autoinc` AS X SET `col_int_key` = 11 WHERE X . `col_char_12_key` BETWEEN 224 AND 559874048 LIMIT 6;

                Show
                philipstoev Philip Stoev added a comment - Re: RQG: UPDATEs report different affected_rows with non-default myisam-block-size --disable_abort_on_error CREATE TABLE `table10_myisam_int_autoinc` ( `col_int` int, `col_char_12` char(12), `col_char_12_key` char(12), pk integer auto_increment, `col_int_key` int, / Indices / key (`col_char_12_key` ), primary key (pk), key (`col_int_key` )); INSERT /*! IGNORE */ INTO table10_myisam_int_autoinc VALUES (4, 'if', 'that', NULL, -474021888) , (1, 'we', 'she', NULL, NULL) , (NULL, 'okay', 'xowgqqxe', NULL, -154927104) , (-2097610752, 'it\'s', 'from', NULL, -2114322432) , (NULL, 'd', 'for', NULL, NULL) , (7, 'yxow', 'o', NULL, NULL) , (-1583284224, 'did', 'the', NULL, 183173120) , (-850395136, 'l', 'i', NULL, NULL) , (6, 'a', 'tell', NULL, 2) , (1, 'm', 'eyxowg', NULL, 2); CREATE TABLE `table10_myisam_key_pk_parts_2_int_autoinc` ( pk integer auto_increment, `col_int_key` int, `col_char_12` char(12), `col_int` int, `col_char_12_key` char(12), / Indices / primary key (pk), key (`col_int_key` ), key (`col_char_12_key` )) /*!50100 PARTITION BY key (pk) partitions 2 */; INSERT /*! IGNORE */ INTO table10_myisam_key_pk_parts_2_int_autoinc VALUES (NULL, 1, 'deyxowg', 4, 'i') , (NULL, NULL, 'that', 5, 'm') , (NULL, -1576271872, 'I\'ll', 7, 'udey') , (NULL, 1104019456, 'u', 1067188224, 'vu') , (NULL, 7, 't', -412811264, 'g') , (NULL, 4, 'm', -1147731968, 'ovudey') , (NULL, NULL, 'get', 1076953088, 'jovudeyx') , (NULL, NULL, 'sjovud', 1862205440, 'zsjovudeyx') , (NULL, 685899776, 'x', 9, 'mean') , (NULL, NULL, 'p', 9, 'mean'); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LIMIT 7; DELETE LOW_PRIORITY IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12_key` LIMIT 1; UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 'q' LIMIT 7; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_int_key` BETWEEN 2 AND 5 ORDER BY X . `col_char_12_key` LIMIT 8; INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X WHERE X . `col_int_key` BETWEEN 60 AND 1379074048 LIMIT 7; DELETE LOW_PRIORITY FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_int_key` IN ( 3316056064 , 9 , 9 , 7 , 'a' ) LIMIT 3; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` , `col_char_12_key` ) VALUES ( 3480551424 , 4061462528 ) , ( 2 , 22 ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_int_autoinc` ( `col_int_key` , `col_char_12_key` ) VALUES ( 950927360 , 'i' ) , ( 'p' , 94 ); UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 'y' LIMIT 8; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 7 WHERE X . `col_char_12_key` < 9 LIMIT 5; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` , `col_char_12` ) VALUES ( 0 , 6 ) , ( 's' , 58 ); UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 3944939520 WHERE X . `col_char_12_key` BETWEEN 1 AND 8 LIMIT 5; UPDATE LOW_PRIORITY IGNORE `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 'n' WHERE X . `col_int_key` BETWEEN 45 AND 4100521984 LIMIT 7; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X ORDER BY X . `col_int_key` LIMIT 5; UPDATE LOW_PRIORITY IGNORE `table10_myisam_int_autoinc` AS X SET `col_int_key` = 171 WHERE X . `col_int_key` BETWEEN 220 AND 2552889344 LIMIT 7; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); DELETE LOW_PRIORITY FROM `table10_myisam_int_autoinc` WHERE `col_int_key` BETWEEN 2 AND 5 LIMIT 4; DELETE LOW_PRIORITY FROM `table10_myisam_int_autoinc` LIMIT 4; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` IN ( 2583429120 , 3574792192 , 4089511936 , 7 , 's' ) LIMIT 5; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); UPDATE LOW_PRIORITY IGNORE `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 'j' WHERE X . `col_char_12_key` < 7 LIMIT 8; DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_int_autoinc` LIMIT 4; INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_int_key` BETWEEN 1 AND 3025797120 ORDER BY X . `col_int_key` LIMIT 7; UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 37 WHERE X . `col_int_key` < 3396468736 LIMIT 7; DELETE LOW_PRIORITY QUICK FROM `table10_myisam_int_autoinc` LIMIT 2; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_int` ) VALUES ( 'g' , 1659043840 ) , ( 4 , 121 ); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); REPLACE LOW_PRIORITY INTO `table10_myisam_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); DELETE LOW_PRIORITY IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12_key` LIMIT 3; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_char_12` ) VALUES ( 19 , 'u' ) , ( 250 , 'e' ); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` , `col_char_12_key` ) VALUES ( 'r' , 1978204160 ) , ( 3794337792 , 3040608256 ); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` , `col_int_key` ) VALUES ( 200 , 24 ) , ( 22 , 117 ); UPDATE LOW_PRIORITY `table10_myisam_int_autoinc` AS X SET `col_char_12_key` = 'c' WHERE X . `col_int_key` IN ( 171 , 1 , 5 , 796983296 , 'd' ) LIMIT 7; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_int_key` FROM `table10_myisam_int_autoinc` AS X LIMIT 5; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LIMIT 5; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_int` ) VALUES ( 't' , 'e' ) , ( 'n' , 'w' ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); REPLACE LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_int_key` ) SELECT X . `col_int_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_int_key` < 2644312064 ORDER BY X . `col_char_12_key` LIMIT 8; DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_int_key` LIMIT 4; INSERT LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_int_key` ) LIMIT 7; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` , `col_int_key` ) VALUES ( 'n' , 8 ) , ( 7 , 2 ); REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` , `col_int_key` ) VALUES ( 'y' , 'n' ) , ( 4 , 'x' ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_char_12_key` < 1 ORDER BY X . `col_char_12_key` LIMIT 7; UPDATE LOW_PRIORITY IGNORE `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 'i' LIMIT 6; UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 24 WHERE X . `col_int_key` IN ( 1522270208 , 1000603648 , 821886976 , 'a' , 4 ) LIMIT 6; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_char_12` ) VALUES ( 6 , 'h' ) , ( 1 , 137 ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_char_12_key` IN ( 174 , 7 , 9 , 3553165312 , 0 ) ORDER BY X . `col_int_key` LIMIT 7; INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` , `col_int` ) VALUES ( 4235264000 , 'w' ) , ( 174 , 173 ); REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 8 WHERE X . `col_int_key` BETWEEN 2 AND 5 LIMIT 6; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); DELETE LOW_PRIORITY FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_int_key` = 'w' LIMIT 2; UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 5 WHERE X . `col_char_12_key` < 217 LIMIT 8; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_int_autoinc` ( `col_int_key` , `col_int` ) VALUES ( 'v' , 4162453504 ) , ( 'n' , 3 ); UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 236 WHERE X . `col_int_key` < 3 LIMIT 6; REPLACE LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_char_12_key` , `col_int` ) VALUES ( 65 , 9 ) , ( 254 , 'k' ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_int_key` ) VALUES ( 5 , 0 ) , ( 'z' , 3204382720 ); UPDATE LOW_PRIORITY `table10_myisam_int_autoinc` AS X SET `col_int_key` = 3279224832 WHERE X . `col_int_key` IN ( 37 , 'd' , 'b' , 'l' , 3 ) LIMIT 5; UPDATE LOW_PRIORITY `table10_myisam_int_autoinc` AS X SET `col_char_12_key` = 'n' WHERE X . `col_char_12_key` < 'j' LIMIT 7; INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_char_12_key` IN ( 60227584 , 2570125312 , 'n' , 'v' , 'z' ) ORDER BY X . `col_int_key` LIMIT 7; INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_int_autoinc` LIMIT 4; INSERT LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_int_key` < 2491613184 LIMIT 6; UPDATE LOW_PRIORITY `table10_myisam_int_autoinc` AS X SET `col_int_key` = 'f' WHERE X . `col_int_key` BETWEEN 52 AND 3790143488 LIMIT 6; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_int_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_char_12_key` < 'c' ORDER BY X . `col_char_12_key` LIMIT 5; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_char_12_key` ) ORDER BY X . `col_char_12_key` LIMIT 5; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_int_key` < 3961323520 LIMIT 6; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` , `col_char_12` ) VALUES ( 253 , 162 ) , ( 3075801088 , 1 ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_char_12_key` ) ORDER BY X . `col_char_12_key` LIMIT 5; DELETE LOW_PRIORITY FROM `table10_myisam_int_autoinc` ORDER BY `col_int_key` LIMIT 1; INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); UPDATE LOW_PRIORITY IGNORE `table10_myisam_int_autoinc` AS X SET `col_int_key` = 1534525440 WHERE X . `col_int_key` < 453181440 LIMIT 6; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); DELETE LOW_PRIORITY QUICK FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_char_12_key` BETWEEN 3 AND 8 LIMIT 3; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_char_12` ) VALUES ( 'u' , 116 ) , ( 128 , 'w' ); UPDATE LOW_PRIORITY IGNORE `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 5 WHERE X . `col_char_12_key` < 135 LIMIT 8; INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); UPDATE LOW_PRIORITY IGNORE `table10_myisam_int_autoinc` AS X SET `col_char_12_key` = 112197632 WHERE X . `col_int_key` BETWEEN 5 AND 2627207168 LIMIT 8; UPDATE LOW_PRIORITY IGNORE `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 'x' WHERE X . `col_char_12_key` BETWEEN 3 AND 7 LIMIT 8; UPDATE LOW_PRIORITY IGNORE `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 'd' LIMIT 6; DELETE LOW_PRIORITY QUICK FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_int_key` BETWEEN 4 AND 6 LIMIT 2; UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_char_12_key` = 101 WHERE X . `col_char_12_key` < 759889920 LIMIT 7; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` , `col_char_12` ) VALUES ( 228 , 2337406976 ) , ( 5 , 3702194176 ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12_key` LIMIT 2; DELETE LOW_PRIORITY QUICK FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12_key` LIMIT 2; INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` IN ( 2555248640 , 3900571648 , 2243821568 , 'i' , 2310799360 ) LIMIT 5; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X WHERE X . `col_char_12_key` IN ( 'e' , 0 , 2 , 5 , 642646016 ) LIMIT 8; DELETE LOW_PRIORITY QUICK FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12_key` LIMIT 4; INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_int_key` IN ( 'v' , 'd' , 'v' , 142 , 1809121280 ) LIMIT 7; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` BETWEEN 215 AND 1962999808 LIMIT 5; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_int_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_int_key` < 3722051584 ORDER BY X . `col_char_12_key` LIMIT 8; REPLACE LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_char_12_key` , `col_int_key` ) VALUES ( 2 , 'n' ) , ( 'j' , 0 ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` , `col_char_12` ) VALUES ( 1029767168 , 63 ) , ( 's' , 40 ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_int_key` ) VALUES ( 'e' , 'y' ) , ( 201 , 'g' ); UPDATE LOW_PRIORITY IGNORE `table10_myisam_int_autoinc` AS X SET `col_char_12_key` = 1 WHERE X . `col_char_12_key` BETWEEN 145 AND 3582656512 LIMIT 8; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` , `col_int_key` ) VALUES ( 3 , 3132096512 ) , ( 'i' , 0 ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LIMIT 8; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_int` ) VALUES ( 4 , 7 ) , ( 1 , 'n' ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_char_12_key` < 1336147968 LIMIT 5; INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_char_12_key` < 191 LIMIT 7; UPDATE LOW_PRIORITY `table10_myisam_int_autoinc` AS X SET `col_int_key` = 206 LIMIT 6; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_int_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_char_12_key` < 'n' ORDER BY X . `col_int_key` LIMIT 5; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` IN ( 'f' , 'k' , 0 , 3148611584 , 2080899072 ) LIMIT 7; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_int_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_char_12_key` ) WHERE X . `col_int_key` < 220 ORDER BY X . `col_char_12_key` LIMIT 6; DELETE LOW_PRIORITY IGNORE FROM `table10_myisam_int_autoinc` WHERE `col_char_12_key` IN ( 844234752 , 'z' , 'i' , 2 , 159 ) LIMIT 3; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X ORDER BY X . `col_int_key` LIMIT 8; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X WHERE X . `col_char_12_key` IN ( 1819541504 , 4 , 'm' , 0 , 8 ) ORDER BY X . `col_char_12_key` LIMIT 8; DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_int_key` BETWEEN 1 AND 7 ORDER BY `col_char_12_key` LIMIT 4; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_int_autoinc` AS Y USING ( `col_char_12_key` ) ORDER BY X . `col_char_12_key` LIMIT 6; DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_int_key` IN ( 4 , 't' , 6 , 7 , 'p' ) LIMIT 3; DELETE LOW_PRIORITY IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_int_key` IN ( 493355008 , 'l' , 13 , 8 , 4052156416 ) ORDER BY `col_int_key` LIMIT 4; DELETE LOW_PRIORITY FROM `table10_myisam_key_pk_parts_2_int_autoinc` WHERE `col_char_12_key` BETWEEN 2 AND 6 LIMIT 3; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` , `col_char_12_key` ) VALUES ( 'i' , 3414228992 ) , ( 'c' , 'h' ); UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 0 LIMIT 6; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` IN ( 7 , 'l' , 'l' , 6 , 'r' ) LIMIT 5; UPDATE LOW_PRIORITY `table10_myisam_key_pk_parts_2_int_autoinc` AS X SET `col_int_key` = 217 WHERE X . `col_char_12_key` < 7 LIMIT 7; DELETE LOW_PRIORITY QUICK FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_char_12_key` LIMIT 4; REPLACE LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); DELETE LOW_PRIORITY QUICK IGNORE FROM `table10_myisam_key_pk_parts_2_int_autoinc` ORDER BY `col_int_key` LIMIT 4; INSERT LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_int_key` , `col_int` ) VALUES ( 71 , 'l' ) , ( 782368768 , 2282487808 ); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` ) SELECT X . `col_char_12_key` FROM `table10_myisam_int_autoinc` AS X LEFT JOIN `table10_myisam_key_pk_parts_2_int_autoinc` AS Y USING ( `col_int_key` ) WHERE X . `col_int_key` BETWEEN 17 AND 1885798400 LIMIT 8; INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int_key` , `col_char_12` ) VALUES ( 3 , 7 ) , ( 124 , 'u' ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12_key` , `col_int_key` ) VALUES ( 707919872 , 2936012800 ) , ( 883359744 , 249 ); INSERT LOW_PRIORITY INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` , `col_char_12_key` ) VALUES ( 236 , 'm' ) , ( 'l' , 9 ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` (`pk`) VALUES (NULL); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_int` , `col_int_key` ) VALUES ( 't' , 150 ) , ( 0 , 1 ); INSERT LOW_PRIORITY IGNORE INTO `table10_myisam_key_pk_parts_2_int_autoinc` ( `col_char_12` , `col_char_12_key` ) VALUES ( 56 , 'g' ) , ( 67 , 'a' ); DELETE LOW_PRIORITY QUICK FROM `table10_myisam_key_pk_parts_2_int_autoinc` LIMIT 4; REPLACE LOW_PRIORITY INTO `table10_myisam_int_autoinc` ( `col_char_12_key` ) SELECT X . `col_int_key` FROM `table10_myisam_key_pk_parts_2_int_autoinc` AS X WHERE X . `col_int_key` < 1743323136 ORDER BY X . `col_char_12_key` LIMIT 8; --enable_result_log --enable_info UPDATE LOW_PRIORITY IGNORE `table10_myisam_int_autoinc` AS X SET `col_int_key` = 11 WHERE X . `col_char_12_key` BETWEEN 224 AND 559874048 LIMIT 6;
                Hide
                Permalink
                philipstoev Philip Stoev added a comment -

                Re: RQG: UPDATEs report different affected_rows with non-default myisam-block-size
                (12:29:24) montywi: philip_stoev: ok, I know understand the problem

                (12:29:32) montywi: No bug in MySQL/MariaDB

                (12:29:41) montywi: The issue is this row:

                (12:29:49) montywi: REPLACE LOW_PRIORITY INTO `t1` ( `col_char_12_key` ) SELECT X . `col_int_key` FROM `t2` AS X WHERE X . `col_int_key` < 1743323136 ORDER BY X . `col_char_12_key` LIMIT 8;

                (12:30:46) montywi: There is a lot of 'col_char_12_key' values of Null. Because of this, ORDER BY X . `col_char_12_key` can give you a different set of rows depending on structure on disk

                (12:31:09) montywi: (as there is no guaranteed order for the rows)

                (12:32:04) montywi: In your case, with the default key size, there is a row that matches the next update query

                (12:32:18) montywi: this row is not present with the 8K block size

                (12:33:11) montywi: So the real difference is this query:

                (12:33:20) montywi: SELECT X . `col_int_key`, col_char_12_key FROM `t2` AS X WHERE X . `col_int_key` < 1743323136 ORDER BY X . `col_char_12_key` LIMIT 8;

                (12:33:56) montywi: With default block size, this uses index only. With 8K size we use filesort

                (12:34:03) montywi: which gives different rows

                Show
                philipstoev Philip Stoev added a comment - Re: RQG: UPDATEs report different affected_rows with non-default myisam-block-size (12:29:24) montywi: philip_stoev: ok, I know understand the problem (12:29:32) montywi: No bug in MySQL/MariaDB (12:29:41) montywi: The issue is this row: (12:29:49) montywi: REPLACE LOW_PRIORITY INTO `t1` ( `col_char_12_key` ) SELECT X . `col_int_key` FROM `t2` AS X WHERE X . `col_int_key` < 1743323136 ORDER BY X . `col_char_12_key` LIMIT 8; (12:30:46) montywi: There is a lot of 'col_char_12_key' values of Null. Because of this, ORDER BY X . `col_char_12_key` can give you a different set of rows depending on structure on disk (12:31:09) montywi: (as there is no guaranteed order for the rows) (12:32:04) montywi: In your case, with the default key size, there is a row that matches the next update query (12:32:18) montywi: this row is not present with the 8K block size (12:33:11) montywi: So the real difference is this query: (12:33:20) montywi: SELECT X . `col_int_key`, col_char_12_key FROM `t2` AS X WHERE X . `col_int_key` < 1743323136 ORDER BY X . `col_char_12_key` LIMIT 8; (12:33:56) montywi: With default block size, this uses index only. With 8K size we use filesort (12:34:03) montywi: which gives different rows
                Hide
                Permalink
                monty Michael Widenius added a comment -

                Re: RQG: UPDATEs report different affected_rows with non-default myisam-block-size
                This is not a bug.

                The reason for the difference in the tests results is that the changing the myisam_block_size may cause the optimizer to do different plans for the query.

                In this case, the problem query is:

                REPLACE LOW_PRIORITY INTO `t1` ( `col_char_12_key` ) SELECT X . `col_int_key` FROM `t2` AS X WHERE X . `col_int_key` < 1743323136 ORDER BY X . `col_char_12_key` LIMIT 8;

                As this table has a lot of identical values for col_char_12_key, the rows returned by the SELECT is depending on the query plan.

                I verified that for this bug report, the above select returns a different set of rows, which caused a different number of affected rows in later queries.

                Show
                monty Michael Widenius added a comment - Re: RQG: UPDATEs report different affected_rows with non-default myisam-block-size This is not a bug. The reason for the difference in the tests results is that the changing the myisam_block_size may cause the optimizer to do different plans for the query. In this case, the problem query is: REPLACE LOW_PRIORITY INTO `t1` ( `col_char_12_key` ) SELECT X . `col_int_key` FROM `t2` AS X WHERE X . `col_int_key` < 1743323136 ORDER BY X . `col_char_12_key` LIMIT 8; As this table has a lot of identical values for col_char_12_key, the rows returned by the SELECT is depending on the query plan. I verified that for this bug report, the above select returns a different set of rows, which caused a different number of affected rows in later queries.
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 604923

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 604923

                  People

                  • Assignee:
                    monty Michael Widenius
                    Reporter:
                    philipstoev Philip Stoev
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: