summaryrefslogtreecommitdiff
path: root/mysql-test/main/func_default.test
diff options
context:
space:
mode:
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 1125ac32e81..ebd4f6e7b1e 100644
--- a/mysql-test/main/func_default.test
+++ b/mysql-test/main/func_default.test
@@ -156,7 +156,7 @@ drop table t1;
--enable_view_protocol
-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;