diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2016-12-07 10:10:08 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-12-12 20:44:46 +0100 |
| commit | b3e335655747c7655e72525d6e47e0cc989e84d9 (patch) | |
| tree | 0e2fcca88bb1504f9b04c59ec19513c47bc6c807 /mysql-test/r | |
| parent | a9a362d3fd52010f601eae99af7e168b370da9d2 (diff) | |
| download | mariadb-git-b3e335655747c7655e72525d6e47e0cc989e84d9.tar.gz | |
bugfix: reset MODE_NO_BACKSLASH_ESCAPES during vcol parsing
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/func_like.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/r/func_like.result b/mysql-test/r/func_like.result index 842ba25e556..0a309bcfab6 100644 --- a/mysql-test/r/func_like.result +++ b/mysql-test/r/func_like.result @@ -262,3 +262,30 @@ select * from v1; 'foo!' like 'foo!!' 'foo!' like 'foo!!' escape '!' 0 1 drop view v1; +create table t1 (a varchar(100), +b int default (a like '%f\\_'), +c int default (a like '%f\\_' escape ''), +d int default (a like '%f\\_' escape '\\')); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) DEFAULT NULL, + `b` int(11) DEFAULT (`a` like '%f\\_'), + `c` int(11) DEFAULT (`a` like '%f\\_' escape ''), + `d` int(11) DEFAULT (`a` like '%f\\_' escape '\\') +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +insert t1 (a) values ('1 f_'), ('1 f\\_'); +set sql_mode=no_backslash_escapes; +insert t1 (a) values ('2 f_'), ('2 f\_'); +flush tables; +insert t1 (a) values ('3 f_'), ('3 f\_'); +set sql_mode=default; +select * from t1; +a b c d +1 f_ 1 0 1 +1 f\_ 0 1 0 +2 f_ 1 0 1 +2 f\_ 0 1 0 +3 f_ 1 0 1 +3 f\_ 0 1 0 +drop table t1; |