diff options
author | unknown <bar@mysql.com> | 2005-09-06 16:16:10 +0500 |
---|---|---|
committer | unknown <bar@mysql.com> | 2005-09-06 16:16:10 +0500 |
commit | 965afd45a18f0af3395c4750c072788e1f9b2ee1 (patch) | |
tree | f5e60a5cc5b8f3d74322e27c60478d1b679f3f79 /mysql-test/r/func_like.result | |
parent | e254105bec21fc101326ca366ef85cd0d8d4ed98 (diff) | |
download | mariadb-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.result | 7 |
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 |