Debian Codegraph @

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

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