diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-09-10 15:01:44 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-09-10 15:01:44 +0400 |
| commit | 8e553c455c4740a51d2a7d0e23c3c79863b5df22 (patch) | |
| tree | 8bc4ae106851eb2b6f90d75b4a83c55f7315fdeb /mysql-test/r/null.result | |
| parent | 4278d6d402b7ff7eeafe264f600cceb7b614792a (diff) | |
| download | mariadb-git-8e553c455c4740a51d2a7d0e23c3c79863b5df22.tar.gz | |
MDEV-8785 Wrong results for EXPLAIN EXTENDED...WHERE NULLIF(latin1_col, _utf8'a' COLLATE utf8_bin) IS NOT NULL
Diffstat (limited to 'mysql-test/r/null.result')
| -rw-r--r-- | mysql-test/r/null.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/null.result b/mysql-test/r/null.result index debb3c05681..e5ce6a10f09 100644 --- a/mysql-test/r/null.result +++ b/mysql-test/r/null.result @@ -1390,5 +1390,24 @@ Warning 1292 Incorrect datetime value: '1' Warning 1292 Incorrect datetime value: '1' DROP TABLE t1; # +# MDEV-8785 Wrong results for EXPLAIN EXTENDED...WHERE NULLIF(latin1_col, _utf8'a' COLLATE utf8_bin) IS NOT NULL +# +CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET latin1); +INSERT INTO t1 VALUES ('a'),('A'); +SELECT a, NULLIF(a,_utf8'a' COLLATE utf8_bin) IS NULL FROM t1; +a NULLIF(a,_utf8'a' COLLATE utf8_bin) IS NULL +a 1 +A 0 +SELECT CHARSET(NULLIF(a,_utf8'a' COLLATE utf8_bin)) FROM t1; +CHARSET(NULLIF(a,_utf8'a' COLLATE utf8_bin)) +latin1 +latin1 +EXPLAIN EXTENDED SELECT NULLIF(a,_utf8'a' COLLATE utf8_bin) IS NULL AS expr FROM t1; +id select_type table type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 +Warnings: +Note 1003 select isnull((case when convert(`test`.`t1`.`a` using utf8) = (_utf8'a' collate utf8_bin) then NULL else `test`.`t1`.`a` end)) AS `expr` from `test`.`t1` +DROP TABLE t1; +# # End of 10.1 tests # |