diff options
Diffstat (limited to 'mysql-test/main/trigger_null-8605.test')
| -rw-r--r-- | mysql-test/main/trigger_null-8605.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/trigger_null-8605.test b/mysql-test/main/trigger_null-8605.test index 7645b61f5ad..c9a7cd5477d 100644 --- a/mysql-test/main/trigger_null-8605.test +++ b/mysql-test/main/trigger_null-8605.test @@ -152,7 +152,7 @@ drop table t1; --remove_file $datadir/test/mdev8605.txt # timestamps (on NULL = NOW()) -create table t1 (a timestamp, b int auto_increment primary key); +create table t1 (a timestamp not null default now() on update now(), b int auto_increment primary key); create trigger trgi before insert on t1 for each row set new.a=if(new.a is null, '2000-10-20 10:20:30', NULL); set statement timestamp=777777777 for insert t1 (a) values (NULL); set statement timestamp=888888888 for insert t1 (a) values ('1999-12-11 10:9:8'); |