mysql-test/suite/rpl/include/rpl_delete_no_where.test
raw| 1 | # Test to see if a DELETE which triggers a fast deletion of all rows |
| 2 | # (not internally row-per-row but more like a TRUNCATE, MyISAM |
| 3 | # supports that), is replicated (BUG#13576). |
| 4 | |
| 5 | eval create table t1 (a int, b int) engine=$engine_type; |
| 6 | insert into t1 values(1,1); |
| 7 | sync_slave_with_master; |
| 8 | select * from t1; |
| 9 | connection master; |
| 10 | delete from t1; |
| 11 | sync_slave_with_master; |
| 12 | select * from t1; |
| 13 | |
| 14 | # cleanup |
| 15 | connection master; |
| 16 | drop table t1; |
| 17 | sync_slave_with_master; |