|
1
by brian
clean slate |
1 |
--source include/have_ujis.inc
|
2 |
||
3 |
--disable_warnings
|
|
4 |
DROP TABLE IF EXISTS `±±±`; |
|
5 |
DROP TABLE IF EXISTS `²²²`; |
|
6 |
DROP TABLE IF EXISTS `€¢€¢€¢`; |
|
7 |
DROP TABLE IF EXISTS `€€€€€€`; |
|
8 |
DROP TABLE IF EXISTS `íÝíÝíÝ`; |
|
9 |
DROP TABLE IF EXISTS `íÞíÞíÞ`; |
|
10 |
--enable_warnings
|
|
11 |
||
12 |
#
|
|
13 |
# Test altering table with Japanese characters in ujis encoding |
|
14 |
#
|
|
15 |
||
16 |
SET NAMES ujis; |
|
17 |
SET character_set_database = ujis; |
|
18 |
||
19 |
#
|
|
20 |
# Test InnoDB |
|
21 |
#
|
|
22 |
CREATE TABLE `±±±`(`···` char(5)) DEFAULT CHARSET = ujis engine=INNODB; |
|
23 |
CREATE TABLE `²²²`(`¹¹¹` char(5)) DEFAULT CHARSET = ujis engine=INNODB; |
|
24 |
CREATE TABLE `€¢€¢€¢`(`€€€` char(5)) DEFAULT CHARSET = ujis engine=INNODB; |
|
25 |
CREATE TABLE `€€€€€€`(`€±€±€±` char(5)) DEFAULT CHARSET = ujis engine=INNODB; |
|
26 |
CREATE TABLE `íÝíÝíÝ`(`°¡°¡°¡` char(5)) DEFAULT CHARSET = ujis engine=INNODB; |
|
27 |
CREATE TABLE `íÞíÞíÞ`(`°Ž°Ž°Ž` char(5)) DEFAULT CHARSET = ujis engine=INNODB; |
|
28 |
||
29 |
INSERT INTO `±±±` VALUES ('±±±±±'),('²²²²²'),('³³³³³'); |
|
30 |
INSERT INTO `€¢€¢€¢` VALUES ('€¢€¢€¢€¢€¢'),('€€€€€€€€€€'),('€Š€Š€Š€Š€Š'); |
|
31 |
INSERT INTO `íÝíÝíÝ` VALUES ('°¡°¡°¡°¡°¡'),('°¢°¢°¢°¢°¢'),('°£°£°£°£°£'); |
|
32 |
||
33 |
# Test basic alter operation |
|
34 |
||
35 |
ALTER TABLE `±±±` ADD `¶¶¶` char(1) FIRST; |
|
36 |
ALTER TABLE `±±±` ADD `žžž` char(1) AFTER `···`; |
|
37 |
ALTER TABLE `±±±` ADD `¹¹¹` char(1); |
|
38 |
ALTER TABLE `±±±` ADD INDEX (`¶¶¶`); |
|
39 |
ALTER TABLE `±±±` ADD PRIMARY KEY (`···`); |
|
40 |
ALTER TABLE `±±±` ADD UNIQUE (`žžž`); |
|
41 |
#Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4 |
|
42 |
#ALTER TABLE `±±±` ADD FOREIGN KEY (`¹¹¹`) REFERENCES `²²²`(`¹¹¹`); |
|
43 |
ALTER TABLE `±±±` CHANGE `¶¶¶` `¶¶` char(1); |
|
44 |
ALTER TABLE `±±±` MODIFY `···` char(6); |
|
45 |
||
46 |
SELECT * FROM `±±±`; |
|
47 |
DESC `±±±`; |
|
48 |
SHOW CREATE TABLE `±±±`; |
|
49 |
||
50 |
ALTER TABLE `±±±` DROP INDEX `¶¶¶`; |
|
51 |
ALTER TABLE `±±±` DROP PRIMARY KEY; |
|
52 |
ALTER TABLE `±±±` DROP INDEX `žžž`; |
|
53 |
#ALTER TABLE `±±±` DROP FOREIGN KEY `¹¹¹`; |
|
54 |
ALTER TABLE `±±±` DROP `¶¶`; |
|
55 |
ALTER TABLE `±±±` DROP `žžž`; |
|
56 |
ALTER TABLE `±±±` DROP `¹¹¹`; |
|
57 |
SELECT * FROM `±±±`; |
|
58 |
DESC `±±±`; |
|
59 |
SHOW CREATE TABLE `±±±`; |
|
60 |
||
61 |
ALTER TABLE `€¢€¢€¢` ADD `€«€«€«` char(1) FIRST; |
|
62 |
ALTER TABLE `€¢€¢€¢` ADD `€¯€¯€¯` char(1) AFTER `€€€`; |
|
63 |
ALTER TABLE `€¢€¢€¢` ADD `€±€±€±` char(1); |
|
64 |
ALTER TABLE `€¢€¢€¢` ADD INDEX (`€«€«€«`); |
|
65 |
ALTER TABLE `€¢€¢€¢` ADD PRIMARY KEY (`€€€`); |
|
66 |
ALTER TABLE `€¢€¢€¢` ADD UNIQUE (`€¯€¯€¯`); |
|
67 |
#Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4 |
|
68 |
#ALTER TABLE `€¢€¢€¢` ADD FOREIGN KEY (`€±€±€±`) REFERENCES `€€€€€€`(`€±€±€±`); |
|
69 |
ALTER TABLE `€¢€¢€¢` CHANGE `€«€«€«` `€«€«` char(1); |
|
70 |
ALTER TABLE `€¢€¢€¢` MODIFY `€€€` char(6); |
|
71 |
||
72 |
SELECT * FROM `€¢€¢€¢`; |
|
73 |
DESC `€¢€¢€¢`; |
|
74 |
SHOW CREATE TABLE `€¢€¢€¢`; |
|
75 |
||
76 |
ALTER TABLE `€¢€¢€¢` DROP INDEX `€«€«€«`; |
|
77 |
ALTER TABLE `€¢€¢€¢` DROP PRIMARY KEY; |
|
78 |
ALTER TABLE `€¢€¢€¢` DROP INDEX `€¯€¯€¯`; |
|
79 |
#ALTER TABLE `€¢€¢€¢` DROP FOREIGN KEY `€±€±€±`; |
|
80 |
ALTER TABLE `€¢€¢€¢` DROP `€«€«`; |
|
81 |
ALTER TABLE `€¢€¢€¢` DROP `€¯€¯€¯`; |
|
82 |
ALTER TABLE `€¢€¢€¢` DROP `€±€±€±`; |
|
83 |
||
84 |
SELECT * FROM `€¢€¢€¢`; |
|
85 |
DESC `€¢€¢€¢`; |
|
86 |
SHOW CREATE TABLE `€¢€¢€¢`; |
|
87 |
||
88 |
ALTER TABLE `íÝíÝíÝ` ADD `°¢°¢°¢` char(1) FIRST; |
|
89 |
ALTER TABLE `íÝíÝíÝ` ADD `°£°£°£` char(1) AFTER `°¡°¡°¡`; |
|
90 |
ALTER TABLE `íÝíÝíÝ` ADD `°Ž°Ž°Ž` char(1); |
|
91 |
ALTER TABLE `íÝíÝíÝ` ADD INDEX (`°¢°¢°¢`); |
|
92 |
ALTER TABLE `íÝíÝíÝ` ADD PRIMARY KEY (`°¡°¡°¡`); |
|
93 |
ALTER TABLE `íÝíÝíÝ` ADD UNIQUE (`°£°£°£`); |
|
94 |
#Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4 |
|
95 |
#ALTER TABLE `íÝíÝíÝ` ADD FOREIGN KEY (`°Ž°Ž°Ž`) REFERENCES `íÞíÞíÞ`(`°Ž°Ž°Ž`); |
|
96 |
ALTER TABLE `íÝíÝíÝ` CHANGE `°¢°¢°¢` `°¢°¢` char(1); |
|
97 |
ALTER TABLE `íÝíÝíÝ` MODIFY `°¡°¡°¡` char(6); |
|
98 |
||
99 |
SELECT * FROM `íÝíÝíÝ`; |
|
100 |
DESC `íÝíÝíÝ`; |
|
101 |
SHOW CREATE TABLE `íÝíÝíÝ`; |
|
102 |
||
103 |
ALTER TABLE `íÝíÝíÝ` DROP INDEX `°¢°¢°¢`; |
|
104 |
ALTER TABLE `íÝíÝíÝ` DROP PRIMARY KEY; |
|
105 |
ALTER TABLE `íÝíÝíÝ` DROP INDEX `°£°£°£`; |
|
106 |
#ALTER TABLE `íÝíÝíÝ` DROP FOREIGN KEY `°Ž°Ž°Ž`; |
|
107 |
ALTER TABLE `íÝíÝíÝ` DROP `°¢°¢`; |
|
108 |
ALTER TABLE `íÝíÝíÝ` DROP `°£°£°£`; |
|
109 |
ALTER TABLE `íÝíÝíÝ` DROP `°Ž°Ž°Ž`; |
|
110 |
||
111 |
SELECT * FROM `íÝíÝíÝ`; |
|
112 |
DESC `íÝíÝíÝ`; |
|
113 |
SHOW CREATE TABLE `íÝíÝíÝ`; |
|
114 |
||
115 |
DROP TABLE `±±±`; |
|
116 |
DROP TABLE `²²²`; |
|
117 |
DROP TABLE `€¢€¢€¢`; |
|
118 |
DROP TABLE `€€€€€€`; |
|
119 |
DROP TABLE `íÝíÝíÝ`; |
|
120 |
DROP TABLE `íÞíÞíÞ`; |
|
121 |
||
122 |
#
|
|
123 |
# Test MyISAM |
|
124 |
#
|
|
125 |
||
126 |
CREATE TABLE `±±±`(`···` char(5)) DEFAULT CHARSET = ujis engine=MYISAM; |
|
127 |
CREATE TABLE `²²²`(`¹¹¹` char(5)) DEFAULT CHARSET = ujis engine=MYISAM; |
|
128 |
CREATE TABLE `€¢€¢€¢`(`€€€` char(5)) DEFAULT CHARSET = ujis engine=MYISAM; |
|
129 |
CREATE TABLE `€€€€€€`(`€±€±€±` char(5)) DEFAULT CHARSET = ujis engine=MYISAM; |
|
130 |
CREATE TABLE `íÝíÝíÝ`(`°¡°¡°¡` char(5)) DEFAULT CHARSET = ujis engine=MYISAM; |
|
131 |
CREATE TABLE `íÞíÞíÞ`(`°Ž°Ž°Ž` char(5)) DEFAULT CHARSET = ujis engine=MYISAM; |
|
132 |
||
133 |
INSERT INTO `±±±` VALUES ('±±±±±'),('²²²²²'),('³³³³³'); |
|
134 |
INSERT INTO `€¢€¢€¢` VALUES ('€¢€¢€¢€¢€¢'),('€€€€€€€€€€'),('€Š€Š€Š€Š€Š'); |
|
135 |
INSERT INTO `íÝíÝíÝ` VALUES ('°¡°¡°¡°¡°¡'),('°¢°¢°¢°¢°¢'),('°£°£°£°£°£'); |
|
136 |
||
137 |
ALTER TABLE `±±±` ADD `¶¶¶` char(1) FIRST; |
|
138 |
ALTER TABLE `±±±` ADD `žžž` char(1) AFTER `···`; |
|
139 |
ALTER TABLE `±±±` ADD `¹¹¹` char(1); |
|
140 |
ALTER TABLE `±±±` ADD INDEX (`¶¶¶`); |
|
141 |
ALTER TABLE `±±±` ADD PRIMARY KEY (`···`); |
|
142 |
ALTER TABLE `±±±` ADD UNIQUE (`žžž`); |
|
143 |
#ALTER TABLE `±±±` ADD FOREIGN KEY (`¹¹¹`) REFERENCES `²²²`(`¹¹¹`); |
|
144 |
ALTER TABLE `±±±` CHANGE `¶¶¶` `¶¶` char(1); |
|
145 |
ALTER TABLE `±±±` MODIFY `···` char(6); |
|
146 |
||
147 |
SELECT * FROM `±±±`; |
|
148 |
DESC `±±±`; |
|
149 |
SHOW CREATE TABLE `±±±`; |
|
150 |
||
151 |
ALTER TABLE `±±±` DROP INDEX `¶¶¶`; |
|
152 |
ALTER TABLE `±±±` DROP PRIMARY KEY; |
|
153 |
ALTER TABLE `±±±` DROP INDEX `žžž`; |
|
154 |
#ALTER TABLE `±±±` DROP FOREIGN KEY `¹¹¹`; |
|
155 |
ALTER TABLE `±±±` DROP `¶¶`; |
|
156 |
ALTER TABLE `±±±` DROP `žžž`; |
|
157 |
ALTER TABLE `±±±` DROP `¹¹¹`; |
|
158 |
SELECT * FROM `±±±`; |
|
159 |
DESC `±±±`; |
|
160 |
SHOW CREATE TABLE `±±±`; |
|
161 |
||
162 |
ALTER TABLE `€¢€¢€¢` ADD `€«€«€«` char(1) FIRST; |
|
163 |
ALTER TABLE `€¢€¢€¢` ADD `€¯€¯€¯` char(1) AFTER `€€€`; |
|
164 |
ALTER TABLE `€¢€¢€¢` ADD `€±€±€±` char(1); |
|
165 |
ALTER TABLE `€¢€¢€¢` ADD INDEX (`€«€«€«`); |
|
166 |
ALTER TABLE `€¢€¢€¢` ADD PRIMARY KEY (`€€€`); |
|
167 |
ALTER TABLE `€¢€¢€¢` ADD UNIQUE (`€¯€¯€¯`); |
|
168 |
#ALTER TABLE `€¢€¢€¢` ADD FOREIGN KEY (`€±€±€±`) REFERENCES `€€€€€€`(`€±€±€±`); |
|
169 |
ALTER TABLE `€¢€¢€¢` CHANGE `€«€«€«` `€«€«` char(1); |
|
170 |
ALTER TABLE `€¢€¢€¢` MODIFY `€€€` char(6); |
|
171 |
||
172 |
SELECT * FROM `€¢€¢€¢`; |
|
173 |
DESC `€¢€¢€¢`; |
|
174 |
SHOW CREATE TABLE `€¢€¢€¢`; |
|
175 |
||
176 |
ALTER TABLE `€¢€¢€¢` DROP INDEX `€«€«€«`; |
|
177 |
ALTER TABLE `€¢€¢€¢` DROP PRIMARY KEY; |
|
178 |
ALTER TABLE `€¢€¢€¢` DROP INDEX `€¯€¯€¯`; |
|
179 |
#ALTER TABLE `€¢€¢€¢` DROP FOREIGN KEY `€±€±€±`; |
|
180 |
ALTER TABLE `€¢€¢€¢` DROP `€«€«`; |
|
181 |
ALTER TABLE `€¢€¢€¢` DROP `€¯€¯€¯`; |
|
182 |
ALTER TABLE `€¢€¢€¢` DROP `€±€±€±`; |
|
183 |
||
184 |
SELECT * FROM `€¢€¢€¢`; |
|
185 |
DESC `€¢€¢€¢`; |
|
186 |
SHOW CREATE TABLE `€¢€¢€¢`; |
|
187 |
||
188 |
ALTER TABLE `íÝíÝíÝ` ADD `°¢°¢°¢` char(1) FIRST; |
|
189 |
ALTER TABLE `íÝíÝíÝ` ADD `°£°£°£` char(1) AFTER `°¡°¡°¡`; |
|
190 |
ALTER TABLE `íÝíÝíÝ` ADD `°Ž°Ž°Ž` char(1); |
|
191 |
ALTER TABLE `íÝíÝíÝ` ADD INDEX (`°¢°¢°¢`); |
|
192 |
ALTER TABLE `íÝíÝíÝ` ADD PRIMARY KEY (`°¡°¡°¡`); |
|
193 |
ALTER TABLE `íÝíÝíÝ` ADD UNIQUE (`°£°£°£`); |
|
194 |
#ALTER TABLE `íÝíÝíÝ` ADD FOREIGN KEY (`°Ž°Ž°Ž`) REFERENCES `íÞíÞíÞ`(`°Ž°Ž°Ž`); |
|
195 |
ALTER TABLE `íÝíÝíÝ` CHANGE `°¢°¢°¢` `°¢°¢` char(1); |
|
196 |
ALTER TABLE `íÝíÝíÝ` MODIFY `°¡°¡°¡` char(6); |
|
197 |
||
198 |
SELECT * FROM `íÝíÝíÝ`; |
|
199 |
DESC `íÝíÝíÝ`; |
|
200 |
SHOW CREATE TABLE `íÝíÝíÝ`; |
|
201 |
||
202 |
ALTER TABLE `íÝíÝíÝ` DROP INDEX `°¢°¢°¢`; |
|
203 |
ALTER TABLE `íÝíÝíÝ` DROP PRIMARY KEY; |
|
204 |
ALTER TABLE `íÝíÝíÝ` DROP INDEX `°£°£°£`; |
|
205 |
#ALTER TABLE `íÝíÝíÝ` DROP FOREIGN KEY `°Ž°Ž°Ž`; |
|
206 |
ALTER TABLE `íÝíÝíÝ` DROP `°¢°¢`; |
|
207 |
ALTER TABLE `íÝíÝíÝ` DROP `°£°£°£`; |
|
208 |
ALTER TABLE `íÝíÝíÝ` DROP `°Ž°Ž°Ž`; |
|
209 |
||
210 |
SELECT * FROM `íÝíÝíÝ`; |
|
211 |
DESC `íÝíÝíÝ`; |
|
212 |
SHOW CREATE TABLE `íÝíÝíÝ`; |
|
213 |
||
214 |
DROP TABLE `±±±`; |
|
215 |
DROP TABLE `²²²`; |
|
216 |
DROP TABLE `€¢€¢€¢`; |
|
217 |
DROP TABLE `€€€€€€`; |
|
218 |
DROP TABLE `íÝíÝíÝ`; |
|
219 |
DROP TABLE `íÞíÞíÞ`; |
|
220 |
||
221 |
#
|
|
222 |
# Test HEAP |
|
223 |
#
|
|
224 |
||
225 |
CREATE TABLE `±±±`(`···` char(5)) DEFAULT CHARSET = ujis engine=HEAP; |
|
226 |
CREATE TABLE `²²²`(`¹¹¹` char(5)) DEFAULT CHARSET = ujis engine=HEAP; |
|
227 |
CREATE TABLE `€¢€¢€¢`(`€€€` char(5)) DEFAULT CHARSET = ujis engine=HEAP; |
|
228 |
CREATE TABLE `€€€€€€`(`€±€±€±` char(5)) DEFAULT CHARSET = ujis engine=HEAP; |
|
229 |
CREATE TABLE `íÝíÝíÝ`(`°¡°¡°¡` char(5)) DEFAULT CHARSET = ujis engine=HEAP; |
|
230 |
CREATE TABLE `íÞíÞíÞ`(`°Ž°Ž°Ž` char(5)) DEFAULT CHARSET = ujis engine=HEAP; |
|
231 |
||
232 |
INSERT INTO `±±±` VALUES ('±±±±±'),('²²²²²'),('³³³³³'); |
|
233 |
INSERT INTO `€¢€¢€¢` VALUES ('€¢€¢€¢€¢€¢'),('€€€€€€€€€€'),('€Š€Š€Š€Š€Š'); |
|
234 |
INSERT INTO `íÝíÝíÝ` VALUES ('°¡°¡°¡°¡°¡'),('°¢°¢°¢°¢°¢'),('°£°£°£°£°£'); |
|
235 |
||
236 |
ALTER TABLE `±±±` ADD `¶¶¶` char(1) FIRST; |
|
237 |
ALTER TABLE `±±±` ADD `žžž` char(1) AFTER `···`; |
|
238 |
ALTER TABLE `±±±` ADD `¹¹¹` char(1); |
|
239 |
ALTER TABLE `±±±` ADD INDEX (`¶¶¶`); |
|
240 |
ALTER TABLE `±±±` ADD PRIMARY KEY (`···`); |
|
241 |
ALTER TABLE `±±±` ADD UNIQUE (`žžž`); |
|
242 |
#ALTER TABLE `±±±` ADD FOREIGN KEY (`¹¹¹`) REFERENCES `²²²`(`¹¹¹`); |
|
243 |
ALTER TABLE `±±±` CHANGE `¶¶¶` `¶¶` char(1); |
|
244 |
ALTER TABLE `±±±` MODIFY `···` char(6); |
|
245 |
||
246 |
SELECT * FROM `±±±`; |
|
247 |
DESC `±±±`; |
|
248 |
SHOW CREATE TABLE `±±±`; |
|
249 |
||
250 |
ALTER TABLE `±±±` DROP INDEX `¶¶¶`; |
|
251 |
ALTER TABLE `±±±` DROP PRIMARY KEY; |
|
252 |
ALTER TABLE `±±±` DROP INDEX `žžž`; |
|
253 |
#ALTER TABLE `±±±` DROP FOREIGN KEY `¹¹¹`; |
|
254 |
ALTER TABLE `±±±` DROP `¶¶`; |
|
255 |
ALTER TABLE `±±±` DROP `žžž`; |
|
256 |
ALTER TABLE `±±±` DROP `¹¹¹`; |
|
257 |
SELECT * FROM `±±±`; |
|
258 |
DESC `±±±`; |
|
259 |
SHOW CREATE TABLE `±±±`; |
|
260 |
||
261 |
ALTER TABLE `€¢€¢€¢` ADD `€«€«€«` char(1) FIRST; |
|
262 |
ALTER TABLE `€¢€¢€¢` ADD `€¯€¯€¯` char(1) AFTER `€€€`; |
|
263 |
ALTER TABLE `€¢€¢€¢` ADD `€±€±€±` char(1); |
|
264 |
ALTER TABLE `€¢€¢€¢` ADD INDEX (`€«€«€«`); |
|
265 |
ALTER TABLE `€¢€¢€¢` ADD PRIMARY KEY (`€€€`); |
|
266 |
ALTER TABLE `€¢€¢€¢` ADD UNIQUE (`€¯€¯€¯`); |
|
267 |
#ALTER TABLE `€¢€¢€¢` ADD FOREIGN KEY (`€±€±€±`) REFERENCES `€€€€€€`(`€±€±€±`); |
|
268 |
ALTER TABLE `€¢€¢€¢` CHANGE `€«€«€«` `€«€«` char(1); |
|
269 |
ALTER TABLE `€¢€¢€¢` MODIFY `€€€` char(6); |
|
270 |
||
271 |
SELECT * FROM `€¢€¢€¢`; |
|
272 |
DESC `€¢€¢€¢`; |
|
273 |
SHOW CREATE TABLE `€¢€¢€¢`; |
|
274 |
||
275 |
ALTER TABLE `€¢€¢€¢` DROP INDEX `€«€«€«`; |
|
276 |
ALTER TABLE `€¢€¢€¢` DROP PRIMARY KEY; |
|
277 |
ALTER TABLE `€¢€¢€¢` DROP INDEX `€¯€¯€¯`; |
|
278 |
#ALTER TABLE `€¢€¢€¢` DROP FOREIGN KEY `€±€±€±`; |
|
279 |
ALTER TABLE `€¢€¢€¢` DROP `€«€«`; |
|
280 |
ALTER TABLE `€¢€¢€¢` DROP `€¯€¯€¯`; |
|
281 |
ALTER TABLE `€¢€¢€¢` DROP `€±€±€±`; |
|
282 |
||
283 |
SELECT * FROM `€¢€¢€¢`; |
|
284 |
DESC `€¢€¢€¢`; |
|
285 |
SHOW CREATE TABLE `€¢€¢€¢`; |
|
286 |
||
287 |
ALTER TABLE `íÝíÝíÝ` ADD `°¢°¢°¢` char(1) FIRST; |
|
288 |
ALTER TABLE `íÝíÝíÝ` ADD `°£°£°£` char(1) AFTER `°¡°¡°¡`; |
|
289 |
ALTER TABLE `íÝíÝíÝ` ADD `°Ž°Ž°Ž` char(1); |
|
290 |
ALTER TABLE `íÝíÝíÝ` ADD INDEX (`°¢°¢°¢`); |
|
291 |
ALTER TABLE `íÝíÝíÝ` ADD PRIMARY KEY (`°¡°¡°¡`); |
|
292 |
ALTER TABLE `íÝíÝíÝ` ADD UNIQUE (`°£°£°£`); |
|
293 |
#ALTER TABLE `íÝíÝíÝ` ADD FOREIGN KEY (`°Ž°Ž°Ž`) REFERENCES `íÞíÞíÞ`(`°Ž°Ž°Ž`); |
|
294 |
ALTER TABLE `íÝíÝíÝ` CHANGE `°¢°¢°¢` `°¢°¢` char(1); |
|
295 |
ALTER TABLE `íÝíÝíÝ` MODIFY `°¡°¡°¡` char(6); |
|
296 |
||
297 |
SELECT * FROM `íÝíÝíÝ`; |
|
298 |
DESC `íÝíÝíÝ`; |
|
299 |
SHOW CREATE TABLE `íÝíÝíÝ`; |
|
300 |
||
301 |
ALTER TABLE `íÝíÝíÝ` DROP INDEX `°¢°¢°¢`; |
|
302 |
ALTER TABLE `íÝíÝíÝ` DROP PRIMARY KEY; |
|
303 |
ALTER TABLE `íÝíÝíÝ` DROP INDEX `°£°£°£`; |
|
304 |
#ALTER TABLE `íÝíÝíÝ` DROP FOREIGN KEY `°Ž°Ž°Ž`; |
|
305 |
ALTER TABLE `íÝíÝíÝ` DROP `°¢°¢`; |
|
306 |
ALTER TABLE `íÝíÝíÝ` DROP `°£°£°£`; |
|
307 |
ALTER TABLE `íÝíÝíÝ` DROP `°Ž°Ž°Ž`; |
|
308 |
||
309 |
SELECT * FROM `íÝíÝíÝ`; |
|
310 |
DESC `íÝíÝíÝ`; |
|
311 |
SHOW CREATE TABLE `íÝíÝíÝ`; |
|
312 |
||
313 |
DROP TABLE `±±±`; |
|
314 |
DROP TABLE `²²²`; |
|
315 |
DROP TABLE `€¢€¢€¢`; |
|
316 |
DROP TABLE `€€€€€€`; |
|
317 |
DROP TABLE `íÝíÝíÝ`; |
|
318 |
DROP TABLE `íÞíÞíÞ`; |
|
319 |
||
320 |
#
|
|
321 |
# Test BDB |
|
322 |
#
|
|
323 |
||
324 |
CREATE TABLE `±±±`(`···` char(5)) DEFAULT CHARSET = ujis engine=BDB; |
|
325 |
CREATE TABLE `²²²`(`¹¹¹` char(5)) DEFAULT CHARSET = ujis engine=BDB; |
|
326 |
CREATE TABLE `€¢€¢€¢`(`€€€` char(5)) DEFAULT CHARSET = ujis engine=BDB; |
|
327 |
CREATE TABLE `€€€€€€`(`€±€±€±` char(5)) DEFAULT CHARSET = ujis engine=BDB; |
|
328 |
CREATE TABLE `íÝíÝíÝ`(`°¡°¡°¡` char(5)) DEFAULT CHARSET = ujis engine=BDB; |
|
329 |
CREATE TABLE `íÞíÞíÞ`(`°Ž°Ž°Ž` char(5)) DEFAULT CHARSET = ujis engine=BDB; |
|
330 |
||
331 |
INSERT INTO `±±±` VALUES ('±±±±±'),('²²²²²'),('³³³³³'); |
|
332 |
INSERT INTO `€¢€¢€¢` VALUES ('€¢€¢€¢€¢€¢'),('€€€€€€€€€€'),('€Š€Š€Š€Š€Š'); |
|
333 |
INSERT INTO `íÝíÝíÝ` VALUES ('°¡°¡°¡°¡°¡'),('°¢°¢°¢°¢°¢'),('°£°£°£°£°£'); |
|
334 |
||
335 |
ALTER TABLE `±±±` ADD `¶¶¶` char(1) FIRST; |
|
336 |
ALTER TABLE `±±±` ADD `žžž` char(1) AFTER `···`; |
|
337 |
ALTER TABLE `±±±` ADD `¹¹¹` char(1); |
|
338 |
ALTER TABLE `±±±` ADD INDEX (`¶¶¶`); |
|
339 |
ALTER TABLE `±±±` ADD PRIMARY KEY (`···`); |
|
340 |
#Multiple NULL fields are not allowed in BDB |
|
341 |
#ALTER TABLE `±±±` ADD UNIQUE (`žžž`); |
|
342 |
#ALTER TABLE `±±±` ADD FOREIGN KEY (`¹¹¹`) REFERENCES `²²²`(`¹¹¹`); |
|
343 |
ALTER TABLE `±±±` CHANGE `¶¶¶` `¶¶` char(1); |
|
344 |
ALTER TABLE `±±±` MODIFY `···` char(6); |
|
345 |
||
346 |
SELECT * FROM `±±±`; |
|
347 |
DESC `±±±`; |
|
348 |
SHOW CREATE TABLE `±±±`; |
|
349 |
||
350 |
ALTER TABLE `±±±` DROP INDEX `¶¶¶`; |
|
351 |
ALTER TABLE `±±±` DROP PRIMARY KEY; |
|
352 |
#ALTER TABLE `±±±` DROP INDEX `žžž`; |
|
353 |
#ALTER TABLE `±±±` DROP FOREIGN KEY `¹¹¹`; |
|
354 |
ALTER TABLE `±±±` DROP `¶¶`; |
|
355 |
ALTER TABLE `±±±` DROP `žžž`; |
|
356 |
ALTER TABLE `±±±` DROP `¹¹¹`; |
|
357 |
SELECT * FROM `±±±`; |
|
358 |
DESC `±±±`; |
|
359 |
SHOW CREATE TABLE `±±±`; |
|
360 |
||
361 |
ALTER TABLE `€¢€¢€¢` ADD `€«€«€«` char(1) FIRST; |
|
362 |
ALTER TABLE `€¢€¢€¢` ADD `€¯€¯€¯` char(1) AFTER `€€€`; |
|
363 |
ALTER TABLE `€¢€¢€¢` ADD `€±€±€±` char(1); |
|
364 |
ALTER TABLE `€¢€¢€¢` ADD INDEX (`€«€«€«`); |
|
365 |
ALTER TABLE `€¢€¢€¢` ADD PRIMARY KEY (`€€€`); |
|
366 |
#ALTER TABLE `€¢€¢€¢` ADD UNIQUE (`€¯€¯€¯`); |
|
367 |
#ALTER TABLE `€¢€¢€¢` ADD FOREIGN KEY (`€±€±€±`) REFERENCES `€€€€€€`(`€±€±€±`); |
|
368 |
ALTER TABLE `€¢€¢€¢` CHANGE `€«€«€«` `€«€«` char(1); |
|
369 |
ALTER TABLE `€¢€¢€¢` MODIFY `€€€` char(6); |
|
370 |
||
371 |
SELECT * FROM `€¢€¢€¢`; |
|
372 |
DESC `€¢€¢€¢`; |
|
373 |
SHOW CREATE TABLE `€¢€¢€¢`; |
|
374 |
||
375 |
ALTER TABLE `€¢€¢€¢` DROP INDEX `€«€«€«`; |
|
376 |
ALTER TABLE `€¢€¢€¢` DROP PRIMARY KEY; |
|
377 |
#ALTER TABLE `€¢€¢€¢` DROP INDEX `€¯€¯€¯`; |
|
378 |
#ALTER TABLE `€¢€¢€¢` DROP FOREIGN KEY `€±€±€±`; |
|
379 |
ALTER TABLE `€¢€¢€¢` DROP `€«€«`; |
|
380 |
ALTER TABLE `€¢€¢€¢` DROP `€¯€¯€¯`; |
|
381 |
ALTER TABLE `€¢€¢€¢` DROP `€±€±€±`; |
|
382 |
||
383 |
SELECT * FROM `€¢€¢€¢`; |
|
384 |
DESC `€¢€¢€¢`; |
|
385 |
SHOW CREATE TABLE `€¢€¢€¢`; |
|
386 |
||
387 |
ALTER TABLE `íÝíÝíÝ` ADD `°¢°¢°¢` char(1) FIRST; |
|
388 |
ALTER TABLE `íÝíÝíÝ` ADD `°£°£°£` char(1) AFTER `°¡°¡°¡`; |
|
389 |
ALTER TABLE `íÝíÝíÝ` ADD `°Ž°Ž°Ž` char(1); |
|
390 |
ALTER TABLE `íÝíÝíÝ` ADD INDEX (`°¢°¢°¢`); |
|
391 |
ALTER TABLE `íÝíÝíÝ` ADD PRIMARY KEY (`°¡°¡°¡`); |
|
392 |
#ALTER TABLE `íÝíÝíÝ` ADD UNIQUE (`°£°£°£`); |
|
393 |
#ALTER TABLE `íÝíÝíÝ` ADD FOREIGN KEY (`°Ž°Ž°Ž`) REFERENCES `íÞíÞíÞ`(`°Ž°Ž°Ž`); |
|
394 |
ALTER TABLE `íÝíÝíÝ` CHANGE `°¢°¢°¢` `°¢°¢` char(1); |
|
395 |
ALTER TABLE `íÝíÝíÝ` MODIFY `°¡°¡°¡` char(6); |
|
396 |
||
397 |
SELECT * FROM `íÝíÝíÝ`; |
|
398 |
DESC `íÝíÝíÝ`; |
|
399 |
SHOW CREATE TABLE `íÝíÝíÝ`; |
|
400 |
||
401 |
ALTER TABLE `íÝíÝíÝ` DROP INDEX `°¢°¢°¢`; |
|
402 |
ALTER TABLE `íÝíÝíÝ` DROP PRIMARY KEY; |
|
403 |
#ALTER TABLE `íÝíÝíÝ` DROP INDEX `°£°£°£`; |
|
404 |
#ALTER TABLE `íÝíÝíÝ` DROP FOREIGN KEY `°Ž°Ž°Ž`; |
|
405 |
ALTER TABLE `íÝíÝíÝ` DROP `°¢°¢`; |
|
406 |
ALTER TABLE `íÝíÝíÝ` DROP `°£°£°£`; |
|
407 |
ALTER TABLE `íÝíÝíÝ` DROP `°Ž°Ž°Ž`; |
|
408 |
||
409 |
SELECT * FROM `íÝíÝíÝ`; |
|
410 |
DESC `íÝíÝíÝ`; |
|
411 |
SHOW CREATE TABLE `íÝíÝíÝ`; |
|
412 |
||
413 |
DROP TABLE `±±±`; |
|
414 |
DROP TABLE `²²²`; |
|
415 |
DROP TABLE `€¢€¢€¢`; |
|
416 |
DROP TABLE `€€€€€€`; |
|
417 |
DROP TABLE `íÝíÝíÝ`; |
|
418 |
DROP TABLE `íÞíÞíÞ`; |