Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT NOT NULL);
3 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4 UPDATE t1 SET c1 = -1 WHERE c1 >= 5;
5 SELECT * FROM t1 ORDER BY c1;
6 c1
7 -1
8 -1
9 -1
10 -1
11 -1
12 0
13 1
14 2
15 3
16 4
17 UPDATE t1 SET c1 = -10;
18 SELECT * FROM t1 ORDER BY c1;
19 c1
20 -10
21 -10
22 -10
23 -10
24 -10
25 -10
26 -10
27 -10
28 -10
29 -10
30 DROP TABLE t1;
31 CREATE TABLE t1(c1 SMALLINT NOT NULL);
32 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
33 UPDATE t1 SET c1 = -1 WHERE c1 >= 5;
34 SELECT * FROM t1 ORDER BY c1;
35 c1
36 -1
37 -1
38 -1
39 -1
40 -1
41 0
42 1
43 2
44 3
45 4
46 UPDATE t1 SET c1 = -10;
47 SELECT * FROM t1 ORDER BY c1;
48 c1
49 -10
50 -10
51 -10
52 -10
53 -10
54 -10
55 -10
56 -10
57 -10
58 -10
59 DROP TABLE t1;
60 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
61 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
62 UPDATE t1 SET c1 = -1 WHERE c1 >= 5;
63 SELECT * FROM t1 ORDER BY c1;
64 c1
65 -1
66 -1
67 -1
68 -1
69 -1
70 0
71 1
72 2
73 3
74 4
75 UPDATE t1 SET c1 = -10;
76 SELECT * FROM t1 ORDER BY c1;
77 c1
78 -10
79 -10
80 -10
81 -10
82 -10
83 -10
84 -10
85 -10
86 -10
87 -10
88 DROP TABLE t1;
89 CREATE TABLE t1(c1 INT NOT NULL);
90 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
91 UPDATE t1 SET c1 = -1 WHERE c1 >= 5;
92 SELECT * FROM t1 ORDER BY c1;
93 c1
94 -1
95 -1
96 -1
97 -1
98 -1
99 0
100 1
101 2
102 3
103 4
104 UPDATE t1 SET c1 = -10;
105 SELECT * FROM t1 ORDER BY c1;
106 c1
107 -10
108 -10
109 -10
110 -10
111 -10
112 -10
113 -10
114 -10
115 -10
116 -10
117 DROP TABLE t1;
118 CREATE TABLE t1(c1 INTEGER NOT NULL);
119 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
120 UPDATE t1 SET c1 = -1 WHERE c1 >= 5;
121 SELECT * FROM t1 ORDER BY c1;
122 c1
123 -1
124 -1
125 -1
126 -1
127 -1
128 0
129 1
130 2
131 3
132 4
133 UPDATE t1 SET c1 = -10;
134 SELECT * FROM t1 ORDER BY c1;
135 c1
136 -10
137 -10
138 -10
139 -10
140 -10
141 -10
142 -10
143 -10
144 -10
145 -10
146 DROP TABLE t1;
147 CREATE TABLE t1(c1 BIGINT NOT NULL);
148 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
149 UPDATE t1 SET c1 = -1 WHERE c1 >= 5;
150 SELECT * FROM t1 ORDER BY c1;
151 c1
152 -1
153 -1
154 -1
155 -1
156 -1
157 0
158 1
159 2
160 3
161 4
162 UPDATE t1 SET c1 = -10;
163 SELECT * FROM t1 ORDER BY c1;
164 c1
165 -10
166 -10
167 -10
168 -10
169 -10
170 -10
171 -10
172 -10
173 -10
174 -10
175 DROP TABLE t1;
176 CREATE TABLE t1(c1 TINYINT NOT NULL);
177 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
178 UPDATE IGNORE t1 SET c1 = -1 WHERE c1 >= 5;
179 SELECT * FROM t1 ORDER BY c1;
180 c1
181 -1
182 -1
183 -1
184 -1
185 -1
186 0
187 1
188 2
189 3
190 4
191 UPDATE IGNORE t1 SET c1 = -10;
192 SELECT * FROM t1 ORDER BY c1;
193 c1
194 -10
195 -10
196 -10
197 -10
198 -10
199 -10
200 -10
201 -10
202 -10
203 -10
204 DROP TABLE t1;
205 CREATE TABLE t1(c1 SMALLINT NOT NULL);
206 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
207 UPDATE IGNORE t1 SET c1 = -1 WHERE c1 >= 5;
208 SELECT * FROM t1 ORDER BY c1;
209 c1
210 -1
211 -1
212 -1
213 -1
214 -1
215 0
216 1
217 2
218 3
219 4
220 UPDATE IGNORE t1 SET c1 = -10;
221 SELECT * FROM t1 ORDER BY c1;
222 c1
223 -10
224 -10
225 -10
226 -10
227 -10
228 -10
229 -10
230 -10
231 -10
232 -10
233 DROP TABLE t1;
234 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
235 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
236 UPDATE IGNORE t1 SET c1 = -1 WHERE c1 >= 5;
237 SELECT * FROM t1 ORDER BY c1;
238 c1
239 -1
240 -1
241 -1
242 -1
243 -1
244 0
245 1
246 2
247 3
248 4
249 UPDATE IGNORE t1 SET c1 = -10;
250 SELECT * FROM t1 ORDER BY c1;
251 c1
252 -10
253 -10
254 -10
255 -10
256 -10
257 -10
258 -10
259 -10
260 -10
261 -10
262 DROP TABLE t1;
263 CREATE TABLE t1(c1 INT NOT NULL);
264 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
265 UPDATE IGNORE t1 SET c1 = -1 WHERE c1 >= 5;
266 SELECT * FROM t1 ORDER BY c1;
267 c1
268 -1
269 -1
270 -1
271 -1
272 -1
273 0
274 1
275 2
276 3
277 4
278 UPDATE IGNORE t1 SET c1 = -10;
279 SELECT * FROM t1 ORDER BY c1;
280 c1
281 -10
282 -10
283 -10
284 -10
285 -10
286 -10
287 -10
288 -10
289 -10
290 -10
291 DROP TABLE t1;
292 CREATE TABLE t1(c1 INTEGER NOT NULL);
293 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
294 UPDATE IGNORE t1 SET c1 = -1 WHERE c1 >= 5;
295 SELECT * FROM t1 ORDER BY c1;
296 c1
297 -1
298 -1
299 -1
300 -1
301 -1
302 0
303 1
304 2
305 3
306 4
307 UPDATE IGNORE t1 SET c1 = -10;
308 SELECT * FROM t1 ORDER BY c1;
309 c1
310 -10
311 -10
312 -10
313 -10
314 -10
315 -10
316 -10
317 -10
318 -10
319 -10
320 DROP TABLE t1;
321 CREATE TABLE t1(c1 BIGINT NOT NULL);
322 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
323 UPDATE IGNORE t1 SET c1 = -1 WHERE c1 >= 5;
324 SELECT * FROM t1 ORDER BY c1;
325 c1
326 -1
327 -1
328 -1
329 -1
330 -1
331 0
332 1
333 2
334 3
335 4
336 UPDATE IGNORE t1 SET c1 = -10;
337 SELECT * FROM t1 ORDER BY c1;
338 c1
339 -10
340 -10
341 -10
342 -10
343 -10
344 -10
345 -10
346 -10
347 -10
348 -10
349 DROP TABLE t1;