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/explain_json.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/explain_json.result')
| -rw-r--r-- | mysql-test/r/explain_json.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/explain_json.result b/mysql-test/r/explain_json.result index d741c1e5362..07ff72b4208 100644 --- a/mysql-test/r/explain_json.result +++ b/mysql-test/r/explain_json.result @@ -1090,3 +1090,23 @@ EXPLAIN } } 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'); +EXPLAIN FORMAT=JSON SELECT * FROM t1 WHERE NULLIF(a,_utf8'a' COLLATE utf8_bin); +EXPLAIN +{ + "query_block": { + "select_id": 1, + "table": { + "table_name": "t1", + "access_type": "ALL", + "rows": 2, + "filtered": 100, + "attached_condition": "(case when convert(t1.a using utf8) = <cache>((_utf8'a' collate utf8_bin)) then NULL else t1.a end)" + } + } +} +DROP TABLE t1; |