diff options
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; |