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/r/partition_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/r/partition_myisam.result')
| -rw-r--r-- | mysql-test/r/partition_myisam.result | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/partition_myisam.result b/mysql-test/r/partition_myisam.result index 664eb60c2c5..8f35075261a 100644 --- a/mysql-test/r/partition_myisam.result +++ b/mysql-test/r/partition_myisam.result @@ -27,10 +27,10 @@ Table Create Table t1 CREATE TABLE `t1` ( `i` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 - PARTITION BY RANGE (i) -(PARTITION p3 VALUES LESS THAN (3) ENGINE = MyISAM, - PARTITION p5 VALUES LESS THAN (5) ENGINE = MyISAM, - PARTITION pMax VALUES LESS THAN MAXVALUE ENGINE = MyISAM) + PARTITION BY RANGE (`i`) +(PARTITION `p3` VALUES LESS THAN (3) ENGINE = MyISAM, + PARTITION `p5` VALUES LESS THAN (5) ENGINE = MyISAM, + PARTITION `pMax` VALUES LESS THAN MAXVALUE ENGINE = MyISAM) DROP TABLE t1; # Same test without partitioning CREATE TABLE t1 ( @@ -131,7 +131,7 @@ t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`a`) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 - PARTITION BY KEY (a) + PARTITION BY KEY (`a`) INSERT INTO t1 VALUES (NULL); SELECT * FROM t1; a |