Debian Codegraph @

mysql-test/suite/jp/t/jp_create_tbl_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 DROP TABLE IF EXISTS `いいい`;
9 DROP TABLE IF EXISTS `ううう`;
10 DROP TABLE IF EXISTS `えええ`;
11 DROP TABLE IF EXISTS `おおお`;
12 DROP TABLE IF EXISTS `龖龖龖`;
13 DROP TABLE IF EXISTS `龗龗龗`;
14 DROP TABLE IF EXISTS `龞龞龞`;
15 DROP TABLE IF EXISTS `龡龡龡`;
16 DROP TABLE IF EXISTS `龢龢龢`;
17 --enable_warnings
18
19 #
20 # Test creating table with Japanese characters in utf8 encoding
21 #
22
23 SET NAMES utf8;
24 SET character_set_database = utf8;
25
26 CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
27 CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
28 CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
29 CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
30 CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
31 CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
32 # Tables should not be created because table names exist
33 CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
34 CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
35 CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
36 CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
37 CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
38 CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
39 # Tables should be created
40 CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
41 CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
42 CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
43 CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
44 CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
45 CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
46 CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
47 CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
48 CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
49
50 DESC `アアア`;
51 DESC `イイイ`;
52 DESC `ウウウ`;
53 DESC `エエエ`;
54 DESC `オオオ`;
55 DESC `あああ`;
56 DESC `いいい`;
57 DESC `ううう`;
58 DESC `えええ`;
59 DESC `おおお`;
60 DESC `龖龖龖`;
61 DESC `龗龗龗`;
62 DESC `龞龞龞`;
63 DESC `龡龡龡`;
64 DESC `龢龢龢`;
65
66 SHOW CREATE TABLE `アアア`;
67 SHOW CREATE TABLE `イイイ`;
68 SHOW CREATE TABLE `ウウウ`;
69 SHOW CREATE TABLE `エエエ`;
70 SHOW CREATE TABLE `オオオ`;
71 SHOW CREATE TABLE `あああ`;
72 SHOW CREATE TABLE `いいい`;
73 SHOW CREATE TABLE `ううう`;
74 SHOW CREATE TABLE `えええ`;
75 SHOW CREATE TABLE `おおお`;
76 SHOW CREATE TABLE `龖龖龖`;
77 SHOW CREATE TABLE `龗龗龗`;
78 SHOW CREATE TABLE `龞龞龞`;
79 SHOW CREATE TABLE `龡龡龡`;
80 SHOW CREATE TABLE `龢龢龢`;
81
82 DROP TABLE `アアア`;
83 DROP TABLE `イイイ`;
84 DROP TABLE `ウウウ`;
85 DROP TABLE `エエエ`;
86 DROP TABLE `オオオ`;
87 DROP TABLE `あああ`;
88 DROP TABLE `いいい`;
89 DROP TABLE `ううう`;
90 DROP TABLE `えええ`;
91 DROP TABLE `おおお`;
92 DROP TABLE `龖龖龖`;
93 DROP TABLE `龗龗龗`;
94 DROP TABLE `龞龞龞`;
95 DROP TABLE `龡龡龡`;
96 DROP TABLE `龢龢龢`;
97
98 CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
99 CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
100 CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
101 CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
102 CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
103 CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
104 # Tables should not be created because table names exist
105 CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
106 CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
107 CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
108 CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
109 CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
110 CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
111 # Tables should be created
112 CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
113 CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
114 CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
115 CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
116 CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
117 CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
118 CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
119 CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
120 CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
121
122 DESC `アアア`;
123 DESC `イイイ`;
124 DESC `ウウウ`;
125 DESC `エエエ`;
126 DESC `オオオ`;
127 DESC `あああ`;
128 DESC `いいい`;
129 DESC `ううう`;
130 DESC `えええ`;
131 DESC `おおお`;
132 DESC `龖龖龖`;
133 DESC `龗龗龗`;
134 DESC `龞龞龞`;
135 DESC `龡龡龡`;
136 DESC `龢龢龢`;
137
138 SHOW CREATE TABLE `アアア`;
139 SHOW CREATE TABLE `イイイ`;
140 SHOW CREATE TABLE `ウウウ`;
141 SHOW CREATE TABLE `エエエ`;
142 SHOW CREATE TABLE `オオオ`;
143 SHOW CREATE TABLE `あああ`;
144 SHOW CREATE TABLE `いいい`;
145 SHOW CREATE TABLE `ううう`;
146 SHOW CREATE TABLE `えええ`;
147 SHOW CREATE TABLE `おおお`;
148 SHOW CREATE TABLE `龖龖龖`;
149 SHOW CREATE TABLE `龗龗龗`;
150 SHOW CREATE TABLE `龞龞龞`;
151 SHOW CREATE TABLE `龡龡龡`;
152 SHOW CREATE TABLE `龢龢龢`;
153
154 DROP TABLE `アアア`;
155 DROP TABLE `イイイ`;
156 DROP TABLE `ウウウ`;
157 DROP TABLE `エエエ`;
158 DROP TABLE `オオオ`;
159 DROP TABLE `あああ`;
160 DROP TABLE `いいい`;
161 DROP TABLE `ううう`;
162 DROP TABLE `えええ`;
163 DROP TABLE `おおお`;
164 DROP TABLE `龖龖龖`;
165 DROP TABLE `龗龗龗`;
166 DROP TABLE `龞龞龞`;
167 DROP TABLE `龡龡龡`;
168 DROP TABLE `龢龢龢`;
169
170 CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
171 CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
172 CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
173 CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
174 CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
175 CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
176 # Tables should not be created because table names exist
177 CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
178 CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
179 CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
180 CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
181 CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
182 CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
183 # Tables should be created
184 CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
185 CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
186 CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
187 CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
188 CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
189 CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
190 CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
191 CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
192 CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
193
194 DESC `アアア`;
195 DESC `イイイ`;
196 DESC `ウウウ`;
197 DESC `エエエ`;
198 DESC `オオオ`;
199 DESC `あああ`;
200 DESC `いいい`;
201 DESC `ううう`;
202 DESC `えええ`;
203 DESC `おおお`;
204 DESC `龖龖龖`;
205 DESC `龗龗龗`;
206 DESC `龞龞龞`;
207 DESC `龡龡龡`;
208 DESC `龢龢龢`;
209
210 SHOW CREATE TABLE `アアア`;
211 SHOW CREATE TABLE `イイイ`;
212 SHOW CREATE TABLE `ウウウ`;
213 SHOW CREATE TABLE `エエエ`;
214 SHOW CREATE TABLE `オオオ`;
215 SHOW CREATE TABLE `あああ`;
216 SHOW CREATE TABLE `いいい`;
217 SHOW CREATE TABLE `ううう`;
218 SHOW CREATE TABLE `えええ`;
219 SHOW CREATE TABLE `おおお`;
220 SHOW CREATE TABLE `龖龖龖`;
221 SHOW CREATE TABLE `龗龗龗`;
222 SHOW CREATE TABLE `龞龞龞`;
223 SHOW CREATE TABLE `龡龡龡`;
224 SHOW CREATE TABLE `龢龢龢`;
225
226 DROP TABLE `アアア`;
227 DROP TABLE `イイイ`;
228 DROP TABLE `ウウウ`;
229 DROP TABLE `エエエ`;
230 DROP TABLE `オオオ`;
231 DROP TABLE `あああ`;
232 DROP TABLE `いいい`;
233 DROP TABLE `ううう`;
234 DROP TABLE `えええ`;
235 DROP TABLE `おおお`;
236 DROP TABLE `龖龖龖`;
237 DROP TABLE `龗龗龗`;
238 DROP TABLE `龞龞龞`;
239 DROP TABLE `龡龡龡`;
240 DROP TABLE `龢龢龢`;