diff options
Diffstat (limited to 'mysql-test/t/insert.test')
| -rw-r--r-- | mysql-test/t/insert.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/t/insert.test b/mysql-test/t/insert.test index ff8396fd7fd..2d95dffa17a 100644 --- a/mysql-test/t/insert.test +++ b/mysql-test/t/insert.test @@ -30,7 +30,7 @@ drop table t1; # Test insert syntax # -create table t1 (a int not null auto_increment, primary key (a), t timestamp, c char(10) default "hello", i int); +create table t1 (a int not null auto_increment, primary key (a), t timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, c char(10) default "hello", i int); insert into t1 values (default,default,default,default), (default,default,default,default), (4,0,"a",5),(default,default,default,default); select a,t>0,c,i from t1; truncate table t1; |