[tomato.git] / release / src / router / mysql / mysql-test / suite / engines / funcs / t / an_calendar.test
| blob | 250c8aa1652eab0377cc0e2b2693c4a4abd9e435 |
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 DATE NULL, c2 DATE NULL);
5 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
6 INSERT INTO t1 VALUES(NOW(),NOW());
7 INSERT INTO t1 VALUES(NOW(),NOW());
8 ANALYZE TABLE t1;
9 DROP TABLE t1;
10 CREATE TABLE t1(c1 TIME NULL, c2 TIME NULL);
11 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
12 INSERT INTO t1 VALUES(NOW(),NOW());
13 INSERT INTO t1 VALUES(NOW(),NOW());
14 ANALYZE TABLE t1;
15 DROP TABLE t1;
16 CREATE TABLE t1(c1 DATETIME NULL, c2 DATETIME NULL);
17 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
18 INSERT INTO t1 VALUES(NOW(),NOW());
19 INSERT INTO t1 VALUES(NOW(),NOW());
20 ANALYZE TABLE t1;
21 DROP TABLE t1;
22 CREATE TABLE t1(c1 TIMESTAMP NULL, c2 TIMESTAMP NULL);
23 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
24 INSERT INTO t1 VALUES(NOW(),NOW());
25 INSERT INTO t1 VALUES(NOW(),NOW());
26 ANALYZE TABLE t1;
27 DROP TABLE t1;