diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_parts/r/partition_basic_tokudb.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb_parts/r/partition_basic_tokudb.result | 912 |
1 files changed, 456 insertions, 456 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_parts/r/partition_basic_tokudb.result b/storage/tokudb/mysql-test/tokudb_parts/r/partition_basic_tokudb.result index ca85132d982..fca6cbe169e 100644 --- a/storage/tokudb/mysql-test/tokudb_parts/r/partition_basic_tokudb.result +++ b/storage/tokudb/mysql-test/tokudb_parts/r/partition_basic_tokudb.result @@ -73,7 +73,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1) + PARTITION BY HASH (`f_int1`) PARTITIONS 2 unified filelist @@ -528,7 +528,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1) + PARTITION BY KEY (`f_int1`) PARTITIONS 5 unified filelist @@ -991,15 +991,15 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1,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` % 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) unified filelist t1.frm @@ -1459,13 +1459,13 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -(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`) +(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) unified filelist t1.frm @@ -1921,13 +1921,13 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1 DIV 2) -SUBPARTITION BY HASH (f_int1) + PARTITION BY RANGE (`f_int1` DIV 2) +SUBPARTITION BY HASH (`f_int1`) 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) unified filelist t1.frm @@ -2389,20 +2389,20 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int1) -(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_int1`) +(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)) unified filelist t1.frm @@ -2866,20 +2866,20 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int1 + 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_int1` + 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)) unified filelist t1.frm @@ -3337,12 +3337,12 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,2))) -SUBPARTITION BY KEY (f_int1) + PARTITION BY LIST (abs(`f_int1` % 2)) +SUBPARTITION BY KEY (`f_int1`) 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) unified filelist t1.frm @@ -3798,7 +3798,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 unified filelist @@ -4253,7 +4253,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 unified filelist @@ -4716,15 +4716,15 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - 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) unified filelist t1.frm @@ -5184,13 +5184,13 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - 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) unified filelist t1.frm @@ -5646,13 +5646,13 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB 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 = 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) unified filelist t1.frm @@ -6112,20 +6112,20 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - 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)) unified filelist t1.frm @@ -6585,20 +6585,20 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB 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 = 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)) unified filelist t1.frm @@ -7056,12 +7056,12 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB 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 = 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) unified filelist t1.frm @@ -7523,7 +7523,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1) + PARTITION BY HASH (`f_int1`) PARTITIONS 2 unified filelist @@ -8015,7 +8015,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1) + PARTITION BY KEY (`f_int1`) PARTITIONS 5 unified filelist @@ -8515,15 +8515,15 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1,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` % 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) unified filelist t1.frm @@ -9020,13 +9020,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -(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`) +(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) unified filelist t1.frm @@ -9519,13 +9519,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1 DIV 2) -SUBPARTITION BY HASH (f_int1) + PARTITION BY RANGE (`f_int1` DIV 2) +SUBPARTITION BY HASH (`f_int1`) 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) unified filelist t1.frm @@ -10024,20 +10024,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int1) -(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_int1`) +(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)) unified filelist t1.frm @@ -10538,20 +10538,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int1 + 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_int1` + 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)) unified filelist t1.frm @@ -11046,12 +11046,12 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,2))) -SUBPARTITION BY KEY (f_int1) + PARTITION BY LIST (abs(`f_int1` % 2)) +SUBPARTITION BY KEY (`f_int1`) 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) unified filelist t1.frm @@ -11543,7 +11543,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1) + PARTITION BY HASH (`f_int1`) PARTITIONS 2 unified filelist @@ -12035,7 +12035,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1) + PARTITION BY KEY (`f_int1`) PARTITIONS 5 unified filelist @@ -12535,15 +12535,15 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1,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` % 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) unified filelist t1.frm @@ -13040,13 +13040,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -(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`) +(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) unified filelist t1.frm @@ -13539,13 +13539,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1 DIV 2) -SUBPARTITION BY HASH (f_int1) + PARTITION BY RANGE (`f_int1` DIV 2) +SUBPARTITION BY HASH (`f_int1`) 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) unified filelist t1.frm @@ -14044,20 +14044,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int1) -(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_int1`) +(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)) unified filelist t1.frm @@ -14558,20 +14558,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int1 + 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_int1` + 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)) unified filelist t1.frm @@ -15066,12 +15066,12 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,2))) -SUBPARTITION BY KEY (f_int1) + PARTITION BY LIST (abs(`f_int1` % 2)) +SUBPARTITION BY KEY (`f_int1`) 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) unified filelist t1.frm @@ -15563,7 +15563,7 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1) + PARTITION BY HASH (`f_int1`) PARTITIONS 2 unified filelist @@ -16071,7 +16071,7 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1) + PARTITION BY KEY (`f_int1`) PARTITIONS 5 unified filelist @@ -16587,15 +16587,15 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1,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` % 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) unified filelist t1.frm @@ -17108,13 +17108,13 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -(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`) +(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) unified filelist t1.frm @@ -17623,13 +17623,13 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1 DIV 2) -SUBPARTITION BY HASH (f_int1) + PARTITION BY RANGE (`f_int1` DIV 2) +SUBPARTITION BY HASH (`f_int1`) 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) unified filelist t1.frm @@ -18144,20 +18144,20 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int1) -(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_int1`) +(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)) unified filelist t1.frm @@ -18674,20 +18674,20 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,3))) -SUBPARTITION BY HASH (f_int1 + 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_int1` + 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)) unified filelist t1.frm @@ -19198,12 +19198,12 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY LIST (ABS(MOD(f_int1,2))) -SUBPARTITION BY KEY (f_int1) + PARTITION BY LIST (abs(`f_int1` % 2)) +SUBPARTITION BY KEY (`f_int1`) 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) unified filelist t1.frm @@ -19716,7 +19716,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 unified filelist @@ -20208,7 +20208,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 unified filelist @@ -20708,15 +20708,15 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - 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) unified filelist t1.frm @@ -21213,13 +21213,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - 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) unified filelist t1.frm @@ -21712,13 +21712,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB 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 = 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) unified filelist t1.frm @@ -22215,20 +22215,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - 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)) unified filelist t1.frm @@ -22725,20 +22725,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB 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 = 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)) unified filelist t1.frm @@ -23233,12 +23233,12 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB 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 = 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) unified filelist t1.frm @@ -23730,7 +23730,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 unified filelist @@ -24222,7 +24222,7 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 unified filelist @@ -24722,15 +24722,15 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - 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) unified filelist t1.frm @@ -25227,13 +25227,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - 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) unified filelist t1.frm @@ -25726,13 +25726,13 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB 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 = 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) unified filelist t1.frm @@ -26229,20 +26229,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - 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)) unified filelist t1.frm @@ -26739,20 +26739,20 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB 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 = 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)) unified filelist t1.frm @@ -27247,12 +27247,12 @@ t1 CREATE TABLE `t1` ( PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB 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 = 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) unified filelist t1.frm @@ -27744,7 +27744,7 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 unified filelist @@ -28252,7 +28252,7 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 unified filelist @@ -28768,15 +28768,15 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - 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) unified filelist t1.frm @@ -29289,13 +29289,13 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - 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) unified filelist t1.frm @@ -29804,13 +29804,13 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB 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 = 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) unified filelist t1.frm @@ -30323,20 +30323,20 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 - 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)) unified filelist t1.frm @@ -30849,20 +30849,20 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB 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 = 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)) unified filelist t1.frm @@ -31373,12 +31373,12 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB 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 = 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) unified filelist t1.frm |