diff options
Diffstat (limited to 'mysql-test/r/view.result')
| -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 # |