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

119 lines
3.7 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_ujis.inc
--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 ``;
drop table if exists ``;
drop table if exists ``;
drop table if exists ``;
--enable_warnings
#
# Test ENUM values with Japanese characters in ujis encoding
#
SET NAMES ujis;
SET character_set_database = ujis;
CREATE TABLE `` (`` ENUM('ア','イ','ウ'), INDEX(``)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `` (`` ENUM('あ','い','う'), INDEX(``)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `` (`` ENUM('龔','龖','龗'), INDEX(``)) DEFAULT CHARSET = ujis engine = innodb;
CREATE TABLE `` (`` ENUM('ア','イ','ウ'), INDEX(``)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `` (`` ENUM('あ','い','う'), INDEX(``)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `` (`` ENUM('龔','龖','龗'), INDEX(``)) DEFAULT CHARSET = ujis engine = myisam;
CREATE TABLE `` (`` ENUM('ア','イ','ウ'), INDEX(``)) DEFAULT CHARSET = ujis engine = MEMORY;
CREATE TABLE `` (`` ENUM('あ','い','う'), INDEX(``)) DEFAULT CHARSET = ujis engine = MEMORY;
CREATE TABLE `` (`` ENUM('龔','龖','龗'), INDEX(``)) DEFAULT CHARSET = ujis 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 ``;
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 ``;