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 | 824111e6c4583441719bd6fa431b6aedcab8fff6 (patch) | |
| tree | 9d651b5aef31bc35f35f5032256af6b1e127a0a1 /mysql-test/r/func_like.result | |
| parent | d9ada7c257a4af713393cc536938e80156810418 (diff) | |
| download | mariadb-git-824111e6c4583441719bd6fa431b6aedcab8fff6.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; |