summaryrefslogtreecommitdiff
path: root/mysql-test/main/old-mode.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/old-mode.result')
-rw-r--r--mysql-test/main/old-mode.result4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/old-mode.result b/mysql-test/main/old-mode.result
index e0a3412bbdf..44e8f5bfece 100644
--- a/mysql-test/main/old-mode.result
+++ b/mysql-test/main/old-mode.result
@@ -129,7 +129,7 @@ DROP TABLE t1;
SET @@global.mysql56_temporal_format=DEFAULT;
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 ();
@@ -158,7 +158,7 @@ a unix_timestamp(a)
2010-10-31 02:25:26 1288481126
drop table t1;
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;