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/explain_json.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/explain_json.test')
| -rw-r--r-- | mysql-test/t/explain_json.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/explain_json.test b/mysql-test/t/explain_json.test index e12cbed6d52..1078222725e 100644 --- a/mysql-test/t/explain_json.test +++ b/mysql-test/t/explain_json.test @@ -286,3 +286,11 @@ CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET latin1); INSERT INTO t1 VALUES ('a'),('b'); EXPLAIN FORMAT=JSON SELECT * FROM t1 WHERE a=_latin1 0xDF; 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'); +EXPLAIN FORMAT=JSON SELECT * FROM t1 WHERE NULLIF(a,_utf8'a' COLLATE utf8_bin); +DROP TABLE t1; |