diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/tc_partition_value_specific.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/tc_partition_value_specific.result | 50 |
1 files changed, 25 insertions, 25 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_partition_value_specific.result b/mysql-test/suite/engines/funcs/r/tc_partition_value_specific.result index 71a38814fd8..0d9393ffeda 100644 --- a/mysql-test/suite/engines/funcs/r/tc_partition_value_specific.result +++ b/mysql-test/suite/engines/funcs/r/tc_partition_value_specific.result @@ -13,11 +13,11 @@ t1 CREATE TABLE `t1` ( `c1` smallint(6) DEFAULT NULL, `c2` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 - PARTITION BY LIST (c1) -(PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE, - PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE, - PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE, - PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) + PARTITION BY LIST (`c1`) +(PARTITION `r0` VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE, + PARTITION `r1` VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE, + PARTITION `r2` VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE, + PARTITION `r3` VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -35,11 +35,11 @@ t1 CREATE TABLE `t1` ( `c1` mediumint(9) DEFAULT NULL, `c2` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 - PARTITION BY LIST (c1) -(PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE, - PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE, - PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE, - PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) + PARTITION BY LIST (`c1`) +(PARTITION `r0` VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE, + PARTITION `r1` VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE, + PARTITION `r2` VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE, + PARTITION `r3` VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -57,11 +57,11 @@ t1 CREATE TABLE `t1` ( `c1` int(11) DEFAULT NULL, `c2` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 - PARTITION BY LIST (c1) -(PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE, - PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE, - PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE, - PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) + PARTITION BY LIST (`c1`) +(PARTITION `r0` VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE, + PARTITION `r1` VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE, + PARTITION `r2` VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE, + PARTITION `r3` VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -79,11 +79,11 @@ t1 CREATE TABLE `t1` ( `c1` int(11) DEFAULT NULL, `c2` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 - PARTITION BY LIST (c1) -(PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE, - PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE, - PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE, - PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) + PARTITION BY LIST (`c1`) +(PARTITION `r0` VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE, + PARTITION `r1` VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE, + PARTITION `r2` VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE, + PARTITION `r3` VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) DROP TABLE t1; SHOW TABLES; Tables_in_test @@ -101,11 +101,11 @@ t1 CREATE TABLE `t1` ( `c1` bigint(20) DEFAULT NULL, `c2` int(11) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 - PARTITION BY LIST (c1) -(PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE, - PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE, - PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE, - PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) + PARTITION BY LIST (`c1`) +(PARTITION `r0` VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE, + PARTITION `r1` VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE, + PARTITION `r2` VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE, + PARTITION `r3` VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE) DROP TABLE t1; SHOW TABLES; Tables_in_test |