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, 24 insertions, 24 deletions

diff --git a/mysql-test/suite/parts/r/partition_bit_innodb.result b/mysql-test/suite/parts/r/partition_bit_innodb.result
index 187b4a13d05..b3bf1dac15e 100644
--- a/mysql-test/suite/parts/r/partition_bit_innodb.result
+++ b/mysql-test/suite/parts/r/partition_bit_innodb.result
@@ -9,7 +9,7 @@ t1	CREATE TABLE `t1` (
   `a` bit(1) NOT NULL,
   PRIMARY KEY (`a`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
+ PARTITION BY KEY (`a`)
 drop table t1;
 create table t1 (a bit(0), primary key (a)) engine='INNODB' 
 partition by key (a) (
@@ -21,9 +21,9 @@ t1	CREATE TABLE `t1` (
   `a` bit(1) NOT NULL,
   PRIMARY KEY (`a`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
-(PARTITION pa1 ENGINE = InnoDB,
- PARTITION pa2 ENGINE = InnoDB)
+ PARTITION BY KEY (`a`)
+(PARTITION `pa1` ENGINE = InnoDB,
+ PARTITION `pa2` ENGINE = InnoDB)
 drop table t1;
 create table t1 (a bit(64), primary key (a)) engine='INNODB' 
 partition by key (a) partitions 2;
@@ -33,7 +33,7 @@ t1	CREATE TABLE `t1` (
   `a` bit(64) NOT NULL,
   PRIMARY KEY (`a`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
+ PARTITION BY KEY (`a`)
 PARTITIONS 2
 insert into t1 values 
 (b'1111111111111111111111111111111111111111111111111111111111111111'),
@@ -61,11 +61,11 @@ t1	CREATE TABLE `t1` (
   `a` bit(64) NOT NULL,
   PRIMARY KEY (`a`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
-(PARTITION pa1 MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = InnoDB,
- PARTITION pa2 MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = InnoDB,
- PARTITION pa3 MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = InnoDB,
- PARTITION pa4 MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = InnoDB)
+ PARTITION BY KEY (`a`)
+(PARTITION `pa1` MAX_ROWS = 20 MIN_ROWS = 2 ENGINE = InnoDB,
+ PARTITION `pa2` MAX_ROWS = 30 MIN_ROWS = 3 ENGINE = InnoDB,
+ PARTITION `pa3` MAX_ROWS = 30 MIN_ROWS = 4 ENGINE = InnoDB,
+ PARTITION `pa4` MAX_ROWS = 40 MIN_ROWS = 2 ENGINE = InnoDB)
 insert into t1 values 
 (b'1111111111111111111111111111111111111111111111111111111111111111'),
 (b'1000000000000000000000000000000000000000000000000000000000000000'),
@@ -91,7 +91,7 @@ t2	CREATE TABLE `t2` (
   `a` bit(1) NOT NULL,
   PRIMARY KEY (`a`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
+ PARTITION BY KEY (`a`)
 PARTITIONS 4
 insert into t2 values (b'0'), (b'1');
 select hex(a) from t2;
@@ -104,7 +104,7 @@ Table	Create Table
 t2	CREATE TABLE `t2` (
   `a` bit(1) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
+ PARTITION BY KEY (`a`)
 PARTITIONS 4
 select hex(a) from t2;
 hex(a)
@@ -117,7 +117,7 @@ t2	CREATE TABLE `t2` (
   `a` bit(1) NOT NULL,
   PRIMARY KEY (`a`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
- PARTITION BY KEY (a)
+ PARTITION BY KEY (`a`)
 PARTITIONS 4
 select hex(a) from t2;
 hex(a)
@@ -136,13 +136,13 @@ t3	CREATE TABLE `t3` (
   `a` bit(8) NOT NULL,
   PRIMARY KEY (`a`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
- PARTITION BY RANGE (a)
-SUBPARTITION BY KEY (a)
+ PARTITION BY RANGE (`a`)
+SUBPARTITION BY KEY (`a`)
 SUBPARTITIONS 2
-(PARTITION pa1 VALUES LESS THAN (3) ENGINE = InnoDB,
- PARTITION pa2 VALUES LESS THAN (16) ENGINE = InnoDB,
- PARTITION pa3 VALUES LESS THAN (64) ENGINE = InnoDB,
- PARTITION pa4 VALUES LESS THAN (256) ENGINE = InnoDB)
+(PARTITION `pa1` VALUES LESS THAN (3) ENGINE = InnoDB,
+ PARTITION `pa2` VALUES LESS THAN (16) ENGINE = InnoDB,
+ PARTITION `pa3` VALUES LESS THAN (64) ENGINE = InnoDB,
+ PARTITION `pa4` VALUES LESS THAN (256) ENGINE = InnoDB)
 255 inserts;
 select hex(a) from t3 where a=b'01010101';
 hex(a)
@@ -419,12 +419,12 @@ t4	CREATE TABLE `t4` (
   `a` bit(8) NOT NULL,
   PRIMARY KEY (`a`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (a)
-SUBPARTITION BY KEY (a)
+ PARTITION BY LIST (`a`)
+SUBPARTITION BY KEY (`a`)
 SUBPARTITIONS 2
-(PARTITION pa1 VALUES IN (0,1,2,3) ENGINE = InnoDB,
- PARTITION pa2 VALUES IN (4,5,6,7,8,9,10,11,12,13,14,15,16) ENGINE = InnoDB,
- PARTITION pa3 VALUES IN (17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32) ENGINE = InnoDB)
+(PARTITION `pa1` VALUES IN (0,1,2,3) ENGINE = InnoDB,
+ PARTITION `pa2` VALUES IN (4,5,6,7,8,9,10,11,12,13,14,15,16) ENGINE = InnoDB,
+ PARTITION `pa3` VALUES IN (17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32) ENGINE = InnoDB)
 32 inserts;
 select hex(a) from t4 where a=b'00000001';
 hex(a)