diff options
Diffstat (limited to 'mysql-test/main/timezone2.result')
| -rw-r--r-- | mysql-test/main/timezone2.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/timezone2.result b/mysql-test/main/timezone2.result index 806255f26f5..31b17fbc0d9 100644 --- a/mysql-test/main/timezone2.result +++ b/mysql-test/main/timezone2.result @@ -607,7 +607,7 @@ SET time_zone=DEFAULT; # MDEV-19961 MIN(timestamp_column) returns a wrong result in a GROUP BY query # SET time_zone='Europe/Moscow'; -CREATE OR REPLACE TABLE t1 (i INT, d TIMESTAMP); +CREATE OR REPLACE TABLE t1 (i INT, d TIMESTAMP NOT NULL DEFAULT NOW()); SET timestamp=1288477526 /* this is summer time */ ; INSERT INTO t1 VALUES (3,NULL); SET timestamp=1288477526+3599 /* this is winter time*/ ; @@ -629,7 +629,7 @@ SET time_zone=DEFAULT; # MDEV-20397 Support TIMESTAMP, DATETIME, TIME in ROUND() and TRUNCATE() # SET time_zone='Europe/Moscow'; -CREATE TABLE t1 (i INT, d TIMESTAMP(6)); +CREATE TABLE t1 (i INT, d TIMESTAMP(6) NOT NULL DEFAULT NOW()); SET timestamp=1288479599.999999 /* this is the last second in summer time */ ; INSERT INTO t1 VALUES (1,NULL); SET timestamp=1288479600.000000 /* this is the first second in winter time */ ; |