[ Avaa Bypassed ]




Upload:

Command:

hmhc3928@3.133.160.239: ~ $
--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 `�\�\�\`;

Filemanager

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