diff options
author | Sergei Golubchik <serg@mariadb.org> | 2017-06-27 20:46:45 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2017-07-05 17:15:59 +0200 |
commit | 785e2248bd12b2b8fc417776c4b24fb62daab35d (patch) | |
tree | 01138b878fe08de0f9c9444c77327e73abf43414 /mysql-test/suite/parts/r/partition_alter2_1_myisam.result | |
parent | 504eff0ca13ef93fa46f919e1fb60b58ac9a34eb (diff) | |
download | mariadb-git-785e2248bd12b2b8fc417776c4b24fb62daab35d.tar.gz |
MDEV-13089 identifier quoting in partitioning
don't print partitioning expression as it was entered by the user,
use Item::print() according to the sql_mode and sql_quote_show_create
Diffstat (limited to 'mysql-test/suite/parts/r/partition_alter2_1_myisam.result')
-rw-r--r-- | mysql-test/suite/parts/r/partition_alter2_1_myisam.result | 684 |
1 files changed, 342 insertions, 342 deletions
diff --git a/mysql-test/suite/parts/r/partition_alter2_1_myisam.result b/mysql-test/suite/parts/r/partition_alter2_1_myisam.result index 44550776616..ee587189113 100644 --- a/mysql-test/suite/parts/r/partition_alter2_1_myisam.result +++ b/mysql-test/suite/parts/r/partition_alter2_1_myisam.result @@ -74,7 +74,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1) + PARTITION BY HASH (`f_int1`) PARTITIONS 2 unified filelist @@ -539,7 +539,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1) + PARTITION BY KEY (`f_int1`) PARTITIONS 5 unified filelist @@ -1018,15 +1018,15 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, - PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, - PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, - PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, - PARTITION part0 VALUES IN (0) ENGINE = MyISAM, - PARTITION part1 VALUES IN (1) ENGINE = MyISAM, - PARTITION part2 VALUES IN (2) ENGINE = MyISAM, - PARTITION part3 VALUES IN (3) ENGINE = MyISAM) + PARTITION BY LIST (`f_int1` % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = MyISAM, + PARTITION `part_2` VALUES IN (-2) ENGINE = MyISAM, + PARTITION `part_1` VALUES IN (-1) ENGINE = MyISAM, + PARTITION `part_N` VALUES IN (NULL) ENGINE = MyISAM, + PARTITION `part0` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part1` VALUES IN (1) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (2) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (3) ENGINE = MyISAM) unified filelist t1#P#part0.MYD @@ -1508,13 +1508,13 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, - PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, - PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) + PARTITION BY RANGE (`f_int1`) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = MyISAM, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = MyISAM, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = MyISAM, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#parta.MYD @@ -1988,13 +1988,13 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM 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 = MyISAM, - PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = MyISAM, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#parta#SP#partasp0.MYD @@ -2478,20 +2478,20 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int1) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = MyISAM, - SUBPARTITION subpart12 ENGINE = MyISAM), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = MyISAM, - SUBPARTITION subpart22 ENGINE = MyISAM), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = MyISAM, - SUBPARTITION subpart32 ENGINE = MyISAM), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = MyISAM, - SUBPARTITION subpart42 ENGINE = MyISAM)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int1`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = MyISAM, + SUBPARTITION `subpart12` ENGINE = MyISAM), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = MyISAM, + SUBPARTITION `subpart22` ENGINE = MyISAM), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = MyISAM, + SUBPARTITION `subpart32` ENGINE = MyISAM), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = MyISAM, + SUBPARTITION `subpart42` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#subpart11.MYD @@ -2973,20 +2973,20 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM 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 = MyISAM, - SUBPARTITION sp12 ENGINE = MyISAM), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = MyISAM, - SUBPARTITION sp22 ENGINE = MyISAM), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = MyISAM, - SUBPARTITION sp32 ENGINE = MyISAM), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = MyISAM, - SUBPARTITION sp42 ENGINE = MyISAM)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int1` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = MyISAM, + SUBPARTITION `sp12` ENGINE = MyISAM), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = MyISAM, + SUBPARTITION `sp22` ENGINE = MyISAM), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = MyISAM, + SUBPARTITION `sp32` ENGINE = MyISAM), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = MyISAM, + SUBPARTITION `sp42` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#sp11.MYD @@ -3466,12 +3466,12 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM 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 = MyISAM, - PARTITION part2 VALUES IN (1) ENGINE = MyISAM, - PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) +(PARTITION `part1` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (1) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (NULL) ENGINE = MyISAM) unified filelist t1#P#part1#SP#part1sp0.MYD @@ -3952,7 +3952,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1) + PARTITION BY HASH (`f_int1`) PARTITIONS 2 unified filelist @@ -4469,7 +4469,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1) + PARTITION BY KEY (`f_int1`) PARTITIONS 5 unified filelist @@ -5000,15 +5000,15 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, - PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, - PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, - PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, - PARTITION part0 VALUES IN (0) ENGINE = MyISAM, - PARTITION part1 VALUES IN (1) ENGINE = MyISAM, - PARTITION part2 VALUES IN (2) ENGINE = MyISAM, - PARTITION part3 VALUES IN (3) ENGINE = MyISAM) + PARTITION BY LIST (`f_int1` % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = MyISAM, + PARTITION `part_2` VALUES IN (-2) ENGINE = MyISAM, + PARTITION `part_1` VALUES IN (-1) ENGINE = MyISAM, + PARTITION `part_N` VALUES IN (NULL) ENGINE = MyISAM, + PARTITION `part0` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part1` VALUES IN (1) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (2) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (3) ENGINE = MyISAM) unified filelist t1#P#part0.MYD @@ -5542,13 +5542,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, - PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, - PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) + PARTITION BY RANGE (`f_int1`) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = MyISAM, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = MyISAM, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = MyISAM, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#parta.MYD @@ -6074,13 +6074,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=MyISAM 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 = MyISAM, - PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = MyISAM, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#parta#SP#partasp0.MYD @@ -6616,20 +6616,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int1) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = MyISAM, - SUBPARTITION subpart12 ENGINE = MyISAM), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = MyISAM, - SUBPARTITION subpart22 ENGINE = MyISAM), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = MyISAM, - SUBPARTITION subpart32 ENGINE = MyISAM), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = MyISAM, - SUBPARTITION subpart42 ENGINE = MyISAM)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int1`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = MyISAM, + SUBPARTITION `subpart12` ENGINE = MyISAM), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = MyISAM, + SUBPARTITION `subpart22` ENGINE = MyISAM), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = MyISAM, + SUBPARTITION `subpart32` ENGINE = MyISAM), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = MyISAM, + SUBPARTITION `subpart42` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#subpart11.MYD @@ -7163,20 +7163,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=MyISAM 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 = MyISAM, - SUBPARTITION sp12 ENGINE = MyISAM), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = MyISAM, - SUBPARTITION sp22 ENGINE = MyISAM), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = MyISAM, - SUBPARTITION sp32 ENGINE = MyISAM), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = MyISAM, - SUBPARTITION sp42 ENGINE = MyISAM)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int1` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = MyISAM, + SUBPARTITION `sp12` ENGINE = MyISAM), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = MyISAM, + SUBPARTITION `sp22` ENGINE = MyISAM), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = MyISAM, + SUBPARTITION `sp32` ENGINE = MyISAM), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = MyISAM, + SUBPARTITION `sp42` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#sp11.MYD @@ -7708,12 +7708,12 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int1`,`f_int2`) ) ENGINE=MyISAM 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 = MyISAM, - PARTITION part2 VALUES IN (1) ENGINE = MyISAM, - PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) +(PARTITION `part1` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (1) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (NULL) ENGINE = MyISAM) unified filelist t1#P#part1#SP#part1sp0.MYD @@ -8244,7 +8244,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1) + PARTITION BY HASH (`f_int1`) PARTITIONS 2 unified filelist @@ -8761,7 +8761,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1) + PARTITION BY KEY (`f_int1`) PARTITIONS 5 unified filelist @@ -9292,15 +9292,15 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, - PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, - PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, - PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, - PARTITION part0 VALUES IN (0) ENGINE = MyISAM, - PARTITION part1 VALUES IN (1) ENGINE = MyISAM, - PARTITION part2 VALUES IN (2) ENGINE = MyISAM, - PARTITION part3 VALUES IN (3) ENGINE = MyISAM) + PARTITION BY LIST (`f_int1` % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = MyISAM, + PARTITION `part_2` VALUES IN (-2) ENGINE = MyISAM, + PARTITION `part_1` VALUES IN (-1) ENGINE = MyISAM, + PARTITION `part_N` VALUES IN (NULL) ENGINE = MyISAM, + PARTITION `part0` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part1` VALUES IN (1) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (2) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (3) ENGINE = MyISAM) unified filelist t1#P#part0.MYD @@ -9834,13 +9834,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, - PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, - PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) + PARTITION BY RANGE (`f_int1`) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = MyISAM, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = MyISAM, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = MyISAM, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#parta.MYD @@ -10366,13 +10366,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=MyISAM 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 = MyISAM, - PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = MyISAM, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#parta#SP#partasp0.MYD @@ -10908,20 +10908,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int1) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = MyISAM, - SUBPARTITION subpart12 ENGINE = MyISAM), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = MyISAM, - SUBPARTITION subpart22 ENGINE = MyISAM), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = MyISAM, - SUBPARTITION subpart32 ENGINE = MyISAM), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = MyISAM, - SUBPARTITION subpart42 ENGINE = MyISAM)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int1`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = MyISAM, + SUBPARTITION `subpart12` ENGINE = MyISAM), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = MyISAM, + SUBPARTITION `subpart22` ENGINE = MyISAM), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = MyISAM, + SUBPARTITION `subpart32` ENGINE = MyISAM), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = MyISAM, + SUBPARTITION `subpart42` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#subpart11.MYD @@ -11455,20 +11455,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=MyISAM 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 = MyISAM, - SUBPARTITION sp12 ENGINE = MyISAM), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = MyISAM, - SUBPARTITION sp22 ENGINE = MyISAM), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = MyISAM, - SUBPARTITION sp32 ENGINE = MyISAM), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = MyISAM, - SUBPARTITION sp42 ENGINE = MyISAM)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int1` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = MyISAM, + SUBPARTITION `sp12` ENGINE = MyISAM), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = MyISAM, + SUBPARTITION `sp22` ENGINE = MyISAM), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = MyISAM, + SUBPARTITION `sp32` ENGINE = MyISAM), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = MyISAM, + SUBPARTITION `sp42` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#sp11.MYD @@ -12000,12 +12000,12 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx1` (`f_int2`,`f_int1`) ) ENGINE=MyISAM 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 = MyISAM, - PARTITION part2 VALUES IN (1) ENGINE = MyISAM, - PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) +(PARTITION `part1` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (1) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (NULL) ENGINE = MyISAM) unified filelist t1#P#part1#SP#part1sp0.MYD @@ -12540,7 +12540,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 unified filelist @@ -13005,7 +13005,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 unified filelist @@ -13484,15 +13484,15 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, - PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, - PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, - PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, - PARTITION part0 VALUES IN (0) ENGINE = MyISAM, - PARTITION part1 VALUES IN (1) ENGINE = MyISAM, - PARTITION part2 VALUES IN (2) ENGINE = MyISAM, - PARTITION part3 VALUES IN (3) ENGINE = MyISAM) + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = MyISAM, + PARTITION `part_2` VALUES IN (-2) ENGINE = MyISAM, + PARTITION `part_1` VALUES IN (-1) ENGINE = MyISAM, + PARTITION `part_N` VALUES IN (NULL) ENGINE = MyISAM, + PARTITION `part0` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part1` VALUES IN (1) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (2) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (3) ENGINE = MyISAM) unified filelist t1#P#part0.MYD @@ -13974,13 +13974,13 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, - PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, - PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = MyISAM, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = MyISAM, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = MyISAM, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#parta.MYD @@ -14454,13 +14454,13 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM 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 = MyISAM, - PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = MyISAM, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#parta#SP#partasp0.MYD @@ -14942,20 +14942,20 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = MyISAM, - SUBPARTITION subpart12 ENGINE = MyISAM), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = MyISAM, - SUBPARTITION subpart22 ENGINE = MyISAM), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = MyISAM, - SUBPARTITION subpart32 ENGINE = MyISAM), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = MyISAM, - SUBPARTITION subpart42 ENGINE = MyISAM)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = MyISAM, + SUBPARTITION `subpart12` ENGINE = MyISAM), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = MyISAM, + SUBPARTITION `subpart22` ENGINE = MyISAM), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = MyISAM, + SUBPARTITION `subpart32` ENGINE = MyISAM), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = MyISAM, + SUBPARTITION `subpart42` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#subpart11.MYD @@ -15437,20 +15437,20 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM 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 = MyISAM, - SUBPARTITION sp12 ENGINE = MyISAM), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = MyISAM, - SUBPARTITION sp22 ENGINE = MyISAM), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = MyISAM, - SUBPARTITION sp32 ENGINE = MyISAM), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = MyISAM, - SUBPARTITION sp42 ENGINE = MyISAM)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = MyISAM, + SUBPARTITION `sp12` ENGINE = MyISAM), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = MyISAM, + SUBPARTITION `sp22` ENGINE = MyISAM), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = MyISAM, + SUBPARTITION `sp32` ENGINE = MyISAM), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = MyISAM, + SUBPARTITION `sp42` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#sp11.MYD @@ -15930,12 +15930,12 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM 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 = MyISAM, - PARTITION part2 VALUES IN (1) ENGINE = MyISAM, - PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) +(PARTITION `part1` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (1) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (NULL) ENGINE = MyISAM) unified filelist t1#P#part1#SP#part1sp0.MYD @@ -16416,7 +16416,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 unified filelist @@ -16933,7 +16933,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 unified filelist @@ -17464,15 +17464,15 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, - PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, - PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, - PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, - PARTITION part0 VALUES IN (0) ENGINE = MyISAM, - PARTITION part1 VALUES IN (1) ENGINE = MyISAM, - PARTITION part2 VALUES IN (2) ENGINE = MyISAM, - PARTITION part3 VALUES IN (3) ENGINE = MyISAM) + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = MyISAM, + PARTITION `part_2` VALUES IN (-2) ENGINE = MyISAM, + PARTITION `part_1` VALUES IN (-1) ENGINE = MyISAM, + PARTITION `part_N` VALUES IN (NULL) ENGINE = MyISAM, + PARTITION `part0` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part1` VALUES IN (1) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (2) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (3) ENGINE = MyISAM) unified filelist t1#P#part0.MYD @@ -18006,13 +18006,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, - PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, - PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = MyISAM, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = MyISAM, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = MyISAM, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#parta.MYD @@ -18538,13 +18538,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=MyISAM 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 = MyISAM, - PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = MyISAM, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#parta#SP#partasp0.MYD @@ -19078,20 +19078,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = MyISAM, - SUBPARTITION subpart12 ENGINE = MyISAM), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = MyISAM, - SUBPARTITION subpart22 ENGINE = MyISAM), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = MyISAM, - SUBPARTITION subpart32 ENGINE = MyISAM), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = MyISAM, - SUBPARTITION subpart42 ENGINE = MyISAM)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = MyISAM, + SUBPARTITION `subpart12` ENGINE = MyISAM), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = MyISAM, + SUBPARTITION `subpart22` ENGINE = MyISAM), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = MyISAM, + SUBPARTITION `subpart32` ENGINE = MyISAM), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = MyISAM, + SUBPARTITION `subpart42` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#subpart11.MYD @@ -19625,20 +19625,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=MyISAM 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 = MyISAM, - SUBPARTITION sp12 ENGINE = MyISAM), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = MyISAM, - SUBPARTITION sp22 ENGINE = MyISAM), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = MyISAM, - SUBPARTITION sp32 ENGINE = MyISAM), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = MyISAM, - SUBPARTITION sp42 ENGINE = MyISAM)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = MyISAM, + SUBPARTITION `sp12` ENGINE = MyISAM), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = MyISAM, + SUBPARTITION `sp22` ENGINE = MyISAM), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = MyISAM, + SUBPARTITION `sp32` ENGINE = MyISAM), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = MyISAM, + SUBPARTITION `sp42` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#sp11.MYD @@ -20170,12 +20170,12 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int1`,`f_int2`) ) ENGINE=MyISAM 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 = MyISAM, - PARTITION part2 VALUES IN (1) ENGINE = MyISAM, - PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) +(PARTITION `part1` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (1) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (NULL) ENGINE = MyISAM) unified filelist t1#P#part1#SP#part1sp0.MYD @@ -20706,7 +20706,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY HASH (f_int1 + f_int2) + PARTITION BY HASH (`f_int1` + `f_int2`) PARTITIONS 2 unified filelist @@ -21223,7 +21223,7 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY KEY (f_int1,f_int2) + PARTITION BY KEY (`f_int1`,`f_int2`) PARTITIONS 5 unified filelist @@ -21754,15 +21754,15 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY LIST (MOD(f_int1 + f_int2,4)) -(PARTITION part_3 VALUES IN (-3) ENGINE = MyISAM, - PARTITION part_2 VALUES IN (-2) ENGINE = MyISAM, - PARTITION part_1 VALUES IN (-1) ENGINE = MyISAM, - PARTITION part_N VALUES IN (NULL) ENGINE = MyISAM, - PARTITION part0 VALUES IN (0) ENGINE = MyISAM, - PARTITION part1 VALUES IN (1) ENGINE = MyISAM, - PARTITION part2 VALUES IN (2) ENGINE = MyISAM, - PARTITION part3 VALUES IN (3) ENGINE = MyISAM) + PARTITION BY LIST ((`f_int1` + `f_int2`) % 4) +(PARTITION `part_3` VALUES IN (-3) ENGINE = MyISAM, + PARTITION `part_2` VALUES IN (-2) ENGINE = MyISAM, + PARTITION `part_1` VALUES IN (-1) ENGINE = MyISAM, + PARTITION `part_N` VALUES IN (NULL) ENGINE = MyISAM, + PARTITION `part0` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part1` VALUES IN (1) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (2) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (3) ENGINE = MyISAM) unified filelist t1#P#part0.MYD @@ -22296,13 +22296,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY RANGE ((f_int1 + f_int2) DIV 2) -(PARTITION parta VALUES LESS THAN (0) ENGINE = MyISAM, - PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION partd VALUES LESS THAN (15) ENGINE = MyISAM, - PARTITION parte VALUES LESS THAN (20) ENGINE = MyISAM, - PARTITION partf VALUES LESS THAN (2147483646) ENGINE = MyISAM) + PARTITION BY RANGE ((`f_int1` + `f_int2`) DIV 2) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = MyISAM, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `partd` VALUES LESS THAN (15) ENGINE = MyISAM, + PARTITION `parte` VALUES LESS THAN (20) ENGINE = MyISAM, + PARTITION `partf` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#parta.MYD @@ -22828,13 +22828,13 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=MyISAM 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 = MyISAM, - PARTITION partb VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION partc VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION partd VALUES LESS THAN (2147483646) ENGINE = MyISAM) +(PARTITION `parta` VALUES LESS THAN (0) ENGINE = MyISAM, + PARTITION `partb` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `partc` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `partd` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#parta#SP#partasp0.MYD @@ -23368,20 +23368,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY RANGE (f_int1) -SUBPARTITION BY KEY (f_int2) -(PARTITION part1 VALUES LESS THAN (0) - (SUBPARTITION subpart11 ENGINE = MyISAM, - SUBPARTITION subpart12 ENGINE = MyISAM), - PARTITION part2 VALUES LESS THAN (5) - (SUBPARTITION subpart21 ENGINE = MyISAM, - SUBPARTITION subpart22 ENGINE = MyISAM), - PARTITION part3 VALUES LESS THAN (10) - (SUBPARTITION subpart31 ENGINE = MyISAM, - SUBPARTITION subpart32 ENGINE = MyISAM), - PARTITION part4 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart41 ENGINE = MyISAM, - SUBPARTITION subpart42 ENGINE = MyISAM)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY KEY (`f_int2`) +(PARTITION `part1` VALUES LESS THAN (0) + (SUBPARTITION `subpart11` ENGINE = MyISAM, + SUBPARTITION `subpart12` ENGINE = MyISAM), + PARTITION `part2` VALUES LESS THAN (5) + (SUBPARTITION `subpart21` ENGINE = MyISAM, + SUBPARTITION `subpart22` ENGINE = MyISAM), + PARTITION `part3` VALUES LESS THAN (10) + (SUBPARTITION `subpart31` ENGINE = MyISAM, + SUBPARTITION `subpart32` ENGINE = MyISAM), + PARTITION `part4` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart41` ENGINE = MyISAM, + SUBPARTITION `subpart42` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#subpart11.MYD @@ -23915,20 +23915,20 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=MyISAM 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 = MyISAM, - SUBPARTITION sp12 ENGINE = MyISAM), - PARTITION part2 VALUES IN (1) - (SUBPARTITION sp21 ENGINE = MyISAM, - SUBPARTITION sp22 ENGINE = MyISAM), - PARTITION part3 VALUES IN (2) - (SUBPARTITION sp31 ENGINE = MyISAM, - SUBPARTITION sp32 ENGINE = MyISAM), - PARTITION part4 VALUES IN (NULL) - (SUBPARTITION sp41 ENGINE = MyISAM, - SUBPARTITION sp42 ENGINE = MyISAM)) + PARTITION BY LIST (abs(`f_int1` % 3)) +SUBPARTITION BY HASH (`f_int2` + 1) +(PARTITION `part1` VALUES IN (0) + (SUBPARTITION `sp11` ENGINE = MyISAM, + SUBPARTITION `sp12` ENGINE = MyISAM), + PARTITION `part2` VALUES IN (1) + (SUBPARTITION `sp21` ENGINE = MyISAM, + SUBPARTITION `sp22` ENGINE = MyISAM), + PARTITION `part3` VALUES IN (2) + (SUBPARTITION `sp31` ENGINE = MyISAM, + SUBPARTITION `sp32` ENGINE = MyISAM), + PARTITION `part4` VALUES IN (NULL) + (SUBPARTITION `sp41` ENGINE = MyISAM, + SUBPARTITION `sp42` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#sp11.MYD @@ -24460,12 +24460,12 @@ t1 CREATE TABLE `t1` ( `f_charbig` varchar(1000) DEFAULT NULL, UNIQUE KEY `uidx` (`f_int2`,`f_int1`) ) ENGINE=MyISAM 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 = MyISAM, - PARTITION part2 VALUES IN (1) ENGINE = MyISAM, - PARTITION part3 VALUES IN (NULL) ENGINE = MyISAM) +(PARTITION `part1` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (1) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (NULL) ENGINE = MyISAM) unified filelist t1#P#part1#SP#part1sp0.MYD |