diff options
Diffstat (limited to 'mysql-test/t/ctype_uca.test')
-rw-r--r-- | mysql-test/t/ctype_uca.test | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/t/ctype_uca.test b/mysql-test/t/ctype_uca.test index 5e8195e4718..3e5fa873e9b 100644 --- a/mysql-test/t/ctype_uca.test +++ b/mysql-test/t/ctype_uca.test @@ -620,3 +620,29 @@ DROP TABLE t1; --echo # --echo # End of MariaDB-10.0 tests --echo # + +--echo # +--echo # Start of MariaDB-10.1 tests +--echo # + +--echo # +--echo # MDEV-6973 XOR aggregates argument collations +--echo # +SELECT '10' COLLATE utf8_general_ci XOR '20' COLLATE utf8_unicode_ci; + +--echo # +--echo # MDEV-8705 Wrong result for SELECT..WHERE latin1_bin_column='a' AND latin1_bin_column='A' +--echo # +SET NAMES utf8 COLLATE utf8_german2_ci; +CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_bin); +INSERT INTO t1 VALUES ('a'),('A'); +SELECT * FROM t1 WHERE a='a'; +SELECT * FROM t1 WHERE a=_utf8'a'; +# Make sure this does not return "Illegal mix of collations" +SELECT * FROM t1 WHERE a='a' AND a=_utf8'a'; +DROP TABLE t1; +SET NAMES utf8; + +--echo # +--echo # End of MariaDB-10.1 tests +--echo # |