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

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

1 by brian clean slate	1	drop table if exists `sP`;
	2	drop table if exists `sQ`;
	3	drop table if exists `sR`;
	4	drop table if exists `sS`;
	5	drop table if exists `sT`;
	6	drop table if exists `sU`;
	7	drop table if exists `sV`;
	8	drop table if exists `sW`;
	9	drop table if exists `sX`;
	10	drop table if exists `sPO`;
	11	drop table if exists `sPP`;
	12	drop table if exists `sPQ`;
	13	SET NAMES sjis;
	14	SET character_set_database = sjis;
	15	CREATE TABLE `sP` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	16	CREATE TABLE `sQ` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	17	CREATE TABLE `sR` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = innodb;
	18	CREATE TABLE `sS` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	19	CREATE TABLE `sT` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	20	CREATE TABLE `sU` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = myisam;
	21	CREATE TABLE `sV` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
	22	CREATE TABLE `sW` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
	23	CREATE TABLE `sX` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = heap;
	24	CREATE TABLE `sPO` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	25	CREATE TABLE `sPP` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	26	CREATE TABLE `sPQ` (`bP` char(20), INDEX(`bP`)) DEFAULT CHARSET = sjis engine = bdb;
	27	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sP`;
	28	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sQ`;
	29	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sR`;
	30	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sS`;
	31	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sT`;
	32	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sU`;
	33	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sV`;
	34	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sW`;
	35	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sX`;
	36	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_sjis.dat' INTO TABLE `sPO`;
	37	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis.dat' INTO TABLE `sPP`;
	38	LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_sjis2.dat' INTO TABLE `sPQ`;
	39	SELECT * FROM `sP` WHERE `bP` LIKE ' %';
	40	bP
	41	!"#$%&'()*+,-./
	42	¡¢£€¥Š§š©ª«¬®¯
	43	SELECT * FROM `sP` WHERE `bP` LIKE '% %';
	44	bP
	45	!"#$%&'()*+,-./
	46	¡¢£€¥Š§š©ª«¬®¯
	47	SELECT * FROM `sP` WHERE `bP` LIKE '% ';
	48	bP
	49	SELECT * FROM `sP` WHERE `bP` LIKE 'À%';
	50	bP
	51	ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ
	52	SELECT * FROM `sP` WHERE `bP` LIKE '%×Ø%';
	53	bP
	54	ÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß
	55	SELECT * FROM `sP` WHERE `bP` LIKE '%¿';
	56	bP
	57	°±²³Žµ¶·ž¹º»ŒœŸ¿
	58	SELECT * FROM `sP` WHERE `bP` LIKE '°±²³Žµ¶·ž¹º»ŒœŸ¿%';
	59	bP
	60	°±²³Žµ¶·ž¹º»ŒœŸ¿
	61	SELECT * FROM `sP` WHERE `bP` LIKE '%°±²³Žµ¶·ž¹º»ŒœŸ¿%';
	62	bP
	63	°±²³Žµ¶·ž¹º»ŒœŸ¿
	64	SELECT * FROM `sP` WHERE `bP` LIKE '%°±²³Žµ¶·ž¹º»ŒœŸ¿';
65	bP
66	°±²³Žµ¶·ž¹º»ŒœŸ¿
67	SELECT * FROM `sQ` WHERE `bP` LIKE '@%';
68	bP
69	@@ABCDEFGHIJKLMNOPQR
70	SELECT * FROM `sQ` WHERE `bP` LIKE '%@%';
71	bP
72	@@ABCDEFGHIJKLMNOPQR
73	EEðñòóôõö÷EEEEüEEEE@
74	SELECT * FROM `sQ` WHERE `bP` LIKE '%@';
75	bP
76	EEðñòóôõö÷EEEEüEEEE@
77	SELECT * FROM `sQ` WHERE `bP` LIKE 'Æ%';
78	bP
79	ÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙ
80	SELECT * FROM `sQ` WHERE `bP` LIKE '% %';
81	bP
82	E ¡¢£€¥Š§š©ª«¬®¯°±
83	SELECT * FROM `sQ` WHERE `bP` LIKE '%í';
84	bP
85	ÚÛÜÝÞßàáâãäåæçèéêëìí
86	SELECT * FROM `sQ` WHERE `bP` LIKE 'E ¡¢£€¥Š§š©ª«¬®¯°±%';
87	bP
88	E ¡¢£€¥Š§š©ª«¬®¯°±
89	SELECT * FROM `sQ` WHERE `bP` LIKE '%E ¡¢£€¥Š§š©ª«¬®¯°±%';
90	bP
91	E ¡¢£€¥Š§š©ª«¬®¯°±
92	SELECT * FROM `sQ` WHERE `bP` LIKE '%E ¡¢£€¥Š§š©ª«¬®¯°±';
93	bP
94	E ¡¢£€¥Š§š©ª«¬®¯°±
95	SELECT * FROM `sR` WHERE `bP` LIKE '\%';
96	bP
97	\\\\\\\\\\\\\\\\\\\\
98	SELECT * FROM `sR` WHERE `bP` LIKE '%\%';
99	bP
100	\\\\\\\\\\\\\\\\\\\\
101	SELECT * FROM `sR` WHERE `bP` LIKE '%\';
102	bP
103	\\\\\\\\\\\\\\\\\\\\
104	SELECT * FROM `sR` WHERE `bP` LIKE '\\\\\\\\\\\\\\\\\\\\%';
105	bP
106	\\\\\\\\\\\\\\\\\\\\
107	SELECT * FROM `sR` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\%';
108	bP
109	\\\\\\\\\\\\\\\\\\\\
110	SELECT * FROM `sR` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\';
111	bP
112	\\\\\\\\\\\\\\\\\\\\
113	SELECT * FROM `sS` WHERE `bP` LIKE ' %';
114	bP
115	!"#$%&'()*+,-./
116	¡¢£€¥Š§š©ª«¬®¯
117	SELECT * FROM `sS` WHERE `bP` LIKE '% %';
118	bP
119	!"#$%&'()*+,-./
120	¡¢£€¥Š§š©ª«¬®¯
121	SELECT * FROM `sS` WHERE `bP` LIKE '% ';
122	bP
123	SELECT * FROM `sS` WHERE `bP` LIKE 'À%';
124	bP
125	ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ
126	SELECT * FROM `sS` WHERE `bP` LIKE '%×Ø%';
127	bP
128	ÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß
129	SELECT * FROM `sS` WHERE `bP` LIKE '%¿';
130	bP
131	°±²³Žµ¶·ž¹º»ŒœŸ¿
132	SELECT * FROM `sS` WHERE `bP` LIKE '°±²³Žµ¶·ž¹º»ŒœŸ¿%';
133	bP
134	°±²³Žµ¶·ž¹º»ŒœŸ¿
135	SELECT * FROM `sS` WHERE `bP` LIKE '%°±²³Žµ¶·ž¹º»ŒœŸ¿%';
136	bP
137	°±²³Žµ¶·ž¹º»ŒœŸ¿
138	SELECT * FROM `sS` WHERE `bP` LIKE '%°±²³Žµ¶·ž¹º»ŒœŸ¿';
139	bP
140	°±²³Žµ¶·ž¹º»ŒœŸ¿
141	SELECT * FROM `sT` WHERE `bP` LIKE '@%';
142	bP
143	@@ABCDEFGHIJKLMNOPQR
144	SELECT * FROM `sT` WHERE `bP` LIKE '%@%';
145	bP
146	@@ABCDEFGHIJKLMNOPQR
147	EEðñòóôõö÷EEEEüEEEE@
148	SELECT * FROM `sT` WHERE `bP` LIKE '%@';
149	bP
150	EEðñòóôõö÷EEEEüEEEE@
151	SELECT * FROM `sT` WHERE `bP` LIKE 'Æ%';
152	bP
153	ÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙ
154	SELECT * FROM `sT` WHERE `bP` LIKE '% %';
155	bP
156	E ¡¢£€¥Š§š©ª«¬®¯°±
157	SELECT * FROM `sT` WHERE `bP` LIKE '%í';
158	bP
159	ÚÛÜÝÞßàáâãäåæçèéêëìí
160	SELECT * FROM `sT` WHERE `bP` LIKE 'E ¡¢£€¥Š§š©ª«¬®¯°±%';
161	bP
162	E ¡¢£€¥Š§š©ª«¬®¯°±
163	SELECT * FROM `sT` WHERE `bP` LIKE '%E ¡¢£€¥Š§š©ª«¬®¯°±%';
164	bP
165	E ¡¢£€¥Š§š©ª«¬®¯°±
166	SELECT * FROM `sT` WHERE `bP` LIKE '%E ¡¢£€¥Š§š©ª«¬®¯°±';
167	bP
168	E ¡¢£€¥Š§š©ª«¬®¯°±
169	SELECT * FROM `sU` WHERE `bP` LIKE '\%';
170	bP
171	\\\\\\\\\\\\\\\\\\\\
172	SELECT * FROM `sU` WHERE `bP` LIKE '%\%';
173	bP
174	\\\\\\\\\\\\\\\\\\\\
175	SELECT * FROM `sU` WHERE `bP` LIKE '%\';
176	bP
177	\\\\\\\\\\\\\\\\\\\\
178	SELECT * FROM `sU` WHERE `bP` LIKE '\\\\\\\\\\\\\\\\\\\\%';
179	bP
180	\\\\\\\\\\\\\\\\\\\\
181	SELECT * FROM `sU` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\%';
182	bP
183	\\\\\\\\\\\\\\\\\\\\
184	SELECT * FROM `sU` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\';
185	bP
186	\\\\\\\\\\\\\\\\\\\\
187	SELECT * FROM `sV` WHERE `bP` LIKE ' %';
188	bP
189	!"#$%&'()*+,-./
190	¡¢£€¥Š§š©ª«¬®¯
191	SELECT * FROM `sV` WHERE `bP` LIKE '% %';
192	bP
193	!"#$%&'()*+,-./
194	¡¢£€¥Š§š©ª«¬®¯
195	SELECT * FROM `sV` WHERE `bP` LIKE '% ';
196	bP
197	SELECT * FROM `sV` WHERE `bP` LIKE 'À%';
198	bP
199	ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ
200	SELECT * FROM `sV` WHERE `bP` LIKE '%×Ø%';
201	bP
202	ÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß
203	SELECT * FROM `sV` WHERE `bP` LIKE '%¿';
204	bP
205	°±²³Žµ¶·ž¹º»ŒœŸ¿
206	SELECT * FROM `sV` WHERE `bP` LIKE '°±²³Žµ¶·ž¹º»ŒœŸ¿%';
207	bP
208	°±²³Žµ¶·ž¹º»ŒœŸ¿
209	SELECT * FROM `sV` WHERE `bP` LIKE '%°±²³Žµ¶·ž¹º»ŒœŸ¿%';
210	bP
211	°±²³Žµ¶·ž¹º»ŒœŸ¿
212	SELECT * FROM `sV` WHERE `bP` LIKE '%°±²³Žµ¶·ž¹º»ŒœŸ¿';
213	bP
214	°±²³Žµ¶·ž¹º»ŒœŸ¿
215	SELECT * FROM `sW` WHERE `bP` LIKE '@%';
216	bP
217	@@ABCDEFGHIJKLMNOPQR
218	SELECT * FROM `sW` WHERE `bP` LIKE '%@%';
219	bP
220	@@ABCDEFGHIJKLMNOPQR
221	EEðñòóôõö÷EEEEüEEEE@
222	SELECT * FROM `sW` WHERE `bP` LIKE '%@';
223	bP
224	EEðñòóôõö÷EEEEüEEEE@
225	SELECT * FROM `sW` WHERE `bP` LIKE 'Æ%';
226	bP
227	ÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙ
228	SELECT * FROM `sW` WHERE `bP` LIKE '% %';
229	bP
230	E ¡¢£€¥Š§š©ª«¬®¯°±
231	SELECT * FROM `sW` WHERE `bP` LIKE '%í';
232	bP
233	ÚÛÜÝÞßàáâãäåæçèéêëìí
234	SELECT * FROM `sW` WHERE `bP` LIKE 'E ¡¢£€¥Š§š©ª«¬®¯°±%';
235	bP
236	E ¡¢£€¥Š§š©ª«¬®¯°±
237	SELECT * FROM `sW` WHERE `bP` LIKE '%E ¡¢£€¥Š§š©ª«¬®¯°±%';
238	bP
239	E ¡¢£€¥Š§š©ª«¬®¯°±
240	SELECT * FROM `sW` WHERE `bP` LIKE '%E ¡¢£€¥Š§š©ª«¬®¯°±';
241	bP
242	E ¡¢£€¥Š§š©ª«¬®¯°±
243	SELECT * FROM `sX` WHERE `bP` LIKE '\%';
244	bP
245	\\\\\\\\\\\\\\\\\\\\
246	SELECT * FROM `sX` WHERE `bP` LIKE '%\%';
247	bP
248	\\\\\\\\\\\\\\\\\\\\
249	SELECT * FROM `sX` WHERE `bP` LIKE '%\';
250	bP
251	\\\\\\\\\\\\\\\\\\\\
252	SELECT * FROM `sX` WHERE `bP` LIKE '\\\\\\\\\\\\\\\\\\\\%';
253	bP
254	\\\\\\\\\\\\\\\\\\\\
255	SELECT * FROM `sX` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\%';
256	bP
257	\\\\\\\\\\\\\\\\\\\\
258	SELECT * FROM `sX` WHERE `bP` LIKE '%\\\\\\\\\\\\\\\\\\\\';
259	bP
260	\\\\\\\\\\\\\\\\\\\\
261	SELECT * FROM `sPO` WHERE `bP` LIKE ' %';
262	bP
263	!"#$%&'()*+,-./
264	¡¢£€¥Š§š©ª«¬®¯
265	SELECT * FROM `sPO` WHERE `bP` LIKE '% %';
266	bP
267	!"#$%&'()*+,-./
268	¡¢£€¥Š§š©ª«¬®¯
269	SELECT * FROM `sPO` WHERE `bP` LIKE '% ';
270	bP
271	SELECT * FROM `sPO` WHERE `bP` LIKE 'À%';
272	bP
273	ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ
274	SELECT * FROM `sPO` WHERE `bP` LIKE '%×Ø%';
275	bP
276	ÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß
277	SELECT * FROM `sPO` WHERE `bP` LIKE '%¿';
278	bP
279	°±²³Žµ¶·ž¹º»ŒœŸ¿
280	SELECT * FROM `sPO` WHERE `bP` LIKE '%°±²³Žµ¶·ž¹º»ŒœŸ¿';
281	bP
282	°±²³Žµ¶·ž¹º»ŒœŸ¿
283	SELECT * FROM `sPP` WHERE `bP` LIKE '@%';
284	bP
285	@@ABCDEFGHIJKLMNOPQR
286	SELECT * FROM `sPP` WHERE `bP` LIKE '%@%';
287	bP
288	@@ABCDEFGHIJKLMNOPQR
289	EEðñòóôõö÷EEEEüEEEE@
290	SELECT * FROM `sPP` WHERE `bP` LIKE '%@';
291	bP
292	EEðñòóôõö÷EEEEüEEEE@
293	SELECT * FROM `sPP` WHERE `bP` LIKE 'Æ%';
294	bP
295	ÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙ
296	SELECT * FROM `sPP` WHERE `bP` LIKE '% %';
297	bP
298	E ¡¢£€¥Š§š©ª«¬®¯°±
299	SELECT * FROM `sPP` WHERE `bP` LIKE '%í';
300	bP
301	ÚÛÜÝÞßàáâãäåæçèéêëìí
302	SELECT * FROM `sPQ` WHERE `bP` LIKE '\%';
303	bP
304	\\\\\\\\\\\\\\\\\\\\
305	SELECT * FROM `sPQ` WHERE `bP` LIKE '%\%';
306	bP
307	\\\\\\\\\\\\\\\\\\\\
308	SELECT * FROM `sPQ` WHERE `bP` LIKE '%\';
309	bP
310	\\\\\\\\\\\\\\\\\\\\
311	DROP TABLE `sP`;
312	DROP TABLE `sQ`;
313	DROP TABLE `sR`;
314	DROP TABLE `sS`;
315	DROP TABLE `sT`;
316	DROP TABLE `sU`;
317	DROP TABLE `sV`;
318	DROP TABLE `sW`;
319	DROP TABLE `sX`;
320	DROP TABLE `sPO`;
321	DROP TABLE `sPP`;
322	DROP TABLE `sPQ`;