diff options
Diffstat (limited to 'mysql-test/extra/rpl_tests/rpl_delete_no_where.test')
-rw-r--r-- | mysql-test/extra/rpl_tests/rpl_delete_no_where.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/extra/rpl_tests/rpl_delete_no_where.test b/mysql-test/extra/rpl_tests/rpl_delete_no_where.test new file mode 100644 index 00000000000..4db9e0fb63f --- /dev/null +++ b/mysql-test/extra/rpl_tests/rpl_delete_no_where.test @@ -0,0 +1,19 @@ +# Test to see if a DELETE which triggers a fast deletion of all rows +# (not internally row-per-row but more like a TRUNCATE, MyISAM +# supports that), is replicated (BUG#13576). + +-- source include/master-slave.inc + +eval create table t1 (a int, b int) engine=$engine_type; +insert into t1 values(1,1); +sync_slave_with_master; +select * from t1; +connection master; +delete from t1; +sync_slave_with_master; +select * from t1; + +# cleanup +connection master; +drop table t1; +sync_slave_with_master; |