~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/drizzledump.test

Committer: Andrew Hutchings
Date: 2010-09-24 13:38:21 UTC
mto: (1792.1.1 build)
mto: This revision was merged to the branch mainline in revision 1793.
Revision ID: andrew@linuxjedi.co.uk-20100924133821-jzesmb013qy3525m

Fix error handling
Make work with dtr drizzledump test case

files modified:
client/drizzledump.cc

client/drizzledump_data.cc

client/drizzledump_data.h

client/drizzledump_drizzle.cc

client/drizzledump_mysql.cc

tests/r/drizzledump.result

tests/t/drizzledump.test

Show diffs side-by-side

added added

removed removed

tests/t/drizzledump.test

DROP TABLE t1;

--echo #

--echo # Bug #1707

--echo #

CREATE TABLE t1 (`a"b"` char(2));

INSERT INTO t1 VALUES ("1\""), ("\"2");

--exec $DRIZZLE_DUMP --compact --skip-create -X test t1

DROP TABLE t1;

--echo #

--echo # Bug #2592 'mysqldump doesn't quote "tricky" names correctly'

--echo #

drop table ```a`;

--echo #

--echo # Bug #2705 'mysqldump --tab extra output'

--echo #

create table t1(a int);

insert into t1 values (1),(2),(3);

--exec $DRIZZLE_DUMP --skip-comments --tab=$MYSQLTEST_VARDIR/tmp/ test

--cat_file $MYSQLTEST_VARDIR/tmp/t1.sql

--cat_file $MYSQLTEST_VARDIR/tmp/t1.txt

--remove_file $MYSQLTEST_VARDIR/tmp/t1.sql

--remove_file $MYSQLTEST_VARDIR/tmp/t1.txt

--exec $DRIZZLE_DUMP --tab=$MYSQLTEST_VARDIR/tmp/ test

--remove_file $MYSQLTEST_VARDIR/tmp/t1.sql

--remove_file $MYSQLTEST_VARDIR/tmp/t1.txt

drop table t1;

--echo #

--echo # Bug #6101: create database problem

--echo #

462

437

INSERT INTO t2 VALUES (1), (2);

463

438

--exec $DRIZZLE_DUMP --skip-comments --no-data mysqldump_test_db

464

439

--exec $DRIZZLE_DUMP --skip-comments --no-data mysqldump_test_db t1 t2

465

--exec $DRIZZLE_DUMP --skip-comments --skip-create --xml --no-data mysqldump_test_db

466

--exec $DRIZZLE_DUMP --skip-comments --skip-create --xml --no-data mysqldump_test_db t1 t2

467

440

DROP TABLE t1, t2;

468

441

DROP DATABASE mysqldump_test_db;

469

442

481

454

--disable_query_log

482

455

select '------ Testing with illegal table names ------' as test_sequence ;

483

456

--enable_query_log

484

--error 6

457

--error 2

485

458

--exec $DRIZZLE_DUMP --compact --skip-comments mysqldump_test_db "\d-2-1.sql" 2>&1

486

459

487

--error 6

460

--error 2

488

461

--exec $DRIZZLE_DUMP --compact --skip-comments mysqldump_test_db "\t1" 2>&1

489

462

490

--error 6

463

--error 2

491

464

--exec $DRIZZLE_DUMP --compact --skip-comments mysqldump_test_db "\\t1" 2>&1

492

465

493

--error 6

466

--error 2

494

467

--exec $DRIZZLE_DUMP --compact --skip-comments mysqldump_test_db "\\\\t1" 2>&1

495

468

496

--error 6

469

--error 2

497

470

--exec $DRIZZLE_DUMP --compact --skip-comments mysqldump_test_db "t\1" 2>&1

498

471

499

--error 6

472

--error 2

500

473

--exec $DRIZZLE_DUMP --compact --skip-comments mysqldump_test_db "t\\1" 2>&1

501

474

502

--error 6

475

--error 2

503

476

--exec $DRIZZLE_DUMP --compact --skip-comments mysqldump_test_db "t/1" 2>&1

504

477

505

--error 6

478

--error 2

506

479

--exec $DRIZZLE_DUMP --compact --skip-comments mysqldump_test_db "T_1" 2>&1

507

480

508

--error 6

481

--error 2

509

482

--exec $DRIZZLE_DUMP --compact --skip-comments mysqldump_test_db "T%1" 2>&1

510

483

511

--error 6

484

--error 2

512

485

--exec $DRIZZLE_DUMP --compact --skip-comments mysqldump_test_db "T'1" 2>&1

513

486

514

--error 6

487

--error 2

515

488

--exec $DRIZZLE_DUMP --compact --skip-comments mysqldump_test_db "T_1" 2>&1

516

489

517

--error 6

490

--error 2

518

491

--exec $DRIZZLE_DUMP --compact --skip-comments mysqldump_test_db "T_" 2>&1

519

492

520

493

--disable_query_log

532

505

533

506

534

507

--echo #

535

--echo # Bug #9657 mysqldump xml ( -x ) does not format NULL fields correctly

536

--echo #

537

538

create table t1 (a int);

539

create table t2 (pk int primary key auto_increment,

540

a int, b varchar(30), c datetime, d blob, e text);

541

insert into t1 values (NULL), (10), (20);

542

insert into t2 (a, b) values (NULL, NULL),(10, NULL),(NULL, "twenty"),(30, "thirty");

543

--exec $DRIZZLE_DUMP --skip-comments --xml --no-create-info test

544

drop table t1, t2;

545

546

--echo #

547

508

--echo # BUG #19025 mysqldump doesn't correctly dump "auto_increment = [int]"

548

509

--echo #

549

510

580

541

create table t1(a int);

581

542

create table t2(a int);

582

543

create table t3(a int);

583

--error 6

544

--error 2

584

545

--exec $DRIZZLE_DUMP --skip-comments --force --no-data test t3 t1 non_existing t2

585

546

drop table t1, t2, t3;

586

547

587

548

--echo #

588

--echo # Bug #21288: mysqldump segmentation fault when using --where

589

--echo #

590

591

create table t1 (a int);

592

--error 2

593

--exec $DRIZZLE_DUMP --skip-comments --force test t1 --where="xx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" 2>&1

594

drop table t1;

595

596

--echo #

597

549

--echo # BUG#13926: --order-by-primary fails if PKEY contains quote character

598

550

--echo #

599

551

624

576

--exec $DRIZZLE_DUMP --skip-dump-date test

625

577

626

578

--echo # --dump-date:

627

--replace_regex /^[^-][^-].*$// /-- [^D][^u][^m][^p].*// /\/\*!.*// / on [0-9 :-]+/ on DATE/ /^-- DRI.*///

579

--replace_regex /^[^-][^-].*$// /-- [^D][^u][^m][^p].*// /\/\*!.*// / on [0-9a-zA-Z :-]+/ on DATE/ /^-- DRI.*///

628

580

--exec $DRIZZLE_DUMP test

629

581

630

582

--echo # --dump-date (default):

631

--replace_regex /^[^-][^-].*$// /-- [^D][^u][^m][^p].*// /\/\*!.*// / on [0-9 :-]+/ on DATE/ /^-- DRI.*///

583

--replace_regex /^[^-][^-].*$// /-- [^D][^u][^m][^p].*// /\/\*!.*// / on [0-9a-zA-Z :-]+/ on DATE/ /^-- DRI.*///

632

584

--exec $DRIZZLE_DUMP test

633

585

634

586

--echo #

Older »