diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_parts/r/partition_alter2_2_2_tokudb.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb_parts/r/partition_alter2_2_2_tokudb.result | 590 |
1 files changed, 295 insertions, 295 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_parts/r/partition_alter2_2_2_tokudb.result b/storage/tokudb/mysql-test/tokudb_parts/r/partition_alter2_2_2_tokudb.result index 993025c9fb2..36be0936c09 100644 --- a/storage/tokudb/mysql-test/tokudb_parts/r/partition_alter2_2_2_tokudb.result +++ b/storage/tokudb/mysql-test/tokudb_parts/r/partition_alter2_2_2_tokudb.result @@ -69,8 +69,8 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY HASH (f_int1 + f_int2) -PARTITIONS 2 */ + PARTITION BY HASH (`f_int1` + `f_int2`) +PARTITIONS 2 # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -528,8 +528,8 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY KEY (f_int1,f_int2) -PARTITIONS 5 */ + PARTITION BY KEY (`f_int1`,`f_int2`) +PARTITIONS 5 # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -995,15 +995,15 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = TokuDB, - PARTITION part_2 VALUES IN (-2) ENGINE = TokuDB, - PARTITION part_1 VALUES IN (-1) ENGINE = TokuDB, - PARTITION part_N VALUES IN (NULL) ENGINE = TokuDB, - PARTITION part0 VALUES IN (0) ENGINE = TokuDB, - PARTITION part1 VALUES IN (1) ENGINE = TokuDB, - PARTITION part2 VALUES IN (2) ENGINE = TokuDB, - PARTITION part3 VALUES IN (3) ENGINE = TokuDB) */ + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB, + PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB, + PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB, + PARTITION `part_N` VALUES IN (NULL) ENGINE = TokuDB, + PARTITION `part0` VALUES IN (0) ENGINE = TokuDB, + PARTITION `part1` VALUES IN (1) ENGINE = TokuDB, + PARTITION `part2` VALUES IN (2) ENGINE = TokuDB, + PARTITION `part3` VALUES IN (3) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -1467,13 +1467,13 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = TokuDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = TokuDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = TokuDB, - PARTITION partd VALUES LESS THAN (15) ENGINE = TokuDB, - PARTITION parte VALUES LESS THAN (20) ENGINE = TokuDB, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = TokuDB) */ + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = TokuDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = TokuDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = TokuDB, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = TokuDB, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = TokuDB, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -1935,13 +1935,13 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 = TokuDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = TokuDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = TokuDB, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = TokuDB) */ +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = TokuDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = TokuDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = TokuDB, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -2407,20 +2407,20 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = TokuDB, - SUBPARTITION subpart12 ENGINE = TokuDB), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = TokuDB, - SUBPARTITION subpart22 ENGINE = TokuDB), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = TokuDB, - SUBPARTITION subpart32 ENGINE = TokuDB), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = TokuDB, - SUBPARTITION subpart42 ENGINE = TokuDB)) */ + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = TokuDB, + SUBPARTITION `subpart12` ENGINE = TokuDB), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = TokuDB, + SUBPARTITION `subpart22` ENGINE = TokuDB), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = TokuDB, + SUBPARTITION `subpart32` ENGINE = TokuDB), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = TokuDB, + SUBPARTITION `subpart42` ENGINE = TokuDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -2886,20 +2886,20 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int2 + 1) -(PARTITION part1 VALUES IN (0) - (SUBPARTITION sp11 ENGINE = TokuDB, - SUBPARTITION sp12 ENGINE = TokuDB), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = TokuDB, - SUBPARTITION sp22 ENGINE = TokuDB), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = TokuDB, - SUBPARTITION sp32 ENGINE = TokuDB), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = TokuDB, - SUBPARTITION sp42 ENGINE = TokuDB)) */ + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = TokuDB, + SUBPARTITION `sp12` ENGINE = TokuDB), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = TokuDB, + SUBPARTITION `sp22` ENGINE = TokuDB), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = TokuDB, + SUBPARTITION `sp32` ENGINE = TokuDB), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = TokuDB, + SUBPARTITION `sp42` ENGINE = TokuDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -3361,12 +3361,12 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 = TokuDB, - PARTITION part2 VALUES IN (1) ENGINE = TokuDB, - PARTITION part3 VALUES IN (NULL) ENGINE = TokuDB) */ +(PARTITION `part1` VALUES IN (0) ENGINE = TokuDB, + PARTITION `part2` VALUES IN (1) ENGINE = TokuDB, + PARTITION `part3` VALUES IN (NULL) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -3827,8 +3827,8 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY HASH (f_int1 + f_int2) -PARTITIONS 2 */ + PARTITION BY HASH (`f_int1` + `f_int2`) +PARTITIONS 2 # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -4325,8 +4325,8 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY KEY (f_int1,f_int2) -PARTITIONS 5 */ + PARTITION BY KEY (`f_int1`,`f_int2`) +PARTITIONS 5 # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -4831,15 +4831,15 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = TokuDB, - PARTITION part_2 VALUES IN (-2) ENGINE = TokuDB, - PARTITION part_1 VALUES IN (-1) ENGINE = TokuDB, - PARTITION part_N VALUES IN (NULL) ENGINE = TokuDB, - PARTITION part0 VALUES IN (0) ENGINE = TokuDB, - PARTITION part1 VALUES IN (1) ENGINE = TokuDB, - PARTITION part2 VALUES IN (2) ENGINE = TokuDB, - PARTITION part3 VALUES IN (3) ENGINE = TokuDB) */ + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB, + PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB, + PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB, + PARTITION `part_N` VALUES IN (NULL) ENGINE = TokuDB, + PARTITION `part0` VALUES IN (0) ENGINE = TokuDB, + PARTITION `part1` VALUES IN (1) ENGINE = TokuDB, + PARTITION `part2` VALUES IN (2) ENGINE = TokuDB, + PARTITION `part3` VALUES IN (3) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -5342,13 +5342,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = TokuDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = TokuDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = TokuDB, - PARTITION partd VALUES LESS THAN (15) ENGINE = TokuDB, - PARTITION parte VALUES LESS THAN (20) ENGINE = TokuDB, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = TokuDB) */ + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = TokuDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = TokuDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = TokuDB, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = TokuDB, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = TokuDB, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -5849,13 +5849,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 = TokuDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = TokuDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = TokuDB, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = TokuDB) */ +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = TokuDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = TokuDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = TokuDB, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -6360,20 +6360,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = TokuDB, - SUBPARTITION subpart12 ENGINE = TokuDB), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = TokuDB, - SUBPARTITION subpart22 ENGINE = TokuDB), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = TokuDB, - SUBPARTITION subpart32 ENGINE = TokuDB), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = TokuDB, - SUBPARTITION subpart42 ENGINE = TokuDB)) */ + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = TokuDB, + SUBPARTITION `subpart12` ENGINE = TokuDB), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = TokuDB, + SUBPARTITION `subpart22` ENGINE = TokuDB), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = TokuDB, + SUBPARTITION `subpart32` ENGINE = TokuDB), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = TokuDB, + SUBPARTITION `subpart42` ENGINE = TokuDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -6878,20 +6878,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int2 + 1) -(PARTITION part1 VALUES IN (0) - (SUBPARTITION sp11 ENGINE = TokuDB, - SUBPARTITION sp12 ENGINE = TokuDB), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = TokuDB, - SUBPARTITION sp22 ENGINE = TokuDB), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = TokuDB, - SUBPARTITION sp32 ENGINE = TokuDB), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = TokuDB, - SUBPARTITION sp42 ENGINE = TokuDB)) */ + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = TokuDB, + SUBPARTITION `sp12` ENGINE = TokuDB), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = TokuDB, + SUBPARTITION `sp22` ENGINE = TokuDB), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = TokuDB, + SUBPARTITION `sp32` ENGINE = TokuDB), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = TokuDB, + SUBPARTITION `sp42` ENGINE = TokuDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -7392,12 +7392,12 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 = TokuDB, - PARTITION part2 VALUES IN (1) ENGINE = TokuDB, - PARTITION part3 VALUES IN (NULL) ENGINE = TokuDB) */ +(PARTITION `part1` VALUES IN (0) ENGINE = TokuDB, + PARTITION `part2` VALUES IN (1) ENGINE = TokuDB, + PARTITION `part3` VALUES IN (NULL) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -7895,8 +7895,8 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY HASH (f_int1 + f_int2) -PARTITIONS 2 */ + PARTITION BY HASH (`f_int1` + `f_int2`) +PARTITIONS 2 # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -8393,8 +8393,8 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY KEY (f_int1,f_int2) -PARTITIONS 5 */ + PARTITION BY KEY (`f_int1`,`f_int2`) +PARTITIONS 5 # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -8899,15 +8899,15 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = TokuDB, - PARTITION part_2 VALUES IN (-2) ENGINE = TokuDB, - PARTITION part_1 VALUES IN (-1) ENGINE = TokuDB, - PARTITION part_N VALUES IN (NULL) ENGINE = TokuDB, - PARTITION part0 VALUES IN (0) ENGINE = TokuDB, - PARTITION part1 VALUES IN (1) ENGINE = TokuDB, - PARTITION part2 VALUES IN (2) ENGINE = TokuDB, - PARTITION part3 VALUES IN (3) ENGINE = TokuDB) */ + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB, + PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB, + PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB, + PARTITION `part_N` VALUES IN (NULL) ENGINE = TokuDB, + PARTITION `part0` VALUES IN (0) ENGINE = TokuDB, + PARTITION `part1` VALUES IN (1) ENGINE = TokuDB, + PARTITION `part2` VALUES IN (2) ENGINE = TokuDB, + PARTITION `part3` VALUES IN (3) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -9410,13 +9410,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = TokuDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = TokuDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = TokuDB, - PARTITION partd VALUES LESS THAN (15) ENGINE = TokuDB, - PARTITION parte VALUES LESS THAN (20) ENGINE = TokuDB, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = TokuDB) */ + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = TokuDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = TokuDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = TokuDB, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = TokuDB, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = TokuDB, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -9917,13 +9917,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 = TokuDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = TokuDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = TokuDB, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = TokuDB) */ +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = TokuDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = TokuDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = TokuDB, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -10428,20 +10428,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = TokuDB, - SUBPARTITION subpart12 ENGINE = TokuDB), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = TokuDB, - SUBPARTITION subpart22 ENGINE = TokuDB), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = TokuDB, - SUBPARTITION subpart32 ENGINE = TokuDB), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = TokuDB, - SUBPARTITION subpart42 ENGINE = TokuDB)) */ + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = TokuDB, + SUBPARTITION `subpart12` ENGINE = TokuDB), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = TokuDB, + SUBPARTITION `subpart22` ENGINE = TokuDB), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = TokuDB, + SUBPARTITION `subpart32` ENGINE = TokuDB), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = TokuDB, + SUBPARTITION `subpart42` ENGINE = TokuDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -10946,20 +10946,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int2 + 1) -(PARTITION part1 VALUES IN (0) - (SUBPARTITION sp11 ENGINE = TokuDB, - SUBPARTITION sp12 ENGINE = TokuDB), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = TokuDB, - SUBPARTITION sp22 ENGINE = TokuDB), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = TokuDB, - SUBPARTITION sp32 ENGINE = TokuDB), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = TokuDB, - SUBPARTITION sp42 ENGINE = TokuDB)) */ + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = TokuDB, + SUBPARTITION `sp12` ENGINE = TokuDB), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = TokuDB, + SUBPARTITION `sp22` ENGINE = TokuDB), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = TokuDB, + SUBPARTITION `sp32` ENGINE = TokuDB), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = TokuDB, + SUBPARTITION `sp42` ENGINE = TokuDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -11460,12 +11460,12 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 = TokuDB, - PARTITION part2 VALUES IN (1) ENGINE = TokuDB, - PARTITION part3 VALUES IN (NULL) ENGINE = TokuDB) */ +(PARTITION `part1` VALUES IN (0) ENGINE = TokuDB, + PARTITION `part2` VALUES IN (1) ENGINE = TokuDB, + PARTITION `part3` VALUES IN (NULL) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -11964,8 +11964,8 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY HASH (f_int1 + f_int2) -PARTITIONS 2 */ + PARTITION BY HASH (`f_int1` + `f_int2`) +PARTITIONS 2 # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -12475,8 +12475,8 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY KEY (f_int1,f_int2) -PARTITIONS 5 */ + PARTITION BY KEY (`f_int1`,`f_int2`) +PARTITIONS 5 # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -12994,15 +12994,15 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = TokuDB, - PARTITION part_2 VALUES IN (-2) ENGINE = TokuDB, - PARTITION part_1 VALUES IN (-1) ENGINE = TokuDB, - PARTITION part_N VALUES IN (NULL) ENGINE = TokuDB, - PARTITION part0 VALUES IN (0) ENGINE = TokuDB, - PARTITION part1 VALUES IN (1) ENGINE = TokuDB, - PARTITION part2 VALUES IN (2) ENGINE = TokuDB, - PARTITION part3 VALUES IN (3) ENGINE = TokuDB) */ + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB, + PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB, + PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB, + PARTITION `part_N` VALUES IN (NULL) ENGINE = TokuDB, + PARTITION `part0` VALUES IN (0) ENGINE = TokuDB, + PARTITION `part1` VALUES IN (1) ENGINE = TokuDB, + PARTITION `part2` VALUES IN (2) ENGINE = TokuDB, + PARTITION `part3` VALUES IN (3) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -13518,13 +13518,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = TokuDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = TokuDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = TokuDB, - PARTITION partd VALUES LESS THAN (15) ENGINE = TokuDB, - PARTITION parte VALUES LESS THAN (20) ENGINE = TokuDB, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = TokuDB) */ + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = TokuDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = TokuDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = TokuDB, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = TokuDB, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = TokuDB, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -14038,13 +14038,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 = TokuDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = TokuDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = TokuDB, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = TokuDB) */ +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = TokuDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = TokuDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = TokuDB, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -14562,20 +14562,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = TokuDB, - SUBPARTITION subpart12 ENGINE = TokuDB), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = TokuDB, - SUBPARTITION subpart22 ENGINE = TokuDB), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = TokuDB, - SUBPARTITION subpart32 ENGINE = TokuDB), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = TokuDB, - SUBPARTITION subpart42 ENGINE = TokuDB)) */ + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = TokuDB, + SUBPARTITION `subpart12` ENGINE = TokuDB), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = TokuDB, + SUBPARTITION `subpart22` ENGINE = TokuDB), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = TokuDB, + SUBPARTITION `subpart32` ENGINE = TokuDB), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = TokuDB, + SUBPARTITION `subpart42` ENGINE = TokuDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -15093,20 +15093,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int2 + 1) -(PARTITION part1 VALUES IN (0) - (SUBPARTITION sp11 ENGINE = TokuDB, - SUBPARTITION sp12 ENGINE = TokuDB), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = TokuDB, - SUBPARTITION sp22 ENGINE = TokuDB), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = TokuDB, - SUBPARTITION sp32 ENGINE = TokuDB), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = TokuDB, - SUBPARTITION sp42 ENGINE = TokuDB)) */ + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = TokuDB, + SUBPARTITION `sp12` ENGINE = TokuDB), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = TokuDB, + SUBPARTITION `sp22` ENGINE = TokuDB), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = TokuDB, + SUBPARTITION `sp32` ENGINE = TokuDB), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = TokuDB, + SUBPARTITION `sp42` ENGINE = TokuDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -15620,12 +15620,12 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 = TokuDB, - PARTITION part2 VALUES IN (1) ENGINE = TokuDB, - PARTITION part3 VALUES IN (NULL) ENGINE = TokuDB) */ +(PARTITION `part1` VALUES IN (0) ENGINE = TokuDB, + PARTITION `part2` VALUES IN (1) ENGINE = TokuDB, + PARTITION `part3` VALUES IN (NULL) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -16136,8 +16136,8 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY HASH (f_int1 + f_int2) -PARTITIONS 2 */ + PARTITION BY HASH (`f_int1` + `f_int2`) +PARTITIONS 2 # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -16647,8 +16647,8 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY KEY (f_int1,f_int2) -PARTITIONS 5 */ + PARTITION BY KEY (`f_int1`,`f_int2`) +PARTITIONS 5 # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -17166,15 +17166,15 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = TokuDB, - PARTITION part_2 VALUES IN (-2) ENGINE = TokuDB, - PARTITION part_1 VALUES IN (-1) ENGINE = TokuDB, - PARTITION part_N VALUES IN (NULL) ENGINE = TokuDB, - PARTITION part0 VALUES IN (0) ENGINE = TokuDB, - PARTITION part1 VALUES IN (1) ENGINE = TokuDB, - PARTITION part2 VALUES IN (2) ENGINE = TokuDB, - PARTITION part3 VALUES IN (3) ENGINE = TokuDB) */ + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB, + PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB, + PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB, + PARTITION `part_N` VALUES IN (NULL) ENGINE = TokuDB, + PARTITION `part0` VALUES IN (0) ENGINE = TokuDB, + PARTITION `part1` VALUES IN (1) ENGINE = TokuDB, + PARTITION `part2` VALUES IN (2) ENGINE = TokuDB, + PARTITION `part3` VALUES IN (3) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -17690,13 +17690,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = TokuDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = TokuDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = TokuDB, - PARTITION partd VALUES LESS THAN (15) ENGINE = TokuDB, - PARTITION parte VALUES LESS THAN (20) ENGINE = TokuDB, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = TokuDB) */ + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = TokuDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = TokuDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = TokuDB, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = TokuDB, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = TokuDB, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -18210,13 +18210,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 = TokuDB, - PARTITION partb VALUES LESS THAN (5) ENGINE = TokuDB, - PARTITION partc VALUES LESS THAN (10) ENGINE = TokuDB, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = TokuDB) */ +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = TokuDB, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = TokuDB, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = TokuDB, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -18734,20 +18734,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = TokuDB, - SUBPARTITION subpart12 ENGINE = TokuDB), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = TokuDB, - SUBPARTITION subpart22 ENGINE = TokuDB), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = TokuDB, - SUBPARTITION subpart32 ENGINE = TokuDB), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = TokuDB, - SUBPARTITION subpart42 ENGINE = TokuDB)) */ + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = TokuDB, + SUBPARTITION `subpart12` ENGINE = TokuDB), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = TokuDB, + SUBPARTITION `subpart22` ENGINE = TokuDB), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = TokuDB, + SUBPARTITION `subpart32` ENGINE = TokuDB), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = TokuDB, + SUBPARTITION `subpart42` ENGINE = TokuDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -19265,20 +19265,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int2 + 1) -(PARTITION part1 VALUES IN (0) - (SUBPARTITION sp11 ENGINE = TokuDB, - SUBPARTITION sp12 ENGINE = TokuDB), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = TokuDB, - SUBPARTITION sp22 ENGINE = TokuDB), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = TokuDB, - SUBPARTITION sp32 ENGINE = TokuDB), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = TokuDB, - SUBPARTITION sp42 ENGINE = TokuDB)) */ + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = TokuDB, + SUBPARTITION `sp12` ENGINE = TokuDB), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = TokuDB, + SUBPARTITION `sp22` ENGINE = TokuDB), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = TokuDB, + SUBPARTITION `sp32` ENGINE = TokuDB), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = TokuDB, + SUBPARTITION `sp42` ENGINE = TokuDB)) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 @@ -19792,12 +19792,12 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 = TokuDB, - PARTITION part2 VALUES IN (1) ENGINE = TokuDB, - PARTITION part3 VALUES IN (NULL) ENGINE = TokuDB) */ +(PARTITION `part1` VALUES IN (0) ENGINE = TokuDB, + PARTITION `part2` VALUES IN (1) ENGINE = TokuDB, + PARTITION `part3` VALUES IN (NULL) ENGINE = TokuDB) # check prerequisites-1 success: 1 # check COUNT(*) success: 1 |