mariadb/mysql-test/suite/jp/t/jp_enum_sjis.test
2025-04-29 13:53:16 +10:00

130 lines
3.9 KiB
Text
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

#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 ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
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 `` (`` ENUM('ア','イ','ウ'), INDEX(``)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `` (`` ENUM('あ','い','う'), INDEX(``)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `` (`` ENUM('ソ','十','表'), INDEX(``)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `` (`` ENUM('ア','イ','ウ'), INDEX(``)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `` (`` ENUM('あ','い','う'), INDEX(``)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `` (`` ENUM('ソ','十','表'), INDEX(``)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `` (`` ENUM('ア','イ','ウ'), INDEX(``)) DEFAULT CHARSET = sjis engine = MEMORY;
CREATE TABLE `` (`` ENUM('あ','い','う'), INDEX(``)) DEFAULT CHARSET = sjis engine = MEMORY;
CREATE TABLE `` (`` ENUM('ソ','十','表'), INDEX(``)) DEFAULT CHARSET = sjis engine = MEMORY;
INSERT INTO `` VALUES ('ア'),('イ'),('ウ');
INSERT INTO `` VALUES ('あ'),('い'),('う');
INSERT INTO `` VALUES ('ソ'),('十'),('表');
INSERT INTO `` VALUES ('ア'),('イ'),('ウ');
INSERT INTO `` VALUES ('あ'),('い'),('う');
INSERT INTO `` VALUES ('ソ'),('十'),('表');
INSERT INTO `` VALUES ('ア'),('イ'),('ウ');
INSERT INTO `` VALUES ('あ'),('い'),('う');
INSERT INTO `` VALUES ('ソ'),('十'),('表');
SELECT * FROM ``;
SELECT * FROM ``;
SELECT * FROM ``;
SELECT * FROM ``;
SELECT * FROM ``;
SELECT * FROM ``;
SELECT * FROM ``;
SELECT * FROM ``;
SELECT * FROM ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
DESC ``;
DESC ``;
DESC ``;
DESC ``;
DESC ``;
DESC ``;
DESC ``;
DESC ``;
DESC ``;
#
# Test problem with enum values after the column with NOT NULL restriction
#
ALTER TABLE `` ADD `` CHAR(1) NOT NULL FIRST;
ALTER TABLE `` ADD `` CHAR(1) NOT NULL FIRST;
ALTER TABLE `` ADD `` CHAR(1) NOT NULL FIRST;
ALTER TABLE `` ADD `` CHAR(1) NOT NULL FIRST;
ALTER TABLE `` ADD `` CHAR(1) NOT NULL FIRST;
ALTER TABLE `` ADD `` CHAR(1) NOT NULL FIRST;
ALTER TABLE `` ADD `` CHAR(1) NOT NULL FIRST;
ALTER TABLE `` ADD `` CHAR(1) NOT NULL FIRST;
ALTER TABLE `` ADD `` CHAR(1) NOT NULL FIRST;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
SHOW CREATE TABLE ``;
#
# Test to distinguish 0x9353 and 0x9373
# Bug#6206 ENUMs are not case sensitive even if declared BINARY
#
CREATE TABLE t1(c1 enum('鉄','都')) default character set = sjis;
INSERT INTO t1 VALUES('鉄'),('都');
SELECT * FROM t1 WHERE c1 LIKE '鉄';
DROP TABLE t1;
DESC ``;
DESC ``;
DESC ``;
DESC ``;
DESC ``;
DESC ``;
DESC ``;
DESC ``;
DESC ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;
DROP TABLE ``;