diff options
Diffstat (limited to 'mysql-test/suite/vcol/t/update.test')
| -rw-r--r-- | mysql-test/suite/vcol/t/update.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/suite/vcol/t/update.test b/mysql-test/suite/vcol/t/update.test index 8326afe214f..5899161dced 100644 --- a/mysql-test/suite/vcol/t/update.test +++ b/mysql-test/suite/vcol/t/update.test @@ -72,10 +72,12 @@ drop table t, t2; # create table t1 (a int, b int, c int, d int, e int); insert t1 values (1,2,3,4,5), (1,2,3,4,5); +set sql_mode = 'NO_ENGINE_SUBSTITUTION'; create table t (a int primary key, b int, c blob as (b), index (c(57)), d blob, e blob as (d), index (e(57))) replace select * from t1; +set sql_mode = DEFAULT; check table t; select * from t; update t set a=10, b=1, d=1; check table t; select * from t; |