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/t/null.test | |
| 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/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 |