1
# this test is generated by change_int_rename.py
3
DROP TABLE IF EXISTS t, ti;
5
SET SESSION DEFAULT_STORAGE_ENGINE="TokuDB";
6
SET SESSION TOKUDB_DISABLE_SLOW_ALTER=1;
8
CREATE TABLE t (a TINYINT);
9
INSERT INTO t VALUES ( -128 );
10
INSERT INTO t VALUES ( -1 );
11
INSERT INTO t VALUES ( 0 );
12
INSERT INTO t VALUES ( 1 );
13
INSERT INTO t VALUES ( 127 );
14
CREATE TABLE ti LIKE t;
15
ALTER TABLE ti ENGINE=myisam;
16
INSERT INTO ti SELECT * from t;
17
ALTER TABLE ti CHANGE COLUMN a aa TINYINT;
18
ALTER TABLE t CHANGE COLUMN a aa TINYINT;
19
ALTER TABLE t CHANGE COLUMN aa a TINYINT;
20
ALTER TABLE ti CHANGE COLUMN aa a TINYINT;
21
let $diff_tables = test.t, test.ti;
22
source include/diff_tables.inc;
26
CREATE TABLE t (a TINYINT);
27
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
28
--error ER_UNSUPPORTED_EXTENSION
29
ALTER TABLE t CHANGE COLUMN a aa SMALLINT;
32
CREATE TABLE t (a TINYINT);
33
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
34
--error ER_UNSUPPORTED_EXTENSION
35
ALTER TABLE t CHANGE COLUMN a aa MEDIUMINT;
38
CREATE TABLE t (a TINYINT);
39
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
40
--error ER_UNSUPPORTED_EXTENSION
41
ALTER TABLE t CHANGE COLUMN a aa INT;
44
CREATE TABLE t (a TINYINT);
45
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
46
--error ER_UNSUPPORTED_EXTENSION
47
ALTER TABLE t CHANGE COLUMN a aa BIGINT;
50
CREATE TABLE t (a SMALLINT);
51
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
52
--error ER_UNSUPPORTED_EXTENSION
53
ALTER TABLE t CHANGE COLUMN a aa TINYINT;
56
CREATE TABLE t (a SMALLINT);
57
INSERT INTO t VALUES ( -32768 );
58
INSERT INTO t VALUES ( -1 );
59
INSERT INTO t VALUES ( 0 );
60
INSERT INTO t VALUES ( 1 );
61
INSERT INTO t VALUES ( 32767 );
62
CREATE TABLE ti LIKE t;
63
ALTER TABLE ti ENGINE=myisam;
64
INSERT INTO ti SELECT * from t;
65
ALTER TABLE ti CHANGE COLUMN a aa SMALLINT;
66
ALTER TABLE t CHANGE COLUMN a aa SMALLINT;
67
ALTER TABLE t CHANGE COLUMN aa a SMALLINT;
68
ALTER TABLE ti CHANGE COLUMN aa a SMALLINT;
69
let $diff_tables = test.t, test.ti;
70
source include/diff_tables.inc;
74
CREATE TABLE t (a SMALLINT);
75
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
76
--error ER_UNSUPPORTED_EXTENSION
77
ALTER TABLE t CHANGE COLUMN a aa MEDIUMINT;
80
CREATE TABLE t (a SMALLINT);
81
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
82
--error ER_UNSUPPORTED_EXTENSION
83
ALTER TABLE t CHANGE COLUMN a aa INT;
86
CREATE TABLE t (a SMALLINT);
87
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
88
--error ER_UNSUPPORTED_EXTENSION
89
ALTER TABLE t CHANGE COLUMN a aa BIGINT;
92
CREATE TABLE t (a MEDIUMINT);
93
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
94
--error ER_UNSUPPORTED_EXTENSION
95
ALTER TABLE t CHANGE COLUMN a aa TINYINT;
98
CREATE TABLE t (a MEDIUMINT);
99
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
100
--error ER_UNSUPPORTED_EXTENSION
101
ALTER TABLE t CHANGE COLUMN a aa SMALLINT;
104
CREATE TABLE t (a MEDIUMINT);
105
INSERT INTO t VALUES ( -8388608 );
106
INSERT INTO t VALUES ( -1 );
107
INSERT INTO t VALUES ( 0 );
108
INSERT INTO t VALUES ( 1 );
109
INSERT INTO t VALUES ( 8388607 );
110
CREATE TABLE ti LIKE t;
111
ALTER TABLE ti ENGINE=myisam;
112
INSERT INTO ti SELECT * from t;
113
ALTER TABLE ti CHANGE COLUMN a aa MEDIUMINT;
114
ALTER TABLE t CHANGE COLUMN a aa MEDIUMINT;
115
ALTER TABLE t CHANGE COLUMN aa a MEDIUMINT;
116
ALTER TABLE ti CHANGE COLUMN aa a MEDIUMINT;
117
let $diff_tables = test.t, test.ti;
118
source include/diff_tables.inc;
122
CREATE TABLE t (a MEDIUMINT);
123
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
124
--error ER_UNSUPPORTED_EXTENSION
125
ALTER TABLE t CHANGE COLUMN a aa INT;
128
CREATE TABLE t (a MEDIUMINT);
129
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
130
--error ER_UNSUPPORTED_EXTENSION
131
ALTER TABLE t CHANGE COLUMN a aa BIGINT;
134
CREATE TABLE t (a INT);
135
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
136
--error ER_UNSUPPORTED_EXTENSION
137
ALTER TABLE t CHANGE COLUMN a aa TINYINT;
140
CREATE TABLE t (a INT);
141
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
142
--error ER_UNSUPPORTED_EXTENSION
143
ALTER TABLE t CHANGE COLUMN a aa SMALLINT;
146
CREATE TABLE t (a INT);
147
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
148
--error ER_UNSUPPORTED_EXTENSION
149
ALTER TABLE t CHANGE COLUMN a aa MEDIUMINT;
152
CREATE TABLE t (a INT);
153
INSERT INTO t VALUES ( -2147483648 );
154
INSERT INTO t VALUES ( 0 );
155
INSERT INTO t VALUES ( 1 );
156
INSERT INTO t VALUES ( 2147483647 );
157
CREATE TABLE ti LIKE t;
158
ALTER TABLE ti ENGINE=myisam;
159
INSERT INTO ti SELECT * from t;
160
ALTER TABLE ti CHANGE COLUMN a aa INT;
161
ALTER TABLE t CHANGE COLUMN a aa INT;
162
ALTER TABLE t CHANGE COLUMN aa a INT;
163
ALTER TABLE ti CHANGE COLUMN aa a INT;
164
let $diff_tables = test.t, test.ti;
165
source include/diff_tables.inc;
169
CREATE TABLE t (a INT);
170
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
171
--error ER_UNSUPPORTED_EXTENSION
172
ALTER TABLE t CHANGE COLUMN a aa BIGINT;
175
CREATE TABLE t (a BIGINT);
176
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
177
--error ER_UNSUPPORTED_EXTENSION
178
ALTER TABLE t CHANGE COLUMN a aa TINYINT;
181
CREATE TABLE t (a BIGINT);
182
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
183
--error ER_UNSUPPORTED_EXTENSION
184
ALTER TABLE t CHANGE COLUMN a aa SMALLINT;
187
CREATE TABLE t (a BIGINT);
188
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
189
--error ER_UNSUPPORTED_EXTENSION
190
ALTER TABLE t CHANGE COLUMN a aa MEDIUMINT;
193
CREATE TABLE t (a BIGINT);
194
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
195
--error ER_UNSUPPORTED_EXTENSION
196
ALTER TABLE t CHANGE COLUMN a aa INT;
199
CREATE TABLE t (a BIGINT);
200
INSERT INTO t VALUES ( -9223372036854775808 );
201
INSERT INTO t VALUES ( 0 );
202
INSERT INTO t VALUES ( 1 );
203
INSERT INTO t VALUES ( 9223372036854775807 );
204
CREATE TABLE ti LIKE t;
205
ALTER TABLE ti ENGINE=myisam;
206
INSERT INTO ti SELECT * from t;
207
ALTER TABLE ti CHANGE COLUMN a aa BIGINT;
208
ALTER TABLE t CHANGE COLUMN a aa BIGINT;
209
ALTER TABLE t CHANGE COLUMN aa a BIGINT;
210
ALTER TABLE ti CHANGE COLUMN aa a BIGINT;
211
let $diff_tables = test.t, test.ti;
212
source include/diff_tables.inc;
216
CREATE TABLE t (a TINYINT UNSIGNED);
217
INSERT INTO t VALUES ( 0 );
218
INSERT INTO t VALUES ( 1 );
219
INSERT INTO t VALUES ( 255 );
220
CREATE TABLE ti LIKE t;
221
ALTER TABLE ti ENGINE=myisam;
222
INSERT INTO ti SELECT * from t;
223
ALTER TABLE ti CHANGE COLUMN a aa TINYINT UNSIGNED;
224
ALTER TABLE t CHANGE COLUMN a aa TINYINT UNSIGNED;
225
ALTER TABLE t CHANGE COLUMN aa a TINYINT UNSIGNED;
226
ALTER TABLE ti CHANGE COLUMN aa a TINYINT UNSIGNED;
227
let $diff_tables = test.t, test.ti;
228
source include/diff_tables.inc;
232
CREATE TABLE t (a TINYINT UNSIGNED);
233
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
234
--error ER_UNSUPPORTED_EXTENSION
235
ALTER TABLE t CHANGE COLUMN a aa SMALLINT UNSIGNED;
238
CREATE TABLE t (a TINYINT UNSIGNED);
239
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
240
--error ER_UNSUPPORTED_EXTENSION
241
ALTER TABLE t CHANGE COLUMN a aa MEDIUMINT UNSIGNED;
244
CREATE TABLE t (a TINYINT UNSIGNED);
245
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
246
--error ER_UNSUPPORTED_EXTENSION
247
ALTER TABLE t CHANGE COLUMN a aa INT UNSIGNED;
250
CREATE TABLE t (a TINYINT UNSIGNED);
251
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
252
--error ER_UNSUPPORTED_EXTENSION
253
ALTER TABLE t CHANGE COLUMN a aa BIGINT UNSIGNED;
256
CREATE TABLE t (a SMALLINT UNSIGNED);
257
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
258
--error ER_UNSUPPORTED_EXTENSION
259
ALTER TABLE t CHANGE COLUMN a aa TINYINT UNSIGNED;
262
CREATE TABLE t (a SMALLINT UNSIGNED);
263
INSERT INTO t VALUES ( 0 );
264
INSERT INTO t VALUES ( 1 );
265
INSERT INTO t VALUES ( 65535 );
266
CREATE TABLE ti LIKE t;
267
ALTER TABLE ti ENGINE=myisam;
268
INSERT INTO ti SELECT * from t;
269
ALTER TABLE ti CHANGE COLUMN a aa SMALLINT UNSIGNED;
270
ALTER TABLE t CHANGE COLUMN a aa SMALLINT UNSIGNED;
271
ALTER TABLE t CHANGE COLUMN aa a SMALLINT UNSIGNED;
272
ALTER TABLE ti CHANGE COLUMN aa a SMALLINT UNSIGNED;
273
let $diff_tables = test.t, test.ti;
274
source include/diff_tables.inc;
278
CREATE TABLE t (a SMALLINT UNSIGNED);
279
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
280
--error ER_UNSUPPORTED_EXTENSION
281
ALTER TABLE t CHANGE COLUMN a aa MEDIUMINT UNSIGNED;
284
CREATE TABLE t (a SMALLINT UNSIGNED);
285
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
286
--error ER_UNSUPPORTED_EXTENSION
287
ALTER TABLE t CHANGE COLUMN a aa INT UNSIGNED;
290
CREATE TABLE t (a SMALLINT UNSIGNED);
291
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
292
--error ER_UNSUPPORTED_EXTENSION
293
ALTER TABLE t CHANGE COLUMN a aa BIGINT UNSIGNED;
296
CREATE TABLE t (a MEDIUMINT UNSIGNED);
297
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
298
--error ER_UNSUPPORTED_EXTENSION
299
ALTER TABLE t CHANGE COLUMN a aa TINYINT UNSIGNED;
302
CREATE TABLE t (a MEDIUMINT UNSIGNED);
303
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
304
--error ER_UNSUPPORTED_EXTENSION
305
ALTER TABLE t CHANGE COLUMN a aa SMALLINT UNSIGNED;
308
CREATE TABLE t (a MEDIUMINT UNSIGNED);
309
INSERT INTO t VALUES ( 0 );
310
INSERT INTO t VALUES ( 1 );
311
INSERT INTO t VALUES ( 16777215 );
312
CREATE TABLE ti LIKE t;
313
ALTER TABLE ti ENGINE=myisam;
314
INSERT INTO ti SELECT * from t;
315
ALTER TABLE ti CHANGE COLUMN a aa MEDIUMINT UNSIGNED;
316
ALTER TABLE t CHANGE COLUMN a aa MEDIUMINT UNSIGNED;
317
ALTER TABLE t CHANGE COLUMN aa a MEDIUMINT UNSIGNED;
318
ALTER TABLE ti CHANGE COLUMN aa a MEDIUMINT UNSIGNED;
319
let $diff_tables = test.t, test.ti;
320
source include/diff_tables.inc;
324
CREATE TABLE t (a MEDIUMINT UNSIGNED);
325
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
326
--error ER_UNSUPPORTED_EXTENSION
327
ALTER TABLE t CHANGE COLUMN a aa INT UNSIGNED;
330
CREATE TABLE t (a MEDIUMINT UNSIGNED);
331
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
332
--error ER_UNSUPPORTED_EXTENSION
333
ALTER TABLE t CHANGE COLUMN a aa BIGINT UNSIGNED;
336
CREATE TABLE t (a INT UNSIGNED);
337
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
338
--error ER_UNSUPPORTED_EXTENSION
339
ALTER TABLE t CHANGE COLUMN a aa TINYINT UNSIGNED;
342
CREATE TABLE t (a INT UNSIGNED);
343
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
344
--error ER_UNSUPPORTED_EXTENSION
345
ALTER TABLE t CHANGE COLUMN a aa SMALLINT UNSIGNED;
348
CREATE TABLE t (a INT UNSIGNED);
349
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
350
--error ER_UNSUPPORTED_EXTENSION
351
ALTER TABLE t CHANGE COLUMN a aa MEDIUMINT UNSIGNED;
354
CREATE TABLE t (a INT UNSIGNED);
355
INSERT INTO t VALUES ( 0 );
356
INSERT INTO t VALUES ( 1 );
357
INSERT INTO t VALUES ( 4294967295 );
358
CREATE TABLE ti LIKE t;
359
ALTER TABLE ti ENGINE=myisam;
360
INSERT INTO ti SELECT * from t;
361
ALTER TABLE ti CHANGE COLUMN a aa INT UNSIGNED;
362
ALTER TABLE t CHANGE COLUMN a aa INT UNSIGNED;
363
ALTER TABLE t CHANGE COLUMN aa a INT UNSIGNED;
364
ALTER TABLE ti CHANGE COLUMN aa a INT UNSIGNED;
365
let $diff_tables = test.t, test.ti;
366
source include/diff_tables.inc;
370
CREATE TABLE t (a INT UNSIGNED);
371
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
372
--error ER_UNSUPPORTED_EXTENSION
373
ALTER TABLE t CHANGE COLUMN a aa BIGINT UNSIGNED;
376
CREATE TABLE t (a BIGINT UNSIGNED);
377
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
378
--error ER_UNSUPPORTED_EXTENSION
379
ALTER TABLE t CHANGE COLUMN a aa TINYINT UNSIGNED;
382
CREATE TABLE t (a BIGINT UNSIGNED);
383
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
384
--error ER_UNSUPPORTED_EXTENSION
385
ALTER TABLE t CHANGE COLUMN a aa SMALLINT UNSIGNED;
388
CREATE TABLE t (a BIGINT UNSIGNED);
389
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
390
--error ER_UNSUPPORTED_EXTENSION
391
ALTER TABLE t CHANGE COLUMN a aa MEDIUMINT UNSIGNED;
394
CREATE TABLE t (a BIGINT UNSIGNED);
395
--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/
396
--error ER_UNSUPPORTED_EXTENSION
397
ALTER TABLE t CHANGE COLUMN a aa INT UNSIGNED;
400
CREATE TABLE t (a BIGINT UNSIGNED);
401
INSERT INTO t VALUES ( 0 );
402
INSERT INTO t VALUES ( 1 );
403
INSERT INTO t VALUES ( 18446744073709551615 );
404
CREATE TABLE ti LIKE t;
405
ALTER TABLE ti ENGINE=myisam;
406
INSERT INTO ti SELECT * from t;
407
ALTER TABLE ti CHANGE COLUMN a aa BIGINT UNSIGNED;
408
ALTER TABLE t CHANGE COLUMN a aa BIGINT UNSIGNED;
409
ALTER TABLE t CHANGE COLUMN aa a BIGINT UNSIGNED;
410
ALTER TABLE ti CHANGE COLUMN aa a BIGINT UNSIGNED;
411
let $diff_tables = test.t, test.ti;
412
source include/diff_tables.inc;