Debian Codegraph @

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

raw
1 --source include/have_utf8.inc
2 --source include/have_innodb.inc
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 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 DROP TABLE IF EXISTS `龡龡龡`;
18 DROP TABLE IF EXISTS `龢龢龢`;
19 --enable_warnings
20
21 #
22 # Test creating table with Japanese characters in utf8 encoding
23 #
24
25 SET NAMES utf8;
26 SET character_set_database = utf8;
27
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 CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
33 CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
34 # Tables should not be created because table names exist
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 CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
40 CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
41 # Tables should be created
42 CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
43 CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
44 CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`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 CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
50 CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=INNODB;
51
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 DESC `龡龡龡`;
66 DESC `龢龢龢`;
67
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 SHOW CREATE TABLE `龡龡龡`;
82 SHOW CREATE TABLE `龢龢龢`;
83
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 DROP TABLE `龡龡龡`;
98 DROP TABLE `龢龢龢`;
99
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 CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
105 CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
106 # Tables should not be created because table names exist
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 CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
112 CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
113 # Tables should be created
114 CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
115 CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
116 CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`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 CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
122 CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM;
123
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 DESC `龡龡龡`;
138 DESC `龢龢龢`;
139
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 SHOW CREATE TABLE `龡龡龡`;
154 SHOW CREATE TABLE `龢龢龢`;
155
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 DROP TABLE `龡龡龡`;
170 DROP TABLE `龢龢龢`;
171
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 CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
177 CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
178 # Tables should not be created because table names exist
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 CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
184 CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
185 # Tables should be created
186 CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
187 CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
188 CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`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 CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
194 CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=MEMORY;
195
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 DESC `龡龡龡`;
210 DESC `龢龢龢`;
211
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 SHOW CREATE TABLE `龡龡龡`;
226 SHOW CREATE TABLE `龢龢龢`;
227
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 `龞龞龞`;
241 DROP TABLE `龡龡龡`;
242 DROP TABLE `龢龢龢`;