--source include/have_sjis.inc --character_set sjis SET NAMES sjis; SET character_set_database = sjis; --source include/have_innodb.inc --disable_warnings DROP TABLE IF EXISTS `���`; DROP TABLE IF EXISTS `���`; DROP TABLE IF EXISTS `������`; DROP TABLE IF EXISTS `������`; DROP TABLE IF EXISTS `�\�\�\`; DROP TABLE IF EXISTS `�\�\�\`; --enable_warnings # # Test altering table with Japanese characters in sjis encoding # # # Test InnoDB # CREATE TABLE `���`(`���` char(5)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE `���`(`���` char(5)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE `������`(`������` char(5)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE `������`(`������` char(5)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE `�\�\�\`(`�\�\�\` char(5)) DEFAULT CHARSET = sjis engine=INNODB; CREATE TABLE `�\�\�\`(`�\�\�\` char(5)) DEFAULT CHARSET = sjis engine=INNODB; INSERT INTO `���` VALUES ('�����'),('�����'),('�����'); INSERT INTO `������` VALUES ('����������'),('����������'),('����������'); INSERT INTO `�\�\�\` VALUES ('�\�\�\�\�\'),('�\�\�\�\�\'),('�\�\�\�\�\'); # Test basic alter operation ALTER TABLE `���` ADD `���` char(1) FIRST; ALTER TABLE `���` ADD `���` char(1) AFTER `���`; ALTER TABLE `���` ADD `���` char(1); ALTER TABLE `���` ADD INDEX (`���`); ALTER TABLE `���` ADD PRIMARY KEY (`���`); ALTER TABLE `���` ADD UNIQUE (`���`); #Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4 #ALTER TABLE `���` ADD FOREIGN KEY (`���`) REFERENCES `���`(`���`); ALTER TABLE `���` CHANGE `���` `��` char(1); ALTER TABLE `���` MODIFY `���` char(6); SELECT * FROM `���`; DESC `���`; SHOW CREATE TABLE `���`; ALTER TABLE `���` DROP INDEX `���`; ALTER TABLE `���` DROP PRIMARY KEY; ALTER TABLE `���` DROP INDEX `���`; #ALTER TABLE `���` DROP FOREIGN KEY `���`; ALTER TABLE `���` DROP `��`; ALTER TABLE `���` DROP `���`; ALTER TABLE `���` DROP `���`; SELECT * FROM `���`; DESC `���`; SHOW CREATE TABLE `���`; ALTER TABLE `������` ADD `������` char(1) FIRST; ALTER TABLE `������` ADD `������` char(1) AFTER `������`; ALTER TABLE `������` ADD `������` char(1); ALTER TABLE `������` ADD INDEX (`������`); ALTER TABLE `������` ADD PRIMARY KEY (`������`); ALTER TABLE `������` ADD UNIQUE (`������`); #Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4 #ALTER TABLE `������` ADD FOREIGN KEY (`������`) REFERENCES `������`(`������`); ALTER TABLE `������` CHANGE `������` `����` char(1); ALTER TABLE `������` MODIFY `������` char(6); SELECT * FROM `������`; DESC `������`; SHOW CREATE TABLE `������`; ALTER TABLE `������` DROP INDEX `������`; ALTER TABLE `������` DROP PRIMARY KEY; ALTER TABLE `������` DROP INDEX `������`; #ALTER TABLE `������` DROP FOREIGN KEY `������`; ALTER TABLE `������` DROP `����`; ALTER TABLE `������` DROP `������`; ALTER TABLE `������` DROP `������`; SELECT * FROM `������`; DESC `������`; SHOW CREATE TABLE `������`; ALTER TABLE `�\�\�\` ADD `�\�\�\` char(1) FIRST; ALTER TABLE `�\�\�\` ADD `�\�\�\` char(1) AFTER `�\�\�\`; ALTER TABLE `�\�\�\` ADD `�\�\�\` char(1); ALTER TABLE `�\�\�\` ADD INDEX (`�\�\�\`); ALTER TABLE `�\�\�\` ADD PRIMARY KEY (`�\�\�\`); ALTER TABLE `�\�\�\` ADD UNIQUE (`�\�\�\`); #Multi-byte field name is not allowed for FOREIGN KEY As of 4.1.4 #ALTER TABLE `�\�\�\` ADD FOREIGN KEY (`�\�\�\`) REFERENCES `�\�\�\`(`�\�\�\`); ALTER TABLE `�\�\�\` CHANGE `�\�\�\` `�\�\` char(1); ALTER TABLE `�\�\�\` MODIFY `�\�\�\` char(6); SELECT * FROM `�\�\�\`; DESC `�\�\�\`; SHOW CREATE TABLE `�\�\�\`; ALTER TABLE `�\�\�\` DROP INDEX `�\�\�\`; ALTER TABLE `�\�\�\` DROP PRIMARY KEY; ALTER TABLE `�\�\�\` DROP INDEX `�\�\�\`; #ALTER TABLE `�\�\�\` DROP FOREIGN KEY `�\�\�\`; ALTER TABLE `�\�\�\` DROP `�\�\`; ALTER TABLE `�\�\�\` DROP `�\�\�\`; ALTER TABLE `�\�\�\` DROP `�\�\�\`; SELECT * FROM `�\�\�\`; DESC `�\�\�\`; SHOW CREATE TABLE `�\�\�\`; DROP TABLE `���`; DROP TABLE `���`; DROP TABLE `������`; DROP TABLE `������`; DROP TABLE `�\�\�\`; DROP TABLE `�\�\�\`; # # Test MyISAM # CREATE TABLE `���`(`���` char(5)) DEFAULT CHARSET = sjis engine=MYISAM; CREATE TABLE `���`(`���` char(5)) DEFAULT CHARSET = sjis engine=MYISAM; CREATE TABLE `������`(`������` char(5)) DEFAULT CHARSET = sjis engine=MYISAM; CREATE TABLE `������`(`������` char(5)) DEFAULT CHARSET = sjis engine=MYISAM; CREATE TABLE `�\�\�\`(`�\�\�\` char(5)) DEFAULT CHARSET = sjis engine=MYISAM; CREATE TABLE `�\�\�\`(`�\�\�\` char(5)) DEFAULT CHARSET = sjis engine=MYISAM; INSERT INTO `���` VALUES ('�����'),('�����'),('�����'); INSERT INTO `������` VALUES ('����������'),('����������'),('����������'); INSERT INTO `�\�\�\` VALUES ('�\�\�\�\�\'),('�\�\�\�\�\'),('�\�\�\�\�\'); ALTER TABLE `���` ADD `���` char(1) FIRST; ALTER TABLE `���` ADD `���` char(1) AFTER `���`; ALTER TABLE `���` ADD `���` char(1); ALTER TABLE `���` ADD INDEX (`���`); ALTER TABLE `���` ADD PRIMARY KEY (`���`); ALTER TABLE `���` ADD UNIQUE (`���`); #ALTER TABLE `���` ADD FOREIGN KEY (`���`) REFERENCES `���`(`���`); ALTER TABLE `���` CHANGE `���` `��` char(1); ALTER TABLE `���` MODIFY `���` char(6); SELECT * FROM `���`; DESC `���`; SHOW CREATE TABLE `���`; ALTER TABLE `���` DROP INDEX `���`; ALTER TABLE `���` DROP PRIMARY KEY; ALTER TABLE `���` DROP INDEX `���`; #ALTER TABLE `���` DROP FOREIGN KEY `���`; ALTER TABLE `���` DROP `��`; ALTER TABLE `���` DROP `���`; ALTER TABLE `���` DROP `���`; SELECT * FROM `���`; DESC `���`; SHOW CREATE TABLE `���`; ALTER TABLE `������` ADD `������` char(1) FIRST; ALTER TABLE `������` ADD `������` char(1) AFTER `������`; ALTER TABLE `������` ADD `������` char(1); ALTER TABLE `������` ADD INDEX (`������`); ALTER TABLE `������` ADD PRIMARY KEY (`������`); ALTER TABLE `������` ADD UNIQUE (`������`); #ALTER TABLE `������` ADD FOREIGN KEY (`������`) REFERENCES `������`(`������`); ALTER TABLE `������` CHANGE `������` `����` char(1); ALTER TABLE `������` MODIFY `������` char(6); SELECT * FROM `������`; DESC `������`; SHOW CREATE TABLE `������`; ALTER TABLE `������` DROP INDEX `������`; ALTER TABLE `������` DROP PRIMARY KEY; ALTER TABLE `������` DROP INDEX `������`; #ALTER TABLE `������` DROP FOREIGN KEY `������`; ALTER TABLE `������` DROP `����`; ALTER TABLE `������` DROP `������`; ALTER TABLE `������` DROP `������`; SELECT * FROM `������`; DESC `������`; SHOW CREATE TABLE `������`; ALTER TABLE `�\�\�\` ADD `�\�\�\` char(1) FIRST; ALTER TABLE `�\�\�\` ADD `�\�\�\` char(1) AFTER `�\�\�\`; ALTER TABLE `�\�\�\` ADD `�\�\�\` char(1); ALTER TABLE `�\�\�\` ADD INDEX (`�\�\�\`); ALTER TABLE `�\�\�\` ADD PRIMARY KEY (`�\�\�\`); ALTER TABLE `�\�\�\` ADD UNIQUE (`�\�\�\`); #ALTER TABLE `�\�\�\` ADD FOREIGN KEY (`�\�\�\`) REFERENCES `�\�\�\`(`�\�\�\`); ALTER TABLE `�\�\�\` CHANGE `�\�\�\` `�\�\` char(1); ALTER TABLE `�\�\�\` MODIFY `�\�\�\` char(6); SELECT * FROM `�\�\�\`; DESC `�\�\�\`; SHOW CREATE TABLE `�\�\�\`; ALTER TABLE `�\�\�\` DROP INDEX `�\�\�\`; ALTER TABLE `�\�\�\` DROP PRIMARY KEY; ALTER TABLE `�\�\�\` DROP INDEX `�\�\�\`; #ALTER TABLE `�\�\�\` DROP FOREIGN KEY `�\�\�\`; ALTER TABLE `�\�\�\` DROP `�\�\`; ALTER TABLE `�\�\�\` DROP `�\�\�\`; ALTER TABLE `�\�\�\` DROP `�\�\�\`; SELECT * FROM `�\�\�\`; DESC `�\�\�\`; SHOW CREATE TABLE `�\�\�\`; DROP TABLE `���`; DROP TABLE `���`; DROP TABLE `������`; DROP TABLE `������`; DROP TABLE `�\�\�\`; DROP TABLE `�\�\�\`; # # Test MEMORY # CREATE TABLE `���`(`���` char(5)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE `���`(`���` char(5)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE `������`(`������` char(5)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE `������`(`������` char(5)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE `�\�\�\`(`�\�\�\` char(5)) DEFAULT CHARSET = sjis engine=MEMORY; CREATE TABLE `�\�\�\`(`�\�\�\` char(5)) DEFAULT CHARSET = sjis engine=MEMORY; INSERT INTO `���` VALUES ('�����'),('�����'),('�����'); INSERT INTO `������` VALUES ('����������'),('����������'),('����������'); INSERT INTO `�\�\�\` VALUES ('�\�\�\�\�\'),('�\�\�\�\�\'),('�\�\�\�\�\'); ALTER TABLE `���` ADD `���` char(1) FIRST; ALTER TABLE `���` ADD `���` char(1) AFTER `���`; ALTER TABLE `���` ADD `���` char(1); ALTER TABLE `���` ADD INDEX (`���`); ALTER TABLE `���` ADD PRIMARY KEY (`���`); ALTER TABLE `���` ADD UNIQUE (`���`); #ALTER TABLE `���` ADD FOREIGN KEY (`���`) REFERENCES `���`(`���`); ALTER TABLE `���` CHANGE `���` `��` char(1); ALTER TABLE `���` MODIFY `���` char(6); SELECT * FROM `���`; DESC `���`; SHOW CREATE TABLE `���`; ALTER TABLE `���` DROP INDEX `���`; ALTER TABLE `���` DROP PRIMARY KEY; ALTER TABLE `���` DROP INDEX `���`; #ALTER TABLE `���` DROP FOREIGN KEY `���`; ALTER TABLE `���` DROP `��`; ALTER TABLE `���` DROP `���`; ALTER TABLE `���` DROP `���`; SELECT * FROM `���`; DESC `���`; SHOW CREATE TABLE `���`; ALTER TABLE `������` ADD `������` char(1) FIRST; ALTER TABLE `������` ADD `������` char(1) AFTER `������`; ALTER TABLE `������` ADD `������` char(1); ALTER TABLE `������` ADD INDEX (`������`); ALTER TABLE `������` ADD PRIMARY KEY (`������`); ALTER TABLE `������` ADD UNIQUE (`������`); #ALTER TABLE `������` ADD FOREIGN KEY (`������`) REFERENCES `������`(`������`); ALTER TABLE `������` CHANGE `������` `����` char(1); ALTER TABLE `������` MODIFY `������` char(6); SELECT * FROM `������`; DESC `������`; SHOW CREATE TABLE `������`; ALTER TABLE `������` DROP INDEX `������`; ALTER TABLE `������` DROP PRIMARY KEY; ALTER TABLE `������` DROP INDEX `������`; #ALTER TABLE `������` DROP FOREIGN KEY `������`; ALTER TABLE `������` DROP `����`; ALTER TABLE `������` DROP `������`; ALTER TABLE `������` DROP `������`; SELECT * FROM `������`; DESC `������`; SHOW CREATE TABLE `������`; ALTER TABLE `�\�\�\` ADD `�\�\�\` char(1) FIRST; ALTER TABLE `�\�\�\` ADD `�\�\�\` char(1) AFTER `�\�\�\`; ALTER TABLE `�\�\�\` ADD `�\�\�\` char(1); ALTER TABLE `�\�\�\` ADD INDEX (`�\�\�\`); ALTER TABLE `�\�\�\` ADD PRIMARY KEY (`�\�\�\`); ALTER TABLE `�\�\�\` ADD UNIQUE (`�\�\�\`); #ALTER TABLE `�\�\�\` ADD FOREIGN KEY (`�\�\�\`) REFERENCES `�\�\�\`(`�\�\�\`); ALTER TABLE `�\�\�\` CHANGE `�\�\�\` `�\�\` char(1); ALTER TABLE `�\�\�\` MODIFY `�\�\�\` char(6); SELECT * FROM `�\�\�\`; DESC `�\�\�\`; SHOW CREATE TABLE `�\�\�\`; ALTER TABLE `�\�\�\` DROP INDEX `�\�\�\`; ALTER TABLE `�\�\�\` DROP PRIMARY KEY; ALTER TABLE `�\�\�\` DROP INDEX `�\�\�\`; #ALTER TABLE `�\�\�\` DROP FOREIGN KEY `�\�\�\`; ALTER TABLE `�\�\�\` DROP `�\�\`; ALTER TABLE `�\�\�\` DROP `�\�\�\`; ALTER TABLE `�\�\�\` DROP `�\�\�\`; SELECT * FROM `�\�\�\`; DESC `�\�\�\`; SHOW CREATE TABLE `�\�\�\`; DROP TABLE `���`; DROP TABLE `���`; DROP TABLE `������`; DROP TABLE `������`; DROP TABLE `�\�\�\`; DROP TABLE `�\�\�\`;
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
disabled.def | File | 404 B | 0644 |
|
jp_alter_sjis.test | File | 10.37 KB | 0644 |
|
jp_alter_ucs2.test | File | 11.33 KB | 0644 |
|
jp_alter_ujis.test | File | 11.28 KB | 0644 |
|
jp_alter_utf8.test | File | 12.21 KB | 0644 |
|
jp_charlength_sjis.test | File | 2.65 KB | 0644 |
|
jp_charlength_ucs2.test | File | 2.76 KB | 0644 |
|
jp_charlength_ujis.test | File | 2.71 KB | 0644 |
|
jp_charlength_utf8.test | File | 2.96 KB | 0644 |
|
jp_charset_sjis.test | File | 4.95 KB | 0644 |
|
jp_charset_ucs2.test | File | 7.27 KB | 0644 |
|
jp_charset_ujis.test | File | 4.97 KB | 0644 |
|
jp_charset_utf8.test | File | 5.23 KB | 0644 |
|
jp_convert_sjis.test | File | 3.89 KB | 0644 |
|
jp_convert_ucs2.test | File | 6.42 KB | 0644 |
|
jp_convert_ujis.test | File | 4.08 KB | 0644 |
|
jp_convert_utf8.test | File | 4.34 KB | 0644 |
|
jp_create_db_sjis.test | File | 597 B | 0644 |
|
jp_create_db_ucs2.test | File | 643 B | 0644 |
|
jp_create_db_ujis.test | File | 610 B | 0644 |
|
jp_create_db_utf8.test | File | 641 B | 0644 |
|
jp_create_tbl_sjis.test | File | 8.77 KB | 0644 |
|
jp_create_tbl_ucs2.test | File | 9.35 KB | 0644 |
|
jp_create_tbl_ujis.test | File | 9.35 KB | 0644 |
|
jp_create_tbl_utf8.test | File | 9.89 KB | 0644 |
|
jp_enum_sjis.test | File | 3.94 KB | 0644 |
|
jp_enum_ucs2.test | File | 3.89 KB | 0644 |
|
jp_enum_ujis.test | File | 3.68 KB | 0644 |
|
jp_enum_utf8.test | File | 3.94 KB | 0644 |
|
jp_insert_sjis.test | File | 11.8 KB | 0644 |
|
jp_insert_ucs2.test | File | 12.06 KB | 0644 |
|
jp_insert_ujis.test | File | 12.06 KB | 0644 |
|
jp_insert_utf8.test | File | 13.32 KB | 0644 |
|
jp_instr_sjis.test | File | 3.89 KB | 0644 |
|
jp_instr_ucs2.test | File | 3.98 KB | 0644 |
|
jp_instr_ujis.test | File | 3.94 KB | 0644 |
|
jp_instr_utf8.test | File | 4.32 KB | 0644 |
|
jp_join_sjis.test | File | 7.98 KB | 0644 |
|
jp_join_ucs2.test | File | 8.01 KB | 0644 |
|
jp_join_ujis.test | File | 7.97 KB | 0644 |
|
jp_join_utf8.test | File | 8.7 KB | 0644 |
|
jp_left_sjis.test | File | 4.49 KB | 0644 |
|
jp_left_ucs2.test | File | 4.6 KB | 0644 |
|
jp_left_ujis.test | File | 4.55 KB | 0644 |
|
jp_left_utf8.test | File | 5.06 KB | 0644 |
|
jp_length_sjis.test | File | 2.6 KB | 0644 |
|
jp_length_ucs2.test | File | 2.71 KB | 0644 |
|
jp_length_ujis.test | File | 2.67 KB | 0644 |
|
jp_length_utf8.test | File | 2.91 KB | 0644 |
|
jp_like_sjis.test | File | 6.31 KB | 0644 |
|
jp_like_ucs2.test | File | 9.45 KB | 0644 |
|
jp_like_ujis.test | File | 6.69 KB | 0644 |
|
jp_like_utf8.test | File | 7.42 KB | 0644 |
|
jp_locate_sjis.test | File | 3.95 KB | 0644 |
|
jp_locate_ucs2.test | File | 4.04 KB | 0644 |
|
jp_locate_ujis.test | File | 3.99 KB | 0644 |
|
jp_locate_utf8.test | File | 4.37 KB | 0644 |
|
jp_lpad_sjis.test | File | 2.64 KB | 0644 |
|
jp_lpad_ucs2.test | File | 2.76 KB | 0644 |
|
jp_lpad_ujis.test | File | 2.71 KB | 0644 |
|
jp_lpad_utf8.test | File | 2.96 KB | 0644 |
|
jp_ltrim_sjis.test | File | 4.89 KB | 0644 |
|
jp_ltrim_ucs2.test | File | 5.11 KB | 0644 |
|
jp_ltrim_ujis.test | File | 5.07 KB | 0644 |
|
jp_ltrim_utf8.test | File | 5.57 KB | 0644 |
|
jp_ps_sjis.test | File | 9.56 KB | 0644 |
|
jp_ps_ujis.test | File | 9.56 KB | 0644 |
|
jp_replace_sjis.test | File | 3.79 KB | 0644 |
|
jp_replace_ucs2.test | File | 3.93 KB | 0644 |
|
jp_replace_ujis.test | File | 3.89 KB | 0644 |
|
jp_replace_utf8.test | File | 4.27 KB | 0644 |
|
jp_reverse_sjis.test | File | 2.17 KB | 0644 |
|
jp_reverse_ucs2.test | File | 2.22 KB | 0644 |
|
jp_reverse_ujis.test | File | 2.18 KB | 0644 |
|
jp_reverse_utf8.test | File | 2.35 KB | 0644 |
|
jp_right_sjis.test | File | 4.54 KB | 0644 |
|
jp_right_ucs2.test | File | 4.65 KB | 0644 |
|
jp_right_ujis.test | File | 4.61 KB | 0644 |
|
jp_right_utf8.test | File | 5.12 KB | 0644 |
|
jp_rpad_sjis.test | File | 2.64 KB | 0644 |
|
jp_rpad_ucs2.test | File | 2.76 KB | 0644 |
|
jp_rpad_ujis.test | File | 2.71 KB | 0644 |
|
jp_rpad_utf8.test | File | 2.96 KB | 0644 |
|
jp_rtrim_sjis.test | File | 4.89 KB | 0644 |
|
jp_rtrim_ucs2.test | File | 5.11 KB | 0644 |
|
jp_rtrim_ujis.test | File | 5.07 KB | 0644 |
|
jp_rtrim_utf8.test | File | 5.57 KB | 0644 |
|
jp_select_sjis.test | File | 2.52 KB | 0644 |
|
jp_select_ucs2.test | File | 4.77 KB | 0644 |
|
jp_select_ujis.test | File | 2.43 KB | 0644 |
|
jp_select_utf8.test | File | 2.51 KB | 0644 |
|
jp_subquery_sjis.test | File | 5.87 KB | 0644 |
|
jp_subquery_ucs2.test | File | 6.19 KB | 0644 |
|
jp_subquery_ujis.test | File | 6.15 KB | 0644 |
|
jp_subquery_utf8.test | File | 6.46 KB | 0644 |
|
jp_substring_sjis.test | File | 15.15 KB | 0644 |
|
jp_substring_ucs2.test | File | 15.49 KB | 0644 |
|
jp_substring_ujis.test | File | 15.22 KB | 0644 |
|
jp_substring_utf8.test | File | 16.89 KB | 0644 |
|
jp_trim_sjis.test | File | 288 B | 0644 |
|
jp_trim_ucs2.test | File | 7.49 KB | 0644 |
|
jp_trim_ujis.test | File | 7.44 KB | 0644 |
|
jp_trim_utf8.test | File | 8.29 KB | 0644 |
|
jp_union_ujis.test | File | 4.8 KB | 0644 |
|
jp_update_sjis.test | File | 2.4 KB | 0644 |
|
jp_update_ucs2.test | File | 2.49 KB | 0644 |
|
jp_update_ujis.test | File | 2.44 KB | 0644 |
|
jp_update_utf8.test | File | 2.66 KB | 0644 |
|
jp_where_sjis.test | File | 3.67 KB | 0644 |
|
jp_where_ucs2.test | File | 5.42 KB | 0644 |
|
jp_where_ujis.test | File | 3.06 KB | 0644 |
|
jp_where_utf8.test | File | 3.31 KB | 0644 |
|