~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

--exec $MYSQL_DUMP --skip-comments --add-drop-table --flush-privileges --ignore-table=mysql.general_log --ignore-table=mysql.slow_log --databases mysqldump_myDB mysql > $MYSQLTEST_VARDIR/tmp/bug21527.sql

1427

1428

# Clean up

1429

connection root;

1430

use mysqldump_myDB;

1431

drop view v1;

1432

drop table t1;

1433

drop table u1;

1434

revoke all privileges on mysqldump_myDB.* from myDB_User@localhost;

1435

drop user myDB_User@localhost;

1436

drop database mysqldump_myDB;

1437

flush privileges;

1438

1439

1440

--echo # Bug#21424 continues from here.

1441

--echo # Restore. Flush Privileges test ends.

1442

--echo #

1443

1444

--exec $MYSQL < $MYSQLTEST_VARDIR/tmp/bug21527.sql

1445

1446

# Do as a user

1447

connection user1;

1448

use mysqldump_myDB;

1449

1450

# Ultimate test for correct data.

1451

select * from mysqldump_myDB.v1;

1452

select * from mysqldump_myDB.u1;

1453

1454

# Final cleanup.

1455

connection root;

1456

disconnect user1;

1457

use mysqldump_myDB;

1458

drop view v1;

1459

drop table t1;

1460

drop table u1;

1461

revoke all privileges on mysqldump_myDB.* from myDB_User@localhost;

1462

drop user myDB_User@localhost;

1463

drop database mysqldump_myDB;

1464

connection default;

1465

disconnect root;

1466

--remove_file $MYSQLTEST_VARDIR/tmp/bug21527.sql

1467

use test;

1468

1469

--echo #

1470

--echo # Bug #21527 mysqldump incorrectly tries to LOCK TABLES on the

1471

--echo # information_schema database.

1472

--echo #

1473

--echo # Bug #33762: mysqldump can not dump INFORMATION_SCHEMA

1474

--echo #

1475

--exec $MYSQL_DUMP --compact --opt -d information_schema TABLES

1476

1477

--echo #

1478

--echo # Bug#19745 mysqldump --xml produces invalid xml

1479

--echo #

1480

1481

--disable_warnings

1482

DROP TABLE IF EXISTS t1;

1483

--enable_warnings

1484

1485

CREATE TABLE t1 (f1 int(10), data MEDIUMBLOB);

1486

INSERT INTO t1 VALUES(1,0xff00fef0);

1487

1488

--exec $MYSQL_DUMP --xml --hex-blob --skip-create-options test t1

1489

1490

DROP TABLE t1;

1491

1492

1493

--echo #

1494

--echo # Bug#26346 stack + buffer overrun in mysqldump

1495

--echo #

1496

1497

CREATE TABLE t1(a int);

1498

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

1499

1500

# too long a file path causes an error

1501

--error 1

1502

--exec $MYSQL_DUMP --tab=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa test 2>&1

1503

1504

--exec $MYSQL_DUMP --tab=$MYSQLTEST_VARDIR/tmp/ --fields-terminated-by=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa test

1505

--error 2

1506

--exec $MYSQL_DUMP --tab=$MYSQLTEST_VARDIR/tmp/ --fields-enclosed-by=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa test

1507

--error 2

1508

--exec $MYSQL_DUMP --tab=$MYSQLTEST_VARDIR/tmp/ --fields-optionally-enclosed-by=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa test

1509

--error 2

1510

--exec $MYSQL_DUMP --tab=$MYSQLTEST_VARDIR/tmp/ --fields-escaped-by=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa test

1511

--exec $MYSQL_DUMP --tab=$MYSQLTEST_VARDIR/tmp/ --lines-terminated-by=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa test

1512

1513

--remove_file $MYSQLTEST_VARDIR/tmp/t1.sql

1514

--remove_file $MYSQLTEST_VARDIR/tmp/t1.txt

1515

1516

DROP TABLE t1;

1517

1518

1519

1520

# Bug#25993 crashes with a merge table and -c

1521

1522

1523

CREATE TABLE t2 (a INT);

1524

CREATE TABLE t3 (a INT);

1525

CREATE TABLE t1 (a INT) ENGINE=merge UNION=(t2, t3);

1526

--exec $MYSQL_DUMP --skip-comments -c test

1527

DROP TABLE t1, t2, t3;

1528

1529

1530

--echo #

1531

--echo # Bug#23491 MySQLDump prefix function call in a view by database name

1532

--echo #

1533

1534

# Setup

1535

create database bug23491_original;

1536

create database bug23491_restore;

1537

use bug23491_original;

1538

create table t1 (c1 int);

1539

create view v1 as select * from t1;

1540

create procedure p1() select 1;

1541

create function f1() returns int return 1;

1542

create view v2 as select f1();

1543

create function f2() returns int return f1();

1544

create view v3 as select bug23491_original.f1();

1545

1546

# Backup.

1547

--exec $MYSQL_DUMP --skip-comments -uroot --opt --routines bug23491_original > $MYSQLTEST_VARDIR/tmp/bug23491_backup.sql

1548

1549

# Restore.

1550

--exec $MYSQL bug23491_restore < $MYSQLTEST_VARDIR/tmp/bug23491_backup.sql

1551

1552

# Verify

1553

use bug23491_restore;

1554

show create view bug23491_restore.v2;

1555

show create view bug23491_restore.v3;

1556

1557

# Cleanup

1558

drop database bug23491_original;

1559

drop database bug23491_restore;

1560

use test;

1561

--remove_file $MYSQLTEST_VARDIR/tmp/bug23491_backup.sql

1562

1563

1564

1565

--echo #

1566

--echo # Bug#27293 mysqldump crashes when dumping routines

1567

--echo # defined by a different user

1568

--echo #

1569

--echo # Bug#22761 mysqldump reports no errors when using

1570

--echo # --routines without mysql.proc privileges

1571

--echo #

1572

1573

create database mysqldump_test_db;

1574

1575

grant all privileges on mysqldump_test_db.* to user1;

1576

grant all privileges on mysqldump_test_db.* to user2;

1577

1578

connect (user27293,localhost,user1,,mysqldump_test_db,$MASTER_MYPORT,$MASTER_MYSOCK);

1579

connection user27293;

1580

1581

create procedure mysqldump_test_db.sp1() select 'hello';

1582

1583

--error 2

1584

--exec $MYSQL_DUMP -f --compact --user=user2 --password= -h 127.0.0.1 -P $MASTER_MYPORT --routines mysqldump_test_db

1585

1586

--exec $MYSQL_DUMP -f --compact --user=user1 --password= -h 127.0.0.1 -P $MASTER_MYPORT --routines mysqldump_test_db

1587

1588

drop procedure sp1;

1589

1590

connection default;

1591

disconnect user27293;

1592

drop user user1;

1593

drop user user2;

1594

1595

drop database mysqldump_test_db;

1596

1597

--echo #

1598

--echo # Bug#28522 buffer overrun by '\0' byte using --hex-blob.

1599

--echo #

1600

1601

CREATE TABLE t1 (c1 INT, c2 LONGBLOB);

1602

INSERT INTO t1 SET c1=11, c2=REPEAT('q',509);

1603

--exec $MYSQL_DUMP --skip-create-options --compact --hex-blob test t1

1604

DROP TABLE t1;

1605

1606

--echo #

1607

--echo # Bug#28524 mysqldump --skip-add-drop-table is not

1608

--echo # compatible with views

1609

--echo #

1610

1611

CREATE VIEW v1 AS SELECT 1;

1612

--exec $MYSQL_DUMP --skip-add-drop-table test > $MYSQLTEST_VARDIR/tmp/bug28524.sql

1613

DROP VIEW v1;

1614

1615

--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/bug28524.sql

1616

SELECT * FROM v1;

1617

DROP VIEW v1;

1618

--remove_file $MYSQLTEST_VARDIR/tmp/bug28524.sql

1619

1620

1621

--echo #

1622

--echo # Bug#29788 mysqldump discards the NO_AUTO_VALUE_ON_ZERO value of

1623

--echo # the SQL_MODE variable after the dumping of triggers.

1624

--echo #

1625

1626

CREATE TABLE t1 (c1 INT);

1627

CREATE TRIGGER t1bd BEFORE DELETE ON t1 FOR EACH ROW BEGIN END;

1628

1629

CREATE TABLE t2 (c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);

1630

1631

SET @TMP_SQL_MODE = @@SQL_MODE;

1632

SET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';

1633

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

1634

SET SQL_MODE = @TMP_SQL_MODE;

1635

SELECT * FROM t2;

1636

1637

--exec $MYSQL_DUMP --routines test >$MYSQLTEST_VARDIR/tmp/bug29788.sql

1638

--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/bug29788.sql

1639

SELECT * FROM t2;

1640

1641

DROP TABLE t1,t2;

1642

--remove_file $MYSQLTEST_VARDIR/tmp/bug29788.sql

1643

1644

1645

--echo #

1646

--echo # Bug#29815 new option for suppressing last line of mysqldump:

1647

--echo # "Dump completed on"

1648

--echo #

1649

1650

--echo # --skip-dump-date:

1651

--replace_regex /-- [^D][^u][^m][^p].*// /\/\*!.*//

1652

--exec $MYSQL_DUMP --skip-dump-date test

1653

1654

--echo # --dump-date:

1655

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

1656

--exec $MYSQL_DUMP --dump-date test

1657

1658

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

1659

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

1660

--exec $MYSQL_DUMP test

1661

1662

--echo #

1663

--echo # Bug #42635: mysqldump includes views that were excluded using

1664

--echo # the --ignore-table option

1665

--echo #

1666

1667

create database db42635;

1668

use db42635;

1669

create table t1 (id int);

1670

create view db42635.v1 (c) as select * from db42635.t1;

1671

create view db42635.v2 (c) as select * from db42635.t1;

1672

--exec $MYSQL_DUMP --skip-comments --ignore-table=db42635.v1 db42635

1673

use test;

1674

drop database db42635;

1675

1676

--echo #

1677

--echo # Bug#33550 mysqldump 4.0 compatibility broken

1678

--echo #

1679

1680

SET NAMES utf8;

1681

CREATE TABLE `straße` ( f1 INT );

1682

--exec $MYSQL_DUMP --character-sets-dir=$MYSQL_SHAREDIR/charsets --skip-comments --default-character-set=utf8 --compatible=mysql323 test

1683

--exec $MYSQL_DUMP --character-sets-dir=$MYSQL_SHAREDIR/charsets --skip-comments --default-character-set=latin1 --compatible=mysql323 test

1684

DROP TABLE `straße`;

1685

1686

CREATE TABLE `כדשגכחךלדגכחשךדגחכךלדגכ` ( f1 INT );

1687

--exec $MYSQL_DUMP --character-sets-dir=$MYSQL_SHAREDIR/charsets --skip-comments --default-character-set=utf8 --compatible=mysql323 test

1688

--error 2

1689

--exec $MYSQL_DUMP --character-sets-dir=$MYSQL_SHAREDIR/charsets --skip-comments --default-character-set=latin1 --compatible=mysql323 test

1690

DROP TABLE `כדשגכחךלדגכחשךדגחכךלדגכ`;

1691

SET NAMES latin1;

1692

1693

--echo #

1694

--echo # End of 5.0 tests

1695

--echo #

1696

1697

# Check new --replace option

1698

1699

--disable_warnings

1700

drop table if exists t1;

1701

--enable_warnings

1702

1703

CREATE TABLE t1(a int, b int);

1704

INSERT INTO t1 VALUES (1,1);

1705

INSERT INTO t1 VALUES (2,3);

1706

INSERT INTO t1 VALUES (3,4), (4,5);

1707

--exec $MYSQL_DUMP --replace --skip-comments test t1

1708

DROP TABLE t1;

1709

1710

1711

# Added for use-thread option

1712

1713

1714

create table t1 (a text , b text);

1715

create table t2 (a text , b text);

1716

insert t1 values ("Duck, Duck", "goose");

1717

insert t1 values ("Duck, Duck", "pidgeon");

1718

insert t2 values ("We the people", "in order to perform");

1719

insert t2 values ("a more perfect", "union");

1720

select * from t1;

1721

select * from t2;

1722

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

1723

--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/t1.sql

1724

--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/t2.sql

1725

# The first load tests the pausing code

1726

--exec $MYSQL_IMPORT --use-threads=1 test $MYSQLTEST_VARDIR/tmp/t1.txt $MYSQLTEST_VARDIR/tmp/t2.txt

1727

# Now we test with multiple threads!

1728

--exec $MYSQL_IMPORT --silent --use-threads=5 test $MYSQLTEST_VARDIR/tmp/t1.txt $MYSQLTEST_VARDIR/tmp/t2.txt

1729

select * from t1;

1730

select * from t2;

1731

# Now we test with multiple threads, but less threads than files.

1732

create table words(a varchar(255));

1733

create table words2(b varchar(255));

1734

--exec $MYSQL_IMPORT --silent --use-threads=2 test $MYSQLTEST_VARDIR/tmp/t1.txt $MYSQLTEST_VARDIR/tmp/t2.txt $MYSQLTEST_VARDIR/std_data/words.dat $MYSQLTEST_VARDIR/std_data/words2.dat

1735

select * from t1;

1736

select * from t2;

1737

select * from words;

1738

select * from words2;

1739

1740

# Drop table "words" and run with threads, should fail

1741

drop table words;

1742

--replace_regex /.*mysqlimport(\.exe)*/mysql-import/

1743

--error 1

1744

--exec $MYSQL_IMPORT --silent --use-threads=2 test $MYSQLTEST_VARDIR/tmp/t1.txt $MYSQLTEST_VARDIR/tmp/t2.txt $MYSQLTEST_VARDIR/std_data/words.dat $MYSQLTEST_VARDIR/std_data/words2.dat 2>&1

1745

1746

drop table t1;

1747

drop table t2;

1748

1749

drop table words2;

1750

1751

--echo #

1752

--echo # Bug#16853 mysqldump doesn't show events

1753

--echo #

1754

1755

create database first;

1756

use first;

1757

set time_zone = 'UTC';

1758

1759

## prove one works (with spaces and tabs on the end)

1760

create event ee1 on schedule at '2035-12-31 20:01:23' do set @a=5;

1761

show events;

1762

show create event ee1;

1763

--exec $MYSQL_DUMP --events first > $MYSQLTEST_VARDIR/tmp/bug16853-1.sql

1764

drop database first;

1765

1766

create database second;

1767

use second;

1768

--exec $MYSQL second < $MYSQLTEST_VARDIR/tmp/bug16853-1.sql

1769

show events;

1770

show create event ee1;

1771

--remove_file $MYSQLTEST_VARDIR/tmp/bug16853-1.sql

1772

1773

## prove three works (with spaces and tabs on the end)

1774

# start with one from the previous restore

1775

create event ee2 on schedule at '2018-12-31 21:01:23' do set @a=5;

1776

create event ee3 on schedule at '2030-12-31 22:01:23' do set @a=5;

1777

show events;

1778

--exec $MYSQL_DUMP --events second > $MYSQLTEST_VARDIR/tmp/bug16853-2.sql

1779

drop database second;

1780

1781

create database third;

1782

use third;

1783

--exec $MYSQL third < $MYSQLTEST_VARDIR/tmp/bug16853-2.sql

1784

show events;

1785

drop database third;

1786

--remove_file $MYSQLTEST_VARDIR/tmp/bug16853-2.sql

1787

1788

# revert back to normal settings

1789

set time_zone = 'SYSTEM';

1790

use test;

1791

1792

--echo #

1793

--echo # Bug#17201 Spurious 'DROP DATABASE' in output,

1794

--echo # also confusion between tables and views.

1795

--echo # Example code from Markus Popp

1796

--echo #

1797

1798

create database mysqldump_test_db;

1799

use mysqldump_test_db;

1800

create table t1 (id int);

1801

create view v1 as select * from t1;

1802

insert into t1 values (1232131);

1803

insert into t1 values (4711);

1804

insert into t1 values (3231);

1805

insert into t1 values (0815);

1806

--exec $MYSQL_DUMP --skip-comments --add-drop-database --databases mysqldump_test_db

1807

drop view v1;

1808

drop table t1;

1809

drop database mysqldump_test_db;

1810

1811

1812

# Bug#26121 mysqldump includes LOCK TABLES general_log WRITE

1813

1814

--exec $MYSQL_DUMP --all-databases > $MYSQLTEST_VARDIR/tmp/bug26121.sql

1815

--exec $MYSQL < $MYSQLTEST_VARDIR/tmp/bug26121.sql

1816

--remove_file $MYSQLTEST_VARDIR/tmp/bug26121.sql

1817

1818

###########################################################################

1819

1820

--echo #

1821

--echo # Bug#30027 mysqldump does not dump views properly.

1822

--echo #

1823

1824

--echo

1825

--echo # Cleanup.

1826

1827

--disable_warnings

1828

DROP DATABASE IF EXISTS mysqldump_test_db;

1829

--enable_warnings

1830

1831

--echo

1832

--echo # Create objects.

1833

1834

CREATE DATABASE mysqldump_test_db;

1835

1836

set names koi8r;

1837

1838

CREATE VIEW mysqldump_test_db.v2 AS SELECT 1 AS ��1;

1839

CREATE VIEW mysqldump_test_db.v1 AS SELECT ��1 FROM mysqldump_test_db.v2;

1840

1841

set names latin1;

1842

1843

--echo

1844

--echo # Dump mysqldump_test_db to bug30027.sql.

1845

1846

--exec $MYSQL_DUMP --character-sets-dir=$MYSQL_SHAREDIR/charsets --default-character-set=latin1 --databases mysqldump_test_db > $MYSQLTEST_VARDIR/tmp/bug30027.sql

1847

1848

--echo

1849

--echo # Drop mysqldump_test_db.

1850

1851

DROP DATABASE mysqldump_test_db;

1852

1853

--echo

1854

--echo # Restore mysqldump_test_db from bug30027.sql.

1855

1856

--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/bug30027.sql

1857

1858

--echo

1859

--echo # Check the view.

1860

1861

set names utf8;

1862

1863

SHOW CREATE VIEW mysqldump_test_db.v1;

1864

SHOW CREATE VIEW mysqldump_test_db.v2;

1865

1866

set names latin1;

1867

1868

--echo

1869

--echo # Cleanup.

1870

1871

DROP DATABASE mysqldump_test_db;

1872

--remove_file $MYSQLTEST_VARDIR/tmp/bug30027.sql

1873

1874

###########################################################################

1875

1876

--echo #

1877

--echo # Bug#29938 wrong behavior of mysqldump --skip-events

1878

--echo # with --all-databases

1879

--echo #

1880

1881

TRUNCATE mysql.event;

1882

1883

USE test;

1884

CREATE event e29938 ON SCHEDULE AT '2035-12-31 20:01:23' DO SET @bug29938=29938;

1885

SHOW EVENTS;

1886

--exec $MYSQL_DUMP --skip-events --all-databases > $MYSQLTEST_VARDIR/tmp/bug29938.sql

1887

1888

TRUNCATE mysql.event;

1889

--exec $MYSQL < $MYSQLTEST_VARDIR/tmp/bug29938.sql

1890

SHOW EVENTS;

1891

--remove_file $MYSQLTEST_VARDIR/tmp/bug29938.sql

1892

DROP EVENT e29938; # Events are now dumped even with --skip-events

1893

1894

1895

--echo #

1896

--echo # Bug#31113 mysqldump 5.1 can't handle a dash ("-") in database names

1897

--echo #

1898

create database `test-database`;

1899

use `test-database`;

1900

create table test (a int);

1901

--exec $MYSQL_DUMP --compact --opt --quote-names test-database

1902

drop database `test-database`;

1903

use test;

1904

1905

###########################################################################

1906

1907

--echo

1908

--echo # -----------------------------------------------------------------

1909

--echo # -- Bug#30217 Views: changes in metadata behaviour between 5.0 and 5.1.

1910

--echo # -----------------------------------------------------------------

1911

--echo

1912

1913

--disable_warnings

1914

DROP DATABASE IF EXISTS mysqldump_test_db;

1915

--enable_warnings

1916

1917

CREATE DATABASE mysqldump_test_db;

1918

use mysqldump_test_db;

1919

1920

--echo

1921

1922

CREATE VIEW v1(x, y) AS SELECT 'a', 'a';

1923

1924

--echo

1925

1926

SELECT view_definition

1927

FROM INFORMATION_SCHEMA.VIEWS

1928

WHERE table_schema = 'mysqldump_test_db' AND table_name = 'v1';

1929

1930

--echo

1931

1932

--echo ---> Dumping mysqldump_test_db to bug30217.sql

1933

--exec $MYSQL_DUMP --character-sets-dir=$MYSQL_SHAREDIR/charsets --databases mysqldump_test_db > $MYSQLTEST_VARDIR/tmp/bug30217.sql

1934

1935

--echo

1936

1937

DROP DATABASE mysqldump_test_db;

1938

use test;

1939

1940

--echo

1941

1942

--echo ---> Restoring mysqldump_test_db...

1943

--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/bug30217.sql

1944

1945

--echo

1946

1947

SELECT view_definition

1948

FROM INFORMATION_SCHEMA.VIEWS

1949

WHERE table_schema = 'mysqldump_test_db' AND table_name = 'v1';

1950

1951

--echo

1952

1953

DROP DATABASE mysqldump_test_db;

1954

--remove_file $MYSQLTEST_VARDIR/tmp/bug30217.sql

1955

1956

--echo

1957

--echo # -- End of test case for Bug#32538.

1958

--echo

1959

1960

--echo #

1961

--echo # Bug#37377 Incorrect DROP TABLE statement in dump of a VIEW using --tab

1962

--echo #

1963

1964

create table t1 (a int);

1965

create view v1 as select a from t1;

1966

1967

--exec $MYSQL_DUMP --skip-comments --tab=$MYSQLTEST_VARDIR/tmp/ test t1 v1

1968

1969

drop view v1;

1970

drop table t1;

1971

1972

--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/t1.sql

1973

--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/v1.sql

1974

1975

drop view v1;

1976

drop table t1;

1977

1978

--remove_file $MYSQLTEST_VARDIR/tmp/t1.sql

1979

--remove_file $MYSQLTEST_VARDIR/tmp/t1.txt

1980

--remove_file $MYSQLTEST_VARDIR/tmp/v1.sql

1981

1982

1983

--echo #

1984

--echo # Bug#28071 mysqlimport does not quote or escape table name

1985

--echo #

1986

1987

--disable_warnings

1988

drop table if exists `load`;

1989

--enable_warnings

1990

create table `load` (a varchar(255));

1991

1992

--copy_file std_data/words.dat $MYSQLTEST_VARDIR/tmp/load.txt

1993

--chmod 0644 $MYSQLTEST_VARDIR/tmp/load.txt

1994

1995

--exec $MYSQL_IMPORT --ignore test $MYSQLTEST_VARDIR/tmp/load.txt

1996

1997

select count(*) from `load`;

1998

1999

--remove_file $MYSQLTEST_VARDIR/tmp/load.txt

2000

2001

drop table `load`;

2002

2003

# We reset concurrent_inserts value to whatever it was at the start of the

2004

# test This line must be executed _after_ all test cases.

2005

SET @@GLOBAL.CONCURRENT_INSERT = @OLD_CONCURRENT_INSERT;

2006

2007

2008

###########################################################################

2009

2010

--echo

2011

--echo Bug #34861 - mysqldump with --tab gives weird output for triggers.

2012

--echo

2013

2014

CREATE TABLE t1 (f1 INT);

2015

CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW SET @f1 = 1;

2016

CREATE PROCEDURE pr1 () SELECT "Meow";

2017

CREATE EVENT ev1 ON SCHEDULE AT '2030-01-01 00:00:00' DO SELECT "Meow";

2018

2019

--echo

2020

SHOW TRIGGERS;

2021

SHOW EVENTS;

2022

SELECT name,body FROM mysql.proc WHERE NAME = 'pr1';

2023

2024

--echo

2025

--echo dump table; if anything goes to stdout, it ends up here: ---------------

2026

--exec $MYSQL_DUMP --compact --routines --triggers --events --result-file=$MYSQLTEST_VARDIR/tmp/test_34861.sql --tab=$MYSQLTEST_VARDIR/tmp/ test

2027

2028

--echo

2029

--echo drop everything

2030

DROP EVENT ev1;

2031

DROP TRIGGER tr1;

2032

DROP TABLE t1;

2033

DROP PROCEDURE pr1;

2034

2035

--echo

2036

--echo reload table; this should restore table and trigger

2037

--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/t1.sql

2038

SHOW TRIGGERS;

2039

SHOW EVENTS;

2040

SELECT name,body FROM mysql.proc WHERE NAME = 'pr1';

2041

2042

--echo

2043

--echo reload db; this should restore routines and events

2044

--exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/test_34861.sql

2045

SHOW TRIGGERS;

2046

SHOW EVENTS;

2047

SELECT name,body FROM mysql.proc WHERE NAME = 'pr1';

2048

2049

--echo

2050

--echo cleanup

2051

--remove_file $MYSQLTEST_VARDIR/tmp/t1.txt

2052

--remove_file $MYSQLTEST_VARDIR/tmp/t1.sql

2053

--remove_file $MYSQLTEST_VARDIR/tmp/test_34861.sql

2054

--disable_warnings

2055

DROP EVENT IF EXISTS ev1;

2056

DROP PROCEDURE IF EXISTS pr1;

2057

DROP TRIGGER IF EXISTS tr1;

2058

DROP TABLE IF EXISTS t1;

2059

--enable_warnings

2060

2061

###########################################################################

2062

2063

--echo #

2064

--echo # Bug #30946: mysqldump silently ignores --default-character-set

2065

--echo # when used with --tab

2066

--echo #

2067

--echo # Also see outfile_loaddata.test

2068

--echo #

2069

2070

SET NAMES utf8;

2071

CREATE TABLE t1 (a INT, b CHAR(10) CHARSET koi8r, c CHAR(10) CHARSET latin1);

2072

CREATE TABLE t2 LIKE t1;

2073

INSERT INTO t1 VALUES (1, 'ABC-АБВ', 'DEF-ÂÃÄ'), (2, NULL, NULL);

2074

2075

--let $file=$MYSQLTEST_VARDIR/tmp/t1.txt

2076

2077

2078

--echo # error on multi-character ENCLOSED/ESCAPED BY

2079

2080

--error 2

2081

--exec $MYSQL_DUMP --tab=$MYSQLTEST_VARDIR/tmp/ --fields-enclosed-by='12345' test t1

2082

--remove_file $file

2083

2084

--error 2

2085

--exec $MYSQL_DUMP --tab=$MYSQLTEST_VARDIR/tmp/ --fields-escaped-by='12345' test t1

2086

--remove_file $file

2087

2088

--echo # default '--default-charset' (binary):

2089

2090

--exec $MYSQL_DUMP --character-sets-dir=$MYSQL_SHAREDIR/charsets --tab=$MYSQLTEST_VARDIR/tmp/ test t1

2091

--echo ##################################################

2092

--cat_file $file

2093

--echo ##################################################

2094

TRUNCATE t2;

2095

--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR

2096

--eval LOAD DATA INFILE '$file' INTO TABLE t2 CHARACTER SET binary

2097

--remove_file $file

2098

SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY a, b, c;

2099

2100

2101

--echo # utf8:

2102

2103

--exec $MYSQL_DUMP --character-sets-dir=$MYSQL_SHAREDIR/charsets --default-character-set=utf8 --tab=$MYSQLTEST_VARDIR/tmp/ test t1

2104

--echo ##################################################

2105

--cat_file $file

2106

--echo ##################################################

2107

TRUNCATE t2;

2108

--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR

2109

--eval LOAD DATA INFILE '$file' INTO TABLE t2 CHARACTER SET utf8

2110

--remove_file $file

2111

SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY a, b, c;

2112

2113

2114

--echo # latin1 (data corruption is expected):

2115

2116

--exec $MYSQL_DUMP --character-sets-dir=$MYSQL_SHAREDIR/charsets --default-character-set=latin1 --tab=$MYSQLTEST_VARDIR/tmp/ test t1

2117

--echo ##################################################

2118

--cat_file $file

2119

--echo ##################################################

2120

TRUNCATE t2;

2121

--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR

2122

--eval LOAD DATA INFILE '$file' INTO TABLE t2 CHARACTER SET latin1

2123

--remove_file $file

2124

SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY a, b, c;

2125

2126

2127

--echo # koi8r (data corruption is expected):

2128

2129

--exec $MYSQL_DUMP --character-sets-dir=$MYSQL_SHAREDIR/charsets --default-character-set=koi8r --tab=$MYSQLTEST_VARDIR/tmp/ test t1

2130

--echo ##################################################

2131

--cat_file $file

2132

--echo ##################################################

2133

TRUNCATE t2;

2134

--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR

2135

--eval LOAD DATA INFILE '$file' INTO TABLE t2 CHARACTER SET koi8r

2136

--remove_file $file

2137

SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY a, b, c;

2138

2139

2140

SET NAMES default;

2141

2142

DROP TABLE t1, t2;

2143

###########################################################################

2144

2145

--echo #

2146

--echo # Bug #53088: mysqldump with -T & --default-character-set set

2147

--echo # truncates text/blob to 766 chars

2148

--echo #

2149

--echo # Also see outfile_loaddata.test

2150

--echo #

2151

2152

CREATE TABLE t1 (a BLOB) CHARSET latin1;

2153

CREATE TABLE t2 LIKE t1;

2154

2155

let $table= t1;

2156

let $dir= $MYSQLTEST_VARDIR/tmp;

2157

let $file= $dir/$table.txt;

2158

let $length= 800;

2159

2160

--eval INSERT INTO t1 VALUES (REPEAT('.', $length))

2161

2162

--exec $MYSQL_DUMP --character-sets-dir=$CHARSETSDIR --default-character-set=latin1 --tab=$dir/ test $table

2163

--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR

2164

2165

--eval LOAD DATA INFILE '$file' INTO TABLE t2 CHARACTER SET latin1

2166

--remove_file $file

2167

2168

--echo # should be $length

2169

SELECT LENGTH(a) FROM t2;

2170

2171

DROP TABLE t1, t2;

2172

2173

2174

# WL#3126 TCP address binding for mysql client library;

2175

# - running mysqldump --protocol=tcp --bind-address=127.0.0.1

2176

# - running mysqlimport --protocol=tcp --bind-address=127.0.0.1

2177

2178

create table t1 (first char(28) , last varchar(37));

2179

insert into t1 values ("Magnus", "Blåudd");

2180

--exec $MYSQL_DUMP --protocol=tcp --bind-address=127.0.0.1 --tab=$MYSQLTEST_VARDIR/tmp/ test

2181

truncate table t1;

2182

--exec $MYSQL_IMPORT --protocol=tcp --bind-address=127.0.0.1 test $MYSQLTEST_VARDIR/tmp/t1.txt

2183

drop table t1;

2184

2185

###########################################################################

2186

2187

--echo #

2188

--echo # Bug #13618 : mysqldump --xml ommit comment on table field

2189

--echo #

2190

2191

CREATE TABLE `comment_table` (i INT COMMENT 'FIELD COMMENT') COMMENT = 'TABLE COMMENT';

2192

--exec $MYSQL_DUMP --compact --skip-create-options --xml test

2193

DROP TABLE `comment_table`;

2194

2195

--echo #

2196

--echo # BUG#11766310 : 59398: MYSQLDUMP 5.1 CAN'T HANDLE A DASH ("-") IN

2197

--echo # DATABASE NAMES IN ALTER DATABASE

2198

--echo #

2199

2200

CREATE DATABASE `test-database`;

2201

USE `test-database`;

2202

CREATE TABLE `test` (`c1` VARCHAR(10)) ENGINE=MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

2203

2204

DELIMITER |;

2205

CREATE TRIGGER `trig` BEFORE INSERT ON `test` FOR EACH ROW BEGIN

2206

END |

2207

DELIMITER ;|

2208

2209

ALTER DATABASE `test-database` CHARACTER SET latin1 COLLATE latin1_swedish_ci;

2210

ALTER DATABASE `test-database` CHARACTER SET utf8 COLLATE utf8_unicode_ci ;

2211

2212

--exec $MYSQL_DUMP --quote-names --compact test-database

2213

2214

DROP DATABASE `test-database`;

2215

# Switching back to test database.

2216

USE test;

2217

2218

--echo #

2219

--echo # BUG#11760384 : 52792: mysqldump in XML mode does not dump routines.

2220

--echo #

2221

CREATE DATABASE BUG52792;

2222

USE BUG52792;

2223

CREATE TABLE t1 (c1 INT, c2 VARCHAR(20));

2224

CREATE TABLE t2 (c1 INT);

2225

INSERT INTO t1 VALUES (1, 'aaa'), (2, 'bbb'), (3, 'ccc');

2226

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

2227

2228

--echo # Stored Procedures.

2229

2230

DELIMITER //;

2231

CREATE PROCEDURE simpleproc1 (OUT param1 INT)

2232

BEGIN

2233

SELECT COUNT(*) INTO param1 FROM t1;

2234

END//

2235

DELIMITER ;//

2236

2237

DELIMITER //;

2238

CREATE PROCEDURE simpleproc2 (OUT param1 INT)

2239

BEGIN

2240

SELECT COUNT(*) INTO param1 FROM t2;

2241

END//

2242

DELIMITER ;//

2243

2244

--echo # Events.

2245

2246

CREATE EVENT e1 ON SCHEDULE EVERY 1 SECOND DO DROP DATABASE BUG52792;

2247

CREATE EVENT e2 ON SCHEDULE EVERY 1 SECOND DO DROP DATABASE BUG52792;

2248

2249

--echo # Functions.

2250

2251

CREATE FUNCTION `hello1` (s CHAR(20))

2252

RETURNS CHAR(50) DETERMINISTIC

2253

RETURN CONCAT('Hello, ' ,s ,'!');

2254

2255

CREATE FUNCTION `hello2` (s CHAR(20))

2256

RETURNS CHAR(50) DETERMINISTIC

2257

RETURN CONCAT(']]>, ' , s ,'!');

2258

2259

--echo # Triggers.

2260

2261

DELIMITER |;

2262

CREATE TRIGGER trig1 BEFORE INSERT ON t2

2263

FOR EACH ROW BEGIN

2264

INSERT INTO t2 VALUES(1);

2265

END;

2266

2267

DELIMITER ;|

2268

2269

DELIMITER |;

2270

CREATE TRIGGER trig2 AFTER INSERT ON t2

2271

FOR EACH ROW BEGIN

2272

INSERT INTO t2 VALUES(1, ']]>');

2273

INSERT INTO t2 VALUES(2, '<![CDATA]]>');

2274

INSERT INTO t2 VALUES(3, '<![CDATA[');

2275

INSERT INTO t2 VALUES(4, '< > & \ " _');

2276

END;

2277

2278

DELIMITER ;|

2279

2280

--echo # Views

2281

2282

CREATE VIEW v1 AS SELECT * FROM t1;

2283

CREATE VIEW v2 AS SELECT * FROM t2;

2284

--echo

2285

--echo # Dumping BUG52792 database in xml format.

2286

--echo

2287

--echo # Running 'replace_regex on timestamp'

2288

--replace_regex /[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}/--TIME--/

2289

--exec $MYSQL_DUMP --user=root --compact -R -E --triggers -X BUG52792

2290

--echo

2291

--echo # Dumping BUG52792 database in xml format with comments.

2292

--echo

2293

--echo # Running 'replace_regex on timestamp'

2294

--replace_regex /[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}/--TIME--/

2295

--exec $MYSQL_DUMP --comments --user=root -R -E --triggers -X BUG52792

2296

2297

--echo

2298

--echo # Test to check 'Insufficient privileges' error.

2299

--echo

2300

2301

GRANT ALL PRIVILEGES ON BUG52792.* TO user1;

2302

2303

connect (conn_1, localhost, user1, , BUG52792, $MASTER_MYPORT, $MASTER_MYSOCK);

2304

connection conn_1;

2305

2306

--echo # Running 'replace_regex on timestamp'

2307

--replace_regex /[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}/--TIME--/

2308

--error 2

2309

--exec $MYSQL_DUMP --user=user1 -R -E --triggers -X BUG52792

2310

2311

connection default;

2312

disconnect conn_1;

2313

2314

DROP USER user1;

2315

DROP DATABASE BUG52792;

2316

--echo # UTF-8

2317

CREATE DATABASE BUG52792;

2318

USE BUG52792;

2319

SET NAMES utf8;

2320

CREATE FUNCTION `straße` ( c1 CHAR(20))

2321

RETURNS CHAR(50) DETERMINISTIC

2322

RETURN CONCAT(']]>, ', s, '!');

2323

2324

--exec $MYSQL_DUMP --character-sets-dir=$CHARSETSDIR --skip-comments --default-character-set=utf8 --compatible=mysql323 -R -X BUG52792

2325

2326

DROP DATABASE BUG52792;

2327

SET NAMES default;

2328

2329

USE test;

2330

2331

--echo #

2332

--echo # End of 5.1 tests

2333

--echo #

2334

2335

--echo #

2336

--echo # Test for --add-drop-trigger

2337

--echo #

2338

USE `test`;

2339

CREATE TABLE t1 (a int, b int);

2340

CREATE TRIGGER tt1_t1 BEFORE INSERT ON t1 FOR EACH ROW

2341

SET NEW.b=NEW.a + 10;

2342

2343

INSERT INTO t1 (a) VALUES (1),(2),(3);

2344

--exec $MYSQL_DUMP --triggers --no-data --no-create-info --add-drop-trigger --skip-comments --databases test

2345

DROP TABLE t1;

2346

2347

--echo #

2348

--echo # Verify that two modes can be given in --compatible;

2349

--echo # and are reflected in SET SQL_MODE in the mysqldump output.

2350

--echo # Also verify that a prefix of the mode's name is enough.

2351

--echo #

2352

CREATE TABLE t1 (a INT);

2353

# no_t = no_table_options; no_f = no_field_options

2354

--exec $MYSQL_DUMP --compatible=no_t,no_f --skip-comments test

2355

DROP TABLE t1;

2356

2357

--echo #

2358

--echo # Test columns with function defaults.

2359

--echo #

2360

CREATE TABLE t1 (

2361

a TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

2362

b TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

2363

c TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,

2364

d TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

2365

e TIMESTAMP NULL,

2366

f TIMESTAMP NOT NULL DEFAULT '2010-05-26 12:34:56',

2367

g DATETIME,

2368

h DATETIME DEFAULT CURRENT_TIMESTAMP,

2369

i DATETIME ON UPDATE CURRENT_TIMESTAMP,

2370

j DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

2371

k DATETIME NULL,

2372

l DATETIME DEFAULT '2010-05-26 12:34:56'

2373

);

2374

--exec $MYSQL_DUMP --skip-comments test

2375

DROP TABLE t1;

2376

2377

--echo #

2378

--echo # Bug#12809202 61854: MYSQLDUMP --SINGLE-TRANSACTION --FLUSH-LOG BREAKS

2379

--echo # CONSISTENCY

2380

--echo #

2381

2382

--disable_warnings

2383

DROP DATABASE IF EXISTS b12809202_db;

2384

--enable_warnings

2385

2386

CREATE DATABASE b12809202_db;

2387

CREATE TABLE b12809202_db.t1 (c1 INT);

2388

CREATE TABLE b12809202_db.t2 (c1 INT);

2389

2390

INSERT INTO b12809202_db.t1 VALUES (1), (2), (3);

2391

INSERT INTO b12809202_db.t2 VALUES (1), (2), (3);

2392

2393

--echo # Starting mysqldump with --single-transaction & --flush-logs options..

2394

--echo # Note : In the following dump the transaction

2395

--echo # should start only after the logs are

2396

--echo # flushed, as 'flush logs' causes implicit

2397

--echo # commit starting 5.5. Also, as stderr is

2398

--echo # unbuffered, it is redirected to a different

2399

--echo # file to avoid diffs due to bad stdout/stderr

2400

--echo # order in the output.

2401

--echo

2402

--echo #### Dump starts here ####

2403

--replace_regex /-- Server version.*// /-- MySQL dump .*// /-- Dump completed on .*/-- Dump completed/

2404

--exec $MYSQL_DUMP --verbose --single-transaction --flush-logs b12809202_db 2> $MYSQLTEST_VARDIR/tmp/b12809202_stderr.sql

2405

--echo

2406

--echo ## stderr ##

2407

--cat_file $MYSQLTEST_VARDIR/tmp/b12809202_stderr.sql

2408

--echo

2409

--echo #### Dump ends here ####

2410

2411

# Cleanup

2412

DROP TABLE b12809202_db.t1;

2413

DROP TABLE b12809202_db.t2;

2414

DROP DATABASE b12809202_db;

2415

--remove_file $MYSQLTEST_VARDIR/tmp/b12809202_stderr.sql

2416

2417

--echo #

2418

--echo # Delete all existing binary logs.

2419

--echo #

2420

RESET MASTER;

2421

2422

--echo #

2423

--echo # Bug#12688860 : SECURITY RECOMMENDATION: PASSWORDS ON CLI

2424

--echo #

2425

2426

--disable_warnings

2427

DROP DATABASE IF EXISTS b12688860_db;

2428

--enable_warnings

2429

2430

CREATE DATABASE b12688860_db;

2431

--exec $MYSQL_DUMP -uroot --password="" --skip-comments b12688860_db 2>&1

2432

DROP DATABASE b12688860_db;

2433

2434

2435

# Wait till we reached the initial number of concurrent sessions

2436

--source include/wait_until_count_sessions.inc

2437

2438

--echo #

2439

--echo # Bug#45740 MYSQLDUMP DOESN'T DUMP GENERAL_LOG AND SLOW_QUERY CAUSES RESTORE PROBLEM

2440

--echo #

2441

SET @old_log_output_state= @@global.log_output;

2442

SET @old_general_log_state= @@global.general_log;

2443

SET @old_slow_query_log_state= @@global.slow_query_log;

2444

2445

call mtr.add_suppression("Failed to write to mysql.general_log");

2446

--exec $MYSQL_DUMP -uroot --all-databases > $MYSQLTEST_VARDIR/tmp/bug45740.sql

2447

# Make log_output as table and disabling general_log and slow_log

2448

SET @@global.log_output="TABLE";

2449

SET @@global.general_log='OFF';

2450

SET @@global.slow_query_log='OFF';

2451

DROP DATABASE mysql;

2452

--exec $MYSQL < $MYSQLTEST_VARDIR/tmp/bug45740.sql

2453

SHOW CREATE TABLE mysql.general_log;

2454

SHOW CREATE TABLE mysql.slow_log;

2455

--remove_file $MYSQLTEST_VARDIR/tmp/bug45740.sql

2456

2457

SET @@global.log_output= @old_log_output_state;

2458

SET @@global.slow_query_log= @old_slow_query_log_state;

2459

SET @@global.general_log= @old_general_log_state;

2460

2461

--echo #

2462

--echo # End of 5.1 tests

2463

--echo #

Older »