Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 SET TIME_ZONE="+03:00";
3 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NOT NULL, c3 DATE NOT NULL, PRIMARY KEY(c1,c2,c3));
4 SET TIMESTAMP=1171346973;
5 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
6 Warnings:
7 Note 1265 Data truncated for column 'c1' at row 1
8 Note 1265 Data truncated for column 'c2' at row 1
9 Note 1265 Data truncated for column 'c3' at row 1
10 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
11 Warnings:
12 Note 1265 Data truncated for column 'c1' at row 1
13 Note 1265 Data truncated for column 'c2' at row 1
14 Note 1265 Data truncated for column 'c3' at row 1
15 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
16 Warnings:
17 Note 1265 Data truncated for column 'c1' at row 1
18 Note 1265 Data truncated for column 'c2' at row 1
19 Note 1265 Data truncated for column 'c3' at row 1
20 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
21 Warnings:
22 Note 1265 Data truncated for column 'c1' at row 1
23 Note 1265 Data truncated for column 'c2' at row 1
24 Note 1265 Data truncated for column 'c3' at row 1
25 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01'),c3=ADDTIME(NOW(),'2 02:01:01');
26 Warnings:
27 Note 1265 Data truncated for column 'c1' at row 1
28 Note 1265 Data truncated for column 'c2' at row 1
29 Note 1265 Data truncated for column 'c3' at row 1
30 Note 1265 Data truncated for column 'c1' at row 1
31 Note 1265 Data truncated for column 'c2' at row 1
32 Note 1265 Data truncated for column 'c3' at row 1
33 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01')) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01');
34 Warnings:
35 Note 1265 Data truncated for column 'c1' at row 1
36 Note 1265 Data truncated for column 'c2' at row 1
37 Note 1265 Data truncated for column 'c3' at row 1
38 Note 1265 Data truncated for column 'c1' at row 1
39 Note 1265 Data truncated for column 'c2' at row 1
40 SELECT * FROM t1;
41 c1 c2 c3
42 2007-02-13 2007-02-14 2007-02-13
43 2007-02-14 2007-02-13 2007-02-13
44 2007-02-15 2007-02-15 2007-02-14
45 2007-02-15 2007-02-15 2007-02-15
46 DROP TABLE t1;
47 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
48 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
49 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
50 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
51 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
52 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
53 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
54 SELECT * FROM t1;
55 c1 c2 c3
56 1999 2000 1999
57 2000 1999 1999
58 2011 2011 2000
59 2011 2011 2011
60 DROP TABLE t1;
61 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL, c3 TIME NOT NULL, PRIMARY KEY(c1,c2,c3));
62 SET TIMESTAMP=1171346973;
63 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
64 Warnings:
65 Note 1265 Data truncated for column 'c1' at row 1
66 Note 1265 Data truncated for column 'c2' at row 1
67 Note 1265 Data truncated for column 'c3' at row 1
68 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
69 Warnings:
70 Note 1265 Data truncated for column 'c1' at row 1
71 Note 1265 Data truncated for column 'c2' at row 1
72 Note 1265 Data truncated for column 'c3' at row 1
73 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
74 Warnings:
75 Note 1265 Data truncated for column 'c1' at row 1
76 Note 1265 Data truncated for column 'c2' at row 1
77 Note 1265 Data truncated for column 'c3' at row 1
78 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
79 Warnings:
80 Note 1265 Data truncated for column 'c1' at row 1
81 Note 1265 Data truncated for column 'c2' at row 1
82 Note 1265 Data truncated for column 'c3' at row 1
83 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01'),c3=ADDTIME(NOW(),'2 02:01:01');
84 Warnings:
85 Note 1265 Data truncated for column 'c1' at row 1
86 Note 1265 Data truncated for column 'c2' at row 1
87 Note 1265 Data truncated for column 'c3' at row 1
88 Note 1265 Data truncated for column 'c1' at row 1
89 Note 1265 Data truncated for column 'c2' at row 1
90 Note 1265 Data truncated for column 'c3' at row 1
91 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01')) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01');
92 Warnings:
93 Note 1265 Data truncated for column 'c1' at row 1
94 Note 1265 Data truncated for column 'c2' at row 1
95 Note 1265 Data truncated for column 'c3' at row 1
96 Note 1265 Data truncated for column 'c1' at row 1
97 Note 1265 Data truncated for column 'c2' at row 1
98 SELECT * FROM t1;
99 c1 c2 c3
100 09:09:33 10:10:34 09:09:33
101 10:10:34 09:09:33 09:09:33
102 11:10:34 11:10:34 10:10:34
103 11:10:34 11:10:34 11:10:34
104 DROP TABLE t1;
105 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
106 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
107 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
108 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
109 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
110 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
111 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
112 SELECT * FROM t1;
113 c1 c2 c3
114 1999 2000 1999
115 2000 1999 1999
116 2011 2011 2000
117 2011 2011 2011
118 DROP TABLE t1;
119 CREATE TABLE t1(c1 DATETIME NOT NULL, c2 DATETIME NOT NULL, c3 DATETIME NOT NULL, PRIMARY KEY(c1,c2,c3));
120 SET TIMESTAMP=1171346973;
121 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
122 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
123 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
124 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
125 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01'),c3=ADDTIME(NOW(),'2 02:01:01');
126 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01')) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01');
127 SELECT * FROM t1;
128 c1 c2 c3
129 2007-02-13 09:09:33 2007-02-14 10:10:34 2007-02-13 09:09:33
130 2007-02-14 10:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
131 2007-02-15 11:10:34 2007-02-15 11:10:34 2007-02-14 10:10:34
132 2007-02-15 11:10:34 2007-02-15 11:10:34 2007-02-15 11:10:34
133 DROP TABLE t1;
134 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
135 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
136 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
137 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
138 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
139 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
140 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
141 SELECT * FROM t1;
142 c1 c2 c3
143 1999 2000 1999
144 2000 1999 1999
145 2011 2011 2000
146 2011 2011 2011
147 DROP TABLE t1;
148 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL, c3 TIMESTAMP NOT NULL, PRIMARY KEY(c1,c2,c3));
149 SET TIMESTAMP=1171346973;
150 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
151 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
152 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
153 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
154 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01'),c3=ADDTIME(NOW(),'2 02:01:01');
155 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01')) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01');
156 SELECT * FROM t1;
157 c1 c2 c3
158 2007-02-13 09:09:33 2007-02-14 10:10:34 2007-02-13 09:09:33
159 2007-02-14 10:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
160 2007-02-15 11:10:34 2007-02-15 11:10:34 2007-02-14 10:10:34
161 2007-02-15 11:10:34 2007-02-15 11:10:34 2007-02-15 11:10:34
162 DROP TABLE t1;
163 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
164 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
165 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
166 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
167 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
168 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
169 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
170 SELECT * FROM t1;
171 c1 c2 c3
172 1999 2000 1999
173 2000 1999 1999
174 2011 2011 2000
175 2011 2011 2011
176 DROP TABLE t1;
177 SET TIME_ZONE= @@global.time_zone;