diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2003-12-30 19:23:38 +0400 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2003-12-30 19:23:38 +0400 |
| commit | a62e02c387df971b340654f4fb9e4a05f094e5ec (patch) | |
| tree | 9d651b5aef31bc35f35f5032256af6b1e127a0a1 /mysql-test/r/func_like.result | |
| parent | 859da0aa383eb5862db26a00984ef983919896d4 (diff) | |
| download | mariadb-git-a62e02c387df971b340654f4fb9e4a05f094e5ec.tar.gz | |
Fix for the bug #2231: string column, INDEX+LIKE, don't take the ESCAPE character.
(acctually i don't like the fix, any suggestions?)
Diffstat (limited to 'mysql-test/r/func_like.result')
| -rw-r--r-- | mysql-test/r/func_like.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/func_like.result b/mysql-test/r/func_like.result index f923c16b2ac..0f94348a5f8 100644 --- a/mysql-test/r/func_like.result +++ b/mysql-test/r/func_like.result @@ -37,3 +37,9 @@ select * from t1 where a like "%abc\d%"; a abcd 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 '#'; +a +a\b +drop table t1; |