summaryrefslogtreecommitdiff
path: root/mysql-test/main/func_default.test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2022-06-12 22:01:56 +0200
committerOleksandr Byelkin <sanja@mariadb.com>2022-08-10 15:03:22 +0200
commit45e0373a7818f137bfbbf5d354c78055cec6c82b (patch)
tree64bfc449bb93f2af74176632f180bbfb4dc157a1 /mysql-test/main/func_default.test
parentc38b8f49b8cbe43e20d7710b0d291dd92490fced (diff)
downloadmariadb-git-45e0373a7818f137bfbbf5d354c78055cec6c82b.tar.gz
MDEV-28632 Change default of explicit_defaults_for_timestamp to ON
Diffstat (limited to 'mysql-test/main/func_default.test')
-rw-r--r--mysql-test/main/func_default.test2
1 files changed, 1 insertions, 1 deletions
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;