diff options
| author | dlenev@brandersnatch.localdomain <> | 2004-06-22 19:27:16 +0400 |
|---|---|---|
| committer | dlenev@brandersnatch.localdomain <> | 2004-06-22 19:27:16 +0400 |
| commit | eea19e52352e739cda7ea7b137710356809d04ec (patch) | |
| tree | d0e1e3af3a439cdd96e7e95fea25e1dc8d02a760 /mysql-test/r/func_like.result | |
| parent | 6b45c24d398e23a758917e3d03c9644c17d60bb3 (diff) | |
| download | mariadb-git-eea19e52352e739cda7ea7b137710356809d04ec.tar.gz | |
Fix for Bug# 4200 "Parse error on LIKE ESCAPE with parameter binding"
Now ESCAPE in LIKE will accept not only string literal but constant
delimited expression.
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 75692738caf..f2c11bc51f6 100644 --- a/mysql-test/r/func_like.result +++ b/mysql-test/r/func_like.result @@ -45,6 +45,12 @@ a\b select * from t1 where a like 'a\\%' escape '#' and a like 'a\\\\b'; a a\b +prepare stmt1 from 'select * from t1 where a like \'a\\%\' escape ?'; +set @esc='#'; +execute stmt1 using @esc; +a +a\b +deallocate prepare stmt1; drop table t1; create table t1 (a datetime); insert into t1 values ('2004-03-11 12:00:21'); |