summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_like.result
diff options
context:
space:
mode:
authorunknown <bar@mysql.com>2005-09-06 16:16:10 +0500
committerunknown <bar@mysql.com>2005-09-06 16:16:10 +0500
commit965afd45a18f0af3395c4750c072788e1f9b2ee1 (patch)
treef5e60a5cc5b8f3d74322e27c60478d1b679f3f79 /mysql-test/r/func_like.result
parente254105bec21fc101326ca366ef85cd0d8d4ed98 (diff)
downloadmariadb-git-965afd45a18f0af3395c4750c072788e1f9b2ee1.tar.gz
func_like.result, func_like.test:
adding test case. item_cmpfunc.cc: Bug#12611 ESCAPE + LIKE do not work when the escape char is a multibyte one Additional fix for 8bit character sets: escape character must be converted into operation character set. sql/item_cmpfunc.cc: Bug#12611 ESCAPE + LIKE do not work when the escape char is a multibyte one Additional fix for 8bit character sets: escape character must be converted into operation character set. mysql-test/t/func_like.test: adding test case. mysql-test/r/func_like.result: adding test case.
Diffstat (limited to 'mysql-test/r/func_like.result')
-rw-r--r--mysql-test/r/func_like.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/func_like.result b/mysql-test/r/func_like.result
index a58432cb06e..bc658f9f7de 100644
--- a/mysql-test/r/func_like.result
+++ b/mysql-test/r/func_like.result
@@ -158,3 +158,10 @@ DROP TABLE t1;
select _cp866'aaaaaaaaa' like _cp866'%aaaa%' collate cp866_bin;
_cp866'aaaaaaaaa' like _cp866'%aaaa%' collate cp866_bin
1
+set names koi8r;
+select 'andre%' like 'andreÊ%' escape 'Ê';
+'andre%' like 'andreÊ%' escape 'Ê'
+1
+select _cp1251'andre%' like convert('andreÊ%' using cp1251) escape 'Ê';
+_cp1251'andre%' like convert('andreÊ%' using cp1251) escape 'Ê'
+1