diff options
| author | Alexander Barkov <bar@mariadb.org> | 2017-07-13 07:21:21 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-07-13 07:21:21 +0400 |
| commit | 29acdcd5427e13bc3aefbbeee17b42bfe23dea84 (patch) | |
| tree | f8f5365594c3b43e01891b7017f47fa6b934c646 /mysql-test/suite/engines/funcs/r/tc_partition_value_specific.result | |
| parent | e33bda183e80ff63a984ed2a938467950b23a3fd (diff) | |
| parent | daec0004502a1f8c2ff7d46de92a61b5c4da1d6c (diff) | |
| download | mariadb-git-MDEV-9804.tar.gz | |
Merge remote-tracking branch 'origin/bb-10.2-ext' into 10.3MDEV-9804
Conflicts:
VERSION
debian/mariadb-backup-10.2.files
debian/mariadb-backup-10.2.install
debian/mariadb-backup-10.3.files
mysql-test/unstable-tests
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 |