1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1(c1 TINYINT NULL, c2 TINYINT NULL, c3 TINYINT NULL, UNIQUE(c1,c2,c3));
3
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
4
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
5
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
6
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
7
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
8
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
9
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
10
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
11
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
12
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
23
CREATE TABLE t1(c1 SMALLINT NULL, c2 SMALLINT NULL, c3 SMALLINT NULL, UNIQUE(c1,c2,c3));
24
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
25
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
26
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
27
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
28
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
29
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
30
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
31
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
32
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
33
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
44
CREATE TABLE t1(c1 MEDIUMINT NULL, c2 MEDIUMINT NULL, c3 MEDIUMINT NULL, UNIQUE(c1,c2,c3));
45
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
46
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
47
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
48
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
49
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
50
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
51
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
52
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
53
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
54
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
65
CREATE TABLE t1(c1 INT NULL, c2 INT NULL, c3 INT NULL, UNIQUE(c1,c2,c3));
66
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
67
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
68
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
69
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
70
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
71
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
72
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
73
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
74
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
75
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
86
CREATE TABLE t1(c1 INTEGER NULL, c2 INTEGER NULL, c3 INTEGER NULL, UNIQUE(c1,c2,c3));
87
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
88
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
89
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
90
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
91
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
92
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
93
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
94
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
95
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
96
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
107
CREATE TABLE t1(c1 BIGINT NULL, c2 BIGINT NULL, c3 BIGINT NULL, UNIQUE(c1,c2,c3));
108
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
109
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
110
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
111
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
112
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
113
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
114
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
115
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
116
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
117
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
128
CREATE TABLE t1(c1 DECIMAL NULL, c2 DECIMAL NULL, c3 DECIMAL NULL, UNIQUE(c1,c2,c3));
129
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
130
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
131
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
132
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
133
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
134
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
135
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
136
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
137
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
138
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
149
CREATE TABLE t1(c1 DEC NULL, c2 DEC NULL, c3 DEC NULL, UNIQUE(c1,c2,c3));
150
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
151
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
152
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
153
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
154
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
155
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
156
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
157
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
158
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
159
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
170
CREATE TABLE t1(c1 FIXED NULL, c2 FIXED NULL, c3 FIXED NULL, UNIQUE(c1,c2,c3));
171
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
172
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
173
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
174
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
175
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
176
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
177
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
178
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
179
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
180
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
191
CREATE TABLE t1(c1 NUMERIC NULL, c2 NUMERIC NULL, c3 NUMERIC NULL, UNIQUE(c1,c2,c3));
192
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
193
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
194
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
195
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
196
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
197
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
198
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
199
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
200
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
201
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
212
CREATE TABLE t1(c1 DOUBLE NULL, c2 DOUBLE NULL, c3 DOUBLE NULL, UNIQUE(c1,c2,c3));
213
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
214
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
215
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
216
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
217
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
218
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
219
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
220
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
221
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
222
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
233
CREATE TABLE t1(c1 REAL NULL, c2 REAL NULL, c3 REAL NULL, UNIQUE(c1,c2,c3));
234
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
235
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
236
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
237
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
238
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
239
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
240
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
241
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
242
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
243
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
254
CREATE TABLE t1(c1 DOUBLE PRECISION NULL, c2 DOUBLE PRECISION NULL, c3 DOUBLE PRECISION NULL, UNIQUE(c1,c2,c3));
255
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
256
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
257
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
258
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
259
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
260
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
261
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
262
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
263
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
264
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;
275
CREATE TABLE t1(c1 FLOAT NULL, c2 FLOAT NULL, c3 FLOAT NULL, UNIQUE(c1,c2,c3));
276
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10);
277
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11);
278
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,10);
279
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,10);
280
INSERT INTO t1 (c1,c2,c3) VALUES(11,11,10);
281
INSERT INTO t1 (c1,c2,c3) VALUES(11,10,11);
282
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11);
283
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,10) ON DUPLICATE KEY UPDATE c1=100,c2=100,c3=100;
284
INSERT INTO t1 (c1,c2,c3) VALUES(10,10,11) ON DUPLICATE KEY UPDATE c1=100,c2=100;
285
INSERT INTO t1 (c1,c2,c3) VALUES(10,11,11) ON DUPLICATE KEY UPDATE c2=100,c3=100;