⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
jp
/
t
/
View File Name :
jp_enum_sjis.test
#Server variable option 'lower_case_table_names' sets '0' as default value #in case sensitive filesystem. Using 'lower_case_table_names=0' in case of #insensitive filsystem is not allowed. -- source include/have_case_sensitive_file_system.inc --source include/have_sjis.inc --source include/have_innodb.inc --character_set sjis --disable_warnings drop table if exists `�s�P`; drop table if exists `�s�Q`; drop table if exists `�s�R`; drop table if exists `�s�S`; drop table if exists `�s�T`; drop table if exists `�s�U`; drop table if exists `�s�V`; drop table if exists `�s�W`; drop table if exists `�s�X`; drop table if exists t1; --enable_warnings # # Test ENUM values with Japanese characters in sjis encoding # SET NAMES sjis; SET character_set_database = sjis; CREATE TABLE `�s�P` (`�b�P` ENUM('�','�','�'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�Q` (`�b�P` ENUM('��','��','��'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�R` (`�b�P` ENUM('�\','�\','�\'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = innodb; CREATE TABLE `�s�S` (`�b�P` ENUM('�','�','�'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�T` (`�b�P` ENUM('��','��','��'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�U` (`�b�P` ENUM('�\','�\','�\'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `�s�V` (`�b�P` ENUM('�','�','�'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `�s�W` (`�b�P` ENUM('��','��','��'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY; CREATE TABLE `�s�X` (`�b�P` ENUM('�\','�\','�\'), INDEX(`�b�P`)) DEFAULT CHARSET = sjis engine = MEMORY; INSERT INTO `�s�P` VALUES ('�'),('�'),('�'); INSERT INTO `�s�Q` VALUES ('��'),('��'),('��'); INSERT INTO `�s�R` VALUES ('�\'),('�\'),('�\'); INSERT INTO `�s�S` VALUES ('�'),('�'),('�'); INSERT INTO `�s�T` VALUES ('��'),('��'),('��'); INSERT INTO `�s�U` VALUES ('�\'),('�\'),('�\'); INSERT INTO `�s�V` VALUES ('�'),('�'),('�'); INSERT INTO `�s�W` VALUES ('��'),('��'),('��'); INSERT INTO `�s�X` VALUES ('�\'),('�\'),('�\'); SELECT * FROM `�s�P`; SELECT * FROM `�s�Q`; SELECT * FROM `�s�R`; SELECT * FROM `�s�S`; SELECT * FROM `�s�T`; SELECT * FROM `�s�U`; SELECT * FROM `�s�V`; SELECT * FROM `�s�W`; SELECT * FROM `�s�X`; SHOW CREATE TABLE `�s�P`; SHOW CREATE TABLE `�s�Q`; SHOW CREATE TABLE `�s�R`; SHOW CREATE TABLE `�s�S`; SHOW CREATE TABLE `�s�T`; SHOW CREATE TABLE `�s�U`; SHOW CREATE TABLE `�s�V`; SHOW CREATE TABLE `�s�W`; SHOW CREATE TABLE `�s�X`; DESC `�s�P`; DESC `�s�Q`; DESC `�s�R`; DESC `�s�S`; DESC `�s�T`; DESC `�s�U`; DESC `�s�V`; DESC `�s�W`; DESC `�s�X`; # # Test problem with enum values after the colum with NOT NULL restriction # ALTER TABLE `�s�P` ADD `�b�Q` CHAR(1) NOT NULL FIRST; ALTER TABLE `�s�Q` ADD `�b�Q` CHAR(1) NOT NULL FIRST; ALTER TABLE `�s�R` ADD `�b�Q` CHAR(1) NOT NULL FIRST; ALTER TABLE `�s�S` ADD `�b�Q` CHAR(1) NOT NULL FIRST; ALTER TABLE `�s�T` ADD `�b�Q` CHAR(1) NOT NULL FIRST; ALTER TABLE `�s�U` ADD `�b�Q` CHAR(1) NOT NULL FIRST; ALTER TABLE `�s�V` ADD `�b�Q` CHAR(1) NOT NULL FIRST; ALTER TABLE `�s�W` ADD `�b�Q` CHAR(1) NOT NULL FIRST; ALTER TABLE `�s�X` ADD `�b�Q` CHAR(1) NOT NULL FIRST; SHOW CREATE TABLE `�s�P`; SHOW CREATE TABLE `�s�Q`; SHOW CREATE TABLE `�s�R`; SHOW CREATE TABLE `�s�S`; SHOW CREATE TABLE `�s�T`; SHOW CREATE TABLE `�s�U`; SHOW CREATE TABLE `�s�V`; SHOW CREATE TABLE `�s�W`; SHOW CREATE TABLE `�s�X`; # # Test to distinguish 0x9353 and 0x9373 # Bug#6206 ENUMs are not case sensitive even if declared BINARY # CREATE TABLE t1(c1 enum('�S','�s')) default character set = sjis; INSERT INTO t1 VALUES('�S'),('�s'); SELECT * FROM t1 WHERE c1 LIKE '�S'; DROP TABLE t1; DESC `�s�P`; DESC `�s�Q`; DESC `�s�R`; DESC `�s�S`; DESC `�s�T`; DESC `�s�U`; DESC `�s�V`; DESC `�s�W`; DESC `�s�X`; DROP TABLE `�s�P`; DROP TABLE `�s�Q`; DROP TABLE `�s�R`; DROP TABLE `�s�S`; DROP TABLE `�s�T`; DROP TABLE `�s�U`; DROP TABLE `�s�V`; DROP TABLE `�s�W`; DROP TABLE `�s�X`;