summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <bar@mysql.com>2004-08-18 12:11:26 +0500
committerunknown <bar@mysql.com>2004-08-18 12:11:26 +0500
commitd8e4cad72ebde4d4b30c5fcb38ab2ac65db889ad (patch)
tree2b509e55bb9cadbecc2edea4067d83ea8f6e2a19 /mysql-test
parenteda663a155d6127d05bfd1beadc648136122b820 (diff)
downloadmariadb-git-d8e4cad72ebde4d4b30c5fcb38ab2ac65db889ad.tar.gz
func_like.result:
LIKE crashed mysqld for binary collations in some cases mysql-test/r/func_like.result: LIKE crashed mysqld for binary collations in some cases
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/func_like.result3
-rw-r--r--mysql-test/t/func_like.test6
2 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/func_like.result b/mysql-test/r/func_like.result
index f2c11bc51f6..a58432cb06e 100644
--- a/mysql-test/r/func_like.result
+++ b/mysql-test/r/func_like.result
@@ -155,3 +155,6 @@ select * from t1 where a like '%ESKA%';
a
PPUH PESKA-I Maria Struniarska
DROP TABLE t1;
+select _cp866'aaaaaaaaa' like _cp866'%aaaa%' collate cp866_bin;
+_cp866'aaaaaaaaa' like _cp866'%aaaa%' collate cp866_bin
+1
diff --git a/mysql-test/t/func_like.test b/mysql-test/t/func_like.test
index ad83202afa0..4ca2f28fa6e 100644
--- a/mysql-test/t/func_like.test
+++ b/mysql-test/t/func_like.test
@@ -90,3 +90,9 @@ select * from t1 where a like '%PES%';
select * from t1 where a like '%PESKA%';
select * from t1 where a like '%ESKA%';
DROP TABLE t1;
+
+#
+# LIKE crashed for binary collations in some cases
+#
+select _cp866'aaaaaaaaa' like _cp866'%aaaa%' collate cp866_bin;
+