From d3550828d44fdbc2731f18656870034d945334f1 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 3 Feb 2005 16:14:02 -0800 Subject: Handle backslashes correctly in strings that also have doubled quotes when we are using the NO_BACKSLASH_ESCAPES SQL mode. (Bug #6368) mysql-test/t/sql_mode.test: Add regression test for Bug #6368 mysql-test/r/sql_mode.result: Add new results sql/sql_lex.cc: Handle NO_BACKSLASH_ESCAPES mode when copying string that also has escapes due to doubled quotes --- mysql-test/t/sql_mode.test | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'mysql-test/t/sql_mode.test') diff --git a/mysql-test/t/sql_mode.test b/mysql-test/t/sql_mode.test index fa5c6cb8a5b..e80752eb71b 100644 --- a/mysql-test/t/sql_mode.test +++ b/mysql-test/t/sql_mode.test @@ -174,4 +174,14 @@ order by masks.p, example; DROP TABLE t1; +# Bug #6368: Make sure backslashes mixed with doubled quotes are handled +# correctly in NO_BACKSLASH_ESCAPES mode +SET @@SQL_MODE='NO_BACKSLASH_ESCAPES'; +SELECT 'a\\b', 'a\\\"b', 'a''\\b', 'a''\\\"b'; +SELECT "a\\b", "a\\\'b", "a""\\b", "a""\\\'b"; + +SET @@SQL_MODE=''; +SELECT 'a\\b', 'a\\\"b', 'a''\\b', 'a''\\\"b'; +SELECT "a\\b", "a\\\'b", "a""\\b", "a""\\\'b"; + SET @@SQL_MODE=@OLD_SQL_MODE; -- cgit v1.2.1