Debian Codegraph @

mysql-test/suite/gcol/inc/gcol_rejected.inc

raw
1 ################################################################################
2 # inc/gcol_rejected.inc #
3 # #
4 # Purpose: #
5 # Testing rejected generated column additions. #
6 # #
7 ################################################################################
8
9 CREATE TABLE t1 (
10 pk INTEGER PRIMARY KEY,
11 i8 BIGINT,
12 i4 INTEGER,
13 i2 SMALLINT,
14 i1 TINYINT,
15 i8u BIGINT UNSIGNED,
16 i4u INTEGER UNSIGNED,
17 i2u SMALLINT UNSIGNED,
18 i1u TINYINT UNSIGNED,
19 f4 REAL,
20 f8 DOUBLE PRECISION,
21 dc DECIMAL(10, 2),
22 fc CHAR(10),
23 vc VARCHAR(10),
24 fb BINARY(8),
25 vb VARBINARY(8),
26 d DATE,
27 t TIME,
28 dt DATETIME,
29 ts TIMESTAMP
30 );
31
32 INSERT INTO t1 VALUES
33 (0, -9223372036854775808, -2147483648, -32768, -128,
34 0, 0, 0, 0, -99999999.99, -99999999.99, -99999999.99,
35 'abcdefgh', 'abcdefgh', 'abcdefgh', 'abcdefgh',
36 DATE '1000-01-01', TIME '00:00:00', TIMESTAMP '1000-01-01 00:00:00',
37 TIMESTAMP '1970-01-01 12:00:00'),
38 (1, 9223372036854775807, 2147483647, 32767, 127,
39 18446744073709551615, 4294967295, 65535, 255, 99999999.99, 99999999.99,
40 99999999.99, 'abcdefgh', 'abcdefgh', 'abcdefgh', 'abcdefgh',
41 DATE '9999-12-31', TIME '23:59:59', TIMESTAMP '9999-12-31 23:59:59',
42 TIMESTAMP '2038-01-01 23:59:59');
43
44 # MySQL does not report a range error for signed <-> unsigned conversion.
45 # Note also there are several similar anomalies below.
46 #--error ER_WARN_DATA_OUT_OF_RANGE
47 #ALTER TABLE t1 ADD gc BIGINT AS (i8u) STORED;
48 --error ER_WARN_DATA_OUT_OF_RANGE
49 ALTER TABLE t1 ADD gc BIGINT UNSIGNED AS (i8) STORED;
50 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
51 ALTER TABLE t1 ADD gc BIGINT AS (fc) STORED;
52 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
53 ALTER TABLE t1 ADD gc BIGINT AS (vc) STORED;
54 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
55 ALTER TABLE t1 ADD gc BIGINT AS (fb) STORED;
56 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
57 ALTER TABLE t1 ADD gc BIGINT AS (vb) STORED;
58
59 --error ER_WARN_DATA_OUT_OF_RANGE
60 ALTER TABLE t1 ADD gc INTEGER AS (i8) STORED;
61 --error ER_WARN_DATA_OUT_OF_RANGE
62 ALTER TABLE t1 ADD gc INTEGER AS (i8u) STORED;
63 #--error ER_WARN_DATA_OUT_OF_RANGE
64 #ALTER TABLE t1 ADD gc INTEGER AS (i4u) STORED;
65 --error ER_WARN_DATA_OUT_OF_RANGE
66 ALTER TABLE t1 ADD gc INTEGER UNSIGNED AS (i8) STORED;
67 --error ER_WARN_DATA_OUT_OF_RANGE
68 ALTER TABLE t1 ADD gc INTEGER UNSIGNED AS (i8u) STORED;
69 --error ER_WARN_DATA_OUT_OF_RANGE
70 ALTER TABLE t1 ADD gc INTEGER UNSIGNED AS (i4) STORED;
71 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
72 ALTER TABLE t1 ADD gc INTEGER AS (fc) STORED;
73 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
74 ALTER TABLE t1 ADD gc INTEGER AS (vc) STORED;
75 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
76 ALTER TABLE t1 ADD gc INTEGER AS (fb) STORED;
77 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
78 ALTER TABLE t1 ADD gc INTEGER AS (vb) STORED;
79 --error ER_WARN_DATA_OUT_OF_RANGE
80 ALTER TABLE t1 ADD gc INTEGER AS (d) STORED;
81 --error ER_WARN_DATA_OUT_OF_RANGE
82 ALTER TABLE t1 ADD gc INTEGER AS (dt) STORED;
83 --error ER_WARN_DATA_OUT_OF_RANGE
84 ALTER TABLE t1 ADD gc INTEGER AS (ts) STORED;
85
86 --error ER_WARN_DATA_OUT_OF_RANGE
87 ALTER TABLE t1 ADD gc SMALLINT AS (i8) STORED;
88 --error ER_WARN_DATA_OUT_OF_RANGE
89 ALTER TABLE t1 ADD gc SMALLINT AS (i8u) STORED;
90 --error ER_WARN_DATA_OUT_OF_RANGE
91 ALTER TABLE t1 ADD gc SMALLINT AS (i4) STORED;
92 --error ER_WARN_DATA_OUT_OF_RANGE
93 ALTER TABLE t1 ADD gc SMALLINT AS (i4u) STORED;
94 #--error ER_WARN_DATA_OUT_OF_RANGE
95 #ALTER TABLE t1 ADD gc SMALLINT AS (i2u) STORED;
96 --error ER_WARN_DATA_OUT_OF_RANGE
97 ALTER TABLE t1 ADD gc SMALLINT AS (dc) STORED;
98 --error ER_WARN_DATA_OUT_OF_RANGE
99 ALTER TABLE t1 ADD gc SMALLINT AS (f4) STORED;
100 --error ER_WARN_DATA_OUT_OF_RANGE
101 ALTER TABLE t1 ADD gc SMALLINT AS (f8) STORED;
102 --error ER_WARN_DATA_OUT_OF_RANGE
103 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (i8) STORED;
104 --error ER_WARN_DATA_OUT_OF_RANGE
105 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (i8u) STORED;
106 --error ER_WARN_DATA_OUT_OF_RANGE
107 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (i4) STORED;
108 --error ER_WARN_DATA_OUT_OF_RANGE
109 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (i4u) STORED;
110 --error ER_WARN_DATA_OUT_OF_RANGE
111 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (i2) STORED;
112 --error ER_WARN_DATA_OUT_OF_RANGE
113 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (dc) STORED;
114 --error ER_WARN_DATA_OUT_OF_RANGE
115 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (f4) STORED;
116 --error ER_WARN_DATA_OUT_OF_RANGE
117 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (f8) STORED;
118 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
119 ALTER TABLE t1 ADD gc SMALLINT AS (fc) STORED;
120 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
121 ALTER TABLE t1 ADD gc SMALLINT AS (vc) STORED;
122 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
123 ALTER TABLE t1 ADD gc SMALLINT AS (fb) STORED;
124 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
125 ALTER TABLE t1 ADD gc SMALLINT AS (vb) STORED;
126 --error ER_WARN_DATA_OUT_OF_RANGE
127 ALTER TABLE t1 ADD gc SMALLINT AS (t) STORED;
128 --error ER_WARN_DATA_OUT_OF_RANGE
129 ALTER TABLE t1 ADD gc SMALLINT AS (d) STORED;
130 --error ER_WARN_DATA_OUT_OF_RANGE
131 ALTER TABLE t1 ADD gc SMALLINT AS (dt) STORED;
132 --error ER_WARN_DATA_OUT_OF_RANGE
133 ALTER TABLE t1 ADD gc SMALLINT AS (ts) STORED;
134
135 --error ER_WARN_DATA_OUT_OF_RANGE
136 ALTER TABLE t1 ADD gc TINYINT AS (i8) STORED;
137 --error ER_WARN_DATA_OUT_OF_RANGE
138 ALTER TABLE t1 ADD gc TINYINT AS (i8u) STORED;
139 --error ER_WARN_DATA_OUT_OF_RANGE
140 ALTER TABLE t1 ADD gc TINYINT AS (i4) STORED;
141 --error ER_WARN_DATA_OUT_OF_RANGE
142 ALTER TABLE t1 ADD gc TINYINT AS (i4u) STORED;
143 --error ER_WARN_DATA_OUT_OF_RANGE
144 ALTER TABLE t1 ADD gc TINYINT AS (i2) STORED;
145 --error ER_WARN_DATA_OUT_OF_RANGE
146 ALTER TABLE t1 ADD gc TINYINT AS (i2u) STORED;
147 #--error ER_WARN_DATA_OUT_OF_RANGE
148 #ALTER TABLE t1 ADD gc TINYINT AS (i1u) STORED;
149 --error ER_WARN_DATA_OUT_OF_RANGE
150 ALTER TABLE t1 ADD gc TINYINT AS (dc) STORED;
151 --error ER_WARN_DATA_OUT_OF_RANGE
152 ALTER TABLE t1 ADD gc TINYINT AS (f4) STORED;
153 --error ER_WARN_DATA_OUT_OF_RANGE
154 ALTER TABLE t1 ADD gc TINYINT AS (f8) STORED;
155 --error ER_WARN_DATA_OUT_OF_RANGE
156 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i8) STORED;
157 --error ER_WARN_DATA_OUT_OF_RANGE
158 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i8u) STORED;
159 --error ER_WARN_DATA_OUT_OF_RANGE
160 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i4) STORED;
161 --error ER_WARN_DATA_OUT_OF_RANGE
162 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i4u) STORED;
163 --error ER_WARN_DATA_OUT_OF_RANGE
164 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i2) STORED;
165 --error ER_WARN_DATA_OUT_OF_RANGE
166 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i2u) STORED;
167 --error ER_WARN_DATA_OUT_OF_RANGE
168 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i1) STORED;
169 --error ER_WARN_DATA_OUT_OF_RANGE
170 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (dc) STORED;
171 --error ER_WARN_DATA_OUT_OF_RANGE
172 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (f4) STORED;
173 --error ER_WARN_DATA_OUT_OF_RANGE
174 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (f8) STORED;
175 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
176 ALTER TABLE t1 ADD gc TINYINT AS (fc) STORED;
177 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
178 ALTER TABLE t1 ADD gc TINYINT AS (vc) STORED;
179 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
180 ALTER TABLE t1 ADD gc TINYINT AS (fb) STORED;
181 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
182 ALTER TABLE t1 ADD gc TINYINT AS (vb) STORED;
183 --error ER_WARN_DATA_OUT_OF_RANGE
184 ALTER TABLE t1 ADD gc TINYINT AS (t) STORED;
185 --error ER_WARN_DATA_OUT_OF_RANGE
186 ALTER TABLE t1 ADD gc TINYINT AS (d) STORED;
187 --error ER_WARN_DATA_OUT_OF_RANGE
188 ALTER TABLE t1 ADD gc TINYINT AS (dt) STORED;
189 --error ER_WARN_DATA_OUT_OF_RANGE
190 ALTER TABLE t1 ADD gc TINYINT AS (ts) STORED;
191
192 --error ER_WARN_DATA_OUT_OF_RANGE
193 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (i8) STORED;
194 --error ER_WARN_DATA_OUT_OF_RANGE
195 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (i8u) STORED;
196 --error ER_WARN_DATA_OUT_OF_RANGE
197 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (i4) STORED;
198 --error ER_WARN_DATA_OUT_OF_RANGE
199 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (i4u) STORED;
200 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
201 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (fc) STORED;
202 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
203 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (vc) STORED;
204 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
205 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (fb) STORED;
206 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
207 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (vb) STORED;
208 --error ER_WARN_DATA_OUT_OF_RANGE
209 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (dt) STORED;
210 --error ER_WARN_DATA_OUT_OF_RANGE
211 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (ts) STORED;
212
213 --error ER_TRUNCATED_WRONG_VALUE
214 ALTER TABLE t1 ADD gc DATE AS (i8) STORED;
215 --error ER_TRUNCATED_WRONG_VALUE
216 ALTER TABLE t1 ADD gc DATE AS (i4) STORED;
217 --error ER_TRUNCATED_WRONG_VALUE
218 ALTER TABLE t1 ADD gc DATE AS (i2) STORED;
219 --error ER_TRUNCATED_WRONG_VALUE
220 ALTER TABLE t1 ADD gc DATE AS (i1) STORED;
221 --error ER_TRUNCATED_WRONG_VALUE
222 ALTER TABLE t1 ADD gc DATE AS (dc) STORED;
223 --error ER_TRUNCATED_WRONG_VALUE
224 ALTER TABLE t1 ADD gc DATE AS (f4) STORED;
225 --error ER_TRUNCATED_WRONG_VALUE
226 ALTER TABLE t1 ADD gc DATE AS (fc) STORED;
227 --error ER_TRUNCATED_WRONG_VALUE
228 ALTER TABLE t1 ADD gc DATE AS (vc) STORED;
229 --error ER_TRUNCATED_WRONG_VALUE
230 ALTER TABLE t1 ADD gc DATE AS (fb) STORED;
231 --error ER_TRUNCATED_WRONG_VALUE
232 ALTER TABLE t1 ADD gc DATE AS (vb) STORED;
233
234 --error ER_TRUNCATED_WRONG_VALUE
235 ALTER TABLE t1 ADD gc TIME AS (i8) STORED;
236 --error ER_TRUNCATED_WRONG_VALUE
237 ALTER TABLE t1 ADD gc TIME AS (i4) STORED;
238 --error ER_TRUNCATED_WRONG_VALUE
239 ALTER TABLE t1 ADD gc TIME AS (i2) STORED;
240 --error ER_TRUNCATED_WRONG_VALUE
241 ALTER TABLE t1 ADD gc TIME AS (dc) STORED;
242 --error ER_TRUNCATED_WRONG_VALUE
243 ALTER TABLE t1 ADD gc TIME AS (f4) STORED;
244 --error ER_TRUNCATED_WRONG_VALUE
245 ALTER TABLE t1 ADD gc TIME AS (fc) STORED;
246 --error ER_TRUNCATED_WRONG_VALUE
247 ALTER TABLE t1 ADD gc TIME AS (vc) STORED;
248 --error ER_TRUNCATED_WRONG_VALUE
249 ALTER TABLE t1 ADD gc TIME AS (fb) STORED;
250 --error ER_TRUNCATED_WRONG_VALUE
251 ALTER TABLE t1 ADD gc TIME AS (vb) STORED;
252
253 --error ER_TRUNCATED_WRONG_VALUE
254 ALTER TABLE t1 ADD gc DATETIME AS (i8) STORED;
255 --error ER_TRUNCATED_WRONG_VALUE
256 ALTER TABLE t1 ADD gc DATETIME AS (i4) STORED;
257 --error ER_TRUNCATED_WRONG_VALUE
258 ALTER TABLE t1 ADD gc DATETIME AS (i2) STORED;
259 --error ER_TRUNCATED_WRONG_VALUE
260 ALTER TABLE t1 ADD gc DATETIME AS (i1) STORED;
261 --error ER_TRUNCATED_WRONG_VALUE
262 ALTER TABLE t1 ADD gc DATETIME AS (dc) STORED;
263 --error ER_TRUNCATED_WRONG_VALUE
264 ALTER TABLE t1 ADD gc DATETIME AS (f4) STORED;
265 --error ER_TRUNCATED_WRONG_VALUE
266 ALTER TABLE t1 ADD gc DATETIME AS (fc) STORED;
267 --error ER_TRUNCATED_WRONG_VALUE
268 ALTER TABLE t1 ADD gc DATETIME AS (vc) STORED;
269 --error ER_TRUNCATED_WRONG_VALUE
270 ALTER TABLE t1 ADD gc DATETIME AS (fb) STORED;
271 --error ER_TRUNCATED_WRONG_VALUE
272 ALTER TABLE t1 ADD gc DATETIME AS (vb) STORED;
273
274 --error ER_TRUNCATED_WRONG_VALUE
275 ALTER TABLE t1 ADD gc TIMESTAMP AS (i8) STORED;
276 --error ER_TRUNCATED_WRONG_VALUE
277 ALTER TABLE t1 ADD gc TIMESTAMP AS (i4) STORED;
278 --error ER_TRUNCATED_WRONG_VALUE
279 ALTER TABLE t1 ADD gc TIMESTAMP AS (i2) STORED;
280 --error ER_TRUNCATED_WRONG_VALUE
281 ALTER TABLE t1 ADD gc TIMESTAMP AS (i1) STORED;
282 --error ER_TRUNCATED_WRONG_VALUE
283 ALTER TABLE t1 ADD gc TIMESTAMP AS (dc) STORED;
284 --error ER_TRUNCATED_WRONG_VALUE
285 ALTER TABLE t1 ADD gc TIMESTAMP AS (f4) STORED;
286 --error ER_TRUNCATED_WRONG_VALUE
287 ALTER TABLE t1 ADD gc TIMESTAMP AS (fc) STORED;
288 --error ER_TRUNCATED_WRONG_VALUE
289 ALTER TABLE t1 ADD gc TIMESTAMP AS (vc) STORED;
290 --error ER_TRUNCATED_WRONG_VALUE
291 ALTER TABLE t1 ADD gc TIMESTAMP AS (fb) STORED;
292 --error ER_TRUNCATED_WRONG_VALUE
293 ALTER TABLE t1 ADD gc TIMESTAMP AS (vb) STORED;
294
295 #--error ER_WARN_DATA_OUT_OF_RANGE
296 #ALTER TABLE t1 ADD gc BIGINT AS (i8u) VIRTUAL;
297 --error ER_WARN_DATA_OUT_OF_RANGE
298 ALTER TABLE t1 ADD gc BIGINT UNSIGNED AS (i8) VIRTUAL;
299 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
300 ALTER TABLE t1 ADD gc BIGINT AS (fc) VIRTUAL;
301 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
302 ALTER TABLE t1 ADD gc BIGINT AS (vc) VIRTUAL;
303 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
304 ALTER TABLE t1 ADD gc BIGINT AS (fb) VIRTUAL;
305 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
306 ALTER TABLE t1 ADD gc BIGINT AS (vb) VIRTUAL;
307
308 --error ER_WARN_DATA_OUT_OF_RANGE
309 ALTER TABLE t1 ADD gc INTEGER AS (i8) VIRTUAL;
310 --error ER_WARN_DATA_OUT_OF_RANGE
311 ALTER TABLE t1 ADD gc INTEGER AS (i8u) VIRTUAL;
312 #--error ER_WARN_DATA_OUT_OF_RANGE
313 #ALTER TABLE t1 ADD gc INTEGER AS (i4u) VIRTUAL;
314 --error ER_WARN_DATA_OUT_OF_RANGE
315 ALTER TABLE t1 ADD gc INTEGER UNSIGNED AS (i8) VIRTUAL;
316 --error ER_WARN_DATA_OUT_OF_RANGE
317 ALTER TABLE t1 ADD gc INTEGER UNSIGNED AS (i8u) VIRTUAL;
318 --error ER_WARN_DATA_OUT_OF_RANGE
319 ALTER TABLE t1 ADD gc INTEGER UNSIGNED AS (i4) VIRTUAL;
320 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
321 ALTER TABLE t1 ADD gc INTEGER AS (fc) VIRTUAL;
322 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
323 ALTER TABLE t1 ADD gc INTEGER AS (vc) VIRTUAL;
324 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
325 ALTER TABLE t1 ADD gc INTEGER AS (fb) VIRTUAL;
326 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
327 ALTER TABLE t1 ADD gc INTEGER AS (vb) VIRTUAL;
328 --error ER_WARN_DATA_OUT_OF_RANGE
329 ALTER TABLE t1 ADD gc INTEGER AS (d) VIRTUAL;
330 --error ER_WARN_DATA_OUT_OF_RANGE
331 ALTER TABLE t1 ADD gc INTEGER AS (dt) VIRTUAL;
332 --error ER_WARN_DATA_OUT_OF_RANGE
333 ALTER TABLE t1 ADD gc INTEGER AS (ts) VIRTUAL;
334
335 --error ER_WARN_DATA_OUT_OF_RANGE
336 ALTER TABLE t1 ADD gc SMALLINT AS (i8) VIRTUAL;
337 --error ER_WARN_DATA_OUT_OF_RANGE
338 ALTER TABLE t1 ADD gc SMALLINT AS (i8u) VIRTUAL;
339 --error ER_WARN_DATA_OUT_OF_RANGE
340 ALTER TABLE t1 ADD gc SMALLINT AS (i4) VIRTUAL;
341 --error ER_WARN_DATA_OUT_OF_RANGE
342 ALTER TABLE t1 ADD gc SMALLINT AS (i4u) VIRTUAL;
343 #--error ER_WARN_DATA_OUT_OF_RANGE
344 #ALTER TABLE t1 ADD gc SMALLINT AS (i2u) VIRTUAL;
345 --error ER_WARN_DATA_OUT_OF_RANGE
346 ALTER TABLE t1 ADD gc SMALLINT AS (dc) VIRTUAL;
347 --error ER_WARN_DATA_OUT_OF_RANGE
348 ALTER TABLE t1 ADD gc SMALLINT AS (f4) VIRTUAL;
349 --error ER_WARN_DATA_OUT_OF_RANGE
350 ALTER TABLE t1 ADD gc SMALLINT AS (f8) VIRTUAL;
351 --error ER_WARN_DATA_OUT_OF_RANGE
352 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (i8) VIRTUAL;
353 --error ER_WARN_DATA_OUT_OF_RANGE
354 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (i8u) VIRTUAL;
355 --error ER_WARN_DATA_OUT_OF_RANGE
356 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (i4) VIRTUAL;
357 --error ER_WARN_DATA_OUT_OF_RANGE
358 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (i4u) VIRTUAL;
359 --error ER_WARN_DATA_OUT_OF_RANGE
360 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (i2) VIRTUAL;
361 --error ER_WARN_DATA_OUT_OF_RANGE
362 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (dc) VIRTUAL;
363 --error ER_WARN_DATA_OUT_OF_RANGE
364 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (f4) VIRTUAL;
365 --error ER_WARN_DATA_OUT_OF_RANGE
366 ALTER TABLE t1 ADD gc SMALLINT UNSIGNED AS (f8) VIRTUAL;
367 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
368 ALTER TABLE t1 ADD gc SMALLINT AS (fc) VIRTUAL;
369 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
370 ALTER TABLE t1 ADD gc SMALLINT AS (vc) VIRTUAL;
371 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
372 ALTER TABLE t1 ADD gc SMALLINT AS (fb) VIRTUAL;
373 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
374 ALTER TABLE t1 ADD gc SMALLINT AS (vb) VIRTUAL;
375 --error ER_WARN_DATA_OUT_OF_RANGE
376 ALTER TABLE t1 ADD gc SMALLINT AS (t) VIRTUAL;
377 --error ER_WARN_DATA_OUT_OF_RANGE
378 ALTER TABLE t1 ADD gc SMALLINT AS (d) VIRTUAL;
379 --error ER_WARN_DATA_OUT_OF_RANGE
380 ALTER TABLE t1 ADD gc SMALLINT AS (dt) VIRTUAL;
381 --error ER_WARN_DATA_OUT_OF_RANGE
382 ALTER TABLE t1 ADD gc SMALLINT AS (ts) VIRTUAL;
383
384 --error ER_WARN_DATA_OUT_OF_RANGE
385 ALTER TABLE t1 ADD gc TINYINT AS (i8) VIRTUAL;
386 --error ER_WARN_DATA_OUT_OF_RANGE
387 ALTER TABLE t1 ADD gc TINYINT AS (i8u) VIRTUAL;
388 --error ER_WARN_DATA_OUT_OF_RANGE
389 ALTER TABLE t1 ADD gc TINYINT AS (i4) VIRTUAL;
390 --error ER_WARN_DATA_OUT_OF_RANGE
391 ALTER TABLE t1 ADD gc TINYINT AS (i4u) VIRTUAL;
392 --error ER_WARN_DATA_OUT_OF_RANGE
393 ALTER TABLE t1 ADD gc TINYINT AS (i2) VIRTUAL;
394 --error ER_WARN_DATA_OUT_OF_RANGE
395 ALTER TABLE t1 ADD gc TINYINT AS (i2u) VIRTUAL;
396 #--error ER_WARN_DATA_OUT_OF_RANGE
397 #ALTER TABLE t1 ADD gc TINYINT AS (i1u) VIRTUAL;
398 --error ER_WARN_DATA_OUT_OF_RANGE
399 ALTER TABLE t1 ADD gc TINYINT AS (dc) VIRTUAL;
400 --error ER_WARN_DATA_OUT_OF_RANGE
401 ALTER TABLE t1 ADD gc TINYINT AS (f4) VIRTUAL;
402 --error ER_WARN_DATA_OUT_OF_RANGE
403 ALTER TABLE t1 ADD gc TINYINT AS (f8) VIRTUAL;
404 --error ER_WARN_DATA_OUT_OF_RANGE
405 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i8) VIRTUAL;
406 --error ER_WARN_DATA_OUT_OF_RANGE
407 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i8u) VIRTUAL;
408 --error ER_WARN_DATA_OUT_OF_RANGE
409 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i4) VIRTUAL;
410 --error ER_WARN_DATA_OUT_OF_RANGE
411 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i4u) VIRTUAL;
412 --error ER_WARN_DATA_OUT_OF_RANGE
413 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i2) VIRTUAL;
414 --error ER_WARN_DATA_OUT_OF_RANGE
415 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i2u) VIRTUAL;
416 --error ER_WARN_DATA_OUT_OF_RANGE
417 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (i1) VIRTUAL;
418 --error ER_WARN_DATA_OUT_OF_RANGE
419 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (dc) VIRTUAL;
420 --error ER_WARN_DATA_OUT_OF_RANGE
421 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (f4) VIRTUAL;
422 --error ER_WARN_DATA_OUT_OF_RANGE
423 ALTER TABLE t1 ADD gc TINYINT UNSIGNED AS (f8) VIRTUAL;
424 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
425 ALTER TABLE t1 ADD gc TINYINT AS (fc) VIRTUAL;
426 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
427 ALTER TABLE t1 ADD gc TINYINT AS (vc) VIRTUAL;
428 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
429 ALTER TABLE t1 ADD gc TINYINT AS (fb) VIRTUAL;
430 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
431 ALTER TABLE t1 ADD gc TINYINT AS (vb) VIRTUAL;
432 --error ER_WARN_DATA_OUT_OF_RANGE
433 ALTER TABLE t1 ADD gc TINYINT AS (t) VIRTUAL;
434 --error ER_WARN_DATA_OUT_OF_RANGE
435 ALTER TABLE t1 ADD gc TINYINT AS (d) VIRTUAL;
436 --error ER_WARN_DATA_OUT_OF_RANGE
437 ALTER TABLE t1 ADD gc TINYINT AS (dt) VIRTUAL;
438 --error ER_WARN_DATA_OUT_OF_RANGE
439 ALTER TABLE t1 ADD gc TINYINT AS (ts) VIRTUAL;
440
441 --error ER_WARN_DATA_OUT_OF_RANGE
442 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (i8) VIRTUAL;
443 --error ER_WARN_DATA_OUT_OF_RANGE
444 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (i8u) VIRTUAL;
445 --error ER_WARN_DATA_OUT_OF_RANGE
446 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (i4) VIRTUAL;
447 --error ER_WARN_DATA_OUT_OF_RANGE
448 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (i4u) VIRTUAL;
449 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
450 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (fc) VIRTUAL;
451 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
452 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (vc) VIRTUAL;
453 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
454 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (fb) VIRTUAL;
455 --error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
456 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (vb) VIRTUAL;
457 --error ER_WARN_DATA_OUT_OF_RANGE
458 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (dt) VIRTUAL;
459 --error ER_WARN_DATA_OUT_OF_RANGE
460 ALTER TABLE t1 ADD gc DECIMAL(10,2) AS (ts) VIRTUAL;
461
462 --error ER_TRUNCATED_WRONG_VALUE
463 ALTER TABLE t1 ADD gc DATE AS (i8) VIRTUAL;
464 --error ER_TRUNCATED_WRONG_VALUE
465 ALTER TABLE t1 ADD gc DATE AS (i4) VIRTUAL;
466 --error ER_TRUNCATED_WRONG_VALUE
467 ALTER TABLE t1 ADD gc DATE AS (i2) VIRTUAL;
468 --error ER_TRUNCATED_WRONG_VALUE
469 ALTER TABLE t1 ADD gc DATE AS (i1) VIRTUAL;
470 --error ER_TRUNCATED_WRONG_VALUE
471 ALTER TABLE t1 ADD gc DATE AS (dc) VIRTUAL;
472 --error ER_TRUNCATED_WRONG_VALUE
473 ALTER TABLE t1 ADD gc DATE AS (f4) VIRTUAL;
474 --error ER_TRUNCATED_WRONG_VALUE
475 ALTER TABLE t1 ADD gc DATE AS (fc) VIRTUAL;
476 --error ER_TRUNCATED_WRONG_VALUE
477 ALTER TABLE t1 ADD gc DATE AS (vc) VIRTUAL;
478 --error ER_TRUNCATED_WRONG_VALUE
479 ALTER TABLE t1 ADD gc DATE AS (fb) VIRTUAL;
480 --error ER_TRUNCATED_WRONG_VALUE
481 ALTER TABLE t1 ADD gc DATE AS (vb) VIRTUAL;
482
483 --error ER_TRUNCATED_WRONG_VALUE
484 ALTER TABLE t1 ADD gc TIME AS (i8) VIRTUAL;
485 --error ER_TRUNCATED_WRONG_VALUE
486 ALTER TABLE t1 ADD gc TIME AS (i4) VIRTUAL;
487 --error ER_TRUNCATED_WRONG_VALUE
488 ALTER TABLE t1 ADD gc TIME AS (i2) VIRTUAL;
489 --error ER_TRUNCATED_WRONG_VALUE
490 ALTER TABLE t1 ADD gc TIME AS (dc) VIRTUAL;
491 --error ER_TRUNCATED_WRONG_VALUE
492 ALTER TABLE t1 ADD gc TIME AS (f4) VIRTUAL;
493 --error ER_TRUNCATED_WRONG_VALUE
494 ALTER TABLE t1 ADD gc TIME AS (fc) VIRTUAL;
495 --error ER_TRUNCATED_WRONG_VALUE
496 ALTER TABLE t1 ADD gc TIME AS (vc) VIRTUAL;
497 --error ER_TRUNCATED_WRONG_VALUE
498 ALTER TABLE t1 ADD gc TIME AS (fb) VIRTUAL;
499 --error ER_TRUNCATED_WRONG_VALUE
500 ALTER TABLE t1 ADD gc TIME AS (vb) VIRTUAL;
501
502 --error ER_TRUNCATED_WRONG_VALUE
503 ALTER TABLE t1 ADD gc DATETIME AS (i8) VIRTUAL;
504 --error ER_TRUNCATED_WRONG_VALUE
505 ALTER TABLE t1 ADD gc DATETIME AS (i4) VIRTUAL;
506 --error ER_TRUNCATED_WRONG_VALUE
507 ALTER TABLE t1 ADD gc DATETIME AS (i2) VIRTUAL;
508 --error ER_TRUNCATED_WRONG_VALUE
509 ALTER TABLE t1 ADD gc DATETIME AS (i1) VIRTUAL;
510 --error ER_TRUNCATED_WRONG_VALUE
511 ALTER TABLE t1 ADD gc DATETIME AS (dc) VIRTUAL;
512 --error ER_TRUNCATED_WRONG_VALUE
513 ALTER TABLE t1 ADD gc DATETIME AS (f4) VIRTUAL;
514 --error ER_TRUNCATED_WRONG_VALUE
515 ALTER TABLE t1 ADD gc DATETIME AS (fc) VIRTUAL;
516 --error ER_TRUNCATED_WRONG_VALUE
517 ALTER TABLE t1 ADD gc DATETIME AS (vc) VIRTUAL;
518 --error ER_TRUNCATED_WRONG_VALUE
519 ALTER TABLE t1 ADD gc DATETIME AS (fb) VIRTUAL;
520 --error ER_TRUNCATED_WRONG_VALUE
521 ALTER TABLE t1 ADD gc DATETIME AS (vb) VIRTUAL;
522
523 --error ER_TRUNCATED_WRONG_VALUE
524 ALTER TABLE t1 ADD gc TIMESTAMP AS (i8) VIRTUAL;
525 --error ER_TRUNCATED_WRONG_VALUE
526 ALTER TABLE t1 ADD gc TIMESTAMP AS (i4) VIRTUAL;
527 --error ER_TRUNCATED_WRONG_VALUE
528 ALTER TABLE t1 ADD gc TIMESTAMP AS (i2) VIRTUAL;
529 --error ER_TRUNCATED_WRONG_VALUE
530 ALTER TABLE t1 ADD gc TIMESTAMP AS (i1) VIRTUAL;
531 --error ER_TRUNCATED_WRONG_VALUE
532 ALTER TABLE t1 ADD gc TIMESTAMP AS (dc) VIRTUAL;
533 --error ER_TRUNCATED_WRONG_VALUE
534 ALTER TABLE t1 ADD gc TIMESTAMP AS (f4) VIRTUAL;
535 --error ER_TRUNCATED_WRONG_VALUE
536 ALTER TABLE t1 ADD gc TIMESTAMP AS (fc) VIRTUAL;
537 --error ER_TRUNCATED_WRONG_VALUE
538 ALTER TABLE t1 ADD gc TIMESTAMP AS (vc) VIRTUAL;
539 --error ER_TRUNCATED_WRONG_VALUE
540 ALTER TABLE t1 ADD gc TIMESTAMP AS (fb) VIRTUAL;
541 --error ER_TRUNCATED_WRONG_VALUE
542 ALTER TABLE t1 ADD gc TIMESTAMP AS (vb) VIRTUAL;
543
544 drop table t1;