diff options
author | Alexander Barkov <bar@mariadb.org> | 2015-09-07 11:07:40 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2015-09-07 11:07:40 +0400 |
commit | 20291639994beaa070b7228eafa7be31eb1d7ff8 (patch) | |
tree | a907dd76e5608020f8a798cf1fc97b9322ac675b /mysql-test/r | |
parent | bf7a2bb12cde9d4ec47e400ab645467783cbaf32 (diff) | |
download | mariadb-git-20291639994beaa070b7228eafa7be31eb1d7ff8.tar.gz |
MDEV-8742 Wrong result for SELECT..WHERE view_latin1_swedish_ci_field='a' COLLATE latin1_bin
The fix for MDEV-8749 also fixed MDEV-8742.
Just adding the test case from the bug report.
Diffstat (limited to 'mysql-test/r')
-rw-r--r-- | mysql-test/r/view.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 4b46a67fc23..cfb7eb1cbdc 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -5643,5 +5643,16 @@ a DROP VIEW v1; DROP TABLE t1; # +# MDEV-8742 Wrong result for SELECT..WHERE view_latin1_swedish_ci_field='a' COLLATE latin1_bin +# +CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET latin1); +INSERT INTO t1 VALUES ('a'),('A'); +CREATE VIEW v1 AS SELECT * FROM t1 WHERE a='a'; +SELECT * FROM v1 WHERE a=_latin1'a' COLLATE latin1_bin; +a +a +DROP VIEW v1; +DROP TABLE t1; +# # End of 10.1 tests # |