Edit File: an_calendar.test
--disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1(c1 DATE NULL, c2 DATE NULL); SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33 INSERT INTO t1 VALUES(NOW(),NOW()); INSERT INTO t1 VALUES(NOW(),NOW()); ANALYZE TABLE t1; DROP TABLE t1; CREATE TABLE t1(c1 TIME NULL, c2 TIME NULL); SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33 INSERT INTO t1 VALUES(NOW(),NOW()); INSERT INTO t1 VALUES(NOW(),NOW()); ANALYZE TABLE t1; DROP TABLE t1; CREATE TABLE t1(c1 DATETIME NULL, c2 DATETIME NULL); SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33 INSERT INTO t1 VALUES(NOW(),NOW()); INSERT INTO t1 VALUES(NOW(),NOW()); ANALYZE TABLE t1; DROP TABLE t1; CREATE TABLE t1(c1 TIMESTAMP NULL, c2 TIMESTAMP NULL); SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33 INSERT INTO t1 VALUES(NOW(),NOW()); INSERT INTO t1 VALUES(NOW(),NOW()); ANALYZE TABLE t1; DROP TABLE t1;
Back to File Manager