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 --source include/have_utf8.inc
15 SET NAMES utf8;
16 SET character_set_database = utf8;
17
18 --source include/have_innodb.inc
19
20 #
21 # Test InnoDB
22 #
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;
29
30 INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
31 INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
32 INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
33
34 # Test basic alter operation
35
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);
46
47 SELECT * FROM `アアア`;
48 DESC `アアア`;
49 SHOW CREATE TABLE `アアア`;
50
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 `ケケケ`;
58 SELECT * FROM `アアア`;
59 DESC `アアア`;
60 SHOW CREATE TABLE `アアア`;
61
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);
72
73 SELECT * FROM `あああ`;
74 DESC `あああ`;
75 SHOW CREATE TABLE `あああ`;
76
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 `けけけ`;
84
85 SELECT * FROM `あああ`;
86 DESC `あああ`;
87 SHOW CREATE TABLE `あああ`;
88
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);
99
100 SELECT * FROM `龖龖龖`;
101 DESC `龖龖龖`;
102 SHOW CREATE TABLE `龖龖龖`;
103
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 `乚乚乚`;
111
112 SELECT * FROM `龖龖龖`;
113 DESC `龖龖龖`;
114 SHOW CREATE TABLE `龖龖龖`;
115
116 DROP TABLE `アアア`;
117 DROP TABLE `イイイ`;
118 DROP TABLE `あああ`;
119 DROP TABLE `いいい`;
120 DROP TABLE `龖龖龖`;
121 DROP TABLE `龗龗龗`;
122
123 #
124 # Test MyISAM
125 #
126
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;
133
134 INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
135 INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
136 INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
137
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);
147
148 SELECT * FROM `アアア`;
149 DESC `アアア`;
150 SHOW CREATE TABLE `アアア`;
151
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 `ケケケ`;
159 SELECT * FROM `アアア`;
160 DESC `アアア`;
161 SHOW CREATE TABLE `アアア`;
162
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);
172
173 SELECT * FROM `あああ`;
174 DESC `あああ`;
175 SHOW CREATE TABLE `あああ`;
176
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 `けけけ`;
184
185 SELECT * FROM `あああ`;
186 DESC `あああ`;
187 SHOW CREATE TABLE `あああ`;
188
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);
198
199 SELECT * FROM `龖龖龖`;
200 DESC `龖龖龖`;
201 SHOW CREATE TABLE `龖龖龖`;
202
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 `乚乚乚`;
210
211 SELECT * FROM `龖龖龖`;
212 DESC `龖龖龖`;
213 SHOW CREATE TABLE `龖龖龖`;
214
215 DROP TABLE `アアア`;
216 DROP TABLE `イイイ`;
217 DROP TABLE `あああ`;
218 DROP TABLE `いいい`;
219 DROP TABLE `龖龖龖`;
220 DROP TABLE `龗龗龗`;
221
222 #
223 # Test MEMORY
224 #
225
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;
232
233 INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
234 INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
235 INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
236
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);
246
247 SELECT * FROM `アアア`;
248 DESC `アアア`;
249 SHOW CREATE TABLE `アアア`;
250
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 `ケケケ`;
258 SELECT * FROM `アアア`;
259 DESC `アアア`;
260 SHOW CREATE TABLE `アアア`;
261
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);
271
272 SELECT * FROM `あああ`;
273 DESC `あああ`;
274 SHOW CREATE TABLE `あああ`;
275
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 `けけけ`;
283
284 SELECT * FROM `あああ`;
285 DESC `あああ`;
286 SHOW CREATE TABLE `あああ`;
287
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);
297
298 SELECT * FROM `龖龖龖`;
299 DESC `龖龖龖`;
300 SHOW CREATE TABLE `龖龖龖`;
301
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 `乚乚乚`;
309
310 SELECT * FROM `龖龖龖`;
311 DESC `龖龖龖`;
312 SHOW CREATE TABLE `龖龖龖`;
313
314 DROP TABLE `アアア`;
315 DROP TABLE `イイイ`;
316 DROP TABLE `あああ`;
317 DROP TABLE `いいい`;
318 DROP TABLE `龖龖龖`;
319 DROP TABLE `龗龗龗`;