Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t3;
3 --enable_warnings
4 SET sql_mode='NO_ENGINE_SUBSTITUTION';
5 CREATE TABLE t3(c1 DATE NOT NULL);
6 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
7 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
8 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
9 INSERT INTO t3 VALUES('2008-02-29 13:13:13');
10 DROP TABLE t3;
11 CREATE TABLE t3(c1 DATETIME NOT NULL);
12 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
13 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
14 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
15 INSERT INTO t3 VALUES('2008-02-29 13:13:13');
16 DROP TABLE t3;
17 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
18 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
19 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
20 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
21 INSERT INTO t3 VALUES('2008-02-29 13:13:13');
22 DROP TABLE t3;
23 CREATE TABLE t3(c1 TIME NOT NULL);
24 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
25 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
26 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
27 INSERT INTO t3 VALUES('2008-02-29 13:13:13');
28 DROP TABLE t3;
29 SET sql_mode=default;