449
CREATE TABLE t1(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = HEAP;
450
CREATE TABLE t2(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = HEAP;
455
)DEFAULT CHARSET = ujis ENGINE = HEAP;
456
CREATE TABLE t4(c1 char(1)) DEFAULT CHARSET = ujis ENGINE =HEAP;
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,9,?) 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,9,?) FROM t1';
473
PREPARE stmt13 FROM 'UPDATE t4 SET c1=\'x\' WHERE c1=?';
474
PREPARE stmt14 FROM 'UPDATE t4 SET c1=? WHERE c1=\'x\'';
476
EXECUTE stmt1 USING @arg;
484
EXECUTE stmt2 USING @arg;
492
EXECUTE stmt3 USING @arg;
495
EXECUTE stmt4 USING @arg;
498
EXECUTE stmt5 USING @arg;
501
EXECUTE stmt6 USING @arg;
504
EXECUTE stmt7 USING @arg;
507
EXECUTE stmt8 USING @arg;
510
EXECUTE stmt9 USING @arg;
513
EXECUTE stmt10 USING @arg;
516
EXECUTE stmt11 USING @arg;
519
EXECUTE stmt12 USING @arg;
522
EXECUTE stmt13 USING @arg;
528
EXECUTE stmt14 USING @arg;
535
EXECUTE stmt1 USING @arg;
543
EXECUTE stmt2 USING @arg;
551
EXECUTE stmt3 USING @arg;
554
EXECUTE stmt4 USING @arg;
557
EXECUTE stmt5 USING @arg;
560
EXECUTE stmt6 USING @arg;
563
EXECUTE stmt7 USING @arg;
566
EXECUTE stmt8 USING @arg;
569
EXECUTE stmt9 USING @arg;
572
EXECUTE stmt10 USING @arg;
575
EXECUTE stmt11 USING @arg;
578
EXECUTE stmt12 USING @arg;
581
EXECUTE stmt13 USING @arg;
587
EXECUTE stmt14 USING @arg;
594
EXECUTE stmt1 USING @arg;
602
EXECUTE stmt2 USING @arg;
610
EXECUTE stmt3 USING @arg;
613
EXECUTE stmt4 USING @arg;
616
EXECUTE stmt5 USING @arg;
619
EXECUTE stmt6 USING @arg;
622
EXECUTE stmt7 USING @arg;
625
EXECUTE stmt8 USING @arg;
628
EXECUTE stmt9 USING @arg;
631
EXECUTE stmt10 USING @arg;
634
EXECUTE stmt11 USING @arg;
637
EXECUTE stmt12 USING @arg;
640
EXECUTE stmt13 USING @arg;
646
EXECUTE stmt14 USING @arg;
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;
670
CREATE TABLE t1(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = BDB;
671
CREATE TABLE t2(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = BDB;
676
)DEFAULT CHARSET = ujis ENGINE = BDB;
677
CREATE TABLE t4(c1 char(1)) DEFAULT CHARSET = ujis ENGINE = BDB;
678
INSERT INTO t1 VALUES ('xxx');
679
INSERT INTO t2 VALUES ('�������');
680
INSERT INTO t3 VALUES ('x','x','x'),('x','x','x'),('y','y','y'),('y','y','y'),('z','z','z'),('z','z','z');
681
INSERT INTO t4 VALUES ('��'),('��'),('���' );
682
PREPARE stmt1 FROM 'SELECT ? FROM t3';
683
PREPARE stmt2 FROM 'SELECT * FROM t3 ORDER BY ?';
684
PREPARE stmt3 FROM 'SELECT COUNT(*) FROM t3 GROUP BY ?';
685
PREPARE stmt4 FROM 'SELECT CHAR_LENGTH(?)';
686
PREPARE stmt5 FROM 'SELECT CHARSET(?)';
687
PREPARE stmt6 FROM 'SELECT INSERT(c1,1,1,?) FROM t1';
688
PREPARE stmt7 FROM 'SELECT INSTR(c1,?) FROM t2';
689
PREPARE stmt8 FROM 'SELECT LOCATE(?,c1) FROM t2';
690
PREPARE stmt9 FROM 'SELECT LPAD(c1,9,?) FROM t1';
691
PREPARE stmt10 FROM 'SELECT REPLACE(c1,?,\'x\') FROM t2';
692
PREPARE stmt11 FROM 'SELECT REPLACE(c1,\'x\',?) FROM t1';
693
PREPARE stmt12 FROM 'SELECT RPAD(c1,9,?) FROM t1';
694
PREPARE stmt13 FROM 'UPDATE t4 SET c1=\'x\' WHERE c1=?';
695
PREPARE stmt14 FROM 'UPDATE t4 SET c1=? WHERE c1=\'x\'';
697
EXECUTE stmt1 USING @arg;
705
EXECUTE stmt2 USING @arg;
713
EXECUTE stmt3 USING @arg;
716
EXECUTE stmt4 USING @arg;
719
EXECUTE stmt5 USING @arg;
722
EXECUTE stmt6 USING @arg;
725
EXECUTE stmt7 USING @arg;
728
EXECUTE stmt8 USING @arg;
731
EXECUTE stmt9 USING @arg;
734
EXECUTE stmt10 USING @arg;
737
EXECUTE stmt11 USING @arg;
740
EXECUTE stmt12 USING @arg;
743
EXECUTE stmt13 USING @arg;
752
EXECUTE stmt14 USING @arg;
449
CREATE TABLE t1(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = MEMORY;
450
CREATE TABLE t2(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = MEMORY;
455
)DEFAULT CHARSET = ujis ENGINE = MEMORY;
456
CREATE TABLE t4(c1 char(1)) DEFAULT CHARSET = ujis 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,9,?) 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,9,?) FROM t1';
473
PREPARE stmt13 FROM 'UPDATE t4 SET c1=\'x\' WHERE c1=?';
474
PREPARE stmt14 FROM 'UPDATE t4 SET c1=? WHERE c1=\'x\'';
476
EXECUTE stmt1 USING @arg;
484
EXECUTE stmt2 USING @arg;
492
EXECUTE stmt3 USING @arg;
495
EXECUTE stmt4 USING @arg;
498
EXECUTE stmt5 USING @arg;
501
EXECUTE stmt6 USING @arg;
504
EXECUTE stmt7 USING @arg;
507
EXECUTE stmt8 USING @arg;
510
EXECUTE stmt9 USING @arg;
513
EXECUTE stmt10 USING @arg;
516
EXECUTE stmt11 USING @arg;
519
EXECUTE stmt12 USING @arg;
522
EXECUTE stmt13 USING @arg;
528
EXECUTE stmt14 USING @arg;
762
535
EXECUTE stmt1 USING @arg;