Debian Codegraph @

mysql-test/suite/engines/funcs/t/an_calendar.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 SET sql_mode='NO_ENGINE_SUBSTITUTION';
5 CREATE TABLE t1(c1 DATE NULL, c2 DATE NULL);
6 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
7 INSERT INTO t1 VALUES(NOW(),NOW());
8 INSERT INTO t1 VALUES(NOW(),NOW());
9 ANALYZE TABLE t1;
10 DROP TABLE t1;
11 CREATE TABLE t1(c1 TIME NULL, c2 TIME NULL);
12 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
13 INSERT INTO t1 VALUES(NOW(),NOW());
14 INSERT INTO t1 VALUES(NOW(),NOW());
15 ANALYZE TABLE t1;
16 DROP TABLE t1;
17 CREATE TABLE t1(c1 DATETIME NULL, c2 DATETIME NULL);
18 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
19 INSERT INTO t1 VALUES(NOW(),NOW());
20 INSERT INTO t1 VALUES(NOW(),NOW());
21 ANALYZE TABLE t1;
22 DROP TABLE t1;
23 CREATE TABLE t1(c1 TIMESTAMP NULL, c2 TIMESTAMP NULL);
24 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
25 INSERT INTO t1 VALUES(NOW(),NOW());
26 INSERT INTO t1 VALUES(NOW(),NOW());
27 ANALYZE TABLE t1;
28 DROP TABLE t1;
29 SET sql_mode=default;