~drizzle-trunk/drizzle/development : contents of tests/suite/jp/r/enum

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

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 `Ｔ１０`;
drop table if exists `Ｔ１１`;
drop table if exists `Ｔ１２`;
CREATE TABLE `Ｔ１` (`Ｃ１` ENUM('ｱ','ｲ','ｳ'), INDEX(`Ｃ１`))  engine = innodb;
CREATE TABLE `Ｔ２` (`Ｃ１` ENUM('あ','い','う'), INDEX(`Ｃ１`))  engine = innodb;
CREATE TABLE `Ｔ３` (`Ｃ１` ENUM('龔','龖','龗'), INDEX(`Ｃ１`))  engine = innodb;
CREATE TEMPORARY TABLE `Ｔ４` (`Ｃ１` ENUM('ｱ','ｲ','ｳ'), INDEX(`Ｃ１`))  engine = myisam;
CREATE TEMPORARY TABLE `Ｔ５` (`Ｃ１` ENUM('あ','い','う'), INDEX(`Ｃ１`))  engine = myisam;
CREATE TEMPORARY TABLE `Ｔ６` (`Ｃ１` ENUM('龔','龖','龗'), INDEX(`Ｃ１`))  engine = myisam;
CREATE TEMPORARY TABLE `Ｔ７` (`Ｃ１` ENUM('ｱ','ｲ','ｳ'), INDEX(`Ｃ１`))  engine = MEMORY;
CREATE TEMPORARY TABLE `Ｔ８` (`Ｃ１` ENUM('あ','い','う'), INDEX(`Ｃ１`))  engine = MEMORY;
CREATE TEMPORARY TABLE `Ｔ９` (`Ｃ１` ENUM('龔','龖','龗'), INDEX(`Ｃ１`))  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 `Ｔ１`;
Table	Create Table
Ｔ１	CREATE TABLE `Ｔ１` (
  `Ｃ１` ENUM('ｱ','ｲ','ｳ') DEFAULT NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=InnoDB COLLATE = utf8_general_ci
SHOW CREATE TABLE `Ｔ２`;
Table	Create Table
Ｔ２	CREATE TABLE `Ｔ２` (
  `Ｃ１` ENUM('あ','い','う') DEFAULT NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=InnoDB COLLATE = utf8_general_ci
SHOW CREATE TABLE `Ｔ３`;
Table	Create Table
Ｔ３	CREATE TABLE `Ｔ３` (
  `Ｃ１` ENUM('龔','龖','龗') DEFAULT NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=InnoDB COLLATE = utf8_general_ci
SHOW CREATE TABLE `Ｔ４`;
Table	Create Table
Ｔ４	CREATE TEMPORARY TABLE `Ｔ４` (
  `Ｃ１` ENUM('ｱ','ｲ','ｳ') DEFAULT NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MyISAM COLLATE = utf8_general_ci
SHOW CREATE TABLE `Ｔ５`;
Table	Create Table
Ｔ５	CREATE TEMPORARY TABLE `Ｔ５` (
  `Ｃ１` ENUM('あ','い','う') DEFAULT NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MyISAM COLLATE = utf8_general_ci
SHOW CREATE TABLE `Ｔ６`;
Table	Create Table
Ｔ６	CREATE TEMPORARY TABLE `Ｔ６` (
  `Ｃ１` ENUM('龔','龖','龗') DEFAULT NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MyISAM COLLATE = utf8_general_ci
SHOW CREATE TABLE `Ｔ７`;
Table	Create Table
Ｔ７	CREATE TEMPORARY TABLE `Ｔ７` (
  `Ｃ１` ENUM('ｱ','ｲ','ｳ') DEFAULT NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MEMORY COLLATE = utf8_general_ci
SHOW CREATE TABLE `Ｔ８`;
Table	Create Table
Ｔ８	CREATE TEMPORARY TABLE `Ｔ８` (
  `Ｃ１` ENUM('あ','い','う') DEFAULT NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MEMORY COLLATE = utf8_general_ci
SHOW CREATE TABLE `Ｔ９`;
Table	Create Table
Ｔ９	CREATE TEMPORARY TABLE `Ｔ９` (
  `Ｃ１` ENUM('龔','龖','龗') DEFAULT NULL,
  KEY `Ｃ１` (`Ｃ１`)
) ENGINE=MEMORY COLLATE = utf8_general_ci
ALTER TABLE `Ｔ１` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
ALTER TABLE `Ｔ２` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
ALTER TABLE `Ｔ３` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
ALTER TABLE `Ｔ４` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
ALTER TABLE `Ｔ５` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
ALTER TABLE `Ｔ６` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
ALTER TABLE `Ｔ７` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
ALTER TABLE `Ｔ８` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
ALTER TABLE `Ｔ９` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
DROP TABLE `Ｔ１`;
DROP TABLE `Ｔ２`;
DROP TABLE `Ｔ３`;
DROP TABLE `Ｔ４`;
DROP TABLE `Ｔ５`;
DROP TABLE `Ｔ６`;
DROP TABLE `Ｔ７`;
DROP TABLE `Ｔ８`;
DROP TABLE `Ｔ９`;

1 by brian clean slate	1	drop table if exists `Ｔ１`;
	2	drop table if exists `Ｔ２`;
	3	drop table if exists `Ｔ３`;
	4	drop table if exists `Ｔ４`;
	5	drop table if exists `Ｔ５`;
	6	drop table if exists `Ｔ６`;
	7	drop table if exists `Ｔ７`;
	8	drop table if exists `Ｔ８`;
	9	drop table if exists `Ｔ９`;
	10	drop table if exists `Ｔ１０`;
	11	drop table if exists `Ｔ１１`;
	12	drop table if exists `Ｔ１２`;
1271.4.1 by lbieber clean up japanese tests, remove tests that no longer apply. In test-run.pl change mysql_version_id to drizzle_version_id	13	CREATE TABLE `Ｔ１` (`Ｃ１` ENUM('ｱ','ｲ','ｳ'), INDEX(`Ｃ１`)) engine = innodb;
	14	CREATE TABLE `Ｔ２` (`Ｃ１` ENUM('あ','い','う'), INDEX(`Ｃ１`)) engine = innodb;
	15	CREATE TABLE `Ｔ３` (`Ｃ１` ENUM('龔','龖','龗'), INDEX(`Ｃ１`)) engine = innodb;
	16	CREATE TEMPORARY TABLE `Ｔ４` (`Ｃ１` ENUM('ｱ','ｲ','ｳ'), INDEX(`Ｃ１`)) engine = myisam;
	17	CREATE TEMPORARY TABLE `Ｔ５` (`Ｃ１` ENUM('あ','い','う'), INDEX(`Ｃ１`)) engine = myisam;
	18	CREATE TEMPORARY TABLE `Ｔ６` (`Ｃ１` ENUM('龔','龖','龗'), INDEX(`Ｃ１`)) engine = myisam;
	19	CREATE TEMPORARY TABLE `Ｔ７` (`Ｃ１` ENUM('ｱ','ｲ','ｳ'), INDEX(`Ｃ１`)) engine = MEMORY;
	20	CREATE TEMPORARY TABLE `Ｔ８` (`Ｃ１` ENUM('あ','い','う'), INDEX(`Ｃ１`)) engine = MEMORY;
	21	CREATE TEMPORARY TABLE `Ｔ９` (`Ｃ１` ENUM('龔','龖','龗'), INDEX(`Ｃ１`)) engine = MEMORY;
1 by brian clean slate	22	INSERT INTO `Ｔ１` VALUES ('ｱ'),('ｲ'),('ｳ');
	23	INSERT INTO `Ｔ２` VALUES ('あ'),('い'),('う');
	24	INSERT INTO `Ｔ３` VALUES ('龔'),('龖'),('龗');
	25	INSERT INTO `Ｔ４` VALUES ('ｱ'),('ｲ'),('ｳ');
	26	INSERT INTO `Ｔ５` VALUES ('あ'),('い'),('う');
	27	INSERT INTO `Ｔ６` VALUES ('龔'),('龖'),('龗');
	28	INSERT INTO `Ｔ７` VALUES ('ｱ'),('ｲ'),('ｳ');
	29	INSERT INTO `Ｔ８` VALUES ('あ'),('い'),('う');
	30	INSERT INTO `Ｔ９` VALUES ('龔'),('龖'),('龗');
	31	SELECT * FROM `Ｔ１`;
	32	Ｃ１
	33	ｱ
	34	ｲ
	35	ｳ
	36	SELECT * FROM `Ｔ２`;
	37	Ｃ１
	38	あ
	39	い
	40	う
	41	SELECT * FROM `Ｔ３`;
	42	Ｃ１
	43	龔
	44	龖
	45	龗
	46	SELECT * FROM `Ｔ４`;
	47	Ｃ１
	48	ｱ
	49	ｲ
	50	ｳ
	51	SELECT * FROM `Ｔ５`;
	52	Ｃ１
	53	あ
	54	い
	55	う
	56	SELECT * FROM `Ｔ６`;
	57	Ｃ１
	58	龔
	59	龖
	60	龗
	61	SELECT * FROM `Ｔ７`;
	62	Ｃ１
	63	ｱ
	64	ｲ
	65	ｳ
	66	SELECT * FROM `Ｔ８`;
	67	Ｃ１
	68	あ
	69	い
	70	う
	71	SELECT * FROM `Ｔ９`;
	72	Ｃ１
	73	龔
	74	龖
	75	龗
	76	SHOW CREATE TABLE `Ｔ１`;
	77	Table Create Table
1937.4.1 by Andrew Hutchings Make mixed case table names work again	78	Ｔ１ CREATE TABLE `Ｔ１` (
	79	`Ｃ１` ENUM('ｱ','ｲ','ｳ') DEFAULT NULL,
	80	KEY `Ｃ１` (`Ｃ１`)
	81	) ENGINE=InnoDB COLLATE = utf8_general_ci
1 by brian clean slate	82	SHOW CREATE TABLE `Ｔ２`;
1 by brian clean slate	83	Table Create Table
1937.4.1 by Andrew Hutchings Make mixed case table names work again	84	Ｔ２ CREATE TABLE `Ｔ２` (
	85	`Ｃ１` ENUM('あ','い','う') DEFAULT NULL,
	86	KEY `Ｃ１` (`Ｃ１`)
	87	) ENGINE=InnoDB COLLATE = utf8_general_ci
1 by brian clean slate	88	SHOW CREATE TABLE `Ｔ３`;
1 by brian clean slate	89	Table Create Table
1937.4.1 by Andrew Hutchings Make mixed case table names work again	90	Ｔ３ CREATE TABLE `Ｔ３` (
	91	`Ｃ１` ENUM('龔','龖','龗') DEFAULT NULL,
	92	KEY `Ｃ１` (`Ｃ１`)
	93	) ENGINE=InnoDB COLLATE = utf8_general_ci
1 by brian clean slate	94	SHOW CREATE TABLE `Ｔ４`;
1 by brian clean slate	95	Table Create Table
1937.4.1 by Andrew Hutchings Make mixed case table names work again	96	Ｔ４ CREATE TEMPORARY TABLE `Ｔ４` (
	97	`Ｃ１` ENUM('ｱ','ｲ','ｳ') DEFAULT NULL,
	98	KEY `Ｃ１` (`Ｃ１`)
	99	) ENGINE=MyISAM COLLATE = utf8_general_ci
1 by brian clean slate	100	SHOW CREATE TABLE `Ｔ５`;
1 by brian clean slate	101	Table Create Table
1937.4.1 by Andrew Hutchings Make mixed case table names work again	102	Ｔ５ CREATE TEMPORARY TABLE `Ｔ５` (
	103	`Ｃ１` ENUM('あ','い','う') DEFAULT NULL,
	104	KEY `Ｃ１` (`Ｃ１`)
	105	) ENGINE=MyISAM COLLATE = utf8_general_ci
1 by brian clean slate	106	SHOW CREATE TABLE `Ｔ６`;
1 by brian clean slate	107	Table Create Table
1937.4.1 by Andrew Hutchings Make mixed case table names work again	108	Ｔ６ CREATE TEMPORARY TABLE `Ｔ６` (
	109	`Ｃ１` ENUM('龔','龖','龗') DEFAULT NULL,
	110	KEY `Ｃ１` (`Ｃ１`)
	111	) ENGINE=MyISAM COLLATE = utf8_general_ci
1 by brian clean slate	112	SHOW CREATE TABLE `Ｔ７`;
1 by brian clean slate	113	Table Create Table
1937.4.1 by Andrew Hutchings Make mixed case table names work again	114	Ｔ７ CREATE TEMPORARY TABLE `Ｔ７` (
	115	`Ｃ１` ENUM('ｱ','ｲ','ｳ') DEFAULT NULL,
	116	KEY `Ｃ１` (`Ｃ１`)
	117	) ENGINE=MEMORY COLLATE = utf8_general_ci
1 by brian clean slate	118	SHOW CREATE TABLE `Ｔ８`;
1 by brian clean slate	119	Table Create Table
1937.4.1 by Andrew Hutchings Make mixed case table names work again	120	Ｔ８ CREATE TEMPORARY TABLE `Ｔ８` (
	121	`Ｃ１` ENUM('あ','い','う') DEFAULT NULL,
	122	KEY `Ｃ１` (`Ｃ１`)
	123	) ENGINE=MEMORY COLLATE = utf8_general_ci
1 by brian clean slate	124	SHOW CREATE TABLE `Ｔ９`;
1 by brian clean slate	125	Table Create Table
1937.4.1 by Andrew Hutchings Make mixed case table names work again	126	Ｔ９ CREATE TEMPORARY TABLE `Ｔ９` (
	127	`Ｃ１` ENUM('龔','龖','龗') DEFAULT NULL,
	128	KEY `Ｃ１` (`Ｃ１`)
	129	) ENGINE=MEMORY COLLATE = utf8_general_ci
1976.6.1 by Brian Aker This is a fix for bug lp:686197	130	ALTER TABLE `Ｔ１` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
	131	ALTER TABLE `Ｔ２` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
	132	ALTER TABLE `Ｔ３` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
	133	ALTER TABLE `Ｔ４` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
	134	ALTER TABLE `Ｔ５` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
	135	ALTER TABLE `Ｔ６` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
	136	ALTER TABLE `Ｔ７` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
	137	ALTER TABLE `Ｔ８` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
	138	ALTER TABLE `Ｔ９` ADD `Ｃ２` CHAR(1) DEFAULT "Y" NOT NULL FIRST;
1 by brian clean slate	139	DROP TABLE `Ｔ１`;
	140	DROP TABLE `Ｔ２`;
	141	DROP TABLE `Ｔ３`;
	142	DROP TABLE `Ｔ４`;
	143	DROP TABLE `Ｔ５`;
	144	DROP TABLE `Ｔ６`;
	145	DROP TABLE `Ｔ７`;
	146	DROP TABLE `Ｔ８`;
	147	DROP TABLE `Ｔ９`;