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 | 1200 |
1 files changed, 600 insertions, 600 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 8182dce5625..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 @@ -67,14 +67,14 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY HASH (f_int1) -PARTITIONS 2 */ + PARTITION BY HASH (`f_int1`) +PARTITIONS 2 unified filelist t1.frm @@ -522,14 +522,14 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY KEY (f_int1) -PARTITIONS 5 */ + PARTITION BY KEY (`f_int1`) +PARTITIONS 5 unified filelist t1.frm @@ -985,21 +985,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -1453,19 +1453,19 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -1915,19 +1915,19 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -2383,26 +2383,26 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `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_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 @@ -2860,26 +2860,26 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `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_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 @@ -3331,18 +3331,18 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `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_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 @@ -3792,14 +3792,14 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `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 unified filelist t1.frm @@ -4247,14 +4247,14 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `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 unified filelist t1.frm @@ -4710,21 +4710,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `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) unified filelist t1.frm @@ -5178,19 +5178,19 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `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) unified filelist t1.frm @@ -5640,19 +5640,19 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `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) unified filelist t1.frm @@ -6106,26 +6106,26 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `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)) unified filelist t1.frm @@ -6579,26 +6579,26 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `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)) unified filelist t1.frm @@ -7050,18 +7050,18 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `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) unified filelist t1.frm @@ -7515,16 +7515,16 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY HASH (f_int1) -PARTITIONS 2 */ + PARTITION BY HASH (`f_int1`) +PARTITIONS 2 unified filelist t1.frm @@ -8007,16 +8007,16 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY KEY (f_int1) -PARTITIONS 5 */ + PARTITION BY KEY (`f_int1`) +PARTITIONS 5 unified filelist t1.frm @@ -8507,23 +8507,23 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -9012,21 +9012,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -9511,21 +9511,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -10016,28 +10016,28 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -10530,28 +10530,28 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -11038,20 +11038,20 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -11535,16 +11535,16 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY HASH (f_int1) -PARTITIONS 2 */ + PARTITION BY HASH (`f_int1`) +PARTITIONS 2 unified filelist t1.frm @@ -12027,16 +12027,16 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY KEY (f_int1) -PARTITIONS 5 */ + PARTITION BY KEY (`f_int1`) +PARTITIONS 5 unified filelist t1.frm @@ -12527,23 +12527,23 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -13032,21 +13032,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -13531,21 +13531,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -14036,28 +14036,28 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -14550,28 +14550,28 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -15058,20 +15058,20 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -15555,16 +15555,16 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY HASH (f_int1) -PARTITIONS 2 */ + PARTITION BY HASH (`f_int1`) +PARTITIONS 2 unified filelist t1.frm @@ -16063,16 +16063,16 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 PARTITION BY KEY (f_int1) -PARTITIONS 5 */ + PARTITION BY KEY (`f_int1`) +PARTITIONS 5 unified filelist t1.frm @@ -16579,23 +16579,23 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -17100,21 +17100,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -17615,21 +17615,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -18136,28 +18136,28 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -18666,28 +18666,28 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -19190,20 +19190,20 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=TokuDB DEFAULT CHARSET=latin1 -/*!50100 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 @@ -19708,16 +19708,16 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`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 unified filelist t1.frm @@ -20200,16 +20200,16 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`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 unified filelist t1.frm @@ -20700,23 +20700,23 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`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) unified filelist t1.frm @@ -21205,21 +21205,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`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) unified filelist t1.frm @@ -21704,21 +21704,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`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) unified filelist t1.frm @@ -22207,28 +22207,28 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`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)) unified filelist t1.frm @@ -22717,28 +22717,28 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`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)) unified filelist t1.frm @@ -23225,20 +23225,20 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int2`,`f_int1`), UNIQUE KEY `uidx1` (`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) unified filelist t1.frm @@ -23722,16 +23722,16 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`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 unified filelist t1.frm @@ -24214,16 +24214,16 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`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 unified filelist t1.frm @@ -24714,23 +24714,23 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`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) unified filelist t1.frm @@ -25219,21 +25219,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`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) unified filelist t1.frm @@ -25718,21 +25718,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`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) unified filelist t1.frm @@ -26221,28 +26221,28 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`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)) unified filelist t1.frm @@ -26731,28 +26731,28 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`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)) unified filelist t1.frm @@ -27239,20 +27239,20 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) NOT NULL DEFAULT '0', - `f_int2` int(11) NOT NULL DEFAULT '0', + `f_int1` int(11) NOT NULL DEFAULT 0, + `f_int2` int(11) NOT NULL DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, PRIMARY KEY (`f_int1`,`f_int2`), UNIQUE KEY `uidx1` (`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) unified filelist t1.frm @@ -27736,16 +27736,16 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`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 unified filelist t1.frm @@ -28244,16 +28244,16 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`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 unified filelist t1.frm @@ -28760,23 +28760,23 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`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) unified filelist t1.frm @@ -29281,21 +29281,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`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) unified filelist t1.frm @@ -29796,21 +29796,21 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`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) unified filelist t1.frm @@ -30315,28 +30315,28 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`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)) unified filelist t1.frm @@ -30841,28 +30841,28 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`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)) unified filelist t1.frm @@ -31365,20 +31365,20 @@ create_command SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `f_int1` int(11) DEFAULT '0', - `f_int2` int(11) DEFAULT '0', + `f_int1` int(11) DEFAULT 0, + `f_int2` int(11) DEFAULT 0, `f_char1` char(20) DEFAULT NULL, `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`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) unified filelist t1.frm |