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/default.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/default.test')
| -rw-r--r-- | mysql-test/main/default.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/default.test b/mysql-test/main/default.test index 3064209a4a2..26fc2186533 100644 --- a/mysql-test/main/default.test +++ b/mysql-test/main/default.test @@ -287,7 +287,7 @@ drop table t1; create table t1 (a int); insert into t1 values(-1); -alter table t1 add b int default 1, add c int default -1, add d int default (1+1), add e timestamp; +alter table t1 add b int default 1, add c int default -1, add d int default (1+1), add e timestamp not null default now(); select a,b,c,d,e from t1; insert into t1 values(10,10,10,10,0); alter table t1 add f int default (1+1+1) null, add g int default (1+1+1+1) not null,add h int default (2+2+2+2); |