Debian Codegraph @

mysql-test/suite/gcol/r/gcol_rejected_myisam.result

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