diff options
| author | unknown <jimw@mysql.com> | 2005-02-03 16:14:02 -0800 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-02-03 16:14:02 -0800 |
| commit | 3443fdf954dbe604db66386711ba3e36116beba0 (patch) | |
| tree | b5e6ef3bd11e1a681107627a7d2085df2a4b4880 /mysql-test/r/sql_mode.result | |
| parent | 2ae812a7d6f5e8789143565364f9700c39c6a424 (diff) | |
| download | mariadb-git-3443fdf954dbe604db66386711ba3e36116beba0.tar.gz | |
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
Diffstat (limited to 'mysql-test/r/sql_mode.result')
| -rw-r--r-- | mysql-test/r/sql_mode.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/sql_mode.result b/mysql-test/r/sql_mode.result index 5492a7a65fc..09adc48259c 100644 --- a/mysql-test/r/sql_mode.result +++ b/mysql-test/r/sql_mode.result @@ -386,4 +386,18 @@ p mask example 20 \\\\% \\\\% 20 \\\\% \\\\_ DROP TABLE t1; +SET @@SQL_MODE='NO_BACKSLASH_ESCAPES'; +SELECT 'a\\b', 'a\\\"b', 'a''\\b', 'a''\\\"b'; +a\\b a\\\"b a'\\b a'\\\"b +a\\b a\\\"b a'\\b a'\\\"b +SELECT "a\\b", "a\\\'b", "a""\\b", "a""\\\'b"; +a\\b a\\\'b a"\\b a"\\\'b +a\\b a\\\'b a"\\b a"\\\'b +SET @@SQL_MODE=''; +SELECT 'a\\b', 'a\\\"b', 'a''\\b', 'a''\\\"b'; +a\b a\"b a'\b a'\"b +a\b a\"b a'\b a'\"b +SELECT "a\\b", "a\\\'b", "a""\\b", "a""\\\'b"; +a\b a\'b a"\b a"\'b +a\b a\'b a"\b a"\'b SET @@SQL_MODE=@OLD_SQL_MODE; |