2
DROP TABLE IF EXISTS t1;
4
# Set Correct timezone to match result
5
SET TIME_ZONE="+03:00";
6
CREATE TABLE t1(c1 DATE NOT NULL PRIMARY KEY);
7
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
8
INSERT INTO t1 (c1) VALUES(NOW());
9
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
11
INSERT INTO t1 (c1) VALUES(NOW());
14
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
15
INSERT INTO t1 (c1) VALUES(1999);
16
INSERT INTO t1 (c1) VALUES(2000);
18
INSERT INTO t1 (c1) VALUES(1999);
21
CREATE TABLE t1(c1 TIME NOT NULL PRIMARY KEY);
22
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
23
INSERT INTO t1 (c1) VALUES(NOW());
24
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
26
INSERT INTO t1 (c1) VALUES(NOW());
29
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
30
INSERT INTO t1 (c1) VALUES(1999);
31
INSERT INTO t1 (c1) VALUES(2000);
33
INSERT INTO t1 (c1) VALUES(1999);
36
CREATE TABLE t1(c1 DATETIME NOT NULL PRIMARY KEY);
37
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
38
INSERT INTO t1 (c1) VALUES(NOW());
39
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
41
INSERT INTO t1 (c1) VALUES(NOW());
44
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
45
INSERT INTO t1 (c1) VALUES(1999);
46
INSERT INTO t1 (c1) VALUES(2000);
48
INSERT INTO t1 (c1) VALUES(1999);
51
CREATE TABLE t1(c1 TIMESTAMP NOT NULL PRIMARY KEY);
52
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
53
INSERT INTO t1 (c1) VALUES(NOW());
54
INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
56
INSERT INTO t1 (c1) VALUES(NOW());
59
CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
60
INSERT INTO t1 (c1) VALUES(1999);
61
INSERT INTO t1 (c1) VALUES(2000);
63
INSERT INTO t1 (c1) VALUES(1999);
66
# Restore timezone to default
67
SET TIME_ZONE= @@global.time_zone;