diff options
Diffstat (limited to 'mysql-test/suite/parts/r/partition_syntax_myisam.result')
| -rw-r--r-- | mysql-test/suite/parts/r/partition_syntax_myisam.result | 86 |
1 files changed, 43 insertions, 43 deletions
diff --git a/mysql-test/suite/parts/r/partition_syntax_myisam.result b/mysql-test/suite/parts/r/partition_syntax_myisam.result index e7ae727ea02..b54591fe538 100644 --- a/mysql-test/suite/parts/r/partition_syntax_myisam.result +++ b/mysql-test/suite/parts/r/partition_syntax_myisam.result @@ -658,9 +658,9 @@ 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,2)) -(PARTITION part1 VALUES IN (NULL) ENGINE = MyISAM, - PARTITION part3 VALUES IN (1) ENGINE = MyISAM) + PARTITION BY LIST (`f_int1` % 2) +(PARTITION `part1` VALUES IN (NULL) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (1) ENGINE = MyISAM) unified filelist t1#P#part1.MYD @@ -693,10 +693,10 @@ 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,2)) -(PARTITION part1 VALUES IN (NULL) ENGINE = MyISAM, - PARTITION part2 VALUES IN (0) ENGINE = MyISAM, - PARTITION part3 VALUES IN (1) ENGINE = MyISAM) + PARTITION BY LIST (`f_int1` % 2) +(PARTITION `part1` VALUES IN (NULL) ENGINE = MyISAM, + PARTITION `part2` VALUES IN (0) ENGINE = MyISAM, + PARTITION `part3` VALUES IN (1) ENGINE = MyISAM) unified filelist t1#P#part1.MYD @@ -737,7 +737,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`) unified filelist t1#P#p0.MYD @@ -765,9 +765,9 @@ 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 part1 ENGINE = MyISAM, - PARTITION part2 ENGINE = MyISAM) + PARTITION BY HASH (`f_int1`) +(PARTITION `part1` ENGINE = MyISAM, + PARTITION `part2` ENGINE = MyISAM) unified filelist t1#P#part1.MYD @@ -858,17 +858,17 @@ 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_int1) -(PARTITION part1 VALUES LESS THAN (10) - (SUBPARTITION subpart11 ENGINE = MyISAM, - SUBPARTITION subpart12 ENGINE = MyISAM), - PARTITION part2 VALUES LESS THAN (20) - (SUBPARTITION subpart21 ENGINE = MyISAM, - SUBPARTITION subpart22 ENGINE = MyISAM), - PARTITION part3 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart31 ENGINE = MyISAM, - SUBPARTITION subpart32 ENGINE = MyISAM)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY HASH (`f_int1`) +(PARTITION `part1` VALUES LESS THAN (10) + (SUBPARTITION `subpart11` ENGINE = MyISAM, + SUBPARTITION `subpart12` ENGINE = MyISAM), + PARTITION `part2` VALUES LESS THAN (20) + (SUBPARTITION `subpart21` ENGINE = MyISAM, + SUBPARTITION `subpart22` ENGINE = MyISAM), + PARTITION `part3` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart31` ENGINE = MyISAM, + SUBPARTITION `subpart32` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#subpart11.MYD @@ -910,7 +910,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 @@ -943,11 +943,11 @@ 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_int1) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY HASH (`f_int1`) SUBPARTITIONS 2 -(PARTITION part1 VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION part2 VALUES LESS THAN (2147483646) ENGINE = MyISAM) +(PARTITION `part1` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `part2` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#part1#SP#part1sp0.MYD @@ -980,7 +980,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 1 unified filelist @@ -1011,11 +1011,11 @@ 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_int1) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY HASH (`f_int1`) SUBPARTITIONS 1 -(PARTITION part1 VALUES LESS THAN (10) ENGINE = MyISAM, - PARTITION part2 VALUES LESS THAN (2147483646) ENGINE = MyISAM) +(PARTITION `part1` VALUES LESS THAN (10) ENGINE = MyISAM, + PARTITION `part2` VALUES LESS THAN (2147483646) ENGINE = MyISAM) unified filelist t1#P#part1#SP#part1sp0.MYD @@ -1763,9 +1763,9 @@ 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 part1 ENGINE = MyISAM, - PARTITION part2 ENGINE = MyISAM) + PARTITION BY HASH (`f_int1`) +(PARTITION `part1` ENGINE = MyISAM, + PARTITION `part2` ENGINE = MyISAM) unified filelist t1#P#part1.MYD @@ -1800,14 +1800,14 @@ 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_int1) -(PARTITION part1 VALUES LESS THAN (1000) - (SUBPARTITION subpart11 ENGINE = MyISAM, - SUBPARTITION subpart12 ENGINE = MyISAM), - PARTITION part2 VALUES LESS THAN (2147483646) - (SUBPARTITION subpart21 ENGINE = MyISAM, - SUBPARTITION subpart22 ENGINE = MyISAM)) + PARTITION BY RANGE (`f_int1`) +SUBPARTITION BY HASH (`f_int1`) +(PARTITION `part1` VALUES LESS THAN (1000) + (SUBPARTITION `subpart11` ENGINE = MyISAM, + SUBPARTITION `subpart12` ENGINE = MyISAM), + PARTITION `part2` VALUES LESS THAN (2147483646) + (SUBPARTITION `subpart21` ENGINE = MyISAM, + SUBPARTITION `subpart22` ENGINE = MyISAM)) unified filelist t1#P#part1#SP#subpart11.MYD |