1
--source include/have_utf8.inc
2
--source include/have_innodb.inc
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 `龢龢龢`;
22
# Test creating table with Japanese characters in utf8 encoding
26
SET character_set_database = utf8;
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;
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 `龢龢龢`;
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;
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 `龢龢龢`;
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;
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 `龢龢龢`;