Debian Codegraph @

mysql-test/suite/jp/t/jp_alter_utf8.test

raw
1 --disable_warnings
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 `龗龗龗`;
8 --enable_warnings
9
10 #
11 # Test altering table with Japanese characters in utf8 encoding
12 #
13
14 SET NAMES utf8;
15 SET character_set_database = utf8;
16
17
18 #
19 # Test InnoDB
20 #
21 CREATE TABLE `アアア`(`キキキ` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
22 CREATE TABLE `イイイ`(`ケケケ` char(5)) DEFAULT CHARSET = utf8 engine=INNODB;
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
28 INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
29 INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
30 INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
31
32 # Test basic alter operation
33
34 ALTER TABLE `アアア` ADD `カカカ` char(1) FIRST;
35 ALTER TABLE `アアア` ADD `ククク` char(1) AFTER `キキキ`;
36 ALTER TABLE `アアア` ADD `ケケケ` char(1);
37 ALTER TABLE `アアア` ADD INDEX (`カカカ`);
38 ALTER TABLE `アアア` ADD PRIMARY KEY (`キキキ`);
39 ALTER TABLE `アアア` ADD UNIQUE (`ククク`);
40 #Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4
41 #ALTER TABLE `アアア` ADD FOREIGN KEY (`ケケケ`) REFERENCES `イイイ`(`ケケケ`);
42 ALTER TABLE `アアア` CHANGE `カカカ` `カカ` char(1);
43 ALTER TABLE `アアア` MODIFY `キキキ` char(6);
44
45 SELECT * FROM `アアア`;
46 DESC `アアア`;
47 SHOW CREATE TABLE `アアア`;
48
49 ALTER TABLE `アアア` DROP INDEX `カカカ`;
50 ALTER TABLE `アアア` DROP PRIMARY KEY;
51 ALTER TABLE `アアア` DROP INDEX `ククク`;
52 #ALTER TABLE `アアア` DROP FOREIGN KEY `ケケケ`;
53 ALTER TABLE `アアア` DROP `カカ`;
54 ALTER TABLE `アアア` DROP `ククク`;
55 ALTER TABLE `アアア` DROP `ケケケ`;
56 SELECT * FROM `アアア`;
57 DESC `アアア`;
58 SHOW CREATE TABLE `アアア`;
59
60 ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
61 ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
62 ALTER TABLE `あああ` ADD `けけけ` char(1);
63 ALTER TABLE `あああ` ADD INDEX (`かかか`);
64 ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
65 ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
66 #Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4
67 #ALTER TABLE `あああ` ADD FOREIGN KEY (`けけけ`) REFERENCES `いいい`(`けけけ`);
68 ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
69 ALTER TABLE `あああ` MODIFY `ききき` char(6);
70
71 SELECT * FROM `あああ`;
72 DESC `あああ`;
73 SHOW CREATE TABLE `あああ`;
74
75 ALTER TABLE `あああ` DROP INDEX `かかか`;
76 ALTER TABLE `あああ` DROP PRIMARY KEY;
77 ALTER TABLE `あああ` DROP INDEX `くくく`;
78 #ALTER TABLE `あああ` DROP FOREIGN KEY `けけけ`;
79 ALTER TABLE `あああ` DROP `かか`;
80 ALTER TABLE `あああ` DROP `くくく`;
81 ALTER TABLE `あああ` DROP `けけけ`;
82
83 SELECT * FROM `あああ`;
84 DESC `あああ`;
85 SHOW CREATE TABLE `あああ`;
86
87 ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
88 ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
89 ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
90 ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
91 ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
92 ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
93 #Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4
94 #ALTER TABLE `龖龖龖` ADD FOREIGN KEY (`乚乚乚`) REFERENCES `龗龗龗`(`乚乚乚`);
95 ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
96 ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
97
98 SELECT * FROM `龖龖龖`;
99 DESC `龖龖龖`;
100 SHOW CREATE TABLE `龖龖龖`;
101
102 ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
103 ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
104 ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
105 #ALTER TABLE `龖龖龖` DROP FOREIGN KEY `乚乚乚`;
106 ALTER TABLE `龖龖龖` DROP `丄丄`;
107 ALTER TABLE `龖龖龖` DROP `丅丅丅`;
108 ALTER TABLE `龖龖龖` DROP `乚乚乚`;
109
110 SELECT * FROM `龖龖龖`;
111 DESC `龖龖龖`;
112 SHOW CREATE TABLE `龖龖龖`;
113
114 DROP TABLE `アアア`;
115 DROP TABLE `イイイ`;
116 DROP TABLE `あああ`;
117 DROP TABLE `いいい`;
118 DROP TABLE `龖龖龖`;
119 DROP TABLE `龗龗龗`;
120
121 #
122 # Test MyISAM
123 #
124
125 CREATE TABLE `アアア`(`キキキ` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
126 CREATE TABLE `イイイ`(`ケケケ` char(5)) DEFAULT CHARSET = utf8 engine=MYISAM;
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
132 INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
133 INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
134 INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
135
136 ALTER TABLE `アアア` ADD `カカカ` char(1) FIRST;
137 ALTER TABLE `アアア` ADD `ククク` char(1) AFTER `キキキ`;
138 ALTER TABLE `アアア` ADD `ケケケ` char(1);
139 ALTER TABLE `アアア` ADD INDEX (`カカカ`);
140 ALTER TABLE `アアア` ADD PRIMARY KEY (`キキキ`);
141 ALTER TABLE `アアア` ADD UNIQUE (`ククク`);
142 #ALTER TABLE `アアア` ADD FOREIGN KEY (`ケケケ`) REFERENCES `イイイ`(`ケケケ`);
143 ALTER TABLE `アアア` CHANGE `カカカ` `カカ` char(1);
144 ALTER TABLE `アアア` MODIFY `キキキ` char(6);
145
146 SELECT * FROM `アアア`;
147 DESC `アアア`;
148 SHOW CREATE TABLE `アアア`;
149
150 ALTER TABLE `アアア` DROP INDEX `カカカ`;
151 ALTER TABLE `アアア` DROP PRIMARY KEY;
152 ALTER TABLE `アアア` DROP INDEX `ククク`;
153 #ALTER TABLE `アアア` DROP FOREIGN KEY `ケケケ`;
154 ALTER TABLE `アアア` DROP `カカ`;
155 ALTER TABLE `アアア` DROP `ククク`;
156 ALTER TABLE `アアア` DROP `ケケケ`;
157 SELECT * FROM `アアア`;
158 DESC `アアア`;
159 SHOW CREATE TABLE `アアア`;
160
161 ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
162 ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
163 ALTER TABLE `あああ` ADD `けけけ` char(1);
164 ALTER TABLE `あああ` ADD INDEX (`かかか`);
165 ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
166 ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
167 #ALTER TABLE `あああ` ADD FOREIGN KEY (`けけけ`) REFERENCES `いいい`(`けけけ`);
168 ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
169 ALTER TABLE `あああ` MODIFY `ききき` char(6);
170
171 SELECT * FROM `あああ`;
172 DESC `あああ`;
173 SHOW CREATE TABLE `あああ`;
174
175 ALTER TABLE `あああ` DROP INDEX `かかか`;
176 ALTER TABLE `あああ` DROP PRIMARY KEY;
177 ALTER TABLE `あああ` DROP INDEX `くくく`;
178 #ALTER TABLE `あああ` DROP FOREIGN KEY `けけけ`;
179 ALTER TABLE `あああ` DROP `かか`;
180 ALTER TABLE `あああ` DROP `くくく`;
181 ALTER TABLE `あああ` DROP `けけけ`;
182
183 SELECT * FROM `あああ`;
184 DESC `あああ`;
185 SHOW CREATE TABLE `あああ`;
186
187 ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
188 ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
189 ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
190 ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
191 ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
192 ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
193 #ALTER TABLE `龖龖龖` ADD FOREIGN KEY (`乚乚乚`) REFERENCES `龗龗龗`(`乚乚乚`);
194 ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
195 ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
196
197 SELECT * FROM `龖龖龖`;
198 DESC `龖龖龖`;
199 SHOW CREATE TABLE `龖龖龖`;
200
201 ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
202 ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
203 ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
204 #ALTER TABLE `龖龖龖` DROP FOREIGN KEY `乚乚乚`;
205 ALTER TABLE `龖龖龖` DROP `丄丄`;
206 ALTER TABLE `龖龖龖` DROP `丅丅丅`;
207 ALTER TABLE `龖龖龖` DROP `乚乚乚`;
208
209 SELECT * FROM `龖龖龖`;
210 DESC `龖龖龖`;
211 SHOW CREATE TABLE `龖龖龖`;
212
213 DROP TABLE `アアア`;
214 DROP TABLE `イイイ`;
215 DROP TABLE `あああ`;
216 DROP TABLE `いいい`;
217 DROP TABLE `龖龖龖`;
218 DROP TABLE `龗龗龗`;
219
220 #
221 # Test MEMORY
222 #
223
224 CREATE TABLE `アアア`(`キキキ` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
225 CREATE TABLE `イイイ`(`ケケケ` char(5)) DEFAULT CHARSET = utf8 engine=MEMORY;
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
231 INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
232 INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
233 INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
234
235 ALTER TABLE `アアア` ADD `カカカ` char(1) FIRST;
236 ALTER TABLE `アアア` ADD `ククク` char(1) AFTER `キキキ`;
237 ALTER TABLE `アアア` ADD `ケケケ` char(1);
238 ALTER TABLE `アアア` ADD INDEX (`カカカ`);
239 ALTER TABLE `アアア` ADD PRIMARY KEY (`キキキ`);
240 ALTER TABLE `アアア` ADD UNIQUE (`ククク`);
241 #ALTER TABLE `アアア` ADD FOREIGN KEY (`ケケケ`) REFERENCES `イイイ`(`ケケケ`);
242 ALTER TABLE `アアア` CHANGE `カカカ` `カカ` char(1);
243 ALTER TABLE `アアア` MODIFY `キキキ` char(6);
244
245 SELECT * FROM `アアア`;
246 DESC `アアア`;
247 SHOW CREATE TABLE `アアア`;
248
249 ALTER TABLE `アアア` DROP INDEX `カカカ`;
250 ALTER TABLE `アアア` DROP PRIMARY KEY;
251 ALTER TABLE `アアア` DROP INDEX `ククク`;
252 #ALTER TABLE `アアア` DROP FOREIGN KEY `ケケケ`;
253 ALTER TABLE `アアア` DROP `カカ`;
254 ALTER TABLE `アアア` DROP `ククク`;
255 ALTER TABLE `アアア` DROP `ケケケ`;
256 SELECT * FROM `アアア`;
257 DESC `アアア`;
258 SHOW CREATE TABLE `アアア`;
259
260 ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
261 ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
262 ALTER TABLE `あああ` ADD `けけけ` char(1);
263 ALTER TABLE `あああ` ADD INDEX (`かかか`);
264 ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
265 ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
266 #ALTER TABLE `あああ` ADD FOREIGN KEY (`けけけ`) REFERENCES `いいい`(`けけけ`);
267 ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
268 ALTER TABLE `あああ` MODIFY `ききき` char(6);
269
270 SELECT * FROM `あああ`;
271 DESC `あああ`;
272 SHOW CREATE TABLE `あああ`;
273
274 ALTER TABLE `あああ` DROP INDEX `かかか`;
275 ALTER TABLE `あああ` DROP PRIMARY KEY;
276 ALTER TABLE `あああ` DROP INDEX `くくく`;
277 #ALTER TABLE `あああ` DROP FOREIGN KEY `けけけ`;
278 ALTER TABLE `あああ` DROP `かか`;
279 ALTER TABLE `あああ` DROP `くくく`;
280 ALTER TABLE `あああ` DROP `けけけ`;
281
282 SELECT * FROM `あああ`;
283 DESC `あああ`;
284 SHOW CREATE TABLE `あああ`;
285
286 ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
287 ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
288 ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
289 ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
290 ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
291 ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
292 #ALTER TABLE `龖龖龖` ADD FOREIGN KEY (`乚乚乚`) REFERENCES `龗龗龗`(`乚乚乚`);
293 ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
294 ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
295
296 SELECT * FROM `龖龖龖`;
297 DESC `龖龖龖`;
298 SHOW CREATE TABLE `龖龖龖`;
299
300 ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
301 ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
302 ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
303 #ALTER TABLE `龖龖龖` DROP FOREIGN KEY `乚乚乚`;
304 ALTER TABLE `龖龖龖` DROP `丄丄`;
305 ALTER TABLE `龖龖龖` DROP `丅丅丅`;
306 ALTER TABLE `龖龖龖` DROP `乚乚乚`;
307
308 SELECT * FROM `龖龖龖`;
309 DESC `龖龖龖`;
310 SHOW CREATE TABLE `龖龖龖`;
311
312 DROP TABLE `アアア`;
313 DROP TABLE `イイイ`;
314 DROP TABLE `あああ`;
315 DROP TABLE `いいい`;
316 DROP TABLE `龖龖龖`;
317 DROP TABLE `龗龗龗`;