diff options
author | Sergei Golubchik <serg@mariadb.org> | 2017-06-28 10:10:31 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2017-06-28 10:10:31 +0200 |
commit | a02ba9c1c96f8245b2fd5c8b555c74204af421e3 (patch) | |
tree | 8d84e04d7ee6ec5713a120f2fb1ac436d0348508 /mysql-test/t/mysql.test | |
parent | 8baf9b0c469e2845d15cc1181bc6b101cdfba087 (diff) | |
parent | d5cd33450413816f8696125cd66c8393921e6267 (diff) | |
download | mariadb-git-a02ba9c1c96f8245b2fd5c8b555c74204af421e3.tar.gz |
Merge branch '5.5' into 10.0
Diffstat (limited to 'mysql-test/t/mysql.test')
-rw-r--r-- | mysql-test/t/mysql.test | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/t/mysql.test b/mysql-test/t/mysql.test index 263e1103e8b..4403a9d668f 100644 --- a/mysql-test/t/mysql.test +++ b/mysql-test/t/mysql.test @@ -618,3 +618,33 @@ EOF --echo --echo End of tests + +# +# MDEV-13187 incorrect backslash parsing in clients +# +create table `a1\``b1` (a int); +show tables; +insert `a1\``b1` values (1),(2); +show create table `a1\``b1`; +--exec $MYSQL_DUMP --compact test +--exec $MYSQL_DUMP test > $MYSQLTEST_VARDIR/tmp/bug.sql +insert `a1\``b1` values (4),(5); +--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/bug.sql +show create table `a1\``b1`; +select * from `a1\``b1`; +drop table `a1\``b1`; + +# same with ansi_quotes +set sql_mode=ansi_quotes; +create table "a1\""b1" (a int); +show tables; +insert "a1\""b1" values (1),(2); +show create table "a1\""b1"; +--exec $MYSQL_DUMP --compact --compatible=postgres test +--exec $MYSQL_DUMP --compatible=postgres test > $MYSQLTEST_VARDIR/tmp/bug.sql +insert "a1\""b1" values (4),(5); +--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/bug.sql +show create table "a1\""b1"; +select * from "a1\""b1"; +drop table "a1\""b1"; +set sql_mode=default; |