← Back to branch summary

~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 `龗龗龗`;