diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2017-06-14 00:48:34 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2017-06-14 13:22:37 +0200 |
| commit | c661b4d0fb38c103fc0b659a95e8552ea72574cf (patch) | |
| tree | b65c4537a1a9bbaff61f56fb78b9de175a8bfab9 /mysql-test/suite/parts | |
| parent | 5cbbfe9f54f15a5281439dc21f22b599a69b5f87 (diff) | |
| download | mariadb-git-c661b4d0fb38c103fc0b659a95e8552ea72574cf.tar.gz | |
MDEV-13017 LOCK TABLE fails with irrelevant error while working with tables affected by ANSI_QUOTES
Diffstat (limited to 'mysql-test/suite/parts')
| -rw-r--r-- | mysql-test/suite/parts/r/quoting.result | 6 | ||||
| -rw-r--r-- | mysql-test/suite/parts/t/quoting.test | 10 |
2 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/suite/parts/r/quoting.result b/mysql-test/suite/parts/r/quoting.result new file mode 100644 index 00000000000..ba6a155e6ac --- /dev/null +++ b/mysql-test/suite/parts/r/quoting.result @@ -0,0 +1,6 @@ +set sql_mode=ansi_quotes; +create table t1 (i int) partition by range (i) (partition flush values less than maxvalue); +set sql_mode=default; +lock tables t1 read local; +unlock tables; +drop table t1; diff --git a/mysql-test/suite/parts/t/quoting.test b/mysql-test/suite/parts/t/quoting.test new file mode 100644 index 00000000000..297896fd9cf --- /dev/null +++ b/mysql-test/suite/parts/t/quoting.test @@ -0,0 +1,10 @@ +# +# MDEV-13017 LOCK TABLE fails with irrelevant error while working with tables affected by ANSI_QUOTES +# +--source include/have_partition.inc +set sql_mode=ansi_quotes; +create table t1 (i int) partition by range (i) (partition flush values less than maxvalue); +set sql_mode=default; +lock tables t1 read local; +unlock tables; +drop table t1; |