diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2017-05-03 12:26:57 +0200 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2017-05-04 14:33:33 +0200 |
commit | 96247be1a0dfa3035580b53b1c27a7247a410713 (patch) | |
tree | f0f5401fcd53d615048d3091749e3252eec073ef /mysql-test/t/mysqldump.test | |
parent | ba824b66c1132f1360a317eeb8b590b705f04b69 (diff) | |
download | mariadb-git-96247be1a0dfa3035580b53b1c27a7247a410713.tar.gz |
MDEV-10431: Please implement mysqldump --add-drop-trigger from MySQL 5.6
Port of mysql changeset by Georgi Kodinov <Georgi.Kodinov@Oracle.com>:
Bug #34325 : --add-drop-trigger option for mysqldump
Implemented the --add-drop-trigger option to prepend each
CREATE TRIGGER in the dump file with DROP TRIGGER.
The option is off by default. Added a test case.
Diffstat (limited to 'mysql-test/t/mysqldump.test')
-rw-r--r-- | mysql-test/t/mysqldump.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/mysqldump.test b/mysql-test/t/mysqldump.test index ea08f540cf3..6d4e0e3f2b9 100644 --- a/mysql-test/t/mysqldump.test +++ b/mysql-test/t/mysqldump.test @@ -2582,3 +2582,15 @@ let SEARCH_FILE=$MYSQLTEST_VARDIR/tmp/bug11505.sql; let SEARCH_PATTERN=Database: mysql; exec $MYSQL_DUMP mysql func > $SEARCH_FILE; source include/search_pattern_in_file.inc; + +--echo # +--echo # Test for --add-drop-trigger +--echo # +use test; +CREATE TABLE t1 (a int, b int); +CREATE TRIGGER tt1_t1 BEFORE INSERT ON t1 FOR EACH ROW + SET NEW.b=NEW.a + 10; + +INSERT INTO t1 (a) VALUES (1),(2),(3); +--exec $MYSQL_DUMP --triggers --no-data --no-create-info --add-drop-trigger --skip-comments --databases test +DROP TABLE t1; |