mirror of
https://github.com/MariaDB/server.git
synced 2025-07-25 12:45:00 +02:00
32 lines
857 B
Text
32 lines
857 B
Text
#
|
|
# 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);
|
|
# "select", "f1", "p1"
|
|
show create table t1;
|
|
show create table t2;
|
|
set sql_quote_show_create=0;
|
|
# "select", f1, p1
|
|
show create table t1;
|
|
show create table t2;
|
|
set sql_mode=default;
|
|
# `select`, f1, p1
|
|
show create table t1;
|
|
show create table t2;
|
|
set sql_quote_show_create=1;
|
|
# `select`, `f1`, `p1`
|
|
show create table t1;
|
|
show create table t2;
|
|
# re-parse
|
|
flush tables;
|
|
# `select`, `f1`, `p1`
|
|
show create table t1;
|
|
show create table t2;
|
|
set sql_mode=ansi_quotes;
|
|
# "select", "f1", "p1"
|
|
show create table t1;
|
|
show create table t2;
|
|
drop table t1, t2;
|