summaryrefslogtreecommitdiff
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.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/mysqldump-compat.test b/mysql-test/main/mysqldump-compat.test
index 9a830b16f26..ae74a760953 100644
--- a/mysql-test/main/mysqldump-compat.test
+++ b/mysql-test/main/mysqldump-compat.test
@@ -15,3 +15,16 @@ CREATE TABLE t1 (c1 int);
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;