summaryrefslogtreecommitdiff
path: root/mysql-test/main/old-mode.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/old-mode.test')
-rw-r--r--mysql-test/main/old-mode.test4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/old-mode.test b/mysql-test/main/old-mode.test
index a09de1cf87d..0419be4bf6a 100644
--- a/mysql-test/main/old-mode.test
+++ b/mysql-test/main/old-mode.test
@@ -91,7 +91,7 @@ SET @@global.mysql56_temporal_format=DEFAULT;
# Copy_field
set time_zone='Europe/Moscow';
set global mysql56_temporal_format=false;
-create table t1 (a timestamp);
+create table t1 (a timestamp not null default now());
set timestamp=1288477526;
insert t1 values (null);
insert t1 values ();
@@ -107,7 +107,7 @@ drop table t1;
# field_conv_incompatible()
set global mysql56_temporal_format=false;
-create table t1 (a timestamp);
+create table t1 (a timestamp not null default now());
set timestamp=1288477526;
insert t1 values (null);
set timestamp=1288481126;