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/t/explain_json.test | |
| 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/t/explain_json.test')
| -rw-r--r-- | mysql-test/t/explain_json.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/explain_json.test b/mysql-test/t/explain_json.test index 3e6f34b854b..e12cbed6d52 100644 --- a/mysql-test/t/explain_json.test +++ b/mysql-test/t/explain_json.test @@ -279,3 +279,10 @@ explain format=json select count(distinct a1,a2,b,c) from t1 where (a2 >= 'b') a drop table t1; +--echo # +--echo # MDEV-8786 Wrong result for SELECT FORMAT=JSON * FROM t1 WHERE a=_latin1 0xDF +--echo # +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; |