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/archive | |
| 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/archive')
| -rw-r--r-- | mysql-test/suite/archive/partition_archive.result | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/mysql-test/suite/archive/partition_archive.result b/mysql-test/suite/archive/partition_archive.result index 1ed979f2c92..a2e0fe7420f 100644 --- a/mysql-test/suite/archive/partition_archive.result +++ b/mysql-test/suite/archive/partition_archive.result @@ -84,7 +84,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL ) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 - PARTITION BY HASH (a) + PARTITION BY HASH (`a`) drop table t1; CREATE TABLE t1(id MEDIUMINT NOT NULL AUTO_INCREMENT, f1 VARCHAR(25), @@ -109,20 +109,20 @@ t1 CREATE TABLE `t1` ( `f1` varchar(25) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=ARCHIVE AUTO_INCREMENT=101 DEFAULT CHARSET=latin1 - PARTITION BY RANGE (id) -SUBPARTITION BY HASH (id) + PARTITION BY RANGE (`id`) +SUBPARTITION BY HASH (`id`) SUBPARTITIONS 2 -(PARTITION pa1 VALUES LESS THAN (10) ENGINE = ARCHIVE, - PARTITION pa2 VALUES LESS THAN (20) ENGINE = ARCHIVE, - PARTITION pa3 VALUES LESS THAN (30) ENGINE = ARCHIVE, - PARTITION pa4 VALUES LESS THAN (40) ENGINE = ARCHIVE, - PARTITION pa5 VALUES LESS THAN (50) ENGINE = ARCHIVE, - PARTITION pa6 VALUES LESS THAN (60) ENGINE = ARCHIVE, - PARTITION pa7 VALUES LESS THAN (70) ENGINE = ARCHIVE, - PARTITION pa8 VALUES LESS THAN (80) ENGINE = ARCHIVE, - PARTITION pa9 VALUES LESS THAN (90) ENGINE = ARCHIVE, - PARTITION pa10 VALUES LESS THAN (100) ENGINE = ARCHIVE, - PARTITION pa11 VALUES LESS THAN MAXVALUE ENGINE = ARCHIVE) +(PARTITION `pa1` VALUES LESS THAN (10) ENGINE = ARCHIVE, + PARTITION `pa2` VALUES LESS THAN (20) ENGINE = ARCHIVE, + PARTITION `pa3` VALUES LESS THAN (30) ENGINE = ARCHIVE, + PARTITION `pa4` VALUES LESS THAN (40) ENGINE = ARCHIVE, + PARTITION `pa5` VALUES LESS THAN (50) ENGINE = ARCHIVE, + PARTITION `pa6` VALUES LESS THAN (60) ENGINE = ARCHIVE, + PARTITION `pa7` VALUES LESS THAN (70) ENGINE = ARCHIVE, + PARTITION `pa8` VALUES LESS THAN (80) ENGINE = ARCHIVE, + PARTITION `pa9` VALUES LESS THAN (90) ENGINE = ARCHIVE, + PARTITION `pa10` VALUES LESS THAN (100) ENGINE = ARCHIVE, + PARTITION `pa11` VALUES LESS THAN MAXVALUE ENGINE = ARCHIVE) select count(*) from t1; count(*) 100 @@ -138,7 +138,7 @@ t1 CREATE TABLE `t1` ( `fld1` int(11) NOT NULL, PRIMARY KEY (`fld1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY HASH (fld1) + PARTITION BY HASH (`fld1`) PARTITIONS 5 ALTER TABLE t1 ENGINE= ARCHIVE; ERROR HY000: Can't create table `test`.`#sql-temporary` (errno: 140 "Wrong create options") @@ -149,7 +149,7 @@ t1 CREATE TABLE `t1` ( `fld1` int(11) NOT NULL, PRIMARY KEY (`fld1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY HASH (fld1) + PARTITION BY HASH (`fld1`) PARTITIONS 5 #Cleanup. DROP TABLE t1; |