diff options
author | unknown <aivanov@mysql.com> | 2005-12-11 17:06:36 +0300 |
---|---|---|
committer | unknown <aivanov@mysql.com> | 2005-12-11 17:06:36 +0300 |
commit | a26e2c200910287fe3b4bd68930112ad378bd58e (patch) | |
tree | 7df7f3c9ef2edd375e3ce55862aa2eb5d7359f56 /mysql-test/t/rpl_trigger.test | |
parent | f81ed05cdcad5723c986c580cfcf3ee5e22a385c (diff) | |
download | mariadb-git-a26e2c200910287fe3b4bd68930112ad378bd58e.tar.gz |
Fixed BUG #14614: Replication of tables with trigger generates
error message if database is changed.
mysql-test/r/rpl_trigger.result:
Fixed results for the added test cases
mysql-test/t/rpl_trigger.test:
Added test cases for bug #14614
sql/sql_db.cc:
Fixed bug #14614.
Modified mysql_change_db(): The memory where db name resides
is freed by a slave thread.
Diffstat (limited to 'mysql-test/t/rpl_trigger.test')
-rw-r--r-- | mysql-test/t/rpl_trigger.test | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_trigger.test b/mysql-test/t/rpl_trigger.test index bf2836b6049..fa6054372c7 100644 --- a/mysql-test/t/rpl_trigger.test +++ b/mysql-test/t/rpl_trigger.test @@ -134,6 +134,35 @@ drop function bug12480; drop table t1; # +# #14614: Replication of tables with trigger generates error message if databases is changed +# Note. The error message is emitted by _myfree() using fprintf() to the stderr +# and because of that does not fall into the .result file. +# + +create table t1 (i int); +create table t2 (i int); + +delimiter |; +create trigger tr1 before insert on t1 for each row +begin + insert into t2 values (1); +end| +delimiter ;| + +create database other; +use other; +insert into test.t1 values (1); + +save_master_pos; +connection slave; +sync_with_master; + +connection master; +use test; +drop table t1,t2; +drop database other; + +# # End of test # save_master_pos; |