diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-09-10 14:04:52 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-09-10 14:04:52 +0400 |
| commit | 4278d6d402b7ff7eeafe264f600cceb7b614792a (patch) | |
| tree | e13ad5d57f8656b0d29e963f8f2819687e47f8d3 /mysql-test/r/explain_json.result | |
| parent | 416b811a4a87ee642fa6ef8bf2c31e7768c597ec (diff) | |
| download | mariadb-git-4278d6d402b7ff7eeafe264f600cceb7b614792a.tar.gz | |
MDEV-8786 Wrong result for SELECT FORMAT=JSON * FROM t1 WHERE a=_latin1 0xDF
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 0507cee62b4..d741c1e5362 100644 --- a/mysql-test/r/explain_json.result +++ b/mysql-test/r/explain_json.result @@ -1070,3 +1070,23 @@ EXPLAIN } } drop table t1; +# +# MDEV-8786 Wrong result for SELECT FORMAT=JSON * FROM t1 WHERE a=_latin1 0xDF +# +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; +EXPLAIN +{ + "query_block": { + "select_id": 1, + "table": { + "table_name": "t1", + "access_type": "ALL", + "rows": 2, + "filtered": 100, + "attached_condition": "(t1.a = _latin1'\xDF')" + } + } +} +DROP TABLE t1; |