summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/mysqldump-compat.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/mysqldump-compat.test')
-rw-r--r--mysql-test/main/mysqldump-compat.test30
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/main/mysqldump-compat.test b/mysql-test/main/mysqldump-compat.test
new file mode 100644
index 00000000..ae74a760
--- /dev/null
+++ b/mysql-test/main/mysqldump-compat.test
@@ -0,0 +1,30 @@
+# Embedded server doesn't support external clients
+--source include/not_embedded.inc
+
+#
+# Bug #30126: semicolon before closing */ in /*!... CREATE DATABASE ;*/
+#
+
+--let $file = $MYSQLTEST_VARDIR/tmp/bug30126.sql
+
+CREATE DATABASE mysqldump_30126;
+USE mysqldump_30126;
+CREATE TABLE t1 (c1 int);
+--exec $MYSQL_DUMP --add-drop-database mysqldump_30126 > $file
+--exec $MYSQL mysqldump_30126 < $file
+DROP DATABASE mysqldump_30126;
+
+--remove_file $file
+use test;
+
+#
+# MDEV-19182 mysqldump not always handling SHOW CREATE TRIGGER failures correctly
+#
+create table t1 (a int);
+create trigger tr after insert on t1 for each row set @a=1;
+let $datadir=`select @@datadir`;
+move_file $datadir/test/tr.TRN $datadir/test/tr-1.TRN;
+error 2;
+exec $MYSQL_DUMP test t1 >/dev/null;
+move_file $datadir/test/tr-1.TRN $datadir/test/tr.TRN;
+drop table t1;