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

1 files changed, 103 insertions, 103 deletions

diff --git a/mysql-test/suite/parts/r/partition_mgm_lc0_memory.result b/mysql-test/suite/parts/r/partition_mgm_lc0_memory.result
index 5451b5a6fd3..585bd24dca6 100644
--- a/mysql-test/suite/parts/r/partition_mgm_lc0_memory.result
+++ b/mysql-test/suite/parts/r/partition_mgm_lc0_memory.result
@@ -56,14 +56,14 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
-(PARTITION parta ENGINE = MEMORY,
- PARTITION partB ENGINE = MEMORY,
- PARTITION Partc ENGINE = MEMORY,
- PARTITION PartD ENGINE = MEMORY,
- PARTITION partE ENGINE = MEMORY,
- PARTITION Partf ENGINE = MEMORY,
- PARTITION PartG ENGINE = MEMORY)
+ PARTITION BY KEY (`a`)
+(PARTITION `parta` ENGINE = MEMORY,
+ PARTITION `partB` ENGINE = MEMORY,
+ PARTITION `Partc` ENGINE = MEMORY,
+ PARTITION `PartD` ENGINE = MEMORY,
+ PARTITION `partE` ENGINE = MEMORY,
+ PARTITION `Partf` ENGINE = MEMORY,
+ PARTITION `PartG` ENGINE = MEMORY)
 ALTER TABLE TableA COALESCE PARTITION 4;
 SELECT * FROM TableA;
 a
@@ -84,10 +84,10 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
-(PARTITION parta ENGINE = MEMORY,
- PARTITION partB ENGINE = MEMORY,
- PARTITION Partc ENGINE = MEMORY)
+ PARTITION BY KEY (`a`)
+(PARTITION `parta` ENGINE = MEMORY,
+ PARTITION `partB` ENGINE = MEMORY,
+ PARTITION `Partc` ENGINE = MEMORY)
 # Test of EXCHANGE PARTITION WITH TABLE
 SELECT PARTITION_NAME, TABLE_ROWS FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA ='MySQL_Test_DB' AND TABLE_NAME = 'TableA';
 PARTITION_NAME	TABLE_ROWS
@@ -112,10 +112,10 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
-(PARTITION parta ENGINE = MEMORY,
- PARTITION partB ENGINE = MEMORY,
- PARTITION Partc ENGINE = MEMORY)
+ PARTITION BY KEY (`a`)
+(PARTITION `parta` ENGINE = MEMORY,
+ PARTITION `partB` ENGINE = MEMORY,
+ PARTITION `Partc` ENGINE = MEMORY)
 SELECT * FROM TableB;
 a
 10
@@ -156,10 +156,10 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
-(PARTITION parta ENGINE = MEMORY,
- PARTITION partB ENGINE = MEMORY,
- PARTITION Partc ENGINE = MEMORY)
+ PARTITION BY KEY (`a`)
+(PARTITION `parta` ENGINE = MEMORY,
+ PARTITION `partB` ENGINE = MEMORY,
+ PARTITION `Partc` ENGINE = MEMORY)
 # Test of REORGANIZE PARTITIONS
 # Should not work on HASH/KEY
 ALTER TABLE TableA REORGANIZE PARTITION parta,partB,Partc INTO
@@ -192,10 +192,10 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
-(PARTITION partB COMMENT = 'Previusly named parta' ENGINE = MEMORY,
- PARTITION parta COMMENT = 'Previusly named partB' ENGINE = MEMORY,
- PARTITION Partc ENGINE = MEMORY)
+ PARTITION BY KEY (`a`)
+(PARTITION `partB` COMMENT = 'Previusly named parta' ENGINE = MEMORY,
+ PARTITION `parta` COMMENT = 'Previusly named partB' ENGINE = MEMORY,
+ PARTITION `Partc` ENGINE = MEMORY)
 # Test of RENAME TABLE
 RENAME TABLE TableA to TableB;
 SELECT * FROM TableB;
@@ -271,11 +271,11 @@ Table	Create Table
 tablea	CREATE TABLE `tablea` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
-(PARTITION parta ENGINE = MEMORY,
- PARTITION partB ENGINE = MEMORY,
- PARTITION Partc ENGINE = MEMORY,
- PARTITION PartD ENGINE = MEMORY)
+ PARTITION BY KEY (`a`)
+(PARTITION `parta` ENGINE = MEMORY,
+ PARTITION `partB` ENGINE = MEMORY,
+ PARTITION `Partc` ENGINE = MEMORY,
+ PARTITION `PartD` ENGINE = MEMORY)
 DROP TABLE tablea;
 # Test of REMOVE PARTITIONING
 ALTER TABLE TableA REMOVE PARTITIONING;
@@ -364,14 +364,14 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY HASH (a)
-(PARTITION parta ENGINE = MEMORY,
- PARTITION partB ENGINE = MEMORY,
- PARTITION Partc ENGINE = MEMORY,
- PARTITION PartD ENGINE = MEMORY,
- PARTITION partE ENGINE = MEMORY,
- PARTITION Partf ENGINE = MEMORY,
- PARTITION PartG ENGINE = MEMORY)
+ PARTITION BY HASH (`a`)
+(PARTITION `parta` ENGINE = MEMORY,
+ PARTITION `partB` ENGINE = MEMORY,
+ PARTITION `Partc` ENGINE = MEMORY,
+ PARTITION `PartD` ENGINE = MEMORY,
+ PARTITION `partE` ENGINE = MEMORY,
+ PARTITION `Partf` ENGINE = MEMORY,
+ PARTITION `PartG` ENGINE = MEMORY)
 ALTER TABLE TableA COALESCE PARTITION 4;
 SELECT * FROM TableA;
 a
@@ -392,10 +392,10 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY HASH (a)
-(PARTITION parta ENGINE = MEMORY,
- PARTITION partB ENGINE = MEMORY,
- PARTITION Partc ENGINE = MEMORY)
+ PARTITION BY HASH (`a`)
+(PARTITION `parta` ENGINE = MEMORY,
+ PARTITION `partB` ENGINE = MEMORY,
+ PARTITION `Partc` ENGINE = MEMORY)
 # Test of REORGANIZE PARTITIONS
 # Should not work on HASH/KEY
 ALTER TABLE TableA REORGANIZE PARTITION parta,partB,Partc INTO
@@ -428,10 +428,10 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY HASH (a)
-(PARTITION partB COMMENT = 'Previusly named parta' ENGINE = MEMORY,
- PARTITION parta COMMENT = 'Previusly named partB' ENGINE = MEMORY,
- PARTITION Partc ENGINE = MEMORY)
+ PARTITION BY HASH (`a`)
+(PARTITION `partB` COMMENT = 'Previusly named parta' ENGINE = MEMORY,
+ PARTITION `parta` COMMENT = 'Previusly named partB' ENGINE = MEMORY,
+ PARTITION `Partc` ENGINE = MEMORY)
 # Test of RENAME TABLE
 RENAME TABLE TableA to TableB;
 SELECT * FROM TableB;
@@ -507,11 +507,11 @@ Table	Create Table
 tablea	CREATE TABLE `tablea` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY HASH (a)
-(PARTITION parta ENGINE = MEMORY,
- PARTITION partB ENGINE = MEMORY,
- PARTITION Partc ENGINE = MEMORY,
- PARTITION PartD ENGINE = MEMORY)
+ PARTITION BY HASH (`a`)
+(PARTITION `parta` ENGINE = MEMORY,
+ PARTITION `partB` ENGINE = MEMORY,
+ PARTITION `Partc` ENGINE = MEMORY,
+ PARTITION `PartD` ENGINE = MEMORY)
 DROP TABLE tablea;
 # Test of REMOVE PARTITIONING
 ALTER TABLE TableA REMOVE PARTITIONING;
@@ -589,14 +589,14 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY RANGE (a)
-(PARTITION parta VALUES LESS THAN (4) ENGINE = MEMORY,
- PARTITION partB VALUES LESS THAN (7) ENGINE = MEMORY,
- PARTITION Partc VALUES LESS THAN (10) ENGINE = MEMORY,
- PARTITION PartD VALUES LESS THAN (13) ENGINE = MEMORY,
- PARTITION partE VALUES LESS THAN (16) ENGINE = MEMORY,
- PARTITION Partf VALUES LESS THAN (19) ENGINE = MEMORY,
- PARTITION PartG VALUES LESS THAN (22) ENGINE = MEMORY)
+ PARTITION BY RANGE (`a`)
+(PARTITION `parta` VALUES LESS THAN (4) ENGINE = MEMORY,
+ PARTITION `partB` VALUES LESS THAN (7) ENGINE = MEMORY,
+ PARTITION `Partc` VALUES LESS THAN (10) ENGINE = MEMORY,
+ PARTITION `PartD` VALUES LESS THAN (13) ENGINE = MEMORY,
+ PARTITION `partE` VALUES LESS THAN (16) ENGINE = MEMORY,
+ PARTITION `Partf` VALUES LESS THAN (19) ENGINE = MEMORY,
+ PARTITION `PartG` VALUES LESS THAN (22) ENGINE = MEMORY)
 ALTER TABLE TableA DROP PARTITION partE, PartG;
 ALTER TABLE TableA DROP PARTITION Partf;
 ALTER TABLE TableA ADD PARTITION
@@ -620,12 +620,12 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY RANGE (a)
-(PARTITION parta VALUES LESS THAN (4) ENGINE = MEMORY,
- PARTITION partB VALUES LESS THAN (7) ENGINE = MEMORY,
- PARTITION Partc VALUES LESS THAN (10) ENGINE = MEMORY,
- PARTITION PartD VALUES LESS THAN (13) ENGINE = MEMORY,
- PARTITION PartE VALUES LESS THAN MAXVALUE ENGINE = MEMORY)
+ PARTITION BY RANGE (`a`)
+(PARTITION `parta` VALUES LESS THAN (4) ENGINE = MEMORY,
+ PARTITION `partB` VALUES LESS THAN (7) ENGINE = MEMORY,
+ PARTITION `Partc` VALUES LESS THAN (10) ENGINE = MEMORY,
+ PARTITION `PartD` VALUES LESS THAN (13) ENGINE = MEMORY,
+ PARTITION `PartE` VALUES LESS THAN MAXVALUE ENGINE = MEMORY)
 # Test of REORGANIZE PARTITIONS
 # Error since it must reorganize a consecutive range
 ALTER TABLE TableA REORGANIZE PARTITION parta,Partc INTO
@@ -658,11 +658,11 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY RANGE (a)
-(PARTITION parta VALUES LESS THAN (4) ENGINE = MEMORY,
- PARTITION partD VALUES LESS THAN (8) COMMENT = 'Previously partB and partly Partc' ENGINE = MEMORY,
- PARTITION partB VALUES LESS THAN (11) COMMENT = 'Previously partly Partc and partly PartD' ENGINE = MEMORY,
- PARTITION partC VALUES LESS THAN MAXVALUE COMMENT = 'Previously partly PartD' ENGINE = MEMORY)
+ PARTITION BY RANGE (`a`)
+(PARTITION `parta` VALUES LESS THAN (4) ENGINE = MEMORY,
+ PARTITION `partD` VALUES LESS THAN (8) COMMENT = 'Previously partB and partly Partc' ENGINE = MEMORY,
+ PARTITION `partB` VALUES LESS THAN (11) COMMENT = 'Previously partly Partc and partly PartD' ENGINE = MEMORY,
+ PARTITION `partC` VALUES LESS THAN MAXVALUE COMMENT = 'Previously partly PartD' ENGINE = MEMORY)
 # Test of RENAME TABLE
 RENAME TABLE TableA to TableB;
 SELECT * FROM TableB;
@@ -738,11 +738,11 @@ Table	Create Table
 tablea	CREATE TABLE `tablea` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY RANGE (a)
-(PARTITION parta VALUES LESS THAN (4) ENGINE = MEMORY,
- PARTITION partB VALUES LESS THAN (7) ENGINE = MEMORY,
- PARTITION Partc VALUES LESS THAN (10) ENGINE = MEMORY,
- PARTITION PartD VALUES LESS THAN (13) ENGINE = MEMORY)
+ PARTITION BY RANGE (`a`)
+(PARTITION `parta` VALUES LESS THAN (4) ENGINE = MEMORY,
+ PARTITION `partB` VALUES LESS THAN (7) ENGINE = MEMORY,
+ PARTITION `Partc` VALUES LESS THAN (10) ENGINE = MEMORY,
+ PARTITION `PartD` VALUES LESS THAN (13) ENGINE = MEMORY)
 DROP TABLE tablea;
 # Test of REMOVE PARTITIONING
 ALTER TABLE TableA REMOVE PARTITIONING;
@@ -820,14 +820,14 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY LIST (a)
-(PARTITION parta VALUES IN (1,8,9) ENGINE = MEMORY,
- PARTITION partB VALUES IN (2,10,11) ENGINE = MEMORY,
- PARTITION Partc VALUES IN (3,4,7) ENGINE = MEMORY,
- PARTITION PartD VALUES IN (5,6,12) ENGINE = MEMORY,
- PARTITION partE VALUES IN (16) ENGINE = MEMORY,
- PARTITION Partf VALUES IN (19) ENGINE = MEMORY,
- PARTITION PartG VALUES IN (22) ENGINE = MEMORY)
+ PARTITION BY LIST (`a`)
+(PARTITION `parta` VALUES IN (1,8,9) ENGINE = MEMORY,
+ PARTITION `partB` VALUES IN (2,10,11) ENGINE = MEMORY,
+ PARTITION `Partc` VALUES IN (3,4,7) ENGINE = MEMORY,
+ PARTITION `PartD` VALUES IN (5,6,12) ENGINE = MEMORY,
+ PARTITION `partE` VALUES IN (16) ENGINE = MEMORY,
+ PARTITION `Partf` VALUES IN (19) ENGINE = MEMORY,
+ PARTITION `PartG` VALUES IN (22) ENGINE = MEMORY)
 ALTER TABLE TableA DROP PARTITION partE, PartG;
 ALTER TABLE TableA DROP PARTITION Partf;
 ALTER TABLE TableA ADD PARTITION
@@ -851,12 +851,12 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY LIST (a)
-(PARTITION parta VALUES IN (1,8,9) ENGINE = MEMORY,
- PARTITION partB VALUES IN (2,10,11) ENGINE = MEMORY,
- PARTITION Partc VALUES IN (3,4,7) ENGINE = MEMORY,
- PARTITION PartD VALUES IN (5,6,12) ENGINE = MEMORY,
- PARTITION PartE VALUES IN (13) ENGINE = MEMORY)
+ PARTITION BY LIST (`a`)
+(PARTITION `parta` VALUES IN (1,8,9) ENGINE = MEMORY,
+ PARTITION `partB` VALUES IN (2,10,11) ENGINE = MEMORY,
+ PARTITION `Partc` VALUES IN (3,4,7) ENGINE = MEMORY,
+ PARTITION `PartD` VALUES IN (5,6,12) ENGINE = MEMORY,
+ PARTITION `PartE` VALUES IN (13) ENGINE = MEMORY)
 # Test of REORGANIZE PARTITIONS
 ALTER TABLE TableA REORGANIZE PARTITION parta,Partc INTO
 (PARTITION Partc VALUES IN (1,7) 
@@ -889,12 +889,12 @@ Table	Create Table
 TableA	CREATE TABLE `TableA` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY LIST (a)
-(PARTITION Partc VALUES IN (1,7) COMMENT = 'Mix 1 of old parta and Partc' ENGINE = MEMORY,
- PARTITION parta VALUES IN (3,9) COMMENT = 'Mix 2 of old parta and Partc' ENGINE = MEMORY,
- PARTITION partB VALUES IN (4,8) COMMENT = 'Mix 3 of old parta and Partc' ENGINE = MEMORY,
- PARTITION PartD VALUES IN (5,6,12) ENGINE = MEMORY,
- PARTITION PartE VALUES IN (13) ENGINE = MEMORY)
+ PARTITION BY LIST (`a`)
+(PARTITION `Partc` VALUES IN (1,7) COMMENT = 'Mix 1 of old parta and Partc' ENGINE = MEMORY,
+ PARTITION `parta` VALUES IN (3,9) COMMENT = 'Mix 2 of old parta and Partc' ENGINE = MEMORY,
+ PARTITION `partB` VALUES IN (4,8) COMMENT = 'Mix 3 of old parta and Partc' ENGINE = MEMORY,
+ PARTITION `PartD` VALUES IN (5,6,12) ENGINE = MEMORY,
+ PARTITION `PartE` VALUES IN (13) ENGINE = MEMORY)
 # Test of RENAME TABLE
 RENAME TABLE TableA to TableB;
 SELECT * FROM TableB;
@@ -961,11 +961,11 @@ Table	Create Table
 tablea	CREATE TABLE `tablea` (
   `a` int(11) DEFAULT NULL
 ) ENGINE=MEMORY DEFAULT CHARSET=latin1
- PARTITION BY LIST (a)
-(PARTITION parta VALUES IN (1,8,9) ENGINE = MEMORY,
- PARTITION partB VALUES IN (2,10,11) ENGINE = MEMORY,
- PARTITION Partc VALUES IN (3,4,7) ENGINE = MEMORY,
- PARTITION PartD VALUES IN (5,6,12) ENGINE = MEMORY)
+ PARTITION BY LIST (`a`)
+(PARTITION `parta` VALUES IN (1,8,9) ENGINE = MEMORY,
+ PARTITION `partB` VALUES IN (2,10,11) ENGINE = MEMORY,
+ PARTITION `Partc` VALUES IN (3,4,7) ENGINE = MEMORY,
+ PARTITION `PartD` VALUES IN (5,6,12) ENGINE = MEMORY)
 DROP TABLE tablea;
 # Test of REMOVE PARTITIONING
 ALTER TABLE TableA REMOVE PARTITIONING;
@@ -1004,10 +1004,10 @@ t1	CREATE TABLE `t1` (
   `b` varchar(255) DEFAULT NULL,
   PRIMARY KEY (`a`)
 ) ENGINE=MEMORY AUTO_INCREMENT=2002 DEFAULT CHARSET=latin1
- PARTITION BY RANGE (a)
-(PARTITION LT1000 VALUES LESS THAN (1000) ENGINE = MEMORY,
- PARTITION LT2000 VALUES LESS THAN (2000) ENGINE = MEMORY,
- PARTITION MAX VALUES LESS THAN MAXVALUE ENGINE = MEMORY)
+ PARTITION BY RANGE (`a`)
+(PARTITION `LT1000` VALUES LESS THAN (1000) ENGINE = MEMORY,
+ PARTITION `LT2000` VALUES LESS THAN (2000) ENGINE = MEMORY,
+ PARTITION `MAX` VALUES LESS THAN MAXVALUE ENGINE = MEMORY)
 SELECT * FROM t1 ORDER BY a;
 a	b
 1	First