From 45e0373a7818f137bfbbf5d354c78055cec6c82b Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Sun, 12 Jun 2022 22:01:56 +0200 Subject: MDEV-28632 Change default of explicit_defaults_for_timestamp to ON --- mysql-test/main/func_default.test | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/main/func_default.test') diff --git a/mysql-test/main/func_default.test b/mysql-test/main/func_default.test index d2099d3ef4c..3cb88b7b597 100644 --- a/mysql-test/main/func_default.test +++ b/mysql-test/main/func_default.test @@ -151,7 +151,7 @@ select default(a) = now() from v2; drop view v1, v2; drop table t1; -create table t1 (v1 timestamp) select 'x'; +create table t1 (v1 timestamp not null default now() on update now()) select 'x'; show create table t1; select default(v1) from (select v1 from t1) dt; select default(v1) from (select v1 from t1 group by v1) dt; -- cgit v1.2.1