~drizzle-trunk/drizzle/development : revision 1

mysql-test/suite/jp/r/jp_ps_ujis.result

DROP TABLE IF EXISTS t1;

DROP TABLE IF EXISTS t2;

DROP TABLE IF EXISTS t3;

DROP TABLE IF EXISTS t4;

SET NAMES ujis;

SET character_set_database = ujis;

CREATE TABLE t1(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = InnoDB;

CREATE TABLE t2(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = InnoDB;

CREATE TABLE t3(

`��` char(1),

`��` char(1)

)DEFAULT CHARSET = ujis ENGINE = InnoDB;

CREATE TABLE t4(c1 char(1)) DEFAULT CHARSET = ujis ENGINE = InnoDB;

INSERT INTO t1 VALUES ('xxx');

INSERT INTO t2 VALUES ('��');

INSERT INTO t3 VALUES ('x','x','x'),('x','x','x'),('y','y','y'),('y','y','y'),('z','z','z'),('z','z','z');

INSERT INTO t4 VALUES ('��'),('��'),('��');

PREPARE stmt1 FROM 'SELECT ? FROM t3';

PREPARE stmt2 FROM 'SELECT * FROM t3 ORDER BY ?';

PREPARE stmt3 FROM 'SELECT COUNT(*) FROM t3 GROUP BY ?';

PREPARE stmt4 FROM 'SELECT CHAR_LENGTH(?)';

PREPARE stmt5 FROM 'SELECT CHARSET(?)';

PREPARE stmt6 FROM 'SELECT INSERT(c1,1,1,?) FROM t1';

PREPARE stmt7 FROM 'SELECT INSTR(c1,?) FROM t2';

PREPARE stmt8 FROM 'SELECT LOCATE(?,c1) FROM t2';

PREPARE stmt9 FROM 'SELECT LPAD(c1,9,?) FROM t1';

PREPARE stmt10 FROM 'SELECT REPLACE(c1,?,\'x\') FROM t2';

PREPARE stmt11 FROM 'SELECT REPLACE(c1,\'x\',?) FROM t1';

PREPARE stmt12 FROM 'SELECT RPAD(c1,9,?) FROM t1';

PREPARE stmt13 FROM 'UPDATE t4 SET c1=\'x\' WHERE c1=?';

PREPARE stmt14 FROM 'UPDATE t4 SET c1=? WHERE c1=\'x\'';

SET @arg = '��';

EXECUTE stmt1 USING @arg;

��

EXECUTE stmt2 USING @arg;

��

x x x

y y y

z z z

EXECUTE stmt3 USING @arg;

COUNT(*)

EXECUTE stmt4 USING @arg;

CHAR_LENGTH(?)

EXECUTE stmt5 USING @arg;

CHARSET(?)

ujis

EXECUTE stmt6 USING @arg;

INSERT(c1,1,1,?)

��xx

EXECUTE stmt7 USING @arg;

INSTR(c1,?)

EXECUTE stmt8 USING @arg;

LOCATE(?,c1)

EXECUTE stmt9 USING @arg;

LPAD(c1,9,?)

��xxx

EXECUTE stmt10 USING @arg;

REPLACE(c1,?,'x')

x��

EXECUTE stmt11 USING @arg;

REPLACE(c1,'x',?)

��

EXECUTE stmt12 USING @arg;

RPAD(c1,9,?)

xxx��

EXECUTE stmt13 USING @arg;

SELECT * FROM t4;

��

EXECUTE stmt14 USING @arg;

SELECT * FROM t4;

��

SET @arg = '��';

EXECUTE stmt1 USING @arg;

��

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

112

EXECUTE stmt4 USING @arg;

113

CHAR_LENGTH(?)

114

115

EXECUTE stmt5 USING @arg;

116

CHARSET(?)

117

ujis

118

EXECUTE stmt6 USING @arg;

119

INSERT(c1,1,1,?)

120

��xx

121

EXECUTE stmt7 USING @arg;

122

INSTR(c1,?)

123

124

EXECUTE stmt8 USING @arg;

125

LOCATE(?,c1)

126

127

EXECUTE stmt9 USING @arg;

128

LPAD(c1,9,?)

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,9,?)

138

xxx��

139

EXECUTE stmt13 USING @arg;

140

SELECT * FROM t4;

141

142

��

143

144

��

145

EXECUTE stmt14 USING @arg;

146

SELECT * FROM t4;

147

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

171

EXECUTE stmt4 USING @arg;

172

CHAR_LENGTH(?)

173

174

EXECUTE stmt5 USING @arg;

175

CHARSET(?)

176

ujis

177

EXECUTE stmt6 USING @arg;

178

INSERT(c1,1,1,?)

179

��xx

180

EXECUTE stmt7 USING @arg;

181

INSTR(c1,?)

182

183

EXECUTE stmt8 USING @arg;

184

LOCATE(?,c1)

185

186

EXECUTE stmt9 USING @arg;

187

LPAD(c1,9,?)

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,9,?)

197

xxx��܏�܏�܏�܏�܏��

198

EXECUTE stmt13 USING @arg;

199

SELECT * FROM t4;

200

201

��

202

��

203

204

EXECUTE stmt14 USING @arg;

205

SELECT * FROM t4;

206

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 = ujis ENGINE = MyISAM;

229

CREATE TABLE t2(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = MyISAM;

230

CREATE TABLE t3(

231

`��` char(1),

232

`��` char(1),

233

`��` char(1)

234

)DEFAULT CHARSET = ujis ENGINE = MyISAM;

235

CREATE TABLE t4(c1 char(1)) DEFAULT CHARSET = ujis 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,9,?) 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,9,?) 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

274

EXECUTE stmt4 USING @arg;

275

CHAR_LENGTH(?)

276

277

EXECUTE stmt5 USING @arg;

278

CHARSET(?)

279

ujis

280

EXECUTE stmt6 USING @arg;

281

INSERT(c1,1,1,?)

282

��xx

283

EXECUTE stmt7 USING @arg;

284

INSTR(c1,?)

285

286

EXECUTE stmt8 USING @arg;

287

LOCATE(?,c1)

288

289

EXECUTE stmt9 USING @arg;

290

LPAD(c1,9,?)

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,9,?)

300

xxx��

301

EXECUTE stmt13 USING @arg;

302

SELECT * FROM t4;

303

304

305

��

306

��

307

EXECUTE stmt14 USING @arg;

308

SELECT * FROM t4;

309

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

333

EXECUTE stmt4 USING @arg;

334

CHAR_LENGTH(?)

335

336

EXECUTE stmt5 USING @arg;

337

CHARSET(?)

338

ujis

339

EXECUTE stmt6 USING @arg;

340

INSERT(c1,1,1,?)

341

��xx

342

EXECUTE stmt7 USING @arg;

343

INSTR(c1,?)

344

345

EXECUTE stmt8 USING @arg;

346

LOCATE(?,c1)

347

348

EXECUTE stmt9 USING @arg;

349

LPAD(c1,9,?)

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,9,?)

359

xxx��

360

EXECUTE stmt13 USING @arg;

361

SELECT * FROM t4;

362

363

��

364

365

��

366

EXECUTE stmt14 USING @arg;

367

SELECT * FROM t4;

368

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

392

EXECUTE stmt4 USING @arg;

393

CHAR_LENGTH(?)

394

395

EXECUTE stmt5 USING @arg;

396

CHARSET(?)

397

ujis

398

EXECUTE stmt6 USING @arg;

399

INSERT(c1,1,1,?)

400

��xx

401

EXECUTE stmt7 USING @arg;

402

INSTR(c1,?)

403

404

EXECUTE stmt8 USING @arg;

405

LOCATE(?,c1)

406

407

EXECUTE stmt9 USING @arg;

408

LPAD(c1,9,?)

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,9,?)

418

xxx��܏�܏�܏�܏�܏��

419

EXECUTE stmt13 USING @arg;

420

SELECT * FROM t4;

421

422

��

423

��

424

425

EXECUTE stmt14 USING @arg;

426

SELECT * FROM t4;

427

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 = ujis ENGINE = HEAP;

450

CREATE TABLE t2(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = HEAP;

451

CREATE TABLE t3(

452

`��` char(1),

453

`��` char(1),

454

`��` char(1)

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\'';

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

495

EXECUTE stmt4 USING @arg;

496

CHAR_LENGTH(?)

497

498

EXECUTE stmt5 USING @arg;

499

CHARSET(?)

500

ujis

501

EXECUTE stmt6 USING @arg;

502

INSERT(c1,1,1,?)

503

��xx

504

EXECUTE stmt7 USING @arg;

505

INSTR(c1,?)

506

507

EXECUTE stmt8 USING @arg;

508

LOCATE(?,c1)

509

510

EXECUTE stmt9 USING @arg;

511

LPAD(c1,9,?)

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,9,?)

521

xxx��

522

EXECUTE stmt13 USING @arg;

523

SELECT * FROM t4;

524

525

526

��

527

��

528

EXECUTE stmt14 USING @arg;

529

SELECT * FROM t4;

530

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

554

EXECUTE stmt4 USING @arg;

555

CHAR_LENGTH(?)

556

557

EXECUTE stmt5 USING @arg;

558

CHARSET(?)

559

ujis

560

EXECUTE stmt6 USING @arg;

561

INSERT(c1,1,1,?)

562

��xx

563

EXECUTE stmt7 USING @arg;

564

INSTR(c1,?)

565

566

EXECUTE stmt8 USING @arg;

567

LOCATE(?,c1)

568

569

EXECUTE stmt9 USING @arg;

570

LPAD(c1,9,?)

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,9,?)

580

xxx��

581

EXECUTE stmt13 USING @arg;

582

SELECT * FROM t4;

583

584

��

585

586

��

587

EXECUTE stmt14 USING @arg;

588

SELECT * FROM t4;

589

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

613

EXECUTE stmt4 USING @arg;

614

CHAR_LENGTH(?)

615

616

EXECUTE stmt5 USING @arg;

617

CHARSET(?)

618

ujis

619

EXECUTE stmt6 USING @arg;

620

INSERT(c1,1,1,?)

621

��xx

622

EXECUTE stmt7 USING @arg;

623

INSTR(c1,?)

624

625

EXECUTE stmt8 USING @arg;

626

LOCATE(?,c1)

627

628

EXECUTE stmt9 USING @arg;

629

LPAD(c1,9,?)

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,9,?)

639

xxx��܏�܏�܏�܏�܏��

640

EXECUTE stmt13 USING @arg;

641

SELECT * FROM t4;

642

643

��

644

��

645

646

EXECUTE stmt14 USING @arg;

647

SELECT * FROM t4;

648

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;

670

CREATE TABLE t1(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = BDB;

671

CREATE TABLE t2(c1 char(3)) DEFAULT CHARSET = ujis ENGINE = BDB;

672

CREATE TABLE t3(

673

`��` char(1),

674

`��` char(1),

675

`��` char(1)

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\'';

696

SET @arg = '��';

697

EXECUTE stmt1 USING @arg;

698

699

��

700

��

701

��

702

��

703

��

704

��

705

EXECUTE stmt2 USING @arg;

706

��

707

x x x

708

x x x

709

y y y

710

y y y

711

z z z

712

z z z

713

EXECUTE stmt3 USING @arg;

714

COUNT(*)

715

716

EXECUTE stmt4 USING @arg;

717

CHAR_LENGTH(?)

718

719

EXECUTE stmt5 USING @arg;

720

CHARSET(?)

721

ujis

722

EXECUTE stmt6 USING @arg;

723

INSERT(c1,1,1,?)

724

��xx

725

EXECUTE stmt7 USING @arg;

726

INSTR(c1,?)

727

728

EXECUTE stmt8 USING @arg;

729

LOCATE(?,c1)

730

731

EXECUTE stmt9 USING @arg;

732

LPAD(c1,9,?)

733

��xxx

734

EXECUTE stmt10 USING @arg;

735

REPLACE(c1,?,'x')

736

x��

737

EXECUTE stmt11 USING @arg;

738

REPLACE(c1,'x',?)

739

��

740

EXECUTE stmt12 USING @arg;

741

RPAD(c1,9,?)

742

xxx��

743

EXECUTE stmt13 USING @arg;

744

SELECT * FROM t3;

745

��

746

x x x

747

x x x

748

y y y

749

y y y

750

z z z

751

z z z

752

EXECUTE stmt14 USING @arg;

753

SELECT * FROM t3;

754

��

755

x x x

756

x x x

757

y y y

758

y y y

759

z z z

760

z z z

761

SET @arg = '��';

762

EXECUTE stmt1 USING @arg;

763

764

��

765

��

766

��

767

��

768

��

769

��

770

EXECUTE stmt2 USING @arg;

771

��

772

x x x

773

x x x

774

y y y

775

y y y

776

z z z

777

z z z

778

EXECUTE stmt3 USING @arg;

779

COUNT(*)

780

781

EXECUTE stmt4 USING @arg;

782

CHAR_LENGTH(?)

783

784

EXECUTE stmt5 USING @arg;

785

CHARSET(?)

786

ujis

787

EXECUTE stmt6 USING @arg;

788

INSERT(c1,1,1,?)

789

��xx

790

EXECUTE stmt7 USING @arg;

791

INSTR(c1,?)

792

793

EXECUTE stmt8 USING @arg;

794

LOCATE(?,c1)

795

796

EXECUTE stmt9 USING @arg;

797

LPAD(c1,9,?)

798

��xxx

799

EXECUTE stmt10 USING @arg;

800

REPLACE(c1,?,'x')

801

��x��

802

EXECUTE stmt11 USING @arg;

803

REPLACE(c1,'x',?)

804

��

805

EXECUTE stmt12 USING @arg;

806

RPAD(c1,9,?)

807

xxx��

808

EXECUTE stmt13 USING @arg;

809

SELECT * FROM t4;

810

811

��

812

813

��

814

EXECUTE stmt14 USING @arg;

815

SELECT * FROM t4;

816

817

��

818

��

819

��

820

SET @arg = '��';

821

EXECUTE stmt1 USING @arg;

822

823

��

824

��

825

��

826

��

827

��

828

��

829

EXECUTE stmt2 USING @arg;

830

��

831

x x x

832

x x x

833

y y y

834

y y y

835

z z z

836

z z z

837

EXECUTE stmt3 USING @arg;

838

COUNT(*)

839

840

EXECUTE stmt4 USING @arg;

841

CHAR_LENGTH(?)

842

843

EXECUTE stmt5 USING @arg;

844

CHARSET(?)

845

ujis

846

EXECUTE stmt6 USING @arg;

847

INSERT(c1,1,1,?)

848

��xx

849

EXECUTE stmt7 USING @arg;

850

INSTR(c1,?)

851

852

EXECUTE stmt8 USING @arg;

853

LOCATE(?,c1)

854

855

EXECUTE stmt9 USING @arg;

856

LPAD(c1,9,?)

857

��܏�܏�܏�܏�܏��xxx

858

EXECUTE stmt10 USING @arg;

859

REPLACE(c1,?,'x')

860

��x

861

EXECUTE stmt11 USING @arg;

862

REPLACE(c1,'x',?)

863

��܏�܏��

864

EXECUTE stmt12 USING @arg;

865

RPAD(c1,9,?)

866

xxx��܏�܏�܏�܏�܏��

867

EXECUTE stmt13 USING @arg;

868

SELECT * FROM t4;

869

870

��

871

��

872

873

EXECUTE stmt14 USING @arg;

874

SELECT * FROM t4;

875

876

��

877

��

878

��

879

DEALLOCATE PREPARE stmt1;

880

DEALLOCATE PREPARE stmt2;

881

DEALLOCATE PREPARE stmt3;

882

DEALLOCATE PREPARE stmt4;

883

DEALLOCATE PREPARE stmt5;

884

DEALLOCATE PREPARE stmt6;

885

DEALLOCATE PREPARE stmt7;

886

DEALLOCATE PREPARE stmt8;

887

DEALLOCATE PREPARE stmt9;

888

DEALLOCATE PREPARE stmt10;

889

DEALLOCATE PREPARE stmt11;

890

DEALLOCATE PREPARE stmt12;

891

DEALLOCATE PREPARE stmt13;

892

DEALLOCATE PREPARE stmt14;

893

DROP TABLE t1;

894

DROP TABLE t2;

895

DROP TABLE t3;

896

DROP TABLE t4;

Older »