Debian Codegraph @

mysql-test/suite/ndb/r/ndb_restore_conv_lossy_integral.result

raw
1 Warnings:
2 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
3 ************************************************************
4 * Creating table with integral types
5 ************************************************************
6 CREATE TABLE t1(
7 t1 tinyint, t2 tinyint, ut1 tinyint unsigned,
8 s1 smallint, s2 smallint, us1 smallint unsigned,
9 m1 mediumint, m2 mediumint, um1 mediumint unsigned,
10 i1 int, i2 int, ui1 int unsigned,
11 b1 bigint, b2 bigint, ub1 bigint unsigned
12 ) ENGINE=NDB;
13 INSERT INTO t1 VALUES(
14 -128, 127, 255,
15 -32768, 32767, 65535,
16 -8388608, 8388607, 16777215,
17 -2147483648, 2147483647, 4294967295,
18 -9223372036854775808, 9223372036854775807, 18446744073709551615
19 );
20 ************************************************************
21 * Backing up table with integral types
22 ************************************************************
23 ************************************************************
24 * Restoring table with unchanged integral types:
25 * tinyint[unsigned] --> tinyint[unsigned]
26 * smallint[unsigned] --> smallint[unsigned]
27 * mediumint[unsigned] --> mediumint[unsigned]
28 * int[unsigned] --> int[unsigned]
29 * bigint[unsigned] --> bigint[unsigned]
30 ************************************************************
31 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
32 DELETE FROM t1;
33 SELECT * FROM t1;
34 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
35 -128 127 255 -32768 32767 65535 -8388608 8388607 16777215 -2147483648 2147483647 4294967295 -9223372036854775808 9223372036854775807 18446744073709551615
36 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
37 COUNT(*)
38 1
39 DROP TABLE t1_myisam;
40 ************************************************************
41 * Restoring table with 1st degree demoted integral types:
42 * tinyint[unsigned] --> tinyint[unsigned]
43 * smallint[unsigned] --> tinyint[unsigned]
44 * mediumint[unsigned] --> smallint[unsigned]
45 * int[unsigned] --> mediumint[unsigned]
46 * bigint[unsigned] --> int[unsigned]
47 ************************************************************
48 ALTER TABLE t1
49 modify t1 tinyint, modify t2 tinyint, modify ut1 tinyint unsigned,
50 modify s1 tinyint, modify s2 tinyint, modify us1 tinyint unsigned,
51 modify m1 smallint, modify m2 smallint, modify um1 smallint unsigned,
52 modify i1 mediumint, modify i2 mediumint, modify ui1 mediumint unsigned,
53 modify b1 int, modify b2 int, modify ub1 int unsigned;
54 SELECT * FROM t1;
55 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
56 -128 127 255 -128 127 255 -32768 32767 65535 -8388608 8388607 16777215 -2147483648 2147483647 4294967295
57 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
58 DELETE FROM t1;
59 SELECT * FROM t1;
60 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
61 -128 127 255 -128 127 255 -32768 32767 65535 -8388608 8388607 16777215 -2147483648 2147483647 4294967295
62 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
63 COUNT(*)
64 1
65 DROP TABLE t1_myisam;
66 ************************************************************
67 * Restoring table with 2nd degree demoted integral types:
68 * tinyint[unsigned] --> tinyint[unsigned]
69 * smallint[unsigned] --> tinyint[unsigned]
70 * mediumint[unsigned] --> tinyint[unsigned]
71 * int[unsigned] --> smallint[unsigned]
72 * bigint[unsigned] --> mediumint[unsigned]
73 ************************************************************
74 ALTER TABLE t1
75 modify t1 tinyint, modify t2 tinyint, modify ut1 tinyint unsigned,
76 modify s1 tinyint, modify s2 tinyint, modify us1 tinyint unsigned,
77 modify m1 tinyint, modify m2 tinyint, modify um1 tinyint unsigned,
78 modify i1 smallint, modify i2 smallint, modify ui1 smallint unsigned,
79 modify b1 mediumint, modify b2 mediumint, modify ub1 mediumint unsigned;
80 SELECT * FROM t1;
81 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
82 -128 127 255 -128 127 255 -128 127 255 -32768 32767 65535 -8388608 8388607 16777215
83 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
84 DELETE FROM t1;
85 SELECT * FROM t1;
86 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
87 -128 127 255 -128 127 255 -128 127 255 -32768 32767 65535 -8388608 8388607 16777215
88 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
89 COUNT(*)
90 1
91 DROP TABLE t1_myisam;
92 ************************************************************
93 * Restoring table with 3rd degree demoted integral types:
94 * tinyint[unsigned] --> tinyint[unsigned]
95 * smallint[unsigned] --> tinyint[unsigned]
96 * mediumint[unsigned] --> tinyint[unsigned]
97 * int[unsigned] --> tinyint[unsigned]
98 * bigint[unsigned] --> smallint[unsigned]
99 ************************************************************
100 ALTER TABLE t1
101 modify t1 tinyint, modify t2 tinyint, modify ut1 tinyint unsigned,
102 modify s1 tinyint, modify s2 tinyint, modify us1 tinyint unsigned,
103 modify m1 tinyint, modify m2 tinyint, modify um1 tinyint unsigned,
104 modify i1 tinyint, modify i2 tinyint, modify ui1 tinyint unsigned,
105 modify b1 smallint, modify b2 smallint, modify ub1 smallint unsigned;
106 SELECT * FROM t1;
107 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
108 -128 127 255 -128 127 255 -128 127 255 -128 127 255 -32768 32767 65535
109 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
110 DELETE FROM t1;
111 SELECT * FROM t1;
112 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
113 -128 127 255 -128 127 255 -128 127 255 -128 127 255 -32768 32767 65535
114 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
115 COUNT(*)
116 1
117 DROP TABLE t1_myisam;
118 ************************************************************
119 * Restoring table with 4th degree demoted integral types:
120 * tinyint[unsigned] --> tinyint[unsigned]
121 * smallint[unsigned] --> tinyint[unsigned]
122 * mediumint[unsigned] --> tinyint[unsigned]
123 * int[unsigned] --> tinyint[unsigned]
124 * bigint[unsigned] --> tinyint[unsigned]
125 ************************************************************
126 ALTER TABLE t1
127 modify t1 tinyint, modify t2 tinyint, modify ut1 tinyint unsigned,
128 modify s1 tinyint, modify s2 tinyint, modify us1 tinyint unsigned,
129 modify m1 tinyint, modify m2 tinyint, modify um1 tinyint unsigned,
130 modify i1 tinyint, modify i2 tinyint, modify ui1 tinyint unsigned,
131 modify b1 tinyint, modify b2 tinyint, modify ub1 tinyint unsigned;
132 SELECT * FROM t1;
133 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
134 -128 127 255 -128 127 255 -128 127 255 -128 127 255 -128 127 255
135 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
136 DELETE FROM t1;
137 SELECT * FROM t1;
138 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
139 -128 127 255 -128 127 255 -128 127 255 -128 127 255 -128 127 255
140 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
141 COUNT(*)
142 1
143 DROP TABLE t1_myisam;
144 ************************************************************
145 * Restoring table with changed signedness:
146 * tinyint unsigned/signed --> tinyint signed/unsigned
147 * smallint unsigned/signed --> smallint signed/unsigned
148 * mediumint unsigned/signed --> mediumint signed/unsigned
149 * int unsigned/signed --> int signed/unsigned
150 * bigint unsigned/signed --> bigint signed/unsigned
151 ************************************************************
152 DELETE FROM t1;
153 ALTER TABLE t1
154 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed,
155 modify s1 smallint unsigned, modify s2 smallint unsigned, modify us1 smallint signed,
156 modify m1 mediumint unsigned, modify m2 mediumint unsigned, modify um1 mediumint signed,
157 modify i1 int unsigned, modify i2 int unsigned, modify ui1 int signed,
158 modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed;
159 INSERT INTO t1 VALUES(
160 -128, 127, 255,
161 -32768, 32767, 65535,
162 -8388608, 8388607, 16777215,
163 -2147483648, 2147483647, 4294967295,
164 -9223372036854775808, 9223372036854775807, 18446744073709551615
165 );
166 SELECT * FROM t1;
167 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
168 0 127 127 0 32767 32767 0 8388607 8388607 0 2147483647 2147483647 0 9223372036854775807 9223372036854775807
169 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
170 DELETE FROM t1;
171 SELECT * FROM t1;
172 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
173 0 127 127 0 32767 32767 0 8388607 8388607 0 2147483647 2147483647 0 9223372036854775807 9223372036854775807
174 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
175 COUNT(*)
176 1
177 DROP TABLE t1_myisam;
178 ************************************************************
179 * Restoring table with changed signedness + 1st degree promoted types:
180 * tinyint unsigned/signed --> smallint signed/unsigned
181 * smallint unsigned/signed --> mediumint signed/unsigned
182 * mediumint unsigned/signed --> int signed/unsigned
183 * int unsigned/signed --> bigint signed/unsigned
184 * bigint unsigned/signed --> bigint signed/unsigned
185 ************************************************************
186 DELETE FROM t1;
187 ALTER TABLE t1
188 modify t1 smallint unsigned, modify t2 smallint unsigned, modify ut1 smallint signed,
189 modify s1 mediumint unsigned, modify s2 mediumint unsigned, modify us1 mediumint signed,
190 modify m1 int unsigned, modify m2 int unsigned, modify um1 int signed,
191 modify i1 bigint unsigned, modify i2 bigint unsigned, modify ui1 bigint signed,
192 modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed;
193 INSERT INTO t1 VALUES(
194 -128, 127, 255,
195 -32768, 32767, 65535,
196 -8388608, 8388607, 16777215,
197 -2147483648, 2147483647, 4294967295,
198 -9223372036854775808, 9223372036854775807, 18446744073709551615
199 );
200 SELECT * FROM t1;
201 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
202 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807
203 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
204 DELETE FROM t1;
205 SELECT * FROM t1;
206 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
207 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807
208 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
209 COUNT(*)
210 1
211 DROP TABLE t1_myisam;
212 ************************************************************
213 * Restoring table with changed signedness + 2nd degree promoted types:
214 * tinyint unsigned/signed --> mediumint signed/unsigned
215 * smallint unsigned/signed --> int signed/unsigned
216 * mediumint unsigned/signed --> bigint signed/unsigned
217 * int unsigned/signed --> bigint signed/unsigned
218 * bigint unsigned/signed --> bigint signed/unsigned
219 ************************************************************
220 DELETE FROM t1;
221 ALTER TABLE t1
222 modify t1 mediumint unsigned, modify t2 mediumint unsigned, modify ut1 mediumint signed,
223 modify s1 int unsigned, modify s2 int unsigned, modify us1 int signed,
224 modify m1 bigint unsigned, modify m2 bigint unsigned, modify um1 bigint signed,
225 modify i1 bigint unsigned, modify i2 bigint unsigned, modify ui1 bigint signed,
226 modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed;
227 INSERT INTO t1 VALUES(
228 -128, 127, 255,
229 -32768, 32767, 65535,
230 -8388608, 8388607, 16777215,
231 -2147483648, 2147483647, 4294967295,
232 -9223372036854775808, 9223372036854775807, 18446744073709551615
233 );
234 SELECT * FROM t1;
235 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
236 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807
237 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
238 DELETE FROM t1;
239 SELECT * FROM t1;
240 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
241 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807
242 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
243 COUNT(*)
244 1
245 DROP TABLE t1_myisam;
246 ************************************************************
247 * Restoring table with changed signedness + 3rd degree promoted types:
248 * tinyint unsigned/signed --> int signed/unsigned
249 * smallint unsigned/signed --> bigint signed/unsigned
250 * mediumint unsigned/signed --> bigint signed/unsigned
251 * int unsigned/signed --> bigint signed/unsigned
252 * bigint unsigned/signed --> bigint signed/unsigned
253 ************************************************************
254 DELETE FROM t1;
255 ALTER TABLE t1
256 modify t1 int unsigned, modify t2 int unsigned, modify ut1 int signed,
257 modify s1 bigint unsigned, modify s2 bigint unsigned, modify us1 bigint signed,
258 modify m1 bigint unsigned, modify m2 bigint unsigned, modify um1 bigint signed,
259 modify i1 bigint unsigned, modify i2 bigint unsigned, modify ui1 bigint signed,
260 modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed;
261 INSERT INTO t1 VALUES(
262 -128, 127, 255,
263 -32768, 32767, 65535,
264 -8388608, 8388607, 16777215,
265 -2147483648, 2147483647, 4294967295,
266 -9223372036854775808, 9223372036854775807, 18446744073709551615
267 );
268 SELECT * FROM t1;
269 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
270 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807
271 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
272 DELETE FROM t1;
273 SELECT * FROM t1;
274 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
275 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807
276 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
277 COUNT(*)
278 1
279 DROP TABLE t1_myisam;
280 ************************************************************
281 * Restoring table with changed signedness + 4th degree promoted types:
282 * tinyint unsigned/signed --> bigint signed/unsigned
283 * smallint unsigned/signed --> bigint signed/unsigned
284 * mediumint unsigned/signed --> bigint signed/unsigned
285 * int unsigned/signed --> bigint signed/unsigned
286 * bigint unsigned/signed --> bigint signed/unsigned
287 ************************************************************
288 DELETE FROM t1;
289 ALTER TABLE t1
290 modify t1 bigint unsigned, modify t2 bigint unsigned, modify ut1 bigint signed,
291 modify s1 bigint unsigned, modify s2 bigint unsigned, modify us1 bigint signed,
292 modify m1 bigint unsigned, modify m2 bigint unsigned, modify um1 bigint signed,
293 modify i1 bigint unsigned, modify i2 bigint unsigned, modify ui1 bigint signed,
294 modify b1 bigint unsigned, modify b2 bigint unsigned, modify ub1 bigint signed;
295 INSERT INTO t1 VALUES(
296 -128, 127, 255,
297 -32768, 32767, 65535,
298 -8388608, 8388607, 16777215,
299 -2147483648, 2147483647, 4294967295,
300 -9223372036854775808, 9223372036854775807, 18446744073709551615
301 );
302 SELECT * FROM t1;
303 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
304 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807
305 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
306 DELETE FROM t1;
307 SELECT * FROM t1;
308 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
309 0 127 255 0 32767 65535 0 8388607 16777215 0 2147483647 4294967295 0 9223372036854775807 9223372036854775807
310 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
311 COUNT(*)
312 1
313 DROP TABLE t1_myisam;
314 ************************************************************
315 * Restoring table with changed signedness + 1st degree demoted types:
316 * tinyint unsigned/signed --> tinyint signed/unsigned
317 * smallint unsigned/signed --> tinyint signed/unsigned
318 * mediumint unsigned/signed --> smallint signed/unsigned
319 * int unsigned/signed --> mediumint signed/unsigned
320 * bigint unsigned/signed --> int signed/unsigned
321 ************************************************************
322 DELETE FROM t1;
323 ALTER TABLE t1
324 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed,
325 modify s1 tinyint unsigned, modify s2 tinyint unsigned, modify us1 tinyint signed,
326 modify m1 smallint unsigned, modify m2 smallint unsigned, modify um1 smallint signed,
327 modify i1 mediumint unsigned, modify i2 mediumint unsigned, modify ui1 mediumint signed,
328 modify b1 int unsigned, modify b2 int unsigned, modify ub1 int signed;
329 INSERT INTO t1 VALUES(
330 -128, 127, 255,
331 -32768, 32767, 65535,
332 -8388608, 8388607, 16777215,
333 -2147483648, 2147483647, 4294967295,
334 -9223372036854775808, 9223372036854775807, 18446744073709551615
335 );
336 SELECT * FROM t1;
337 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
338 0 127 127 0 255 127 0 65535 32767 0 16777215 8388607 0 4294967295 2147483647
339 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
340 DELETE FROM t1;
341 SELECT * FROM t1;
342 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
343 0 127 127 0 255 127 0 65535 32767 0 16777215 8388607 0 4294967295 2147483647
344 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
345 COUNT(*)
346 1
347 DROP TABLE t1_myisam;
348 ************************************************************
349 * Restoring table with changed signedness + 2nd degree demoted types:
350 * tinyint unsigned/signed --> tinyint signed/unsigned
351 * smallint unsigned/signed --> tinyint signed/unsigned
352 * mediumint unsigned/signed --> tinyint signed/unsigned
353 * int unsigned/signed --> smallint signed/unsigned
354 * bigint unsigned/signed --> mediumint signed/unsigned
355 ************************************************************
356 DELETE FROM t1;
357 ALTER TABLE t1
358 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed,
359 modify s1 tinyint unsigned, modify s2 tinyint unsigned, modify us1 tinyint signed,
360 modify m1 tinyint unsigned, modify m2 tinyint unsigned, modify um1 tinyint signed,
361 modify i1 smallint unsigned, modify i2 smallint unsigned, modify ui1 smallint signed,
362 modify b1 mediumint unsigned, modify b2 mediumint unsigned, modify ub1 mediumint signed;
363 INSERT INTO t1 VALUES(
364 -128, 127, 255,
365 -32768, 32767, 65535,
366 -8388608, 8388607, 16777215,
367 -2147483648, 2147483647, 4294967295,
368 -9223372036854775808, 9223372036854775807, 18446744073709551615
369 );
370 SELECT * FROM t1;
371 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
372 0 127 127 0 255 127 0 255 127 0 65535 32767 0 16777215 8388607
373 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
374 DELETE FROM t1;
375 SELECT * FROM t1;
376 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
377 0 127 127 0 255 127 0 255 127 0 65535 32767 0 16777215 8388607
378 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
379 COUNT(*)
380 1
381 DROP TABLE t1_myisam;
382 ************************************************************
383 * Restoring table with changed signedness + 3rd degree demoted types:
384 * tinyint unsigned/signed --> tinyint signed/unsigned
385 * smallint unsigned/signed --> tinyint signed/unsigned
386 * mediumint unsigned/signed --> tinyint signed/unsigned
387 * int unsigned/signed --> tinyint signed/unsigned
388 * bigint unsigned/signed --> smallint signed/unsigned
389 ************************************************************
390 DELETE FROM t1;
391 ALTER TABLE t1
392 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed,
393 modify s1 tinyint unsigned, modify s2 tinyint unsigned, modify us1 tinyint signed,
394 modify m1 tinyint unsigned, modify m2 tinyint unsigned, modify um1 tinyint signed,
395 modify i1 tinyint unsigned, modify i2 tinyint unsigned, modify ui1 tinyint signed,
396 modify b1 smallint unsigned, modify b2 smallint unsigned, modify ub1 smallint signed;
397 INSERT INTO t1 VALUES(
398 -128, 127, 255,
399 -32768, 32767, 65535,
400 -8388608, 8388607, 16777215,
401 -2147483648, 2147483647, 4294967295,
402 -9223372036854775808, 9223372036854775807, 18446744073709551615
403 );
404 SELECT * FROM t1;
405 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
406 0 127 127 0 255 127 0 255 127 0 255 127 0 65535 32767
407 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
408 DELETE FROM t1;
409 SELECT * FROM t1;
410 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
411 0 127 127 0 255 127 0 255 127 0 255 127 0 65535 32767
412 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
413 COUNT(*)
414 1
415 DROP TABLE t1_myisam;
416 ************************************************************
417 * Restoring table with changed signedness + 4th degree demoted types:
418 * tinyint unsigned/signed --> tinyint signed/unsigned
419 * smallint unsigned/signed --> tinyint signed/unsigned
420 * mediumint unsigned/signed --> tinyint signed/unsigned
421 * int unsigned/signed --> tinyint signed/unsigned
422 * bigint unsigned/signed --> tinyint signed/unsigned
423 ************************************************************
424 DELETE FROM t1;
425 ALTER TABLE t1
426 modify t1 tinyint unsigned, modify t2 tinyint unsigned, modify ut1 tinyint signed,
427 modify s1 tinyint unsigned, modify s2 tinyint unsigned, modify us1 tinyint signed,
428 modify m1 tinyint unsigned, modify m2 tinyint unsigned, modify um1 tinyint signed,
429 modify i1 tinyint unsigned, modify i2 tinyint unsigned, modify ui1 tinyint signed,
430 modify b1 tinyint unsigned, modify b2 tinyint unsigned, modify ub1 tinyint signed;
431 INSERT INTO t1 VALUES(
432 -128, 127, 255,
433 -32768, 32767, 65535,
434 -8388608, 8388607, 16777215,
435 -2147483648, 2147483647, 4294967295,
436 -9223372036854775808, 9223372036854775807, 18446744073709551615
437 );
438 SELECT * FROM t1;
439 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
440 0 127 127 0 255 127 0 255 127 0 255 127 0 255 127
441 CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;
442 DELETE FROM t1;
443 SELECT * FROM t1;
444 t1 t2 ut1 s1 s2 us1 m1 m2 um1 i1 i2 ui1 b1 b2 ub1
445 0 127 127 0 255 127 0 255 127 0 255 127 0 255 127
446 SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
447 COUNT(*)
448 1
449 DROP TABLE t1_myisam;
450 ************************************************************
451 * Deleting table with integral types
452 ************************************************************
453 DROP TABLE t1;