summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2015-09-07 11:07:40 +0400
committerAlexander Barkov <bar@mariadb.org>2015-09-07 11:07:40 +0400
commit20291639994beaa070b7228eafa7be31eb1d7ff8 (patch)
treea907dd76e5608020f8a798cf1fc97b9322ac675b /mysql-test/r
parentbf7a2bb12cde9d4ec47e400ab645467783cbaf32 (diff)
downloadmariadb-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.result11
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
#