diff options
| author | Alexander Barkov <bar@mariadb.org> | 2014-09-12 12:57:27 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2014-09-12 12:57:27 +0400 |
| commit | 6a576f1a581b75ac86d85c1aa80c3386f8a55cd3 (patch) | |
| tree | 3d0352087b7b40647e35a02f5a43db226424d56a /mysql-test/include/bytes.inc | |
| parent | d2ae40ac2e9867fcf67ee3b3135de2905d463a12 (diff) | |
| download | mariadb-git-6a576f1a581b75ac86d85c1aa80c3386f8a55cd3.tar.gz | |
Adding thorough tests covering what happens with escaped sequences
in the SQL parser.
Various backslash escapes and quote-quote escaped sequences are covered
in combination with single and multi-byte characters.
This is especially important for the character sets that can have 0x5C
as the second byte in a multi-byte character (big5, cp932, gbk, sjis).
swe7 is also a special character set, because in swe7 0x5C is used for
both escape character and for "LATIN CAPITAL LETTER O WITH DIAERESIS".
Diffstat (limited to 'mysql-test/include/bytes.inc')
| -rw-r--r-- | mysql-test/include/bytes.inc | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/include/bytes.inc b/mysql-test/include/bytes.inc new file mode 100644 index 00000000000..71575992bcf --- /dev/null +++ b/mysql-test/include/bytes.inc @@ -0,0 +1,9 @@ +# +# Create a table with all byte values +# +CREATE TABLE halfs (a INT); +INSERT INTO halfs VALUES (0x00),(0x01),(0x02),(0x03),(0x04),(0x05),(0x06),(0x07); +INSERT INTO halfs VALUES (0x08),(0x09),(0x0A),(0x0B),(0x0C),(0x0D),(0x0E),(0x0F); +CREATE TEMPORARY TABLE bytes (a BINARY(1), KEY(a)) ENGINE=MyISAM; +INSERT INTO bytes SELECT CHAR((t1.a << 4) | t2.a USING BINARY) FROM halfs t1, halfs t2; +DROP TABLE halfs; |