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

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

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	SET NAMES ujis;
	12	SET character_set_database = ucs2;
	13	SET collation_connection = ucs2_general_ci;
	14	CREATE TABLE `£Ô£±` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
	15	CREATE TABLE `£Ô£²` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
	16	CREATE TABLE `£Ô£³` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = innodb;
	17	CREATE TABLE `£Ô£Ž` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
	18	CREATE TABLE `£Ô£µ` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
	19	CREATE TABLE `£Ô£¶` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = myisam;
1233.2.1 by Monty Taylor Renamed instances of HEAP engine to MEMORY. Removed the alias.	20	CREATE TABLE `£Ô£·` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = MEMORY;
	21	CREATE TABLE `£Ô£ž` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = MEMORY;
	22	CREATE TABLE `£Ô£¹` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = MEMORY;
1 by brian clean slate	23	CREATE TABLE `£Ô£±£°` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = bdb;
	24	CREATE TABLE `£Ô£±£±` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = bdb;
	25	CREATE TABLE `£Ô£±£²` (`£Ã£±` char(8), INDEX(`£Ã£±`)) DEFAULT CHARSET = ucs2 engine = bdb;
	26	INSERT INTO `£Ô£±` VALUES ('±²³Žµ');
	27	INSERT INTO `£Ô£±` VALUES (' ±²³Žµ');
	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	INSERT INTO `£Ô£³` VALUES ('íÜíÝíÞíßíà');
	41	INSERT INTO `£Ô£³` VALUES (' íÜíÝíÞíßíà');
	42	INSERT INTO `£Ô£³` VALUES (' íÜíÝíÞíßíà');
	43	INSERT INTO `£Ô£³` VALUES (' íÜíÝíÞíßíà');
	44	INSERT INTO `£Ô£³` VALUES ('¡¡íÜíÝíÞíßíà');
	45	INSERT INTO `£Ô£³` VALUES ('¡¡¡¡íÜíÝíÞíßíà');
	46	INSERT INTO `£Ô£³` VALUES ('¡¡¡¡¡¡íÜíÝíÞíßíà');
	47	INSERT INTO `£Ô£Ž` VALUES ('±²³Žµ');
	48	INSERT INTO `£Ô£Ž` VALUES (' ±²³Žµ');
	49	INSERT INTO `£Ô£Ž` VALUES (' ±²³Žµ');
	50	INSERT INTO `£Ô£Ž` VALUES (' ±²³Žµ');
	51	INSERT INTO `£Ô£Ž` VALUES ('¡¡±²³Žµ');
	52	INSERT INTO `£Ô£Ž` VALUES ('¡¡¡¡±²³Žµ');
	53	INSERT INTO `£Ô£Ž` VALUES ('¡¡¡¡¡¡±²³Žµ');
	54	INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª');
	55	INSERT INTO `£Ô£µ` VALUES (' €¢€€€Š€š€ª');
	56	INSERT INTO `£Ô£µ` VALUES (' €¢€€€Š€š€ª');
	57	INSERT INTO `£Ô£µ` VALUES (' €¢€€€Š€š€ª');
	58	INSERT INTO `£Ô£µ` VALUES ('¡¡€¢€€€Š€š€ª');
	59	INSERT INTO `£Ô£µ` VALUES ('¡¡¡¡€¢€€€Š€š€ª');
	60	INSERT INTO `£Ô£µ` VALUES ('¡¡¡¡¡¡€¢€€€Š€š€ª');
	61	INSERT INTO `£Ô£¶` VALUES ('íÜíÝíÞíßíà');
	62	INSERT INTO `£Ô£¶` VALUES (' íÜíÝíÞíßíà');
	63	INSERT INTO `£Ô£¶` VALUES (' íÜíÝíÞíßíà');
	64	INSERT INTO `£Ô£¶` VALUES (' íÜíÝíÞíßíà');
	65	INSERT INTO `£Ô£¶` VALUES ('¡¡íÜíÝíÞíßíà');
	66	INSERT INTO `£Ô£¶` VALUES ('¡¡¡¡íÜíÝíÞíßíà');
	67	INSERT INTO `£Ô£¶` VALUES ('¡¡¡¡¡¡íÜíÝíÞíßíà');
	68	INSERT INTO `£Ô£·` VALUES ('±²³Žµ');
	69	INSERT INTO `£Ô£·` VALUES (' ±²³Žµ');
	70	INSERT INTO `£Ô£·` VALUES (' ±²³Žµ');
	71	INSERT INTO `£Ô£·` VALUES (' ±²³Žµ');
	72	INSERT INTO `£Ô£·` VALUES ('¡¡±²³Žµ');
	73	INSERT INTO `£Ô£·` VALUES ('¡¡¡¡±²³Žµ');
	74	INSERT INTO `£Ô£·` VALUES ('¡¡¡¡¡¡±²³Žµ');
	75	INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª');
	76	INSERT INTO `£Ô£ž` VALUES (' €¢€€€Š€š€ª');
	77	INSERT INTO `£Ô£ž` VALUES (' €¢€€€Š€š€ª');
	78	INSERT INTO `£Ô£ž` VALUES (' €¢€€€Š€š€ª');
	79	INSERT INTO `£Ô£ž` VALUES ('¡¡€¢€€€Š€š€ª');
	80	INSERT INTO `£Ô£ž` VALUES ('¡¡¡¡€¢€€€Š€š€ª');
	81	INSERT INTO `£Ô£ž` VALUES ('¡¡¡¡¡¡€¢€€€Š€š€ª');
	82	INSERT INTO `£Ô£¹` VALUES ('íÜíÝíÞíßíà');
	83	INSERT INTO `£Ô£¹` VALUES (' íÜíÝíÞíßíà');
	84	INSERT INTO `£Ô£¹` VALUES (' íÜíÝíÞíßíà');
	85	INSERT INTO `£Ô£¹` VALUES (' íÜíÝíÞíßíà');
	86	INSERT INTO `£Ô£¹` VALUES ('¡¡íÜíÝíÞíßíà');
87	INSERT INTO `£Ô£¹` VALUES ('¡¡¡¡íÜíÝíÞíßíà');
88	INSERT INTO `£Ô£¹` VALUES ('¡¡¡¡¡¡íÜíÝíÞíßíà');
89	INSERT INTO `£Ô£±£°` VALUES ('±²³Žµ');
90	INSERT INTO `£Ô£±£°` VALUES (' ±²³Žµ');
91	INSERT INTO `£Ô£±£°` VALUES (' ±²³Žµ');
92	INSERT INTO `£Ô£±£°` VALUES (' ±²³Žµ');
93	INSERT INTO `£Ô£±£°` VALUES ('¡¡±²³Žµ');
94	INSERT INTO `£Ô£±£°` VALUES ('¡¡¡¡±²³Žµ');
95	INSERT INTO `£Ô£±£°` VALUES ('¡¡¡¡¡¡±²³Žµ');
96	INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª');
97	INSERT INTO `£Ô£±£±` VALUES (' €¢€€€Š€š€ª');
98	INSERT INTO `£Ô£±£±` VALUES (' €¢€€€Š€š€ª');
99	INSERT INTO `£Ô£±£±` VALUES (' €¢€€€Š€š€ª');
100	INSERT INTO `£Ô£±£±` VALUES ('¡¡€¢€€€Š€š€ª');
101	INSERT INTO `£Ô£±£±` VALUES ('¡¡¡¡€¢€€€Š€š€ª');
102	INSERT INTO `£Ô£±£±` VALUES ('¡¡¡¡¡¡€¢€€€Š€š€ª');
103	INSERT INTO `£Ô£±£²` VALUES ('íÜíÝíÞíßíà');
104	INSERT INTO `£Ô£±£²` VALUES (' íÜíÝíÞíßíà');
105	INSERT INTO `£Ô£±£²` VALUES (' íÜíÝíÞíßíà');
106	INSERT INTO `£Ô£±£²` VALUES (' íÜíÝíÞíßíà');
107	INSERT INTO `£Ô£±£²` VALUES ('¡¡íÜíÝíÞíßíà');
108	INSERT INTO `£Ô£±£²` VALUES ('¡¡¡¡íÜíÝíÞíßíà');
109	INSERT INTO `£Ô£±£²` VALUES ('¡¡¡¡¡¡íÜíÝíÞíßíà');
110	SELECT LTRIM(`£Ã£±`) from `£Ô£±`;
111	LTRIM(`£Ã£±`)
112	±²³Žµ
113	±²³Žµ
114	±²³Žµ
115	¡¡¡¡¡¡±²³Žµ
116	¡¡¡¡±²³Žµ
117	¡¡±²³Žµ
118	±²³Žµ
119	SELECT LTRIM(`£Ã£±`) from `£Ô£²`;
120	LTRIM(`£Ã£±`)
121	€¢€€€Š€š€ª
122	€¢€€€Š€š€ª
123	€¢€€€Š€š€ª
124	¡¡¡¡¡¡€¢€€€Š€š€ª
125	¡¡¡¡€¢€€€Š€š€ª
126	¡¡€¢€€€Š€š€ª
127	€¢€€€Š€š€ª
128	SELECT LTRIM(`£Ã£±`) from `£Ô£³`;
129	LTRIM(`£Ã£±`)
130	íÜíÝíÞíßíà
131	íÜíÝíÞíßíà
132	íÜíÝíÞíßíà
133	¡¡¡¡¡¡íÜíÝíÞíßíà
134	¡¡¡¡íÜíÝíÞíßíà
135	¡¡íÜíÝíÞíßíà
136	íÜíÝíÞíßíà
137	SELECT LTRIM(`£Ã£±`) from `£Ô£Ž`;
138	LTRIM(`£Ã£±`)
139	±²³Žµ
140	±²³Žµ
141	±²³Žµ
142	¡¡¡¡¡¡±²³Žµ
143	¡¡¡¡±²³Žµ
144	¡¡±²³Žµ
145	±²³Žµ
146	SELECT LTRIM(`£Ã£±`) from `£Ô£µ`;
147	LTRIM(`£Ã£±`)
148	€¢€€€Š€š€ª
149	€¢€€€Š€š€ª
150	€¢€€€Š€š€ª
151	¡¡¡¡¡¡€¢€€€Š€š€ª
152	¡¡¡¡€¢€€€Š€š€ª
153	¡¡€¢€€€Š€š€ª
154	€¢€€€Š€š€ª
155	SELECT LTRIM(`£Ã£±`) from `£Ô£¶`;
156	LTRIM(`£Ã£±`)
157	íÜíÝíÞíßíà
158	íÜíÝíÞíßíà
159	íÜíÝíÞíßíà
160	¡¡¡¡¡¡íÜíÝíÞíßíà
161	¡¡¡¡íÜíÝíÞíßíà
162	¡¡íÜíÝíÞíßíà
163	íÜíÝíÞíßíà
164	SELECT LTRIM(`£Ã£±`) from `£Ô£·`;
165	LTRIM(`£Ã£±`)
166	±²³Žµ
167	±²³Žµ
168	±²³Žµ
169	±²³Žµ
170	¡¡±²³Žµ
171	¡¡¡¡±²³Žµ
172	¡¡¡¡¡¡±²³Žµ
173	SELECT LTRIM(`£Ã£±`) from `£Ô£ž`;
174	LTRIM(`£Ã£±`)
175	€¢€€€Š€š€ª
176	€¢€€€Š€š€ª
177	€¢€€€Š€š€ª
178	€¢€€€Š€š€ª
179	¡¡€¢€€€Š€š€ª
180	¡¡¡¡€¢€€€Š€š€ª
181	¡¡¡¡¡¡€¢€€€Š€š€ª
182	SELECT LTRIM(`£Ã£±`) from `£Ô£¹`;
183	LTRIM(`£Ã£±`)
184	íÜíÝíÞíßíà
185	íÜíÝíÞíßíà
186	íÜíÝíÞíßíà
187	íÜíÝíÞíßíà
188	¡¡íÜíÝíÞíßíà
189	¡¡¡¡íÜíÝíÞíßíà
190	¡¡¡¡¡¡íÜíÝíÞíßíà
191	SELECT LTRIM(`£Ã£±`) from `£Ô£±£°`;
192	LTRIM(`£Ã£±`)
193	±²³Žµ
194	±²³Žµ
195	±²³Žµ
196	±²³Žµ
197	¡¡±²³Žµ
198	¡¡¡¡±²³Žµ
199	¡¡¡¡¡¡±²³Žµ
200	SELECT LTRIM(`£Ã£±`) from `£Ô£±£±`;
201	LTRIM(`£Ã£±`)
202	€¢€€€Š€š€ª
203	€¢€€€Š€š€ª
204	€¢€€€Š€š€ª
205	€¢€€€Š€š€ª
206	¡¡€¢€€€Š€š€ª
207	¡¡¡¡€¢€€€Š€š€ª
208	¡¡¡¡¡¡€¢€€€Š€š€ª
209	SELECT LTRIM(`£Ã£±`) from `£Ô£±£²`;
210	LTRIM(`£Ã£±`)
211	íÜíÝíÞíßíà
212	íÜíÝíÞíßíà
213	íÜíÝíÞíßíà
214	íÜíÝíÞíßíà
215	¡¡íÜíÝíÞíßíà
216	¡¡¡¡íÜíÝíÞíßíà
217	¡¡¡¡¡¡íÜíÝíÞíßíà
218	DROP TABLE `£Ô£±`;
219	DROP TABLE `£Ô£²`;
220	DROP TABLE `£Ô£³`;
221	DROP TABLE `£Ô£Ž`;
222	DROP TABLE `£Ô£µ`;
223	DROP TABLE `£Ô£¶`;
224	DROP TABLE `£Ô£·`;
225	DROP TABLE `£Ô£ž`;
226	DROP TABLE `£Ô£¹`;
227	DROP TABLE `£Ô£±£°`;
228	DROP TABLE `£Ô£±£±`;
229	DROP TABLE `£Ô£±£²`;