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, 19 insertions, 0 deletions

diff --git a/mysql-test/suite/parts/t/quoting.test b/mysql-test/suite/parts/t/quoting.test
new file mode 100644
index 00000000000..4fec9a4f319
--- /dev/null
+++ b/mysql-test/suite/parts/t/quoting.test
@@ -0,0 +1,19 @@
+#
+# MDEV-13089 identifier quoting in partitioning
+#
+source include/have_partition.inc;
+set sql_mode=ansi_quotes;
+create table t1 ("select" int) partition by range ("select") (partition "select" values less than maxvalue);
+create table t2 (f1 int) partition by range (f1) (partition p1 values less than maxvalue);
+show create table t1;
+show create table t2;
+set sql_quote_show_create=0;
+show create table t1;
+show create table t2;
+set sql_mode=default;
+show create table t1;
+show create table t2;
+set sql_quote_show_create=1;
+show create table t1;
+show create table t2;
+drop table t1, t2;