MDEV-13187 incorrect backslash parsing in clients

cover ANSI_QUOTES and NO_BACKSLASH_ESCAPES in mysqltest

1 files changed, 15 insertions, 0 deletions

diff --git a/mysql-test/t/mysql.test b/mysql-test/t/mysql.test
index 20205924e15..dd964c46420 100644
--- a/mysql-test/t/mysql.test
+++ b/mysql-test/t/mysql.test
@@ -633,3 +633,18 @@ insert `a1\``b1` values (4),(5);
 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;