2
DROP TABLE IF EXISTS `アアア`;
3
DROP TABLE IF EXISTS `イイイ`;
4
DROP TABLE IF EXISTS `あああ`;
5
DROP TABLE IF EXISTS `いいい`;
6
DROP TABLE IF EXISTS `龖龖龖`;
7
DROP TABLE IF EXISTS `龗龗龗`;
11
# Test altering table with Japanese characters in utf8 encoding
14
--source include/have_utf8.inc
16
SET character_set_database = utf8;
18
--source include/have_innodb.inc
23
CREATE TABLE `アアア`(`キキキ` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
24
CREATE TABLE `イイイ`(`ケケケ` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
25
CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
26
CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
27
CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
28
CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
30
INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
31
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
32
INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
34
# Test basic alter operation
36
ALTER TABLE `アアア` ADD `カカカ` char(1) FIRST;
37
ALTER TABLE `アアア` ADD `ククク` char(1) AFTER `キキキ`;
38
ALTER TABLE `アアア` ADD `ケケケ` char(1);
39
ALTER TABLE `アアア` ADD INDEX (`カカカ`);
40
ALTER TABLE `アアア` ADD PRIMARY KEY (`キキキ`);
41
ALTER TABLE `アアア` ADD UNIQUE (`ククク`);
42
#Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4
43
#ALTER TABLE `アアア` ADD FOREIGN KEY (`ケケケ`) REFERENCES `イイイ`(`ケケケ`);
44
ALTER TABLE `アアア` CHANGE `カカカ` `カカ` char(1);
45
ALTER TABLE `アアア` MODIFY `キキキ` char(6);
49
SHOW CREATE TABLE `アアア`;
51
ALTER TABLE `アアア` DROP INDEX `カカカ`;
52
ALTER TABLE `アアア` DROP PRIMARY KEY;
53
ALTER TABLE `アアア` DROP INDEX `ククク`;
54
#ALTER TABLE `アアア` DROP FOREIGN KEY `ケケケ`;
55
ALTER TABLE `アアア` DROP `カカ`;
56
ALTER TABLE `アアア` DROP `ククク`;
57
ALTER TABLE `アアア` DROP `ケケケ`;
60
SHOW CREATE TABLE `アアア`;
62
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
63
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
64
ALTER TABLE `あああ` ADD `けけけ` char(1);
65
ALTER TABLE `あああ` ADD INDEX (`かかか`);
66
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
67
ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
68
#Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4
69
#ALTER TABLE `あああ` ADD FOREIGN KEY (`けけけ`) REFERENCES `いいい`(`けけけ`);
70
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
71
ALTER TABLE `あああ` MODIFY `ききき` char(6);
75
SHOW CREATE TABLE `あああ`;
77
ALTER TABLE `あああ` DROP INDEX `かかか`;
78
ALTER TABLE `あああ` DROP PRIMARY KEY;
79
ALTER TABLE `あああ` DROP INDEX `くくく`;
80
#ALTER TABLE `あああ` DROP FOREIGN KEY `けけけ`;
81
ALTER TABLE `あああ` DROP `かか`;
82
ALTER TABLE `あああ` DROP `くくく`;
83
ALTER TABLE `あああ` DROP `けけけ`;
87
SHOW CREATE TABLE `あああ`;
89
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
90
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
91
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
92
ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
93
ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
94
ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
95
#Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4
96
#ALTER TABLE `龖龖龖` ADD FOREIGN KEY (`乚乚乚`) REFERENCES `龗龗龗`(`乚乚乚`);
97
ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
98
ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
102
SHOW CREATE TABLE `龖龖龖`;
104
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
105
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
106
ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
107
#ALTER TABLE `龖龖龖` DROP FOREIGN KEY `乚乚乚`;
108
ALTER TABLE `龖龖龖` DROP `丄丄`;
109
ALTER TABLE `龖龖龖` DROP `丅丅丅`;
110
ALTER TABLE `龖龖龖` DROP `乚乚乚`;
114
SHOW CREATE TABLE `龖龖龖`;
127
CREATE TABLE `アアア`(`キキキ` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
128
CREATE TABLE `イイイ`(`ケケケ` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
129
CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
130
CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
131
CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
132
CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
134
INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
135
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
136
INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
138
ALTER TABLE `アアア` ADD `カカカ` char(1) FIRST;
139
ALTER TABLE `アアア` ADD `ククク` char(1) AFTER `キキキ`;
140
ALTER TABLE `アアア` ADD `ケケケ` char(1);
141
ALTER TABLE `アアア` ADD INDEX (`カカカ`);
142
ALTER TABLE `アアア` ADD PRIMARY KEY (`キキキ`);
143
ALTER TABLE `アアア` ADD UNIQUE (`ククク`);
144
#ALTER TABLE `アアア` ADD FOREIGN KEY (`ケケケ`) REFERENCES `イイイ`(`ケケケ`);
145
ALTER TABLE `アアア` CHANGE `カカカ` `カカ` char(1);
146
ALTER TABLE `アアア` MODIFY `キキキ` char(6);
150
SHOW CREATE TABLE `アアア`;
152
ALTER TABLE `アアア` DROP INDEX `カカカ`;
153
ALTER TABLE `アアア` DROP PRIMARY KEY;
154
ALTER TABLE `アアア` DROP INDEX `ククク`;
155
#ALTER TABLE `アアア` DROP FOREIGN KEY `ケケケ`;
156
ALTER TABLE `アアア` DROP `カカ`;
157
ALTER TABLE `アアア` DROP `ククク`;
158
ALTER TABLE `アアア` DROP `ケケケ`;
161
SHOW CREATE TABLE `アアア`;
163
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
164
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
165
ALTER TABLE `あああ` ADD `けけけ` char(1);
166
ALTER TABLE `あああ` ADD INDEX (`かかか`);
167
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
168
ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
169
#ALTER TABLE `あああ` ADD FOREIGN KEY (`けけけ`) REFERENCES `いいい`(`けけけ`);
170
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
171
ALTER TABLE `あああ` MODIFY `ききき` char(6);
175
SHOW CREATE TABLE `あああ`;
177
ALTER TABLE `あああ` DROP INDEX `かかか`;
178
ALTER TABLE `あああ` DROP PRIMARY KEY;
179
ALTER TABLE `あああ` DROP INDEX `くくく`;
180
#ALTER TABLE `あああ` DROP FOREIGN KEY `けけけ`;
181
ALTER TABLE `あああ` DROP `かか`;
182
ALTER TABLE `あああ` DROP `くくく`;
183
ALTER TABLE `あああ` DROP `けけけ`;
187
SHOW CREATE TABLE `あああ`;
189
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
190
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
191
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
192
ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
193
ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
194
ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
195
#ALTER TABLE `龖龖龖` ADD FOREIGN KEY (`乚乚乚`) REFERENCES `龗龗龗`(`乚乚乚`);
196
ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
197
ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
201
SHOW CREATE TABLE `龖龖龖`;
203
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
204
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
205
ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
206
#ALTER TABLE `龖龖龖` DROP FOREIGN KEY `乚乚乚`;
207
ALTER TABLE `龖龖龖` DROP `丄丄`;
208
ALTER TABLE `龖龖龖` DROP `丅丅丅`;
209
ALTER TABLE `龖龖龖` DROP `乚乚乚`;
213
SHOW CREATE TABLE `龖龖龖`;
226
CREATE TABLE `アアア`(`キキキ` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
227
CREATE TABLE `イイイ`(`ケケケ` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
228
CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
229
CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
230
CREATE TABLE `龖龖龖`(`丂丂丂` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
231
CREATE TABLE `龗龗龗`(`乚乚乚` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
233
INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
234
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
235
INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
237
ALTER TABLE `アアア` ADD `カカカ` char(1) FIRST;
238
ALTER TABLE `アアア` ADD `ククク` char(1) AFTER `キキキ`;
239
ALTER TABLE `アアア` ADD `ケケケ` char(1);
240
ALTER TABLE `アアア` ADD INDEX (`カカカ`);
241
ALTER TABLE `アアア` ADD PRIMARY KEY (`キキキ`);
242
ALTER TABLE `アアア` ADD UNIQUE (`ククク`);
243
#ALTER TABLE `アアア` ADD FOREIGN KEY (`ケケケ`) REFERENCES `イイイ`(`ケケケ`);
244
ALTER TABLE `アアア` CHANGE `カカカ` `カカ` char(1);
245
ALTER TABLE `アアア` MODIFY `キキキ` char(6);
249
SHOW CREATE TABLE `アアア`;
251
ALTER TABLE `アアア` DROP INDEX `カカカ`;
252
ALTER TABLE `アアア` DROP PRIMARY KEY;
253
ALTER TABLE `アアア` DROP INDEX `ククク`;
254
#ALTER TABLE `アアア` DROP FOREIGN KEY `ケケケ`;
255
ALTER TABLE `アアア` DROP `カカ`;
256
ALTER TABLE `アアア` DROP `ククク`;
257
ALTER TABLE `アアア` DROP `ケケケ`;
260
SHOW CREATE TABLE `アアア`;
262
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
263
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
264
ALTER TABLE `あああ` ADD `けけけ` char(1);
265
ALTER TABLE `あああ` ADD INDEX (`かかか`);
266
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
267
ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
268
#ALTER TABLE `あああ` ADD FOREIGN KEY (`けけけ`) REFERENCES `いいい`(`けけけ`);
269
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
270
ALTER TABLE `あああ` MODIFY `ききき` char(6);
274
SHOW CREATE TABLE `あああ`;
276
ALTER TABLE `あああ` DROP INDEX `かかか`;
277
ALTER TABLE `あああ` DROP PRIMARY KEY;
278
ALTER TABLE `あああ` DROP INDEX `くくく`;
279
#ALTER TABLE `あああ` DROP FOREIGN KEY `けけけ`;
280
ALTER TABLE `あああ` DROP `かか`;
281
ALTER TABLE `あああ` DROP `くくく`;
282
ALTER TABLE `あああ` DROP `けけけ`;
286
SHOW CREATE TABLE `あああ`;
288
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
289
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
290
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
291
ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
292
ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
293
ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
294
#ALTER TABLE `龖龖龖` ADD FOREIGN KEY (`乚乚乚`) REFERENCES `龗龗龗`(`乚乚乚`);
295
ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
296
ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
300
SHOW CREATE TABLE `龖龖龖`;
302
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
303
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
304
ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
305
#ALTER TABLE `龖龖龖` DROP FOREIGN KEY `乚乚乚`;
306
ALTER TABLE `龖龖龖` DROP `丄丄`;
307
ALTER TABLE `龖龖龖` DROP `丅丅丅`;
308
ALTER TABLE `龖龖龖` DROP `乚乚乚`;
312
SHOW CREATE TABLE `龖龖龖`;