Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 SET TIME_ZONE="+03:00";
3 CREATE TABLE t1(c1 DATE NULL UNIQUE);
4 SET TIMESTAMP=1171346973;
5 INSERT INTO t1 (c1) VALUES(NOW());
6 Warnings:
7 Note 1265 Data truncated for column 'c1' at row 1
8 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
9 Warnings:
10 Note 1265 Data truncated for column 'c1' at row 1
11 INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01');
12 Warnings:
13 Note 1265 Data truncated for column 'c1' at row 1
14 Note 1265 Data truncated for column 'c1' at row 1
15 SELECT * FROM t1;
16 c1
17 2007-02-14
18 2007-02-15
19 DROP TABLE t1;
20 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
21 INSERT INTO t1 (c1) VALUES(1999);
22 INSERT INTO t1 (c1) VALUES(2000);
23 INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011;
24 SELECT * FROM t1;
25 c1
26 2000
27 2011
28 DROP TABLE t1;
29 CREATE TABLE t1(c1 TIME NULL UNIQUE);
30 SET TIMESTAMP=1171346973;
31 INSERT INTO t1 (c1) VALUES(NOW());
32 Warnings:
33 Note 1265 Data truncated for column 'c1' at row 1
34 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
35 Warnings:
36 Note 1265 Data truncated for column 'c1' at row 1
37 INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01');
38 Warnings:
39 Note 1265 Data truncated for column 'c1' at row 1
40 Note 1265 Data truncated for column 'c1' at row 1
41 SELECT * FROM t1;
42 c1
43 10:10:34
44 11:10:34
45 DROP TABLE t1;
46 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
47 INSERT INTO t1 (c1) VALUES(1999);
48 INSERT INTO t1 (c1) VALUES(2000);
49 INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011;
50 SELECT * FROM t1;
51 c1
52 2000
53 2011
54 DROP TABLE t1;
55 CREATE TABLE t1(c1 DATETIME NULL UNIQUE);
56 SET TIMESTAMP=1171346973;
57 INSERT INTO t1 (c1) VALUES(NOW());
58 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
59 INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01');
60 SELECT * FROM t1;
61 c1
62 2007-02-14 10:10:34
63 2007-02-15 11:10:34
64 DROP TABLE t1;
65 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
66 INSERT INTO t1 (c1) VALUES(1999);
67 INSERT INTO t1 (c1) VALUES(2000);
68 INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011;
69 SELECT * FROM t1;
70 c1
71 2000
72 2011
73 DROP TABLE t1;
74 CREATE TABLE t1(c1 TIMESTAMP NULL UNIQUE);
75 SET TIMESTAMP=1171346973;
76 INSERT INTO t1 (c1) VALUES(NOW());
77 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
78 INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01');
79 SELECT * FROM t1;
80 c1
81 2007-02-14 10:10:34
82 2007-02-15 11:10:34
83 DROP TABLE t1;
84 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
85 INSERT INTO t1 (c1) VALUES(1999);
86 INSERT INTO t1 (c1) VALUES(2000);
87 INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011;
88 SELECT * FROM t1;
89 c1
90 2000
91 2011
92 DROP TABLE t1;
93 SET TIME_ZONE= @@global.time_zone;