Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 DATE NULL, c2 DATE NULL);
3 SET TIMESTAMP=1171346973;
4 INSERT INTO t1 VALUES(NOW(),NOW());
5 Warnings:
6 Note 1265 Data truncated for column 'c1' at row 1
7 Note 1265 Data truncated for column 'c2' at row 1
8 INSERT INTO t1 VALUES(NOW(),NOW());
9 Warnings:
10 Note 1265 Data truncated for column 'c1' at row 1
11 Note 1265 Data truncated for column 'c2' at row 1
12 ANALYZE TABLE t1;
13 Table Op Msg_type Msg_text
14 test.t1 analyze status Engine-independent statistics collected
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 Warnings:
21 Note 1265 Data truncated for column 'c1' at row 1
22 Note 1265 Data truncated for column 'c2' at row 1
23 INSERT INTO t1 VALUES(NOW(),NOW());
24 Warnings:
25 Note 1265 Data truncated for column 'c1' at row 1
26 Note 1265 Data truncated for column 'c2' at row 1
27 ANALYZE TABLE t1;
28 Table Op Msg_type Msg_text
29 test.t1 analyze status Engine-independent statistics collected
30 test.t1 analyze status OK
31 DROP TABLE t1;
32 CREATE TABLE t1(c1 DATETIME NULL, c2 DATETIME NULL);
33 SET TIMESTAMP=1171346973;
34 INSERT INTO t1 VALUES(NOW(),NOW());
35 INSERT INTO t1 VALUES(NOW(),NOW());
36 ANALYZE TABLE t1;
37 Table Op Msg_type Msg_text
38 test.t1 analyze status Engine-independent statistics collected
39 test.t1 analyze status OK
40 DROP TABLE t1;
41 CREATE TABLE t1(c1 TIMESTAMP NULL, c2 TIMESTAMP NULL);
42 SET TIMESTAMP=1171346973;
43 INSERT INTO t1 VALUES(NOW(),NOW());
44 INSERT INTO t1 VALUES(NOW(),NOW());
45 ANALYZE TABLE t1;
46 Table Op Msg_type Msg_text
47 test.t1 analyze status Engine-independent statistics collected
48 test.t1 analyze status OK
49 DROP TABLE t1;