diff options
Diffstat (limited to 'mysql-test/suite/parts/r/partition_alter1_1_2_innodb.result')
| -rw-r--r-- | mysql-test/suite/parts/r/partition_alter1_1_2_innodb.result | 798 |
1 files changed, 399 insertions, 399 deletions
diff --git a/mysql-test/suite/parts/r/partition_alter1_1_2_innodb.result b/mysql-test/suite/parts/r/partition_alter1_1_2_innodb.result index b126d459335..ac56faae01e 100644 --- a/mysql-test/suite/parts/r/partition_alter1_1_2_innodb.result +++ b/mysql-test/suite/parts/r/partition_alter1_1_2_innodb.result @@ -75,7 +75,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 # check prerequisites-1 success: 1 @@ -567,7 +567,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 # check prerequisites-1 success: 1 @@ -1067,15 +1067,15 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = InnoDB, - PARTITION part_2 VALUES IN (-2) ENGINE = InnoDB, - PARTITION part_1 VALUES IN (-1) ENGINE = InnoDB, - PARTITION part_N VALUES IN (NULL) ENGINE = InnoDB, - PARTITION part0 VALUES IN (0) ENGINE = InnoDB, - PARTITION part1 VALUES IN (1) ENGINE = InnoDB, - PARTITION part2 VALUES IN (2) ENGINE = InnoDB, - PARTITION part3 VALUES IN (3) ENGINE = InnoDB) + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = InnoDB, + PARTITION `part_2` VALUES IN (-2) ENGINE = InnoDB, + PARTITION `part_1` VALUES IN (-1) ENGINE = InnoDB, + PARTITION `part_N` VALUES IN (NULL) ENGINE = InnoDB, + PARTITION `part0` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part1` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (2) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (3) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -1572,13 +1572,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (15) ENGINE = InnoDB, - PARTITION parte VALUES LESS THAN (20) ENGINE = InnoDB, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = InnoDB) + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = InnoDB, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = InnoDB, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -2071,13 +2071,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY HASH (f_int2) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY HASH (`f_int2`) SUBPARTITIONS 2 -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = InnoDB) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -2574,20 +2574,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = InnoDB, - SUBPARTITION subpart12 ENGINE = InnoDB), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = InnoDB, - SUBPARTITION subpart22 ENGINE = InnoDB), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = InnoDB, - SUBPARTITION subpart32 ENGINE = InnoDB), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = InnoDB, - SUBPARTITION subpart42 ENGINE = InnoDB)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = InnoDB, + SUBPARTITION `subpart12` ENGINE = InnoDB), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = InnoDB, + SUBPARTITION `subpart22` ENGINE = InnoDB), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = InnoDB, + SUBPARTITION `subpart32` ENGINE = InnoDB), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = InnoDB, + SUBPARTITION `subpart42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -3084,20 +3084,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int2 + 1) -(PARTITION part1 VALUES IN (0) - (SUBPARTITION sp11 ENGINE = InnoDB, - SUBPARTITION sp12 ENGINE = InnoDB), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = InnoDB, - SUBPARTITION sp22 ENGINE = InnoDB), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = InnoDB, - SUBPARTITION sp32 ENGINE = InnoDB), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = InnoDB, - SUBPARTITION sp42 ENGINE = InnoDB)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = InnoDB, + SUBPARTITION `sp12` ENGINE = InnoDB), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = InnoDB, + SUBPARTITION `sp22` ENGINE = InnoDB), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = InnoDB, + SUBPARTITION `sp32` ENGINE = InnoDB), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = InnoDB, + SUBPARTITION `sp42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -3592,12 +3592,12 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,2))) -SUBPARTITION BY KEY (f_int2) + PARTITION BY LIST (abs(`f_int1` % 2)) +SUBPARTITION BY KEY (`f_int2`) SUBPARTITIONS 3 -(PARTITION part1 VALUES IN (0) ENGINE = InnoDB, - PARTITION part2 VALUES IN (1) ENGINE = InnoDB, - PARTITION part3 VALUES IN (NULL) ENGINE = InnoDB) +(PARTITION `part1` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (NULL) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -4089,7 +4089,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 # check prerequisites-1 success: 1 @@ -4581,7 +4581,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 # check prerequisites-1 success: 1 @@ -5081,15 +5081,15 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = InnoDB, - PARTITION part_2 VALUES IN (-2) ENGINE = InnoDB, - PARTITION part_1 VALUES IN (-1) ENGINE = InnoDB, - PARTITION part_N VALUES IN (NULL) ENGINE = InnoDB, - PARTITION part0 VALUES IN (0) ENGINE = InnoDB, - PARTITION part1 VALUES IN (1) ENGINE = InnoDB, - PARTITION part2 VALUES IN (2) ENGINE = InnoDB, - PARTITION part3 VALUES IN (3) ENGINE = InnoDB) + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = InnoDB, + PARTITION `part_2` VALUES IN (-2) ENGINE = InnoDB, + PARTITION `part_1` VALUES IN (-1) ENGINE = InnoDB, + PARTITION `part_N` VALUES IN (NULL) ENGINE = InnoDB, + PARTITION `part0` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part1` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (2) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (3) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -5586,13 +5586,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (15) ENGINE = InnoDB, - PARTITION parte VALUES LESS THAN (20) ENGINE = InnoDB, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = InnoDB) + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = InnoDB, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = InnoDB, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -6085,13 +6085,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY HASH (f_int2) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY HASH (`f_int2`) SUBPARTITIONS 2 -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = InnoDB) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -6588,20 +6588,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = InnoDB, - SUBPARTITION subpart12 ENGINE = InnoDB), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = InnoDB, - SUBPARTITION subpart22 ENGINE = InnoDB), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = InnoDB, - SUBPARTITION subpart32 ENGINE = InnoDB), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = InnoDB, - SUBPARTITION subpart42 ENGINE = InnoDB)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = InnoDB, + SUBPARTITION `subpart12` ENGINE = InnoDB), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = InnoDB, + SUBPARTITION `subpart22` ENGINE = InnoDB), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = InnoDB, + SUBPARTITION `subpart32` ENGINE = InnoDB), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = InnoDB, + SUBPARTITION `subpart42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -7098,20 +7098,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int2 + 1) -(PARTITION part1 VALUES IN (0) - (SUBPARTITION sp11 ENGINE = InnoDB, - SUBPARTITION sp12 ENGINE = InnoDB), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = InnoDB, - SUBPARTITION sp22 ENGINE = InnoDB), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = InnoDB, - SUBPARTITION sp32 ENGINE = InnoDB), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = InnoDB, - SUBPARTITION sp42 ENGINE = InnoDB)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = InnoDB, + SUBPARTITION `sp12` ENGINE = InnoDB), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = InnoDB, + SUBPARTITION `sp22` ENGINE = InnoDB), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = InnoDB, + SUBPARTITION `sp32` ENGINE = InnoDB), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = InnoDB, + SUBPARTITION `sp42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -7606,12 +7606,12 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,2))) -SUBPARTITION BY KEY (f_int2) + PARTITION BY LIST (abs(`f_int1` % 2)) +SUBPARTITION BY KEY (`f_int2`) SUBPARTITIONS 3 -(PARTITION part1 VALUES IN (0) ENGINE = InnoDB, - PARTITION part2 VALUES IN (1) ENGINE = InnoDB, - PARTITION part3 VALUES IN (NULL) ENGINE = InnoDB) +(PARTITION `part1` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (NULL) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -8104,7 +8104,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 # check prerequisites-1 success: 1 @@ -8612,7 +8612,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 # check prerequisites-1 success: 1 @@ -9128,15 +9128,15 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = InnoDB, - PARTITION part_2 VALUES IN (-2) ENGINE = InnoDB, - PARTITION part_1 VALUES IN (-1) ENGINE = InnoDB, - PARTITION part_N VALUES IN (NULL) ENGINE = InnoDB, - PARTITION part0 VALUES IN (0) ENGINE = InnoDB, - PARTITION part1 VALUES IN (1) ENGINE = InnoDB, - PARTITION part2 VALUES IN (2) ENGINE = InnoDB, - PARTITION part3 VALUES IN (3) ENGINE = InnoDB) + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = InnoDB, + PARTITION `part_2` VALUES IN (-2) ENGINE = InnoDB, + PARTITION `part_1` VALUES IN (-1) ENGINE = InnoDB, + PARTITION `part_N` VALUES IN (NULL) ENGINE = InnoDB, + PARTITION `part0` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part1` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (2) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (3) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -9649,13 +9649,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (15) ENGINE = InnoDB, - PARTITION parte VALUES LESS THAN (20) ENGINE = InnoDB, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = InnoDB) + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = InnoDB, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = InnoDB, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -10164,13 +10164,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY HASH (f_int2) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY HASH (`f_int2`) SUBPARTITIONS 2 -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = InnoDB) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -10683,20 +10683,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = InnoDB, - SUBPARTITION subpart12 ENGINE = InnoDB), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = InnoDB, - SUBPARTITION subpart22 ENGINE = InnoDB), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = InnoDB, - SUBPARTITION subpart32 ENGINE = InnoDB), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = InnoDB, - SUBPARTITION subpart42 ENGINE = InnoDB)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = InnoDB, + SUBPARTITION `subpart12` ENGINE = InnoDB), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = InnoDB, + SUBPARTITION `subpart22` ENGINE = InnoDB), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = InnoDB, + SUBPARTITION `subpart32` ENGINE = InnoDB), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = InnoDB, + SUBPARTITION `subpart42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -11209,20 +11209,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int2 + 1) -(PARTITION part1 VALUES IN (0) - (SUBPARTITION sp11 ENGINE = InnoDB, - SUBPARTITION sp12 ENGINE = InnoDB), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = InnoDB, - SUBPARTITION sp22 ENGINE = InnoDB), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = InnoDB, - SUBPARTITION sp32 ENGINE = InnoDB), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = InnoDB, - SUBPARTITION sp42 ENGINE = InnoDB)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = InnoDB, + SUBPARTITION `sp12` ENGINE = InnoDB), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = InnoDB, + SUBPARTITION `sp22` ENGINE = InnoDB), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = InnoDB, + SUBPARTITION `sp32` ENGINE = InnoDB), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = InnoDB, + SUBPARTITION `sp42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -11733,12 +11733,12 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,2))) -SUBPARTITION BY KEY (f_int2) + PARTITION BY LIST (abs(`f_int1` % 2)) +SUBPARTITION BY KEY (`f_int2`) SUBPARTITIONS 3 -(PARTITION part1 VALUES IN (0) ENGINE = InnoDB, - PARTITION part2 VALUES IN (1) ENGINE = InnoDB, - PARTITION part3 VALUES IN (NULL) ENGINE = InnoDB) +(PARTITION `part1` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (NULL) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -12246,7 +12246,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 # check prerequisites-1 success: 1 @@ -12754,7 +12754,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 # check prerequisites-1 success: 1 @@ -13270,15 +13270,15 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = InnoDB, - PARTITION part_2 VALUES IN (-2) ENGINE = InnoDB, - PARTITION part_1 VALUES IN (-1) ENGINE = InnoDB, - PARTITION part_N VALUES IN (NULL) ENGINE = InnoDB, - PARTITION part0 VALUES IN (0) ENGINE = InnoDB, - PARTITION part1 VALUES IN (1) ENGINE = InnoDB, - PARTITION part2 VALUES IN (2) ENGINE = InnoDB, - PARTITION part3 VALUES IN (3) ENGINE = InnoDB) + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = InnoDB, + PARTITION `part_2` VALUES IN (-2) ENGINE = InnoDB, + PARTITION `part_1` VALUES IN (-1) ENGINE = InnoDB, + PARTITION `part_N` VALUES IN (NULL) ENGINE = InnoDB, + PARTITION `part0` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part1` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (2) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (3) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -13791,13 +13791,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (15) ENGINE = InnoDB, - PARTITION parte VALUES LESS THAN (20) ENGINE = InnoDB, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = InnoDB) + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = InnoDB, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = InnoDB, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -14306,13 +14306,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY HASH (f_int2) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY HASH (`f_int2`) SUBPARTITIONS 2 -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = InnoDB) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -14825,20 +14825,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = InnoDB, - SUBPARTITION subpart12 ENGINE = InnoDB), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = InnoDB, - SUBPARTITION subpart22 ENGINE = InnoDB), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = InnoDB, - SUBPARTITION subpart32 ENGINE = InnoDB), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = InnoDB, - SUBPARTITION subpart42 ENGINE = InnoDB)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = InnoDB, + SUBPARTITION `subpart12` ENGINE = InnoDB), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = InnoDB, + SUBPARTITION `subpart22` ENGINE = InnoDB), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = InnoDB, + SUBPARTITION `subpart32` ENGINE = InnoDB), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = InnoDB, + SUBPARTITION `subpart42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -15351,20 +15351,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int2 + 1) -(PARTITION part1 VALUES IN (0) - (SUBPARTITION sp11 ENGINE = InnoDB, - SUBPARTITION sp12 ENGINE = InnoDB), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = InnoDB, - SUBPARTITION sp22 ENGINE = InnoDB), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = InnoDB, - SUBPARTITION sp32 ENGINE = InnoDB), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = InnoDB, - SUBPARTITION sp42 ENGINE = InnoDB)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = InnoDB, + SUBPARTITION `sp12` ENGINE = InnoDB), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = InnoDB, + SUBPARTITION `sp22` ENGINE = InnoDB), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = InnoDB, + SUBPARTITION `sp32` ENGINE = InnoDB), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = InnoDB, + SUBPARTITION `sp42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -15875,12 +15875,12 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,2))) -SUBPARTITION BY KEY (f_int2) + PARTITION BY LIST (abs(`f_int1` % 2)) +SUBPARTITION BY KEY (`f_int2`) SUBPARTITIONS 3 -(PARTITION part1 VALUES IN (0) ENGINE = InnoDB, - PARTITION part2 VALUES IN (1) ENGINE = InnoDB, - PARTITION part3 VALUES IN (NULL) ENGINE = InnoDB) +(PARTITION `part1` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (NULL) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -16390,7 +16390,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 # check prerequisites-1 success: 1 @@ -16883,7 +16883,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 # check prerequisites-1 success: 1 @@ -17384,15 +17384,15 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = InnoDB, - PARTITION part_2 VALUES IN (-2) ENGINE = InnoDB, - PARTITION part_1 VALUES IN (-1) ENGINE = InnoDB, - PARTITION part_N VALUES IN (NULL) ENGINE = InnoDB, - PARTITION part0 VALUES IN (0) ENGINE = InnoDB, - PARTITION part1 VALUES IN (1) ENGINE = InnoDB, - PARTITION part2 VALUES IN (2) ENGINE = InnoDB, - PARTITION part3 VALUES IN (3) ENGINE = InnoDB) + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = InnoDB, + PARTITION `part_2` VALUES IN (-2) ENGINE = InnoDB, + PARTITION `part_1` VALUES IN (-1) ENGINE = InnoDB, + PARTITION `part_N` VALUES IN (NULL) ENGINE = InnoDB, + PARTITION `part0` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part1` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (2) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (3) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -17890,13 +17890,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (15) ENGINE = InnoDB, - PARTITION parte VALUES LESS THAN (20) ENGINE = InnoDB, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = InnoDB) + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = InnoDB, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = InnoDB, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -18390,13 +18390,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY HASH (f_int2) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY HASH (`f_int2`) SUBPARTITIONS 2 -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = InnoDB) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -18894,20 +18894,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = InnoDB, - SUBPARTITION subpart12 ENGINE = InnoDB), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = InnoDB, - SUBPARTITION subpart22 ENGINE = InnoDB), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = InnoDB, - SUBPARTITION subpart32 ENGINE = InnoDB), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = InnoDB, - SUBPARTITION subpart42 ENGINE = InnoDB)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = InnoDB, + SUBPARTITION `subpart12` ENGINE = InnoDB), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = InnoDB, + SUBPARTITION `subpart22` ENGINE = InnoDB), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = InnoDB, + SUBPARTITION `subpart32` ENGINE = InnoDB), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = InnoDB, + SUBPARTITION `subpart42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -19405,20 +19405,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int2 + 1) -(PARTITION part1 VALUES IN (0) - (SUBPARTITION sp11 ENGINE = InnoDB, - SUBPARTITION sp12 ENGINE = InnoDB), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = InnoDB, - SUBPARTITION sp22 ENGINE = InnoDB), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = InnoDB, - SUBPARTITION sp32 ENGINE = InnoDB), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = InnoDB, - SUBPARTITION sp42 ENGINE = InnoDB)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = InnoDB, + SUBPARTITION `sp12` ENGINE = InnoDB), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = InnoDB, + SUBPARTITION `sp22` ENGINE = InnoDB), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = InnoDB, + SUBPARTITION `sp32` ENGINE = InnoDB), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = InnoDB, + SUBPARTITION `sp42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -19914,12 +19914,12 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,2))) -SUBPARTITION BY KEY (f_int2) + PARTITION BY LIST (abs(`f_int1` % 2)) +SUBPARTITION BY KEY (`f_int2`) SUBPARTITIONS 3 -(PARTITION part1 VALUES IN (0) ENGINE = InnoDB, - PARTITION part2 VALUES IN (1) ENGINE = InnoDB, - PARTITION part3 VALUES IN (NULL) ENGINE = InnoDB) +(PARTITION `part1` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (NULL) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -20412,7 +20412,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 # check prerequisites-1 success: 1 @@ -20905,7 +20905,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 # check prerequisites-1 success: 1 @@ -21406,15 +21406,15 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = InnoDB, - PARTITION part_2 VALUES IN (-2) ENGINE = InnoDB, - PARTITION part_1 VALUES IN (-1) ENGINE = InnoDB, - PARTITION part_N VALUES IN (NULL) ENGINE = InnoDB, - PARTITION part0 VALUES IN (0) ENGINE = InnoDB, - PARTITION part1 VALUES IN (1) ENGINE = InnoDB, - PARTITION part2 VALUES IN (2) ENGINE = InnoDB, - PARTITION part3 VALUES IN (3) ENGINE = InnoDB) + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = InnoDB, + PARTITION `part_2` VALUES IN (-2) ENGINE = InnoDB, + PARTITION `part_1` VALUES IN (-1) ENGINE = InnoDB, + PARTITION `part_N` VALUES IN (NULL) ENGINE = InnoDB, + PARTITION `part0` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part1` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (2) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (3) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -21912,13 +21912,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (15) ENGINE = InnoDB, - PARTITION parte VALUES LESS THAN (20) ENGINE = InnoDB, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = InnoDB) + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = InnoDB, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = InnoDB, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -22412,13 +22412,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY HASH (f_int2) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY HASH (`f_int2`) SUBPARTITIONS 2 -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = InnoDB) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -22916,20 +22916,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = InnoDB, - SUBPARTITION subpart12 ENGINE = InnoDB), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = InnoDB, - SUBPARTITION subpart22 ENGINE = InnoDB), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = InnoDB, - SUBPARTITION subpart32 ENGINE = InnoDB), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = InnoDB, - SUBPARTITION subpart42 ENGINE = InnoDB)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = InnoDB, + SUBPARTITION `subpart12` ENGINE = InnoDB), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = InnoDB, + SUBPARTITION `subpart22` ENGINE = InnoDB), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = InnoDB, + SUBPARTITION `subpart32` ENGINE = InnoDB), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = InnoDB, + SUBPARTITION `subpart42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -23427,20 +23427,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int2 + 1) -(PARTITION part1 VALUES IN (0) - (SUBPARTITION sp11 ENGINE = InnoDB, - SUBPARTITION sp12 ENGINE = InnoDB), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = InnoDB, - SUBPARTITION sp22 ENGINE = InnoDB), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = InnoDB, - SUBPARTITION sp32 ENGINE = InnoDB), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = InnoDB, - SUBPARTITION sp42 ENGINE = InnoDB)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = InnoDB, + SUBPARTITION `sp12` ENGINE = InnoDB), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = InnoDB, + SUBPARTITION `sp22` ENGINE = InnoDB), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = InnoDB, + SUBPARTITION `sp32` ENGINE = InnoDB), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = InnoDB, + SUBPARTITION `sp42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -23936,12 +23936,12 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,2))) -SUBPARTITION BY KEY (f_int2) + PARTITION BY LIST (abs(`f_int1` % 2)) +SUBPARTITION BY KEY (`f_int2`) SUBPARTITIONS 3 -(PARTITION part1 VALUES IN (0) ENGINE = InnoDB, - PARTITION part2 VALUES IN (1) ENGINE = InnoDB, - PARTITION part3 VALUES IN (NULL) ENGINE = InnoDB) +(PARTITION `part1` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (NULL) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -24434,7 +24434,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 # check prerequisites-1 success: 1 @@ -24927,7 +24927,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 # check prerequisites-1 success: 1 @@ -25428,15 +25428,15 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = InnoDB, - PARTITION part_2 VALUES IN (-2) ENGINE = InnoDB, - PARTITION part_1 VALUES IN (-1) ENGINE = InnoDB, - PARTITION part_N VALUES IN (NULL) ENGINE = InnoDB, - PARTITION part0 VALUES IN (0) ENGINE = InnoDB, - PARTITION part1 VALUES IN (1) ENGINE = InnoDB, - PARTITION part2 VALUES IN (2) ENGINE = InnoDB, - PARTITION part3 VALUES IN (3) ENGINE = InnoDB) + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = InnoDB, + PARTITION `part_2` VALUES IN (-2) ENGINE = InnoDB, + PARTITION `part_1` VALUES IN (-1) ENGINE = InnoDB, + PARTITION `part_N` VALUES IN (NULL) ENGINE = InnoDB, + PARTITION `part0` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part1` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (2) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (3) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -25934,13 +25934,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (15) ENGINE = InnoDB, - PARTITION parte VALUES LESS THAN (20) ENGINE = InnoDB, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = InnoDB) + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = InnoDB, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = InnoDB, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -26434,13 +26434,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY HASH (f_int2) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY HASH (`f_int2`) SUBPARTITIONS 2 -(PARTITION parta VALUES LESS THAN (0) ENGINE = InnoDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = InnoDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = InnoDB, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = InnoDB) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = InnoDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = InnoDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = InnoDB, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -26938,20 +26938,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = InnoDB, - SUBPARTITION subpart12 ENGINE = InnoDB), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = InnoDB, - SUBPARTITION subpart22 ENGINE = InnoDB), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = InnoDB, - SUBPARTITION subpart32 ENGINE = InnoDB), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = InnoDB, - SUBPARTITION subpart42 ENGINE = InnoDB)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = InnoDB, + SUBPARTITION `subpart12` ENGINE = InnoDB), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = InnoDB, + SUBPARTITION `subpart22` ENGINE = InnoDB), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = InnoDB, + SUBPARTITION `subpart32` ENGINE = InnoDB), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = InnoDB, + SUBPARTITION `subpart42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -27449,20 +27449,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int2 + 1) -(PARTITION part1 VALUES IN (0) - (SUBPARTITION sp11 ENGINE = InnoDB, - SUBPARTITION sp12 ENGINE = InnoDB), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = InnoDB, - SUBPARTITION sp22 ENGINE = InnoDB), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = InnoDB, - SUBPARTITION sp32 ENGINE = InnoDB), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = InnoDB, - SUBPARTITION sp42 ENGINE = InnoDB)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = InnoDB, + SUBPARTITION `sp12` ENGINE = InnoDB), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = InnoDB, + SUBPARTITION `sp22` ENGINE = InnoDB), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = InnoDB, + SUBPARTITION `sp32` ENGINE = InnoDB), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = InnoDB, + SUBPARTITION `sp42` ENGINE = InnoDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -27958,12 +27958,12 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,2))) -SUBPARTITION BY KEY (f_int2) + PARTITION BY LIST (abs(`f_int1` % 2)) +SUBPARTITION BY KEY (`f_int2`) SUBPARTITIONS 3 -(PARTITION part1 VALUES IN (0) ENGINE = InnoDB, - PARTITION part2 VALUES IN (1) ENGINE = InnoDB, - PARTITION part3 VALUES IN (NULL) ENGINE = InnoDB) +(PARTITION `part1` VALUES IN (0) ENGINE = InnoDB, + PARTITION `part2` VALUES IN (1) ENGINE = InnoDB, + PARTITION `part3` VALUES IN (NULL) ENGINE = InnoDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 |