Debian Codegraph @

mysql-test/suite/engines/funcs/r/an_calendar.result

raw
1 DROP TABLE IF EXISTS t1;
2 SET sql_mode='NO_ENGINE_SUBSTITUTION';
3 CREATE TABLE t1(c1 DATE NULL, c2 DATE NULL);
4 SET TIMESTAMP=1171346973;
5 INSERT INTO t1 VALUES(NOW(),NOW());
6 Warnings:
7 Note 1265 Data truncated for column 'c1' at row 1
8 Note 1265 Data truncated for column 'c2' at row 1
9 INSERT INTO t1 VALUES(NOW(),NOW());
10 Warnings:
11 Note 1265 Data truncated for column 'c1' at row 1
12 Note 1265 Data truncated for column 'c2' at row 1
13 ANALYZE TABLE t1;
14 Table Op Msg_type Msg_text
15 test.t1 analyze status OK
16 DROP TABLE t1;
17 CREATE TABLE t1(c1 TIME NULL, c2 TIME NULL);
18 SET TIMESTAMP=1171346973;
19 INSERT INTO t1 VALUES(NOW(),NOW());
20 INSERT INTO t1 VALUES(NOW(),NOW());
21 ANALYZE TABLE t1;
22 Table Op Msg_type Msg_text
23 test.t1 analyze status OK
24 DROP TABLE t1;
25 CREATE TABLE t1(c1 DATETIME NULL, c2 DATETIME NULL);
26 SET TIMESTAMP=1171346973;
27 INSERT INTO t1 VALUES(NOW(),NOW());
28 INSERT INTO t1 VALUES(NOW(),NOW());
29 ANALYZE TABLE t1;
30 Table Op Msg_type Msg_text
31 test.t1 analyze status OK
32 DROP TABLE t1;
33 CREATE TABLE t1(c1 TIMESTAMP NULL, c2 TIMESTAMP NULL);
34 SET TIMESTAMP=1171346973;
35 INSERT INTO t1 VALUES(NOW(),NOW());
36 INSERT INTO t1 VALUES(NOW(),NOW());
37 ANALYZE TABLE t1;
38 Table Op Msg_type Msg_text
39 test.t1 analyze status OK
40 DROP TABLE t1;
41 SET sql_mode=default;