diff options
author | Elena Stepanova <elenst@montyprogram.com> | 2017-07-10 00:05:45 +0300 |
---|---|---|
committer | Elena Stepanova <elenst@montyprogram.com> | 2017-07-10 00:05:45 +0300 |
commit | 5ff2db7f67401511b30dbd3fc69a1ea87d7e8cc4 (patch) | |
tree | 47f3a7e9649e3e1a6767b530ed0144584c26ba5c | |
parent | 4df726e1801907d7f3c68ed760c0c8f4df73998b (diff) | |
download | mariadb-git-5ff2db7f67401511b30dbd3fc69a1ea87d7e8cc4.tar.gz |
Follow-up for MDEV-13089 (identifier quoting in partitioning)mariadb-10.2.7
Adjust results for storage_engine tests
-rw-r--r-- | mysql-test/suite/storage_engine/parts/truncate_table.result | 8 | ||||
-rw-r--r-- | storage/myisammrg/mysql-test/storage_engine/parts/truncate_table.rdiff | 8 |
2 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/suite/storage_engine/parts/truncate_table.result b/mysql-test/suite/storage_engine/parts/truncate_table.result index fc409b805e2..bfbca529200 100644 --- a/mysql-test/suite/storage_engine/parts/truncate_table.result +++ b/mysql-test/suite/storage_engine/parts/truncate_table.result @@ -14,7 +14,7 @@ t1 CREATE TABLE `t1` ( `c` char(8) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 - PARTITION BY HASH (a) + PARTITION BY HASH (`a`) PARTITIONS 2 INSERT INTO t1 (c) VALUES ('a'),('b'),('c'); SHOW CREATE TABLE t1; @@ -24,7 +24,7 @@ t1 CREATE TABLE `t1` ( `c` char(8) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=<STORAGE_ENGINE> AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 - PARTITION BY HASH (a) + PARTITION BY HASH (`a`) PARTITIONS 2 TRUNCATE TABLE t1; SHOW CREATE TABLE t1; @@ -34,7 +34,7 @@ t1 CREATE TABLE `t1` ( `c` char(8) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 - PARTITION BY HASH (a) + PARTITION BY HASH (`a`) PARTITIONS 2 INSERT INTO t1 (c) VALUES ('d'); SHOW CREATE TABLE t1; @@ -44,7 +44,7 @@ t1 CREATE TABLE `t1` ( `c` char(8) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=<STORAGE_ENGINE> AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 - PARTITION BY HASH (a) + PARTITION BY HASH (`a`) PARTITIONS 2 SELECT a,c FROM t1; a c diff --git a/storage/myisammrg/mysql-test/storage_engine/parts/truncate_table.rdiff b/storage/myisammrg/mysql-test/storage_engine/parts/truncate_table.rdiff index 22e3447e00a..9ba985f7adc 100644 --- a/storage/myisammrg/mysql-test/storage_engine/parts/truncate_table.rdiff +++ b/storage/myisammrg/mysql-test/storage_engine/parts/truncate_table.rdiff @@ -27,7 +27,7 @@ - `c` char(8) DEFAULT NULL, - PRIMARY KEY (`a`) -) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 -- PARTITION BY HASH (a) +- PARTITION BY HASH (`a`) -PARTITIONS 2 -INSERT INTO t1 (c) VALUES ('a'),('b'),('c'); -SHOW CREATE TABLE t1; @@ -37,7 +37,7 @@ - `c` char(8) DEFAULT NULL, - PRIMARY KEY (`a`) -) ENGINE=<STORAGE_ENGINE> AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 -- PARTITION BY HASH (a) +- PARTITION BY HASH (`a`) -PARTITIONS 2 -TRUNCATE TABLE t1; -SHOW CREATE TABLE t1; @@ -47,7 +47,7 @@ - `c` char(8) DEFAULT NULL, - PRIMARY KEY (`a`) -) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 -- PARTITION BY HASH (a) +- PARTITION BY HASH (`a`) -PARTITIONS 2 -INSERT INTO t1 (c) VALUES ('d'); -SHOW CREATE TABLE t1; @@ -57,7 +57,7 @@ - `c` char(8) DEFAULT NULL, - PRIMARY KEY (`a`) -) ENGINE=<STORAGE_ENGINE> AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 -- PARTITION BY HASH (a) +- PARTITION BY HASH (`a`) -PARTITIONS 2 -SELECT a,c FROM t1; -a c |