~drizzle-trunk/drizzle/development : contents of tests/suite/jp/t/jp_enum

~drizzle-trunk/drizzle/development : (revision 1273.12.1)

--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 `sPO`;
drop table if exists `sPP`;
drop table if exists `sPQ`;
#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;
CREATE TABLE `sPO` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `sPP` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
CREATE TABLE `sPQ` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;

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 ('\'),('\'),('\');
INSERT INTO `sPO` VALUES ('±'),('²'),('³');
INSERT INTO `sPP` VALUES (' '),('¢'),('€');
INSERT INTO `sPQ` 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`;
SELECT * FROM `sPO`;
SELECT * FROM `sPP`;
SELECT * FROM `sPQ`;

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`;
SHOW CREATE TABLE `sPO`;
SHOW CREATE TABLE `sPP`;
SHOW CREATE TABLE `sPQ`;

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`;
DESC `sPO`;
DESC `sPP`;
DESC `sPQ`;

#
# 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;
ALTER TABLE `sPO` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sPP` ADD `bQ` CHAR(1) NOT NULL FIRST;
ALTER TABLE `sPQ` 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`;
SHOW CREATE TABLE `sPO`;
SHOW CREATE TABLE `sPP`;
SHOW CREATE TABLE `sPQ`;

#
# Test to distinguish 0x9353 and 0x9373
# bug #6206 need to be fixed

#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`;
DESC `sPO`;
DESC `sPP`;
DESC `sPQ`;

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`;
DROP TABLE `sPO`;
DROP TABLE `sPP`;
DROP TABLE `sPQ`;

1 by brian clean slate	1	--character_set sjis
	2	--disable_warnings
	3	drop table if exists `sP`;
	4	drop table if exists `sQ`;
	5	drop table if exists `sR`;
	6	drop table if exists `sS`;
	7	drop table if exists `sT`;
	8	drop table if exists `sU`;
	9	drop table if exists `sV`;
	10	drop table if exists `sW`;
	11	drop table if exists `sX`;
	12	drop table if exists `sPO`;
	13	drop table if exists `sPP`;
	14	drop table if exists `sPQ`;
	15	#drop table if exists t1;
	16	--enable_warnings
	17
	18	#
	19	# Test ENUM values with Japanese characters in sjis encoding
	20	#
	21
	22	SET NAMES sjis;
	23	SET character_set_database = sjis;
	24
	25	CREATE TABLE `sP` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	26	CREATE TABLE `sQ` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	27	CREATE TABLE `sR` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	28	CREATE TABLE `sS` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	29	CREATE TABLE `sT` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	30	CREATE TABLE `sU` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
1233.2.1 by Monty Taylor Renamed instances of HEAP engine to MEMORY. Removed the alias.	31	CREATE TABLE `sV` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = MEMORY;
	32	CREATE TABLE `sW` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = MEMORY;
	33	CREATE TABLE `sX` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = MEMORY;
1 by brian clean slate	34	CREATE TABLE `sPO` (`bP` ENUM('±','²','³'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	35	CREATE TABLE `sPP` (`bP` ENUM(' ','¢','€'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	36	CREATE TABLE `sPQ` (`bP` ENUM('\','\','\'), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	37
	38	INSERT INTO `sP` VALUES ('±'),('²'),('³');
	39	INSERT INTO `sQ` VALUES (' '),('¢'),('€');
	40	INSERT INTO `sR` VALUES ('\'),('\'),('\');
	41	INSERT INTO `sS` VALUES ('±'),('²'),('³');
	42	INSERT INTO `sT` VALUES (' '),('¢'),('€');
	43	INSERT INTO `sU` VALUES ('\'),('\'),('\');
	44	INSERT INTO `sV` VALUES ('±'),('²'),('³');
	45	INSERT INTO `sW` VALUES (' '),('¢'),('€');
	46	INSERT INTO `sX` VALUES ('\'),('\'),('\');
	47	INSERT INTO `sPO` VALUES ('±'),('²'),('³');
	48	INSERT INTO `sPP` VALUES (' '),('¢'),('€');
	49	INSERT INTO `sPQ` VALUES ('\'),('\'),('\');
	50
	51	SELECT * FROM `sP`;
	52	SELECT * FROM `sQ`;
	53	SELECT * FROM `sR`;
	54	SELECT * FROM `sS`;
	55	SELECT * FROM `sT`;
	56	SELECT * FROM `sU`;
	57	SELECT * FROM `sV`;
	58	SELECT * FROM `sW`;
	59	SELECT * FROM `sX`;
	60	SELECT * FROM `sPO`;
	61	SELECT * FROM `sPP`;
	62	SELECT * FROM `sPQ`;
	63
	64	SHOW CREATE TABLE `sP`;
	65	SHOW CREATE TABLE `sQ`;
	66	SHOW CREATE TABLE `sR`;
	67	SHOW CREATE TABLE `sS`;
	68	SHOW CREATE TABLE `sT`;
	69	SHOW CREATE TABLE `sU`;
	70	SHOW CREATE TABLE `sV`;
	71	SHOW CREATE TABLE `sW`;
	72	SHOW CREATE TABLE `sX`;
	73	SHOW CREATE TABLE `sPO`;
	74	SHOW CREATE TABLE `sPP`;
	75	SHOW CREATE TABLE `sPQ`;
	76
	77	DESC `sP`;
	78	DESC `sQ`;
	79	DESC `sR`;
	80	DESC `sS`;
	81	DESC `sT`;
	82	DESC `sU`;
	83	DESC `sV`;
	84	DESC `sW`;
	85	DESC `sX`;
	86	DESC `sPO`;
	87	DESC `sPP`;
	88	DESC `sPQ`;
	89
	90	#
	91	# Test problem with enum values after the colum with NOT NULL restriction
	92	#
	93
	94	ALTER TABLE `sP` ADD `bQ` CHAR(1) NOT NULL FIRST;
	95	ALTER TABLE `sQ` ADD `bQ` CHAR(1) NOT NULL FIRST;
	96	ALTER TABLE `sR` ADD `bQ` CHAR(1) NOT NULL FIRST;
	97	ALTER TABLE `sS` ADD `bQ` CHAR(1) NOT NULL FIRST;
98	ALTER TABLE `sT` ADD `bQ` CHAR(1) NOT NULL FIRST;
99	ALTER TABLE `sU` ADD `bQ` CHAR(1) NOT NULL FIRST;
100	ALTER TABLE `sV` ADD `bQ` CHAR(1) NOT NULL FIRST;
101	ALTER TABLE `sW` ADD `bQ` CHAR(1) NOT NULL FIRST;
102	ALTER TABLE `sX` ADD `bQ` CHAR(1) NOT NULL FIRST;
103	ALTER TABLE `sPO` ADD `bQ` CHAR(1) NOT NULL FIRST;
104	ALTER TABLE `sPP` ADD `bQ` CHAR(1) NOT NULL FIRST;
105	ALTER TABLE `sPQ` ADD `bQ` CHAR(1) NOT NULL FIRST;
106
107	SHOW CREATE TABLE `sP`;
108	SHOW CREATE TABLE `sQ`;
109	SHOW CREATE TABLE `sR`;
110	SHOW CREATE TABLE `sS`;
111	SHOW CREATE TABLE `sT`;
112	SHOW CREATE TABLE `sU`;
113	SHOW CREATE TABLE `sV`;
114	SHOW CREATE TABLE `sW`;
115	SHOW CREATE TABLE `sX`;
116	SHOW CREATE TABLE `sPO`;
117	SHOW CREATE TABLE `sPP`;
118	SHOW CREATE TABLE `sPQ`;
119
120	#
121	# Test to distinguish 0x9353 and 0x9373
122	# bug #6206 need to be fixed
123
124	#CREATE TABLE t1(c1 enum('S','s')) default character set = sjis;
125	#INSERT INTO t1 VALUES('S'),('s');
126	#SELECT * FROM t1 WHERE c1 LIKE 'S';
127	#DROP TABLE t1;
128
129	DESC `sP`;
130	DESC `sQ`;
131	DESC `sR`;
132	DESC `sS`;
133	DESC `sT`;
134	DESC `sU`;
135	DESC `sV`;
136	DESC `sW`;
137	DESC `sX`;
138	DESC `sPO`;
139	DESC `sPP`;
140	DESC `sPQ`;
141
142	DROP TABLE `sP`;
143	DROP TABLE `sQ`;
144	DROP TABLE `sR`;
145	DROP TABLE `sS`;
146	DROP TABLE `sT`;
147	DROP TABLE `sU`;
148	DROP TABLE `sV`;
149	DROP TABLE `sW`;
150	DROP TABLE `sX`;
151	DROP TABLE `sPO`;
152	DROP TABLE `sPP`;
153	DROP TABLE `sPQ`;