| blob | 0990b30338c88b0d148840736e1549d18a2bf4cf |
1 DROP TABLE IF EXISTS t1;
2 DROP TABLE IF EXISTS t2;
3 DROP TABLE IF EXISTS t3;
4 DROP TABLE IF EXISTS t4;
5 SET NAMES sjis;
6 SET character_set_database = sjis;
7 CREATE TABLE t1(c1 char(3)) DEFAULT CHARSET = sjis ENGINE = InnoDB;
8 CREATE TABLE t2(c1 char(3)) DEFAULT CHARSET = sjis ENGINE = InnoDB;
9 CREATE TABLE t3(
10 `±` char(1),
11 `‚ ` char(1),
12 `•\` char(1)
13 )DEFAULT CHARSET = sjis ENGINE = InnoDB;
14 CREATE TABLE t4(c1 char(1)) DEFAULT CHARSET = sjis ENGINE = InnoDB;
15 INSERT INTO t1 VALUES ('xxx');
16 INSERT INTO t2 VALUES ('±‚ •\');
17 INSERT INTO t3 VALUES ('x','x','x'),('x','x','x'),('y','y','y'),('y','y','y'),('z','z','z'),('z','z','z');
18 INSERT INTO t4 VALUES ('±'),('‚ '),('•\');
19 PREPARE stmt1 FROM 'SELECT ? FROM t3';
20 PREPARE stmt2 FROM 'SELECT * FROM t3 ORDER BY ?';
21 PREPARE stmt3 FROM 'SELECT COUNT(*) FROM t3 GROUP BY ?';
22 PREPARE stmt4 FROM 'SELECT CHAR_LENGTH(?)';
23 PREPARE stmt5 FROM 'SELECT CHARSET(?)';
24 PREPARE stmt6 FROM 'SELECT INSERT(c1,1,1,?) FROM t1';
25 PREPARE stmt7 FROM 'SELECT INSTR(c1,?) FROM t2';
26 PREPARE stmt8 FROM 'SELECT LOCATE(?,c1) FROM t2';
27 PREPARE stmt9 FROM 'SELECT LPAD(c1,10,?) FROM t1';
28 PREPARE stmt10 FROM 'SELECT REPLACE(c1,?,\'x\') FROM t2';
29 PREPARE stmt11 FROM 'SELECT REPLACE(c1,\'x\',?) FROM t1';
30 PREPARE stmt12 FROM 'SELECT RPAD(c1,10,?) FROM t1';
31 PREPARE stmt13 FROM 'UPDATE t4 SET c1=\'x\' WHERE c1=?';
32 PREPARE stmt14 FROM 'UPDATE t4 SET c1=? WHERE c1=\'x\'';
33 SET @arg = '±';
34 EXECUTE stmt1 USING @arg;
35 ?
36 ±
37 ±
38 ±
39 ±
40 ±
41 ±
42 EXECUTE stmt2 USING @arg;
43 ± ‚ •\
44 x x x
45 x x x
46 y y y
47 y y y
48 z z z
49 z z z
50 EXECUTE stmt3 USING @arg;
51 COUNT(*)
52 6
53 EXECUTE stmt4 USING @arg;
54 CHAR_LENGTH(?)
55 1
56 EXECUTE stmt5 USING @arg;
57 CHARSET(?)
58 sjis
59 EXECUTE stmt6 USING @arg;
60 INSERT(c1,1,1,?)
61 ±xx
62 EXECUTE stmt7 USING @arg;
63 INSTR(c1,?)
64 1
65 EXECUTE stmt8 USING @arg;
66 LOCATE(?,c1)
67 1
68 EXECUTE stmt9 USING @arg;
69 LPAD(c1,10,?)
70 ±±±±±±±xxx
71 EXECUTE stmt10 USING @arg;
72 REPLACE(c1,?,'x')
73 x‚ •\
74 EXECUTE stmt11 USING @arg;
75 REPLACE(c1,'x',?)
76 ±±±
77 EXECUTE stmt12 USING @arg;
78 RPAD(c1,10,?)
79 xxx±±±±±±±
80 EXECUTE stmt13 USING @arg;
81 SELECT * FROM t4;
82 c1
83 x
84 ‚
85 •\
86 EXECUTE stmt14 USING @arg;
87 SELECT * FROM t4;
88 c1
89 ±
90 ‚
91 •\
92 SET @arg = '‚ ';
93 EXECUTE stmt1 USING @arg;
94 ?
95 ‚
96 ‚
97 ‚
98 ‚
99 ‚
100 ‚
101 EXECUTE stmt2 USING @arg;
102 ± ‚ •\
103 x x x
104 x x x
105 y y y
106 y y y
107 z z z
108 z z z
109 EXECUTE stmt3 USING @arg;
110 COUNT(*)
111 6
112 EXECUTE stmt4 USING @arg;
113 CHAR_LENGTH(?)
114 1
115 EXECUTE stmt5 USING @arg;
116 CHARSET(?)
117 sjis
118 EXECUTE stmt6 USING @arg;
119 INSERT(c1,1,1,?)
120 ‚ xx
121 EXECUTE stmt7 USING @arg;
122 INSTR(c1,?)
123 2
124 EXECUTE stmt8 USING @arg;
125 LOCATE(?,c1)
126 2
127 EXECUTE stmt9 USING @arg;
128 LPAD(c1,10,?)
129 ‚ ‚ ‚ ‚ ‚ ‚ ‚ xxx
130 EXECUTE stmt10 USING @arg;
131 REPLACE(c1,?,'x')
132 ±x•\
133 EXECUTE stmt11 USING @arg;
134 REPLACE(c1,'x',?)
135 ‚ ‚ ‚
136 EXECUTE stmt12 USING @arg;
137 RPAD(c1,10,?)
138 xxx‚ ‚ ‚ ‚ ‚ ‚ ‚
139 EXECUTE stmt13 USING @arg;
140 SELECT * FROM t4;
141 c1
142 ±
143 x
144 •\
145 EXECUTE stmt14 USING @arg;
146 SELECT * FROM t4;
147 c1
148 ±
149 ‚
150 •\
151 SET @arg = '•\';
152 EXECUTE stmt1 USING @arg;
153 ?
154 •\
155 •\
156 •\
157 •\
158 •\
159 •\
160 EXECUTE stmt2 USING @arg;
161 ± ‚ •\
162 x x x
163 x x x
164 y y y
165 y y y
166 z z z
167 z z z
168 EXECUTE stmt3 USING @arg;
169 COUNT(*)
170 6
171 EXECUTE stmt4 USING @arg;
172 CHAR_LENGTH(?)
173 1
174 EXECUTE stmt5 USING @arg;
175 CHARSET(?)
176 sjis
177 EXECUTE stmt6 USING @arg;
178 INSERT(c1,1,1,?)
179 •\xx
180 EXECUTE stmt7 USING @arg;
181 INSTR(c1,?)
182 3
183 EXECUTE stmt8 USING @arg;
184 LOCATE(?,c1)
185 3
186 EXECUTE stmt9 USING @arg;
187 LPAD(c1,10,?)
188 •\•\•\•\•\•\•\xxx
189 EXECUTE stmt10 USING @arg;
190 REPLACE(c1,?,'x')
191 ±‚ x
192 EXECUTE stmt11 USING @arg;
193 REPLACE(c1,'x',?)
194 •\•\•\
195 EXECUTE stmt12 USING @arg;
196 RPAD(c1,10,?)
197 xxx•\•\•\•\•\•\•\
198 EXECUTE stmt13 USING @arg;
199 SELECT * FROM t4;
200 c1
201 ±
202 ‚
203 x
204 EXECUTE stmt14 USING @arg;
205 SELECT * FROM t4;
206 c1
207 ±
208 ‚
209 •\
210 DEALLOCATE PREPARE stmt1;
211 DEALLOCATE PREPARE stmt2;
212 DEALLOCATE PREPARE stmt3;
213 DEALLOCATE PREPARE stmt4;
214 DEALLOCATE PREPARE stmt5;
215 DEALLOCATE PREPARE stmt6;
216 DEALLOCATE PREPARE stmt7;
217 DEALLOCATE PREPARE stmt8;
218 DEALLOCATE PREPARE stmt9;
219 DEALLOCATE PREPARE stmt10;
220 DEALLOCATE PREPARE stmt11;
221 DEALLOCATE PREPARE stmt12;
222 DEALLOCATE PREPARE stmt13;
223 DEALLOCATE PREPARE stmt14;
224 DROP TABLE t1;
225 DROP TABLE t2;
226 DROP TABLE t3;
227 DROP TABLE t4;
228 CREATE TABLE t1(c1 char(3)) DEFAULT CHARSET = sjis ENGINE = MyISAM;
229 CREATE TABLE t2(c1 char(3)) DEFAULT CHARSET = sjis ENGINE = MyISAM;
230 CREATE TABLE t3(
231 `±` char(1),
232 `‚ ` char(1),
233 `•\` char(1)
234 )DEFAULT CHARSET = sjis ENGINE = MyISAM;
235 CREATE TABLE t4(c1 char(1)) DEFAULT CHARSET = sjis ENGINE = MyISAM;
236 INSERT INTO t1 VALUES ('xxx');
237 INSERT INTO t2 VALUES ('±‚ •\');
238 INSERT INTO t3 VALUES ('x','x','x'),('x','x','x'),('y','y','y'),('y','y','y'),('z','z','z'),('z','z','z');
239 INSERT INTO t4 VALUES ('±'),('‚ '),('•\' );
240 PREPARE stmt1 FROM 'SELECT ? FROM t3';
241 PREPARE stmt2 FROM 'SELECT * FROM t3 ORDER BY ?';
242 PREPARE stmt3 FROM 'SELECT COUNT(*) FROM t3 GROUP BY ?';
243 PREPARE stmt4 FROM 'SELECT CHAR_LENGTH(?)';
244 PREPARE stmt5 FROM 'SELECT CHARSET(?)';
245 PREPARE stmt6 FROM 'SELECT INSERT(c1,1,1,?) FROM t1';
246 PREPARE stmt7 FROM 'SELECT INSTR(c1,?) FROM t2';
247 PREPARE stmt8 FROM 'SELECT LOCATE(?,c1) FROM t2';
248 PREPARE stmt9 FROM 'SELECT LPAD(c1,10,?) FROM t1';
249 PREPARE stmt10 FROM 'SELECT REPLACE(c1,?,\'x\') FROM t2';
250 PREPARE stmt11 FROM 'SELECT REPLACE(c1,\'x\',?) FROM t1';
251 PREPARE stmt12 FROM 'SELECT RPAD(c1,10,?) FROM t1';
252 PREPARE stmt13 FROM 'UPDATE t4 SET c1=\'x\' WHERE c1=?';
253 PREPARE stmt14 FROM 'UPDATE t4 SET c1=? WHERE c1=\'x\'';
254 SET @arg = '±';
255 EXECUTE stmt1 USING @arg;
256 ?
257 ±
258 ±
259 ±
260 ±
261 ±
262 ±
263 EXECUTE stmt2 USING @arg;
264 ± ‚ •\
265 x x x
266 x x x
267 y y y
268 y y y
269 z z z
270 z z z
271 EXECUTE stmt3 USING @arg;
272 COUNT(*)
273 6
274 EXECUTE stmt4 USING @arg;
275 CHAR_LENGTH(?)
276 1
277 EXECUTE stmt5 USING @arg;
278 CHARSET(?)
279 sjis
280 EXECUTE stmt6 USING @arg;
281 INSERT(c1,1,1,?)
282 ±xx
283 EXECUTE stmt7 USING @arg;
284 INSTR(c1,?)
285 1
286 EXECUTE stmt8 USING @arg;
287 LOCATE(?,c1)
288 1
289 EXECUTE stmt9 USING @arg;
290 LPAD(c1,10,?)
291 ±±±±±±±xxx
292 EXECUTE stmt10 USING @arg;
293 REPLACE(c1,?,'x')
294 x‚ •\
295 EXECUTE stmt11 USING @arg;
296 REPLACE(c1,'x',?)
297 ±±±
298 EXECUTE stmt12 USING @arg;
299 RPAD(c1,10,?)
300 xxx±±±±±±±
301 EXECUTE stmt13 USING @arg;
302 SELECT * FROM t4;
303 c1
304 x
305 ‚
306 •\
307 EXECUTE stmt14 USING @arg;
308 SELECT * FROM t4;
309 c1
310 ±
311 ‚
312 •\
313 SET @arg = '‚ ';
314 EXECUTE stmt1 USING @arg;
315 ?
316 ‚
317 ‚
318 ‚
319 ‚
320 ‚
321 ‚
322 EXECUTE stmt2 USING @arg;
323 ± ‚ •\
324 x x x
325 x x x
326 y y y
327 y y y
328 z z z
329 z z z
330 EXECUTE stmt3 USING @arg;
331 COUNT(*)
332 6
333 EXECUTE stmt4 USING @arg;
334 CHAR_LENGTH(?)
335 1
336 EXECUTE stmt5 USING @arg;
337 CHARSET(?)
338 sjis
339 EXECUTE stmt6 USING @arg;
340 INSERT(c1,1,1,?)
341 ‚ xx
342 EXECUTE stmt7 USING @arg;
343 INSTR(c1,?)
344 2
345 EXECUTE stmt8 USING @arg;
346 LOCATE(?,c1)
347 2
348 EXECUTE stmt9 USING @arg;
349 LPAD(c1,10,?)
350 ‚ ‚ ‚ ‚ ‚ ‚ ‚ xxx
351 EXECUTE stmt10 USING @arg;
352 REPLACE(c1,?,'x')
353 ±x•\
354 EXECUTE stmt11 USING @arg;
355 REPLACE(c1,'x',?)
356 ‚ ‚ ‚
357 EXECUTE stmt12 USING @arg;
358 RPAD(c1,10,?)
359 xxx‚ ‚ ‚ ‚ ‚ ‚ ‚
360 EXECUTE stmt13 USING @arg;
361 SELECT * FROM t4;
362 c1
363 ±
364 x
365 •\
366 EXECUTE stmt14 USING @arg;
367 SELECT * FROM t4;
368 c1
369 ±
370 ‚
371 •\
372 SET @arg = '•\';
373 EXECUTE stmt1 USING @arg;
374 ?
375 •\
376 •\
377 •\
378 •\
379 •\
380 •\
381 EXECUTE stmt2 USING @arg;
382 ± ‚ •\
383 x x x
384 x x x
385 y y y
386 y y y
387 z z z
388 z z z
389 EXECUTE stmt3 USING @arg;
390 COUNT(*)
391 6
392 EXECUTE stmt4 USING @arg;
393 CHAR_LENGTH(?)
394 1
395 EXECUTE stmt5 USING @arg;
396 CHARSET(?)
397 sjis
398 EXECUTE stmt6 USING @arg;
399 INSERT(c1,1,1,?)
400 •\xx
401 EXECUTE stmt7 USING @arg;
402 INSTR(c1,?)
403 3
404 EXECUTE stmt8 USING @arg;
405 LOCATE(?,c1)
406 3
407 EXECUTE stmt9 USING @arg;
408 LPAD(c1,10,?)
409 •\•\•\•\•\•\•\xxx
410 EXECUTE stmt10 USING @arg;
411 REPLACE(c1,?,'x')
412 ±‚ x
413 EXECUTE stmt11 USING @arg;
414 REPLACE(c1,'x',?)
415 •\•\•\
416 EXECUTE stmt12 USING @arg;
417 RPAD(c1,10,?)
418 xxx•\•\•\•\•\•\•\
419 EXECUTE stmt13 USING @arg;
420 SELECT * FROM t4;
421 c1
422 ±
423 ‚
424 x
425 EXECUTE stmt14 USING @arg;
426 SELECT * FROM t4;
427 c1
428 ±
429 ‚
430 •\
431 DEALLOCATE PREPARE stmt1;
432 DEALLOCATE PREPARE stmt2;
433 DEALLOCATE PREPARE stmt3;
434 DEALLOCATE PREPARE stmt4;
435 DEALLOCATE PREPARE stmt5;
436 DEALLOCATE PREPARE stmt6;
437 DEALLOCATE PREPARE stmt7;
438 DEALLOCATE PREPARE stmt8;
439 DEALLOCATE PREPARE stmt9;
440 DEALLOCATE PREPARE stmt10;
441 DEALLOCATE PREPARE stmt11;
442 DEALLOCATE PREPARE stmt12;
443 DEALLOCATE PREPARE stmt13;
444 DEALLOCATE PREPARE stmt14;
445 DROP TABLE t1;
446 DROP TABLE t2;
447 DROP TABLE t3;
448 DROP TABLE t4;
449 CREATE TABLE t1(c1 char(3)) DEFAULT CHARSET = sjis ENGINE = MEMORY;
450 CREATE TABLE t2(c1 char(3)) DEFAULT CHARSET = sjis ENGINE = MEMORY;
451 CREATE TABLE t3(
452 `±` char(1),
453 `‚ ` char(1),
454 `•\` char(1)
455 )DEFAULT CHARSET = sjis ENGINE = MEMORY;
456 CREATE TABLE t4(c1 char(1)) DEFAULT CHARSET = sjis ENGINE =MEMORY;
457 INSERT INTO t1 VALUES ('xxx');
458 INSERT INTO t2 VALUES ('±‚ •\');
459 INSERT INTO t3 VALUES ('x','x','x'),('x','x','x'),('y','y','y'),('y','y','y'),('z','z','z'),('z','z','z');
460 INSERT INTO t4 VALUES ('±'),('‚ '),('•\' );
461 PREPARE stmt1 FROM 'SELECT ? FROM t3';
462 PREPARE stmt2 FROM 'SELECT * FROM t3 ORDER BY ?';
463 PREPARE stmt3 FROM 'SELECT COUNT(*) FROM t3 GROUP BY ?';
464 PREPARE stmt4 FROM 'SELECT CHAR_LENGTH(?)';
465 PREPARE stmt5 FROM 'SELECT CHARSET(?)';
466 PREPARE stmt6 FROM 'SELECT INSERT(c1,1,1,?) FROM t1';
467 PREPARE stmt7 FROM 'SELECT INSTR(c1,?) FROM t2';
468 PREPARE stmt8 FROM 'SELECT LOCATE(?,c1) FROM t2';
469 PREPARE stmt9 FROM 'SELECT LPAD(c1,10,?) FROM t1';
470 PREPARE stmt10 FROM 'SELECT REPLACE(c1,?,\'x\') FROM t2';
471 PREPARE stmt11 FROM 'SELECT REPLACE(c1,\'x\',?) FROM t1';
472 PREPARE stmt12 FROM 'SELECT RPAD(c1,10,?) FROM t1';
473 PREPARE stmt13 FROM 'UPDATE t4 SET c1=\'x\' WHERE c1=?';
474 PREPARE stmt14 FROM 'UPDATE t4 SET c1=? WHERE c1=\'x\'';
475 SET @arg = '±';
476 EXECUTE stmt1 USING @arg;
477 ?
478 ±
479 ±
480 ±
481 ±
482 ±
483 ±
484 EXECUTE stmt2 USING @arg;
485 ± ‚ •\
486 x x x
487 x x x
488 y y y
489 y y y
490 z z z
491 z z z
492 EXECUTE stmt3 USING @arg;
493 COUNT(*)
494 6
495 EXECUTE stmt4 USING @arg;
496 CHAR_LENGTH(?)
497 1
498 EXECUTE stmt5 USING @arg;
499 CHARSET(?)
500 sjis
501 EXECUTE stmt6 USING @arg;
502 INSERT(c1,1,1,?)
503 ±xx
504 EXECUTE stmt7 USING @arg;
505 INSTR(c1,?)
506 1
507 EXECUTE stmt8 USING @arg;
508 LOCATE(?,c1)
509 1
510 EXECUTE stmt9 USING @arg;
511 LPAD(c1,10,?)
512 ±±±±±±±xxx
513 EXECUTE stmt10 USING @arg;
514 REPLACE(c1,?,'x')
515 x‚ •\
516 EXECUTE stmt11 USING @arg;
517 REPLACE(c1,'x',?)
518 ±±±
519 EXECUTE stmt12 USING @arg;
520 RPAD(c1,10,?)
521 xxx±±±±±±±
522 EXECUTE stmt13 USING @arg;
523 SELECT * FROM t4;
524 c1
525 x
526 ‚
527 •\
528 EXECUTE stmt14 USING @arg;
529 SELECT * FROM t4;
530 c1
531 ±
532 ‚
533 •\
534 SET @arg = '‚ ';
535 EXECUTE stmt1 USING @arg;
536 ?
537 ‚
538 ‚
539 ‚
540 ‚
541 ‚
542 ‚
543 EXECUTE stmt2 USING @arg;
544 ± ‚ •\
545 x x x
546 x x x
547 y y y
548 y y y
549 z z z
550 z z z
551 EXECUTE stmt3 USING @arg;
552 COUNT(*)
553 6
554 EXECUTE stmt4 USING @arg;
555 CHAR_LENGTH(?)
556 1
557 EXECUTE stmt5 USING @arg;
558 CHARSET(?)
559 sjis
560 EXECUTE stmt6 USING @arg;
561 INSERT(c1,1,1,?)
562 ‚ xx
563 EXECUTE stmt7 USING @arg;
564 INSTR(c1,?)
565 2
566 EXECUTE stmt8 USING @arg;
567 LOCATE(?,c1)
568 2
569 EXECUTE stmt9 USING @arg;
570 LPAD(c1,10,?)
571 ‚ ‚ ‚ ‚ ‚ ‚ ‚ xxx
572 EXECUTE stmt10 USING @arg;
573 REPLACE(c1,?,'x')
574 ±x•\
575 EXECUTE stmt11 USING @arg;
576 REPLACE(c1,'x',?)
577 ‚ ‚ ‚
578 EXECUTE stmt12 USING @arg;
579 RPAD(c1,10,?)
580 xxx‚ ‚ ‚ ‚ ‚ ‚ ‚
581 EXECUTE stmt13 USING @arg;
582 SELECT * FROM t4;
583 c1
584 ±
585 x
586 •\
587 EXECUTE stmt14 USING @arg;
588 SELECT * FROM t4;
589 c1
590 ±
591 ‚
592 •\
593 SET @arg = '•\';
594 EXECUTE stmt1 USING @arg;
595 ?
596 •\
597 •\
598 •\
599 •\
600 •\
601 •\
602 EXECUTE stmt2 USING @arg;
603 ± ‚ •\
604 x x x
605 x x x
606 y y y
607 y y y
608 z z z
609 z z z
610 EXECUTE stmt3 USING @arg;
611 COUNT(*)
612 6
613 EXECUTE stmt4 USING @arg;
614 CHAR_LENGTH(?)
615 1
616 EXECUTE stmt5 USING @arg;
617 CHARSET(?)
618 sjis
619 EXECUTE stmt6 USING @arg;
620 INSERT(c1,1,1,?)
621 •\xx
622 EXECUTE stmt7 USING @arg;
623 INSTR(c1,?)
624 3
625 EXECUTE stmt8 USING @arg;
626 LOCATE(?,c1)
627 3
628 EXECUTE stmt9 USING @arg;
629 LPAD(c1,10,?)
630 •\•\•\•\•\•\•\xxx
631 EXECUTE stmt10 USING @arg;
632 REPLACE(c1,?,'x')
633 ±‚ x
634 EXECUTE stmt11 USING @arg;
635 REPLACE(c1,'x',?)
636 •\•\•\
637 EXECUTE stmt12 USING @arg;
638 RPAD(c1,10,?)
639 xxx•\•\•\•\•\•\•\
640 EXECUTE stmt13 USING @arg;
641 SELECT * FROM t4;
642 c1
643 ±
644 ‚
645 x
646 EXECUTE stmt14 USING @arg;
647 SELECT * FROM t4;
648 c1
649 ±
650 ‚
651 •\
652 DEALLOCATE PREPARE stmt1;
653 DEALLOCATE PREPARE stmt2;
654 DEALLOCATE PREPARE stmt3;
655 DEALLOCATE PREPARE stmt4;
656 DEALLOCATE PREPARE stmt5;
657 DEALLOCATE PREPARE stmt6;
658 DEALLOCATE PREPARE stmt7;
659 DEALLOCATE PREPARE stmt8;
660 DEALLOCATE PREPARE stmt9;
661 DEALLOCATE PREPARE stmt10;
662 DEALLOCATE PREPARE stmt11;
663 DEALLOCATE PREPARE stmt12;
664 DEALLOCATE PREPARE stmt13;
665 DEALLOCATE PREPARE stmt14;
666 DROP TABLE t1;
667 DROP TABLE t2;
668 DROP TABLE t3;
669 DROP TABLE t4;