summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_like.result
diff options
context:
space:
mode:
authorbar@mysql.com <>2005-09-06 16:16:10 +0500
committerbar@mysql.com <>2005-09-06 16:16:10 +0500
commitd40278e0415f58f78d12f381eb370aeffe158e12 (patch)
treef5e60a5cc5b8f3d74322e27c60478d1b679f3f79 /mysql-test/r/func_like.result
parentcdf89955d9d5293efc3902fd67675a497b416d27 (diff)
downloadmariadb-git-d40278e0415f58f78d12f381eb370aeffe158e12.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.
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