diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2022-06-12 22:01:56 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2022-08-10 15:03:22 +0200 |
| commit | 45e0373a7818f137bfbbf5d354c78055cec6c82b (patch) | |
| tree | 64bfc449bb93f2af74176632f180bbfb4dc157a1 /mysql-test/main/timezone2.test | |
| parent | c38b8f49b8cbe43e20d7710b0d291dd92490fced (diff) | |
| download | mariadb-git-45e0373a7818f137bfbbf5d354c78055cec6c82b.tar.gz | |
MDEV-28632 Change default of explicit_defaults_for_timestamp to ON
Diffstat (limited to 'mysql-test/main/timezone2.test')
| -rw-r--r-- | mysql-test/main/timezone2.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/timezone2.test b/mysql-test/main/timezone2.test index 6a8c9f258e4..d366cb6d4d3 100644 --- a/mysql-test/main/timezone2.test +++ b/mysql-test/main/timezone2.test @@ -556,7 +556,7 @@ SET time_zone=DEFAULT; --echo # 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*/ ; @@ -573,7 +573,7 @@ SET time_zone=DEFAULT; --echo # 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 */ ; |