diff options
Diffstat (limited to 'mysql-test/t/null.test')
| -rw-r--r-- | mysql-test/t/null.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/null.test b/mysql-test/t/null.test index 65a45b9a21c..695c22f3bbd 100644 --- a/mysql-test/t/null.test +++ b/mysql-test/t/null.test @@ -868,6 +868,16 @@ CREATE TABLE t1 AS SELECT END AS b; DROP TABLE t1; +--echo # +--echo # MDEV-8785 Wrong results for EXPLAIN EXTENDED...WHERE NULLIF(latin1_col, _utf8'a' COLLATE utf8_bin) IS NOT NULL +--echo # +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; +SELECT CHARSET(NULLIF(a,_utf8'a' COLLATE utf8_bin)) FROM t1; +EXPLAIN EXTENDED SELECT NULLIF(a,_utf8'a' COLLATE utf8_bin) IS NULL AS expr FROM t1; +DROP TABLE t1; + --echo # --echo # End of 10.1 tests |