Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_calendar_2_unique_constraints_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 NOT NULL, c2 DATE NULL, c3 DATE NULL, PRIMARY KEY(c1), UNIQUE(c2));
5 SET TIMESTAMP=1171346973;
6 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'4 04:01:01'),NOW());
7 Warnings:
8 Note 1265 Data truncated for column 'c1' at row 1
9 Note 1265 Data truncated for column 'c2' at row 1
10 Note 1265 Data truncated for column 'c3' at row 1
11 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),ADDTIME(NOW(),'3 03:01:01'),NOW());
12 Warnings:
13 Note 1265 Data truncated for column 'c1' at row 1
14 Note 1265 Data truncated for column 'c2' at row 1
15 Note 1265 Data truncated for column 'c3' at row 1
16 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'2 02:01:01'),ADDTIME(NOW(),'2 02:01:01'),NOW());
17 Warnings:
18 Note 1265 Data truncated for column 'c1' at row 1
19 Note 1265 Data truncated for column 'c2' at row 1
20 Note 1265 Data truncated for column 'c3' at row 1
21 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'3 03:01:01'),ADDTIME(NOW(),'1 01:01:01'),NOW());
22 Warnings:
23 Note 1265 Data truncated for column 'c1' at row 1
24 Note 1265 Data truncated for column 'c2' at row 1
25 Note 1265 Data truncated for column 'c3' at row 1
26 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'4 04:01:01'),NOW(),NOW());
27 Warnings:
28 Note 1265 Data truncated for column 'c1' at row 1
29 Note 1265 Data truncated for column 'c2' at row 1
30 Note 1265 Data truncated for column 'c3' at row 1
31 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'2 02:01:01'),ADDTIME(NOW(),'2 02:01:01'),NOW()) ON DUPLICATE KEY UPDATE c3=ADDTIME(NOW(),'6 06:01:01');
32 Warnings:
33 Note 1265 Data truncated for column 'c1' at row 1
34 Note 1265 Data truncated for column 'c2' at row 1
35 Note 1265 Data truncated for column 'c3' at row 1
36 Note 1265 Data truncated for column 'c3' at row 1
37 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c3=ADDTIME(NOW(),'6 06:01:01');
38 Warnings:
39 Note 1265 Data truncated for column 'c1' at row 1
40 Note 1265 Data truncated for column 'c2' at row 1
41 Note 1265 Data truncated for column 'c3' at row 1
42 Note 1265 Data truncated for column 'c3' at row 1
43 SELECT * FROM t1;
44 c1 c2 c3
45 2007-02-13 2007-02-17 2007-02-19
46 2007-02-14 2007-02-16 2007-02-13
47 2007-02-15 2007-02-15 2007-02-19
48 2007-02-16 2007-02-14 2007-02-13
49 2007-02-17 2007-02-13 2007-02-13
50 DROP TABLE t1;
51 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NULL, c3 YEAR NULL, PRIMARY KEY(c1), UNIQUE(c2));
52 INSERT INTO t1 (c1,c2,c3) VALUES(2000,2004,2000);
53 INSERT INTO t1 (c1,c2,c3) VALUES(2001,2003,2000);
54 INSERT INTO t1 (c1,c2,c3) VALUES(2002,2002,2000);
55 INSERT INTO t1 (c1,c2,c3) VALUES(2003,2001,2000);
56 INSERT INTO t1 (c1,c2,c3) VALUES(2004,2000,2000);
57 INSERT INTO t1 (c1,c2,c3) VALUES(2002,2002,2000) ON DUPLICATE KEY UPDATE c3=2011;
58 INSERT INTO t1 (c1,c2,c3) VALUES(2000,2000,2000) ON DUPLICATE KEY UPDATE c3=2011;
59 SELECT * FROM t1;
60 c1 c2 c3
61 2000 2004 2011
62 2001 2003 2000
63 2002 2002 2011
64 2003 2001 2000
65 2004 2000 2000
66 DROP TABLE t1;
67 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NULL, c3 TIME NULL, PRIMARY KEY(c1), UNIQUE(c2));
68 SET TIMESTAMP=1171346973;
69 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'4 04:01:01'),NOW());
70 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),ADDTIME(NOW(),'3 03:01:01'),NOW());
71 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'2 02:01:01'),ADDTIME(NOW(),'2 02:01:01'),NOW());
72 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'3 03:01:01'),ADDTIME(NOW(),'1 01:01:01'),NOW());
73 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'4 04:01:01'),NOW(),NOW());
74 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'2 02:01:01'),ADDTIME(NOW(),'2 02:01:01'),NOW()) ON DUPLICATE KEY UPDATE c3=ADDTIME(NOW(),'6 06:01:01');
75 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c3=ADDTIME(NOW(),'6 06:01:01');
76 SELECT * FROM t1;
77 c1 c2 c3
78 09:09:33 13:10:34 15:10:34
79 10:10:34 12:10:34 09:09:33
80 11:10:34 11:10:34 15:10:34
81 12:10:34 10:10:34 09:09:33
82 13:10:34 09:09:33 09:09:33
83 DROP TABLE t1;
84 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NULL, c3 YEAR NULL, PRIMARY KEY(c1), UNIQUE(c2));
85 INSERT INTO t1 (c1,c2,c3) VALUES(2000,2004,2000);
86 INSERT INTO t1 (c1,c2,c3) VALUES(2001,2003,2000);
87 INSERT INTO t1 (c1,c2,c3) VALUES(2002,2002,2000);
88 INSERT INTO t1 (c1,c2,c3) VALUES(2003,2001,2000);
89 INSERT INTO t1 (c1,c2,c3) VALUES(2004,2000,2000);
90 INSERT INTO t1 (c1,c2,c3) VALUES(2002,2002,2000) ON DUPLICATE KEY UPDATE c3=2011;
91 INSERT INTO t1 (c1,c2,c3) VALUES(2000,2000,2000) ON DUPLICATE KEY UPDATE c3=2011;
92 SELECT * FROM t1;
93 c1 c2 c3
94 2000 2004 2011
95 2001 2003 2000
96 2002 2002 2011
97 2003 2001 2000
98 2004 2000 2000
99 DROP TABLE t1;
100 CREATE TABLE t1(c1 DATETIME NOT NULL, c2 DATETIME NULL, c3 DATETIME NULL, PRIMARY KEY(c1), UNIQUE(c2));
101 SET TIMESTAMP=1171346973;
102 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'4 04:01:01'),NOW());
103 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),ADDTIME(NOW(),'3 03:01:01'),NOW());
104 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'2 02:01:01'),ADDTIME(NOW(),'2 02:01:01'),NOW());
105 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'3 03:01:01'),ADDTIME(NOW(),'1 01:01:01'),NOW());
106 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'4 04:01:01'),NOW(),NOW());
107 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'2 02:01:01'),ADDTIME(NOW(),'2 02:01:01'),NOW()) ON DUPLICATE KEY UPDATE c3=ADDTIME(NOW(),'6 06:01:01');
108 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c3=ADDTIME(NOW(),'6 06:01:01');
109 SELECT * FROM t1;
110 c1 c2 c3
111 2007-02-13 09:09:33 2007-02-17 13:10:34 2007-02-19 15:10:34
112 2007-02-14 10:10:34 2007-02-16 12:10:34 2007-02-13 09:09:33
113 2007-02-15 11:10:34 2007-02-15 11:10:34 2007-02-19 15:10:34
114 2007-02-16 12:10:34 2007-02-14 10:10:34 2007-02-13 09:09:33
115 2007-02-17 13:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
116 DROP TABLE t1;
117 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NULL, c3 YEAR NULL, PRIMARY KEY(c1), UNIQUE(c2));
118 INSERT INTO t1 (c1,c2,c3) VALUES(2000,2004,2000);
119 INSERT INTO t1 (c1,c2,c3) VALUES(2001,2003,2000);
120 INSERT INTO t1 (c1,c2,c3) VALUES(2002,2002,2000);
121 INSERT INTO t1 (c1,c2,c3) VALUES(2003,2001,2000);
122 INSERT INTO t1 (c1,c2,c3) VALUES(2004,2000,2000);
123 INSERT INTO t1 (c1,c2,c3) VALUES(2002,2002,2000) ON DUPLICATE KEY UPDATE c3=2011;
124 INSERT INTO t1 (c1,c2,c3) VALUES(2000,2000,2000) ON DUPLICATE KEY UPDATE c3=2011;
125 SELECT * FROM t1;
126 c1 c2 c3
127 2000 2004 2011
128 2001 2003 2000
129 2002 2002 2011
130 2003 2001 2000
131 2004 2000 2000
132 DROP TABLE t1;
133 SET TIME_ZONE= @@global.time_zone;
134 SET sql_mode=default;