diff options
| author | ram@gw.mysql.r18.ru <> | 2003-12-09 12:59:00 +0400 |
|---|---|---|
| committer | ram@gw.mysql.r18.ru <> | 2003-12-09 12:59:00 +0400 |
| commit | 9428000f4629581082c524f749e88f8b7feae1ab (patch) | |
| tree | 3a5a390f11072f13fec6258d302d7562ce847817 | |
| parent | 34b101cadfa3816f6392653f22993722adbb894f (diff) | |
| download | mariadb-git-9428000f4629581082c524f749e88f8b7feae1ab.tar.gz | |
test for the bug #1885: mysqldump does not dumps timestamp default.
| -rw-r--r-- | mysql-test/r/type_timestamp.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/type_timestamp.test | 6 |
2 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/type_timestamp.result b/mysql-test/r/type_timestamp.result index 9403b73d459..b513f958787 100644 --- a/mysql-test/r/type_timestamp.result +++ b/mysql-test/r/type_timestamp.result @@ -122,3 +122,5 @@ t2 t4 t6 t8 t10 t12 t14 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 1997-12-31 23:47:59 1997-12-31 23:47:59 1997-12-31 23:47:59 1997-12-31 23:47:59 1997-12-31 23:47:59 1997-12-31 23:47:59 1997-12-31 23:47:59 drop table t1; +create table t1 (a timestamp default 1); +Invalid default value for 'a' diff --git a/mysql-test/t/type_timestamp.test b/mysql-test/t/type_timestamp.test index 0c88f1b8025..17f7b7c487f 100644 --- a/mysql-test/t/type_timestamp.test +++ b/mysql-test/t/type_timestamp.test @@ -72,3 +72,9 @@ set new=1; select * from t1; drop table t1; +# +# Bug #1885 +# + +--error 1067 +create table t1 (a timestamp default 1); |