From 6f96fb795684400b06af96ad535d7f84d33a9273 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 9 Dec 2003 12:59:00 +0400 Subject: test for the bug #1885: mysqldump does not dumps timestamp default. --- mysql-test/r/type_timestamp.result | 2 ++ mysql-test/t/type_timestamp.test | 6 ++++++ 2 files changed, 8 insertions(+) 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); -- cgit v1.2.1