mysqlpump_bugs.test

--source include/not_embedded.inc

--echo #
--echo # Bug #83144: mysqlpump reads mysql_dump group, not mysqlpump in config-group
--echo #

--write_file $MYSQLTEST_VARDIR/tmp/bug83144.cnf
[mysqlpump]
exclude_databases=db1,mysql,mtr
EOF

CREATE DATABASE db1;
CREATE DATABASE db2;

--exec $MYSQLPUMP --defaults-extra-file=$MYSQLTEST_VARDIR/tmp/bug83144.cnf -S $MASTER_MYSOCK -P $MASTER_MYPORT -uroot > $MYSQLTEST_VARDIR/tmp/bug83144.dump

DROP DATABASE db1;
DROP DATABASE db2;

--exec $MYSQL < $MYSQLTEST_VARDIR/tmp/bug83144.dump

SHOW DATABASES like 'db%';

#cleanup
DROP DATABASE db2;
--remove_file $MYSQLTEST_VARDIR/tmp/bug83144.cnf
--remove_file $MYSQLTEST_VARDIR/tmp/bug83144.dump


--echo #
--echo # Bug #32067013: MYSQLPUMP SEGMENTATION FAULT
--echo #

CREATE DATABASE B32067013;
CREATE TABLE B32067013.t1(v1 INT, v2 INT);
CREATE TABLE B32067013.t2(v1 INT, v2 INT);
CREATE VIEW B32067013.t123 AS SELECT * FROM B32067013.t1;
DROP TABLE B32067013.t1;

--echo # Test criteria: shouldn't crash
--error 76,1356
--exec $MYSQL_PUMP --all-databases > $MYSQLTEST_VARDIR/tmp/bug32067013.dump 2>&1

#cleanup
DROP DATABASE B32067013;
--remove_file $MYSQLTEST_VARDIR/tmp/bug32067013.dump


--echo #
--echo # Bug#33866103 : MYSQLPUMP [ERROR] (1356) WITH VIEW CONTAINING FROM SUBQUERY - REGRESSION
--echo #

CREATE DATABASE db1;

CREATE TABLE db1.t1 (c1 int);
CREATE TABLE db1.t2 (c1 int);

USE db1;

CREATE VIEW db1.v12 AS (SELECT * FROM (SELECT * FROM db1.t1 UNION SELECT * FROM db1.t2) AS t12);

--exec $MYSQL_PUMP -u root --result-file=$MYSQLTEST_VARDIR/tmp/bug33866103.sql

--remove_file $MYSQLTEST_VARDIR/tmp/bug33866103.sql

DROP DATABASE db1;


--echo # End of 5.7 tests