diff options
author | Alexander Barkov <bar@mariadb.org> | 2015-03-13 16:51:36 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2015-03-13 16:51:36 +0400 |
commit | 197afb413fcc9f06b5e5e6ef41ce980d108b354f (patch) | |
tree | 7052fbaa1bf1af1c5c849e8fda4a3a790af09b25 /mysql-test/r/ctype_big5.result | |
parent | 702fba1511c90ea9c72b6c00122e0f31a05237b4 (diff) | |
download | mariadb-git-197afb413fcc9f06b5e5e6ef41ce980d108b354f.tar.gz |
MDEV-6566 Different INSERT behaviour on bad bytes with and without character set conversion
Diffstat (limited to 'mysql-test/r/ctype_big5.result')
-rw-r--r-- | mysql-test/r/ctype_big5.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/ctype_big5.result b/mysql-test/r/ctype_big5.result index 175bbf0f09f..d18c2a00c6f 100644 --- a/mysql-test/r/ctype_big5.result +++ b/mysql-test/r/ctype_big5.result @@ -597,7 +597,7 @@ Warning 1366 Incorrect string value: '\x80\' for column 'a' at row 61 Warning 1366 Incorrect string value: '\x80]' for column 'a' at row 62 Warning 1366 Incorrect string value: '\x80^' for column 'a' at row 63 Warning 1366 Incorrect string value: '\x80_' for column 'a' at row 64 -SELECT COUNT(*) FROM t1 WHERE a<>''; +SELECT COUNT(*) FROM t1 WHERE a<>'?'; COUNT(*) 13973 SELECT code, hex(upper(a)), hex(lower(a)),a, upper(a), lower(a) FROM t1 WHERE hex(a)<>hex(upper(a)) OR hex(a)<>hex(lower(a)); |