diff options
| author | unknown <bar@mysql.com> | 2005-02-22 09:56:07 +0400 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2005-02-22 09:56:07 +0400 |
| commit | 14707d71c388375817b4ffb74df189bbe14a709d (patch) | |
| tree | 493e9f0339c425a9656ed088bda4b0349006313a /mysql-test | |
| parent | 1329f063c052e70fa71c7aaacb08e49357d108f5 (diff) | |
| download | mariadb-git-14707d71c388375817b4ffb74df189bbe14a709d.tar.gz | |
ctype_latin1.result, ctype_latin1.test, charset.c:
Treat unknown characters straight in a query as syntax error, rather skipping it as a space character.
mysys/charset.c:
Treat unknown characters straight in a query as syntax error, rather skipping it as a space character.
mysql-test/t/ctype_latin1.test:
Treat unknown characters straight in a query as syntax error, rather skipping it as a space character.
mysql-test/r/ctype_latin1.result:
Treat unknown characters straight in a query as syntax error, rather skipping it as a space character.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/ctype_latin1.result | 5 | ||||
| -rw-r--r-- | mysql-test/t/ctype_latin1.test | 9 |
2 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_latin1.result b/mysql-test/r/ctype_latin1.result index cd804939a75..21c40e24fe2 100644 --- a/mysql-test/r/ctype_latin1.result +++ b/mysql-test/r/ctype_latin1.result @@ -325,3 +325,8 @@ latin1_bin 6109 latin1_bin 61 latin1_bin 6120 drop table t1; +CREATE TABLE „a (a int); +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '„a (a int)' at line 1 +SELECT '„a' as str; +str +„a diff --git a/mysql-test/t/ctype_latin1.test b/mysql-test/t/ctype_latin1.test index cee0324d12f..6006ee4c527 100644 --- a/mysql-test/t/ctype_latin1.test +++ b/mysql-test/t/ctype_latin1.test @@ -66,3 +66,12 @@ SET collation_connection='latin1_swedish_ci'; -- source include/ctype_filesort.inc SET collation_connection='latin1_bin'; -- source include/ctype_filesort.inc + +# +# Bug#8041 +# An unknown character (e.g. 0x84) should result in ERROR, +# It was treated like a space character earlier. +# Howerver, it should still work fine as a string part. +--error 1064 +CREATE TABLE „a (a int); +SELECT '„a' as str; |