~drizzle-trunk/drizzle/development

1 by brian
clean slate
1
DROP TABLE IF EXISTS `アアア`;
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 `龗龗龗`;
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
7
CREATE TABLE `アアア`(`キキキ` char(5))  engine=INNODB;
8
CREATE TABLE `イイイ`(`ケケケ` char(5))  engine=INNODB;
9
CREATE TABLE `あああ`(`ききき` char(5))  engine=INNODB;
10
CREATE TABLE `いいい`(`けけけ` char(5))  engine=INNODB;
11
CREATE TABLE `龖龖龖`(`丂丂丂` char(5))  engine=INNODB;
12
CREATE TABLE `龗龗龗`(`乚乚乚` char(5))  engine=INNODB;
13
INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
14
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
15
INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
16
ALTER TABLE `アアア` ADD `カカカ` char(1) FIRST;
17
ALTER TABLE `アアア` ADD `ククク` char(1) AFTER `キキキ`;
18
ALTER TABLE `アアア` ADD `ケケケ` char(1);
19
ALTER TABLE `アアア` ADD INDEX (`カカカ`);
20
ALTER TABLE `アアア` ADD PRIMARY KEY (`キキキ`);
21
ALTER TABLE `アアア` ADD UNIQUE (`ククク`);
22
ALTER TABLE `アアア` CHANGE `カカカ` `カカ` char(1);
23
ALTER TABLE `アアア` MODIFY `キキキ` char(6);
24
SELECT * FROM `アアア`;
25
カカ	キキキ	ククク	ケケケ
26
NULL	アアアアア	NULL	NULL
27
NULL	イイイイイ	NULL	NULL
28
NULL	ウウウウウ	NULL	NULL
29
DESC `アアア`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
30
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
31
カカ	VARCHAR	YES		YES	
32
キキキ	VARCHAR	NO		NO	
33
ククク	VARCHAR	YES		YES	
34
ケケケ	VARCHAR	YES		YES	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
35
SHOW CREATE TABLE `アアア`;
36
Table	Create Table
37
アアア	CREATE TABLE `アアア` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
38
  `カカ` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
39
  `キキキ` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
40
  `ククク` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
41
  `ケケケ` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
42
  PRIMARY KEY (`キキキ`),
43
  UNIQUE KEY `ククク` (`ククク`),
44
  KEY `カカカ` (`カカ`)
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
45
) ENGINE=InnoDB COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
46
ALTER TABLE `アアア` DROP INDEX `カカカ`;
47
ALTER TABLE `アアア` DROP PRIMARY KEY;
48
ALTER TABLE `アアア` DROP INDEX `ククク`;
49
ALTER TABLE `アアア` DROP `カカ`;
50
ALTER TABLE `アアア` DROP `ククク`;
51
ALTER TABLE `アアア` DROP `ケケケ`;
52
SELECT * FROM `アアア`;
53
キキキ
54
アアアアア
55
イイイイイ
56
ウウウウウ
57
DESC `アアア`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
58
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
59
キキキ	VARCHAR	NO		NO	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
60
SHOW CREATE TABLE `アアア`;
61
Table	Create Table
62
アアア	CREATE TABLE `アアア` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
63
  `キキキ` VARCHAR(6) COLLATE utf8_general_ci NOT NULL
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
64
) ENGINE=InnoDB COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
65
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
66
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
67
ALTER TABLE `あああ` ADD `けけけ` char(1);
68
ALTER TABLE `あああ` ADD INDEX (`かかか`);
69
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
70
ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
71
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
72
ALTER TABLE `あああ` MODIFY `ききき` char(6);
73
SELECT * FROM `あああ`;
74
かか	ききき	くくく	けけけ
75
NULL	あああああ	NULL	NULL
76
NULL	いいいいい	NULL	NULL
77
NULL	ううううう	NULL	NULL
78
DESC `あああ`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
79
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
80
かか	VARCHAR	YES		YES	
81
ききき	VARCHAR	NO		NO	
82
くくく	VARCHAR	YES		YES	
83
けけけ	VARCHAR	YES		YES	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
84
SHOW CREATE TABLE `あああ`;
85
Table	Create Table
86
あああ	CREATE TABLE `あああ` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
87
  `かか` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
88
  `ききき` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
89
  `くくく` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
90
  `けけけ` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
91
  PRIMARY KEY (`ききき`),
92
  UNIQUE KEY `くくく` (`くくく`),
93
  KEY `かかか` (`かか`)
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
94
) ENGINE=InnoDB COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
95
ALTER TABLE `あああ` DROP INDEX `かかか`;
96
ALTER TABLE `あああ` DROP PRIMARY KEY;
97
ALTER TABLE `あああ` DROP INDEX `くくく`;
98
ALTER TABLE `あああ` DROP `かか`;
99
ALTER TABLE `あああ` DROP `くくく`;
100
ALTER TABLE `あああ` DROP `けけけ`;
101
SELECT * FROM `あああ`;
102
ききき
103
あああああ
104
いいいいい
105
ううううう
106
DESC `あああ`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
107
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
108
ききき	VARCHAR	NO		NO	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
109
SHOW CREATE TABLE `あああ`;
110
Table	Create Table
111
あああ	CREATE TABLE `あああ` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
112
  `ききき` VARCHAR(6) COLLATE utf8_general_ci NOT NULL
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
113
) ENGINE=InnoDB COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
114
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
115
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
116
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
117
ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
118
ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
119
ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
120
ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
121
ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
122
SELECT * FROM `龖龖龖`;
123
丄丄	丂丂丂	丅丅丅	乚乚乚
124
NULL	丂丂丂丂丂	NULL	NULL
125
NULL	丄丄丄丄丄	NULL	NULL
126
NULL	丅丅丅丅丅	NULL	NULL
127
DESC `龖龖龖`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
128
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
129
丄丄	VARCHAR	YES		YES	
130
丂丂丂	VARCHAR	NO		NO	
131
丅丅丅	VARCHAR	YES		YES	
132
乚乚乚	VARCHAR	YES		YES	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
133
SHOW CREATE TABLE `龖龖龖`;
134
Table	Create Table
135
龖龖龖	CREATE TABLE `龖龖龖` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
136
  `丄丄` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
137
  `丂丂丂` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
138
  `丅丅丅` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
139
  `乚乚乚` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
140
  PRIMARY KEY (`丂丂丂`),
141
  UNIQUE KEY `丅丅丅` (`丅丅丅`),
142
  KEY `丄丄丄` (`丄丄`)
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
143
) ENGINE=InnoDB COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
144
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
145
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
146
ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
147
ALTER TABLE `龖龖龖` DROP `丄丄`;
148
ALTER TABLE `龖龖龖` DROP `丅丅丅`;
149
ALTER TABLE `龖龖龖` DROP `乚乚乚`;
150
SELECT * FROM `龖龖龖`;
151
丂丂丂
152
丂丂丂丂丂
153
丄丄丄丄丄
154
丅丅丅丅丅
155
DESC `龖龖龖`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
156
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
157
丂丂丂	VARCHAR	NO		NO	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
158
SHOW CREATE TABLE `龖龖龖`;
159
Table	Create Table
160
龖龖龖	CREATE TABLE `龖龖龖` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
161
  `丂丂丂` VARCHAR(6) COLLATE utf8_general_ci NOT NULL
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
162
) ENGINE=InnoDB COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
163
DROP TABLE `アアア`;
164
DROP TABLE `イイイ`;
165
DROP TABLE `あああ`;
166
DROP TABLE `いいい`;
167
DROP TABLE `龖龖龖`;
168
DROP TABLE `龗龗龗`;
169
CREATE TEMPORARY TABLE `アアア`(`キキキ` char(5))  engine=MYISAM;
170
CREATE TEMPORARY TABLE `イイイ`(`ケケケ` char(5))  engine=MYISAM;
171
CREATE TEMPORARY TABLE `あああ`(`ききき` char(5))  engine=MYISAM;
172
CREATE TEMPORARY TABLE `いいい`(`けけけ` char(5))  engine=MYISAM;
173
CREATE TEMPORARY TABLE `龖龖龖`(`丂丂丂` char(5))  engine=MYISAM;
174
CREATE TEMPORARY TABLE `龗龗龗`(`乚乚乚` char(5))  engine=MYISAM;
175
INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
176
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
177
INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
178
ALTER TABLE `アアア` ADD `カカカ` char(1) FIRST;
179
ALTER TABLE `アアア` ADD `ククク` char(1) AFTER `キキキ`;
180
ALTER TABLE `アアア` ADD `ケケケ` char(1);
181
ALTER TABLE `アアア` ADD INDEX (`カカカ`);
182
ALTER TABLE `アアア` ADD PRIMARY KEY (`キキキ`);
183
ALTER TABLE `アアア` ADD UNIQUE (`ククク`);
184
ALTER TABLE `アアア` CHANGE `カカカ` `カカ` char(1);
185
ALTER TABLE `アアア` MODIFY `キキキ` char(6);
186
SELECT * FROM `アアア`;
187
カカ	キキキ	ククク	ケケケ
188
NULL	アアアアア	NULL	NULL
189
NULL	イイイイイ	NULL	NULL
190
NULL	ウウウウウ	NULL	NULL
191
DESC `アアア`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
192
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
193
カカ	VARCHAR	YES		YES	
194
キキキ	VARCHAR	NO		NO	
195
ククク	VARCHAR	YES		YES	
196
ケケケ	VARCHAR	YES		YES	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
197
SHOW CREATE TABLE `アアア`;
198
Table	Create Table
199
アアア	CREATE TEMPORARY TABLE `アアア` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
200
  `カカ` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
201
  `キキキ` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
202
  `ククク` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
203
  `ケケケ` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
204
  PRIMARY KEY (`キキキ`),
205
  UNIQUE KEY `ククク` (`ククク`),
206
  KEY `カカカ` (`カカ`)
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
207
) ENGINE=MyISAM COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
208
ALTER TABLE `アアア` DROP INDEX `カカカ`;
209
ALTER TABLE `アアア` DROP PRIMARY KEY;
210
ALTER TABLE `アアア` DROP INDEX `ククク`;
211
ALTER TABLE `アアア` DROP `カカ`;
212
ALTER TABLE `アアア` DROP `ククク`;
213
ALTER TABLE `アアア` DROP `ケケケ`;
214
SELECT * FROM `アアア`;
215
キキキ
216
アアアアア
217
イイイイイ
218
ウウウウウ
219
DESC `アアア`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
220
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
221
キキキ	VARCHAR	NO		NO	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
222
SHOW CREATE TABLE `アアア`;
223
Table	Create Table
224
アアア	CREATE TEMPORARY TABLE `アアア` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
225
  `キキキ` VARCHAR(6) COLLATE utf8_general_ci NOT NULL
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
226
) ENGINE=MyISAM COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
227
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
228
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
229
ALTER TABLE `あああ` ADD `けけけ` char(1);
230
ALTER TABLE `あああ` ADD INDEX (`かかか`);
231
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
232
ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
233
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
234
ALTER TABLE `あああ` MODIFY `ききき` char(6);
235
SELECT * FROM `あああ`;
236
かか	ききき	くくく	けけけ
237
NULL	あああああ	NULL	NULL
238
NULL	いいいいい	NULL	NULL
239
NULL	ううううう	NULL	NULL
240
DESC `あああ`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
241
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
242
かか	VARCHAR	YES		YES	
243
ききき	VARCHAR	NO		NO	
244
くくく	VARCHAR	YES		YES	
245
けけけ	VARCHAR	YES		YES	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
246
SHOW CREATE TABLE `あああ`;
247
Table	Create Table
248
あああ	CREATE TEMPORARY TABLE `あああ` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
249
  `かか` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
250
  `ききき` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
251
  `くくく` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
252
  `けけけ` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
253
  PRIMARY KEY (`ききき`),
254
  UNIQUE KEY `くくく` (`くくく`),
255
  KEY `かかか` (`かか`)
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
256
) ENGINE=MyISAM COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
257
ALTER TABLE `あああ` DROP INDEX `かかか`;
258
ALTER TABLE `あああ` DROP PRIMARY KEY;
259
ALTER TABLE `あああ` DROP INDEX `くくく`;
260
ALTER TABLE `あああ` DROP `かか`;
261
ALTER TABLE `あああ` DROP `くくく`;
262
ALTER TABLE `あああ` DROP `けけけ`;
263
SELECT * FROM `あああ`;
264
ききき
265
あああああ
266
いいいいい
267
ううううう
268
DESC `あああ`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
269
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
270
ききき	VARCHAR	NO		NO	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
271
SHOW CREATE TABLE `あああ`;
272
Table	Create Table
273
あああ	CREATE TEMPORARY TABLE `あああ` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
274
  `ききき` VARCHAR(6) COLLATE utf8_general_ci NOT NULL
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
275
) ENGINE=MyISAM COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
276
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
277
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
278
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
279
ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
280
ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
281
ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
282
ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
283
ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
284
SELECT * FROM `龖龖龖`;
285
丄丄	丂丂丂	丅丅丅	乚乚乚
286
NULL	丂丂丂丂丂	NULL	NULL
287
NULL	丄丄丄丄丄	NULL	NULL
288
NULL	丅丅丅丅丅	NULL	NULL
289
DESC `龖龖龖`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
290
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
291
丄丄	VARCHAR	YES		YES	
292
丂丂丂	VARCHAR	NO		NO	
293
丅丅丅	VARCHAR	YES		YES	
294
乚乚乚	VARCHAR	YES		YES	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
295
SHOW CREATE TABLE `龖龖龖`;
296
Table	Create Table
297
龖龖龖	CREATE TEMPORARY TABLE `龖龖龖` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
298
  `丄丄` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
299
  `丂丂丂` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
300
  `丅丅丅` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
301
  `乚乚乚` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
302
  PRIMARY KEY (`丂丂丂`),
303
  UNIQUE KEY `丅丅丅` (`丅丅丅`),
304
  KEY `丄丄丄` (`丄丄`)
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
305
) ENGINE=MyISAM COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
306
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
307
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
308
ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
309
ALTER TABLE `龖龖龖` DROP `丄丄`;
310
ALTER TABLE `龖龖龖` DROP `丅丅丅`;
311
ALTER TABLE `龖龖龖` DROP `乚乚乚`;
312
SELECT * FROM `龖龖龖`;
313
丂丂丂
314
丂丂丂丂丂
315
丄丄丄丄丄
316
丅丅丅丅丅
317
DESC `龖龖龖`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
318
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
319
丂丂丂	VARCHAR	NO		NO	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
320
SHOW CREATE TABLE `龖龖龖`;
321
Table	Create Table
322
龖龖龖	CREATE TEMPORARY TABLE `龖龖龖` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
323
  `丂丂丂` VARCHAR(6) COLLATE utf8_general_ci NOT NULL
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
324
) ENGINE=MyISAM COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
325
DROP TABLE `アアア`;
326
DROP TABLE `イイイ`;
327
DROP TABLE `あああ`;
328
DROP TABLE `いいい`;
329
DROP TABLE `龖龖龖`;
330
DROP TABLE `龗龗龗`;
331
CREATE TEMPORARY TABLE `アアア`(`キキキ` char(5))  engine=MEMORY;
332
CREATE TEMPORARY TABLE `イイイ`(`ケケケ` char(5))  engine=MEMORY;
333
CREATE TEMPORARY TABLE `あああ`(`ききき` char(5))  engine=MEMORY;
334
CREATE TEMPORARY TABLE `いいい`(`けけけ` char(5))  engine=MEMORY;
335
CREATE TEMPORARY TABLE `龖龖龖`(`丂丂丂` char(5))  engine=MEMORY;
336
CREATE TEMPORARY TABLE `龗龗龗`(`乚乚乚` char(5))  engine=MEMORY;
337
INSERT INTO `アアア` VALUES ('アアアアア'),('イイイイイ'),('ウウウウウ');
338
INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
339
INSERT INTO `龖龖龖` VALUES ('丂丂丂丂丂'),('丄丄丄丄丄'),('丅丅丅丅丅');
340
ALTER TABLE `アアア` ADD `カカカ` char(1) FIRST;
341
ALTER TABLE `アアア` ADD `ククク` char(1) AFTER `キキキ`;
342
ALTER TABLE `アアア` ADD `ケケケ` char(1);
343
ALTER TABLE `アアア` ADD INDEX (`カカカ`);
344
ALTER TABLE `アアア` ADD PRIMARY KEY (`キキキ`);
345
ALTER TABLE `アアア` ADD UNIQUE (`ククク`);
346
ALTER TABLE `アアア` CHANGE `カカカ` `カカ` char(1);
347
ALTER TABLE `アアア` MODIFY `キキキ` char(6);
348
SELECT * FROM `アアア`;
349
カカ	キキキ	ククク	ケケケ
350
NULL	アアアアア	NULL	NULL
351
NULL	イイイイイ	NULL	NULL
352
NULL	ウウウウウ	NULL	NULL
353
DESC `アアア`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
354
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
355
カカ	VARCHAR	YES		YES	
356
キキキ	VARCHAR	NO		NO	
357
ククク	VARCHAR	YES		YES	
358
ケケケ	VARCHAR	YES		YES	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
359
SHOW CREATE TABLE `アアア`;
360
Table	Create Table
361
アアア	CREATE TEMPORARY TABLE `アアア` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
362
  `カカ` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
363
  `キキキ` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
364
  `ククク` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
365
  `ケケケ` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
366
  PRIMARY KEY (`キキキ`),
367
  UNIQUE KEY `ククク` (`ククク`),
368
  KEY `カカカ` (`カカ`)
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
369
) ENGINE=MEMORY COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
370
ALTER TABLE `アアア` DROP INDEX `カカカ`;
371
ALTER TABLE `アアア` DROP PRIMARY KEY;
372
ALTER TABLE `アアア` DROP INDEX `ククク`;
373
ALTER TABLE `アアア` DROP `カカ`;
374
ALTER TABLE `アアア` DROP `ククク`;
375
ALTER TABLE `アアア` DROP `ケケケ`;
376
SELECT * FROM `アアア`;
377
キキキ
378
アアアアア
379
イイイイイ
380
ウウウウウ
381
DESC `アアア`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
382
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
383
キキキ	VARCHAR	NO		NO	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
384
SHOW CREATE TABLE `アアア`;
385
Table	Create Table
386
アアア	CREATE TEMPORARY TABLE `アアア` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
387
  `キキキ` VARCHAR(6) COLLATE utf8_general_ci NOT NULL
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
388
) ENGINE=MEMORY COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
389
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
390
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
391
ALTER TABLE `あああ` ADD `けけけ` char(1);
392
ALTER TABLE `あああ` ADD INDEX (`かかか`);
393
ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
394
ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
395
ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
396
ALTER TABLE `あああ` MODIFY `ききき` char(6);
397
SELECT * FROM `あああ`;
398
かか	ききき	くくく	けけけ
399
NULL	あああああ	NULL	NULL
400
NULL	いいいいい	NULL	NULL
401
NULL	ううううう	NULL	NULL
402
DESC `あああ`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
403
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
404
かか	VARCHAR	YES		YES	
405
ききき	VARCHAR	NO		NO	
406
くくく	VARCHAR	YES		YES	
407
けけけ	VARCHAR	YES		YES	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
408
SHOW CREATE TABLE `あああ`;
409
Table	Create Table
410
あああ	CREATE TEMPORARY TABLE `あああ` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
411
  `かか` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
412
  `ききき` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
413
  `くくく` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
414
  `けけけ` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
415
  PRIMARY KEY (`ききき`),
416
  UNIQUE KEY `くくく` (`くくく`),
417
  KEY `かかか` (`かか`)
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
418
) ENGINE=MEMORY COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
419
ALTER TABLE `あああ` DROP INDEX `かかか`;
420
ALTER TABLE `あああ` DROP PRIMARY KEY;
421
ALTER TABLE `あああ` DROP INDEX `くくく`;
422
ALTER TABLE `あああ` DROP `かか`;
423
ALTER TABLE `あああ` DROP `くくく`;
424
ALTER TABLE `あああ` DROP `けけけ`;
425
SELECT * FROM `あああ`;
426
ききき
427
あああああ
428
いいいいい
429
ううううう
430
DESC `あああ`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
431
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
432
ききき	VARCHAR	NO		NO	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
433
SHOW CREATE TABLE `あああ`;
434
Table	Create Table
435
あああ	CREATE TEMPORARY TABLE `あああ` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
436
  `ききき` VARCHAR(6) COLLATE utf8_general_ci NOT NULL
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
437
) ENGINE=MEMORY COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
438
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
439
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
440
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
441
ALTER TABLE `龖龖龖` ADD INDEX (`丄丄丄`);
442
ALTER TABLE `龖龖龖` ADD PRIMARY KEY (`丂丂丂`);
443
ALTER TABLE `龖龖龖` ADD UNIQUE (`丅丅丅`);
444
ALTER TABLE `龖龖龖` CHANGE `丄丄丄` `丄丄` char(1);
445
ALTER TABLE `龖龖龖` MODIFY `丂丂丂` char(6);
446
SELECT * FROM `龖龖龖`;
447
丄丄	丂丂丂	丅丅丅	乚乚乚
448
NULL	丂丂丂丂丂	NULL	NULL
449
NULL	丄丄丄丄丄	NULL	NULL
450
NULL	丅丅丅丅丅	NULL	NULL
451
DESC `龖龖龖`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
452
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
453
丄丄	VARCHAR	YES		YES	
454
丂丂丂	VARCHAR	NO		NO	
455
丅丅丅	VARCHAR	YES		YES	
456
乚乚乚	VARCHAR	YES		YES	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
457
SHOW CREATE TABLE `龖龖龖`;
458
Table	Create Table
459
龖龖龖	CREATE TEMPORARY TABLE `龖龖龖` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
460
  `丄丄` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
461
  `丂丂丂` VARCHAR(6) COLLATE utf8_general_ci NOT NULL,
462
  `丅丅丅` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
463
  `乚乚乚` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
464
  PRIMARY KEY (`丂丂丂`),
465
  UNIQUE KEY `丅丅丅` (`丅丅丅`),
466
  KEY `丄丄丄` (`丄丄`)
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
467
) ENGINE=MEMORY COLLATE = utf8_general_ci
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
468
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
469
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
470
ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
471
ALTER TABLE `龖龖龖` DROP `丄丄`;
472
ALTER TABLE `龖龖龖` DROP `丅丅丅`;
473
ALTER TABLE `龖龖龖` DROP `乚乚乚`;
474
SELECT * FROM `龖龖龖`;
475
丂丂丂
476
丂丂丂丂丂
477
丄丄丄丄丄
478
丅丅丅丅丅
479
DESC `龖龖龖`;
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
480
Field	Type	Null	Default	Default_is_NULL	On_Update
1672.3.1 by Brian Aker
Updates JP tests for clean IS. This also removes table name from Field so
481
丂丂丂	VARCHAR	NO		NO	
1271.4.1 by lbieber
clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id
482
SHOW CREATE TABLE `龖龖龖`;
483
Table	Create Table
484
龖龖龖	CREATE TEMPORARY TABLE `龖龖龖` (
1743.5.3 by LinuxJedi
Also fix broken jp test cases
485
  `丂丂丂` VARCHAR(6) COLLATE utf8_general_ci NOT NULL
1737.2.1 by Patrick Crews
Updated jp suite .result files to account for COLLATE info being in SHOW CREATE TABLE output
486
) ENGINE=MEMORY COLLATE = utf8_general_ci
1 by brian
clean slate
487
DROP TABLE `アアア`;
488
DROP TABLE `イイイ`;
489
DROP TABLE `あああ`;
490
DROP TABLE `いいい`;
491
DROP TABLE `龖龖龖`;
492
DROP TABLE `龗龗龗`;