~drizzle-trunk/drizzle/development : contents of mysql-test/suite/jp/r/jp_enum

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

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 `£Ô£±£²`;
SET NAMES ujis;
SET character_set_database = ucs2;
SET collation_connection = ucs2_general_ci;
CREATE TABLE `£Ô£±` (`£Ã£±` ENUM('±','²','³'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `£Ô£²` (`£Ã£±` ENUM('€¢','€€','€Š'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `£Ô£³` (`£Ã£±` ENUM('íÜ','íÝ','íÞ'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
CREATE TABLE `£Ô£Ž` (`£Ã£±` ENUM('±','²','³'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `£Ô£µ` (`£Ã£±` ENUM('€¢','€€','€Š'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `£Ô£¶` (`£Ã£±` ENUM('íÜ','íÝ','íÞ'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
CREATE TABLE `£Ô£·` (`£Ã£±` ENUM('±','²','³'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = heap;
CREATE TABLE `£Ô£ž` (`£Ã£±` ENUM('€¢','€€','€Š'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = heap;
CREATE TABLE `£Ô£¹` (`£Ã£±` ENUM('íÜ','íÝ','íÞ'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = heap;
CREATE TABLE `£Ô£±£°` (`£Ã£±` ENUM('±','²','³'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = bdb;
CREATE TABLE `£Ô£±£±` (`£Ã£±` ENUM('€¢','€€','€Š'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = bdb;
CREATE TABLE `£Ô£±£²` (`£Ã£±` ENUM('íÜ','íÝ','íÞ'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = bdb;
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 ('íÜ'),('íÝ'),('íÞ');
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 `£Ô£¹`;
£Ã£±
íÜ
íÝ
íÞ
SELECT * FROM `£Ô£±£°`;
£Ã£±
±
²
³
SELECT * FROM `£Ô£±£±`;
£Ã£±
€¢
€€
€Š
SELECT * FROM `£Ô£±£²`;
£Ã£±
íÜ
íÝ
íÞ
SHOW CREATE TABLE `£Ô£±`;
Table	Create Table
£Ô£±	CREATE TABLE `£Ô£±` (
  `£Ã£±` enum('±','²','³') default NULL,
  KEY `£Ã£±` (`£Ã£±`)
) ENGINE=InnoDB DEFAULT CHARSET=ucs2
SHOW CREATE TABLE `£Ô£²`;
Table	Create Table
£Ô£²	CREATE TABLE `£Ô£²` (
  `£Ã£±` enum('€¢','€€','€Š') default NULL,
  KEY `£Ã£±` (`£Ã£±`)
) ENGINE=InnoDB DEFAULT CHARSET=ucs2
SHOW CREATE TABLE `£Ô£³`;
Table	Create Table
£Ô£³	CREATE TABLE `£Ô£³` (
  `£Ã£±` enum('íÜ','íÝ','íÞ') default NULL,
  KEY `£Ã£±` (`£Ã£±`)
) ENGINE=InnoDB DEFAULT CHARSET=ucs2
SHOW CREATE TABLE `£Ô£Ž`;
Table	Create Table
£Ô£Ž	CREATE TABLE `£Ô£Ž` (
  `£Ã£±` enum('±','²','³') default NULL,
  KEY `£Ã£±` (`£Ã£±`)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2
SHOW CREATE TABLE `£Ô£µ`;
Table	Create Table
£Ô£µ	CREATE TABLE `£Ô£µ` (
  `£Ã£±` enum('€¢','€€','€Š') default NULL,
  KEY `£Ã£±` (`£Ã£±`)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2
SHOW CREATE TABLE `£Ô£¶`;
Table	Create Table
£Ô£¶	CREATE TABLE `£Ô£¶` (
  `£Ã£±` enum('íÜ','íÝ','íÞ') default NULL,
  KEY `£Ã£±` (`£Ã£±`)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2
SHOW CREATE TABLE `£Ô£·`;
Table	Create Table
£Ô£·	CREATE TABLE `£Ô£·` (
  `£Ã£±` enum('±','²','³') default NULL,
  KEY `£Ã£±` (`£Ã£±`)
) ENGINE=HEAP DEFAULT CHARSET=ucs2
SHOW CREATE TABLE `£Ô£ž`;
Table	Create Table
£Ô£ž	CREATE TABLE `£Ô£ž` (
  `£Ã£±` enum('€¢','€€','€Š') default NULL,
  KEY `£Ã£±` (`£Ã£±`)
) ENGINE=HEAP DEFAULT CHARSET=ucs2
SHOW CREATE TABLE `£Ô£¹`;
Table	Create Table
£Ô£¹	CREATE TABLE `£Ô£¹` (
  `£Ã£±` enum('íÜ','íÝ','íÞ') default NULL,
  KEY `£Ã£±` (`£Ã£±`)
) ENGINE=HEAP DEFAULT CHARSET=ucs2
SHOW CREATE TABLE `£Ô£±£°`;
Table	Create Table
£Ô£±£°	CREATE TABLE `£Ô£±£°` (
  `£Ã£±` enum('±','²','³') default NULL,
  KEY `£Ã£±` (`£Ã£±`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=ucs2
SHOW CREATE TABLE `£Ô£±£±`;
Table	Create Table
£Ô£±£±	CREATE TABLE `£Ô£±£±` (
  `£Ã£±` enum('€¢','€€','€Š') default NULL,
  KEY `£Ã£±` (`£Ã£±`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=ucs2
SHOW CREATE TABLE `£Ô£±£²`;
Table	Create Table
£Ô£±£²	CREATE TABLE `£Ô£±£²` (
  `£Ã£±` enum('íÜ','íÝ','íÞ') default NULL,
  KEY `£Ã£±` (`£Ã£±`)
) ENGINE=BerkeleyDB DEFAULT CHARSET=ucs2
DESC `£Ô£±`;
Field	Type	Null	Key	Default	Extra
£Ã£±	enum('±','²','³')	YES	MUL	NULL	
DESC `£Ô£²`;
Field	Type	Null	Key	Default	Extra
£Ã£±	enum('€¢','€€','€Š')	YES	MUL	NULL	
DESC `£Ô£³`;
Field	Type	Null	Key	Default	Extra
£Ã£±	enum('íÜ','íÝ','íÞ')	YES	MUL	NULL	
DESC `£Ô£Ž`;
Field	Type	Null	Key	Default	Extra
£Ã£±	enum('±','²','³')	YES	MUL	NULL	
DESC `£Ô£µ`;
Field	Type	Null	Key	Default	Extra
£Ã£±	enum('€¢','€€','€Š')	YES	MUL	NULL	
DESC `£Ô£¶`;
Field	Type	Null	Key	Default	Extra
£Ã£±	enum('íÜ','íÝ','íÞ')	YES	MUL	NULL	
DESC `£Ô£·`;
Field	Type	Null	Key	Default	Extra
£Ã£±	enum('±','²','³')	YES	MUL	NULL	
DESC `£Ô£ž`;
Field	Type	Null	Key	Default	Extra
£Ã£±	enum('€¢','€€','€Š')	YES	MUL	NULL	
DESC `£Ô£¹`;
Field	Type	Null	Key	Default	Extra
£Ã£±	enum('íÜ','íÝ','íÞ')	YES	MUL	NULL	
DESC `£Ô£±£°`;
Field	Type	Null	Key	Default	Extra
£Ã£±	enum('±','²','³')	YES	MUL	NULL	
DESC `£Ô£±£±`;
Field	Type	Null	Key	Default	Extra
£Ã£±	enum('€¢','€€','€Š')	YES	MUL	NULL	
DESC `£Ô£±£²`;
Field	Type	Null	Key	Default	Extra
£Ã£±	enum('íÜ','íÝ','íÞ')	YES	MUL	NULL	
DROP TABLE `£Ô£±`;
DROP TABLE `£Ô£²`;
DROP TABLE `£Ô£³`;
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 `£Ô£±£²`;
	13	SET NAMES ujis;
	14	SET character_set_database = ucs2;
	15	SET collation_connection = ucs2_general_ci;
	16	CREATE TABLE `£Ô£±` (`£Ã£±` ENUM('±','²','³'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
	17	CREATE TABLE `£Ô£²` (`£Ã£±` ENUM('€¢','€€','€Š'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
	18	CREATE TABLE `£Ô£³` (`£Ã£±` ENUM('íÜ','íÝ','íÞ'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
	19	CREATE TABLE `£Ô£Ž` (`£Ã£±` ENUM('±','²','³'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
	20	CREATE TABLE `£Ô£µ` (`£Ã£±` ENUM('€¢','€€','€Š'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
	21	CREATE TABLE `£Ô£¶` (`£Ã£±` ENUM('íÜ','íÝ','íÞ'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
	22	CREATE TABLE `£Ô£·` (`£Ã£±` ENUM('±','²','³'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = heap;
	23	CREATE TABLE `£Ô£ž` (`£Ã£±` ENUM('€¢','€€','€Š'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = heap;
	24	CREATE TABLE `£Ô£¹` (`£Ã£±` ENUM('íÜ','íÝ','íÞ'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = heap;
	25	CREATE TABLE `£Ô£±£°` (`£Ã£±` ENUM('±','²','³'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = bdb;
	26	CREATE TABLE `£Ô£±£±` (`£Ã£±` ENUM('€¢','€€','€Š'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = bdb;
	27	CREATE TABLE `£Ô£±£²` (`£Ã£±` ENUM('íÜ','íÝ','íÞ'), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = bdb;
	28	INSERT INTO `£Ô£±` VALUES ('±'),('²'),('³');
	29	INSERT INTO `£Ô£²` VALUES ('€¢'),('€€'),('€Š');
	30	INSERT INTO `£Ô£³` VALUES ('íÜ'),('íÝ'),('íÞ');
	31	INSERT INTO `£Ô£Ž` VALUES ('±'),('²'),('³');
	32	INSERT INTO `£Ô£µ` VALUES ('€¢'),('€€'),('€Š');
	33	INSERT INTO `£Ô£¶` VALUES ('íÜ'),('íÝ'),('íÞ');
	34	INSERT INTO `£Ô£·` VALUES ('±'),('²'),('³');
	35	INSERT INTO `£Ô£ž` VALUES ('€¢'),('€€'),('€Š');
	36	INSERT INTO `£Ô£¹` VALUES ('íÜ'),('íÝ'),('íÞ');
	37	INSERT INTO `£Ô£±£°` VALUES ('±'),('²'),('³');
	38	INSERT INTO `£Ô£±£±` VALUES ('€¢'),('€€'),('€Š');
	39	INSERT INTO `£Ô£±£²` VALUES ('íÜ'),('íÝ'),('íÞ');
	40	SELECT * FROM `£Ô£±`;
	41	£Ã£±
	42	±
	43	²
	44	³
	45	SELECT * FROM `£Ô£²`;
	46	£Ã£±
	47	€¢
	48	€€
	49	€Š
	50	SELECT * FROM `£Ô£³`;
	51	£Ã£±
	52	íÜ
	53	íÝ
	54	íÞ
	55	SELECT * FROM `£Ô£Ž`;
	56	£Ã£±
	57	±
	58	²
	59	³
	60	SELECT * FROM `£Ô£µ`;
	61	£Ã£±
	62	€¢
	63	€€
	64	€Š
65	SELECT * FROM `£Ô£¶`;
66	£Ã£±
67	íÜ
68	íÝ
69	íÞ
70	SELECT * FROM `£Ô£·`;
71	£Ã£±
72	±
73	²
74	³
75	SELECT * FROM `£Ô£ž`;
76	£Ã£±
77	€¢
78	€€
79	€Š
80	SELECT * FROM `£Ô£¹`;
81	£Ã£±
82	íÜ
83	íÝ
84	íÞ
85	SELECT * FROM `£Ô£±£°`;
86	£Ã£±
87	±
88	²
89	³
90	SELECT * FROM `£Ô£±£±`;
91	£Ã£±
92	€¢
93	€€
94	€Š
95	SELECT * FROM `£Ô£±£²`;
96	£Ã£±
97	íÜ
98	íÝ
99	íÞ
100	SHOW CREATE TABLE `£Ô£±`;
101	Table Create Table
102	£Ô£± CREATE TABLE `£Ô£±` (
103	`£Ã£±` enum('±','²','³') default NULL,
104	KEY `£Ã£±` (`£Ã£±`)
105	) ENGINE=InnoDB DEFAULT CHARSET=ucs2
106	SHOW CREATE TABLE `£Ô£²`;
107	Table Create Table
108	£Ô£² CREATE TABLE `£Ô£²` (
109	`£Ã£±` enum('€¢','€€','€Š') default NULL,
110	KEY `£Ã£±` (`£Ã£±`)
111	) ENGINE=InnoDB DEFAULT CHARSET=ucs2
112	SHOW CREATE TABLE `£Ô£³`;
113	Table Create Table
114	£Ô£³ CREATE TABLE `£Ô£³` (
115	`£Ã£±` enum('íÜ','íÝ','íÞ') default NULL,
116	KEY `£Ã£±` (`£Ã£±`)
117	) ENGINE=InnoDB DEFAULT CHARSET=ucs2
118	SHOW CREATE TABLE `£Ô£Ž`;
119	Table Create Table
120	£Ô£Ž CREATE TABLE `£Ô£Ž` (
121	`£Ã£±` enum('±','²','³') default NULL,
122	KEY `£Ã£±` (`£Ã£±`)
123	) ENGINE=MyISAM DEFAULT CHARSET=ucs2
124	SHOW CREATE TABLE `£Ô£µ`;
125	Table Create Table
126	£Ô£µ CREATE TABLE `£Ô£µ` (
127	`£Ã£±` enum('€¢','€€','€Š') default NULL,
128	KEY `£Ã£±` (`£Ã£±`)
129	) ENGINE=MyISAM DEFAULT CHARSET=ucs2
130	SHOW CREATE TABLE `£Ô£¶`;
131	Table Create Table
132	£Ô£¶ CREATE TABLE `£Ô£¶` (
133	`£Ã£±` enum('íÜ','íÝ','íÞ') default NULL,
134	KEY `£Ã£±` (`£Ã£±`)
135	) ENGINE=MyISAM DEFAULT CHARSET=ucs2
136	SHOW CREATE TABLE `£Ô£·`;
137	Table Create Table
138	£Ô£· CREATE TABLE `£Ô£·` (
139	`£Ã£±` enum('±','²','³') default NULL,
140	KEY `£Ã£±` (`£Ã£±`)
141	) ENGINE=HEAP DEFAULT CHARSET=ucs2
142	SHOW CREATE TABLE `£Ô£ž`;
143	Table Create Table
144	£Ô£ž CREATE TABLE `£Ô£ž` (
145	`£Ã£±` enum('€¢','€€','€Š') default NULL,
146	KEY `£Ã£±` (`£Ã£±`)
147	) ENGINE=HEAP DEFAULT CHARSET=ucs2
148	SHOW CREATE TABLE `£Ô£¹`;
149	Table Create Table
150	£Ô£¹ CREATE TABLE `£Ô£¹` (
151	`£Ã£±` enum('íÜ','íÝ','íÞ') default NULL,
152	KEY `£Ã£±` (`£Ã£±`)
153	) ENGINE=HEAP DEFAULT CHARSET=ucs2
154	SHOW CREATE TABLE `£Ô£±£°`;
155	Table Create Table
156	£Ô£±£° CREATE TABLE `£Ô£±£°` (
157	`£Ã£±` enum('±','²','³') default NULL,
158	KEY `£Ã£±` (`£Ã£±`)
159	) ENGINE=BerkeleyDB DEFAULT CHARSET=ucs2
160	SHOW CREATE TABLE `£Ô£±£±`;
161	Table Create Table
162	£Ô£±£± CREATE TABLE `£Ô£±£±` (
163	`£Ã£±` enum('€¢','€€','€Š') default NULL,
164	KEY `£Ã£±` (`£Ã£±`)
165	) ENGINE=BerkeleyDB DEFAULT CHARSET=ucs2
166	SHOW CREATE TABLE `£Ô£±£²`;
167	Table Create Table
168	£Ô£±£² CREATE TABLE `£Ô£±£²` (
169	`£Ã£±` enum('íÜ','íÝ','íÞ') default NULL,
170	KEY `£Ã£±` (`£Ã£±`)
171	) ENGINE=BerkeleyDB DEFAULT CHARSET=ucs2
172	DESC `£Ô£±`;
173	Field Type Null Key Default Extra
174	£Ã£± enum('±','²','³') YES MUL NULL
175	DESC `£Ô£²`;
176	Field Type Null Key Default Extra
177	£Ã£± enum('€¢','€€','€Š') YES MUL NULL
178	DESC `£Ô£³`;
179	Field Type Null Key Default Extra
180	£Ã£± enum('íÜ','íÝ','íÞ') YES MUL NULL
181	DESC `£Ô£Ž`;
182	Field Type Null Key Default Extra
183	£Ã£± enum('±','²','³') YES MUL NULL
184	DESC `£Ô£µ`;
185	Field Type Null Key Default Extra
186	£Ã£± enum('€¢','€€','€Š') YES MUL NULL
187	DESC `£Ô£¶`;
188	Field Type Null Key Default Extra
189	£Ã£± enum('íÜ','íÝ','íÞ') YES MUL NULL
190	DESC `£Ô£·`;
191	Field Type Null Key Default Extra
192	£Ã£± enum('±','²','³') YES MUL NULL
193	DESC `£Ô£ž`;
194	Field Type Null Key Default Extra
195	£Ã£± enum('€¢','€€','€Š') YES MUL NULL
196	DESC `£Ô£¹`;
197	Field Type Null Key Default Extra
198	£Ã£± enum('íÜ','íÝ','íÞ') YES MUL NULL
199	DESC `£Ô£±£°`;
200	Field Type Null Key Default Extra
201	£Ã£± enum('±','²','³') YES MUL NULL
202	DESC `£Ô£±£±`;
203	Field Type Null Key Default Extra
204	£Ã£± enum('€¢','€€','€Š') YES MUL NULL
205	DESC `£Ô£±£²`;
206	Field Type Null Key Default Extra
207	£Ã£± enum('íÜ','íÝ','íÞ') YES MUL NULL
208	DROP TABLE `£Ô£±`;
209	DROP TABLE `£Ô£²`;
210	DROP TABLE `£Ô£³`;
211	DROP TABLE `£Ô£Ž`;
212	DROP TABLE `£Ô£µ`;
213	DROP TABLE `£Ô£¶`;
214	DROP TABLE `£Ô£·`;
215	DROP TABLE `£Ô£ž`;
216	DROP TABLE `£Ô£¹`;
217	DROP TABLE `£Ô£±£°`;
218	DROP TABLE `£Ô£±£±`;
219	DROP TABLE `£Ô£±£²`;