1
by brian
clean slate |
1 |
-- source include/master-slave.inc
|
2 |
||
3 |
#
|
|
4 |
# BUG#5551 "Failed OPTIMIZE TABLE is logged to binary log" |
|
5 |
# Replication should work when OPTIMIZE TABLE timeouts, and |
|
6 |
# when OPTIMIZE TABLE is executed on a non-existing table |
|
7 |
#
|
|
8 |
||
9 |
eval CREATE TABLE t1 ( a int ) ENGINE=$engine_type; |
|
10 |
BEGIN; |
|
11 |
INSERT INTO t1 VALUES (1); |
|
12 |
||
13 |
connection master1; |
|
14 |
OPTIMIZE TABLE t1; |
|
15 |
||
16 |
OPTIMIZE TABLE non_existing; |
|
17 |
sync_slave_with_master; |
|
18 |
||
19 |
# End of 4.1 tests |
|
20 |
||
21 |
connection master; |
|
22 |
select * from t1; |
|
23 |
commit; |
|
24 |
drop table t1; |