bugfix: reset MODE_NO_BACKSLASH_ESCAPES during vcol parsing

1 files changed, 14 insertions, 0 deletions

diff --git a/mysql-test/t/func_like.test b/mysql-test/t/func_like.test
index ed648fdc70a..b65bff63298 100644
--- a/mysql-test/t/func_like.test
+++ b/mysql-test/t/func_like.test
@@ -193,3 +193,17 @@ create view v1 as select 'foo!' like 'foo!!', 'foo!' like 'foo!!' escape '!';
 show create view v1;
 select * from v1;
 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;
+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;
+drop table t1;