diff options
| author | ram@gw.mysql.r18.ru <> | 2004-01-08 12:24:36 +0400 |
|---|---|---|
| committer | ram@gw.mysql.r18.ru <> | 2004-01-08 12:24:36 +0400 |
| commit | 75df01727697988b52e616c1f82ab9324ae2663d (patch) | |
| tree | a9c902383bee8048336b59899ba298130a221bcc /mysql-test/t/func_like.test | |
| parent | e49c7ae45fb5dc301700cf9a890889a24ab91c69 (diff) | |
| download | mariadb-git-75df01727697988b52e616c1f82ab9324ae2663d.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.test | 1 |
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; |