summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_like.test
diff options
context:
space:
mode:
authorunknown <ram@gw.mysql.r18.ru>2004-01-08 12:24:36 +0400
committerunknown <ram@gw.mysql.r18.ru>2004-01-08 12:24:36 +0400
commitaafca9f08dcf5252fc05eabf9be4f15fe4b65ac2 (patch)
treea9c902383bee8048336b59899ba298130a221bcc /mysql-test/t/func_like.test
parent824111e6c4583441719bd6fa431b6aedcab8fff6 (diff)
downloadmariadb-git-aafca9f08dcf5252fc05eabf9be4f15fe4b65ac2.tar.gz
An improvement of the fix for the bug #2231: string column,
INDEX+LIKE, don't take the ESCAPE character. (ver. 2)
Diffstat (limited to 'mysql-test/t/func_like.test')
-rw-r--r--mysql-test/t/func_like.test1
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/t/func_like.test b/mysql-test/t/func_like.test
index 1e14c70a76a..6d6ee8f86a3 100644
--- a/mysql-test/t/func_like.test
+++ b/mysql-test/t/func_like.test
@@ -29,4 +29,5 @@ drop table t1;
create table t1 (a varchar(10), key(a));
insert into t1 values ('a'), ('a\\b');
select * from t1 where a like 'a\\%' escape '#';
+select * from t1 where a like 'a\\%' escape '#' and a like 'a\\\\b';
drop table t1;