Description:
--replicate-wild-do-table filter failed with error 1049 when doing
replication.
How to repeat:
1. rpl_do_filter.test:
-- source include/master-slave.inc
-- source include/have_binlog_format_statement.inc
-- source extra/rpl_tests/rpl_filters.test
2. extra/rpl_tests/rpl_filters.test:
CREATE DATABASE mydb;
USE mydb;
CREATE TABLE T1 (a INT) ENGINE= MYISAM;
CREATE TABLE t2 (a INT) ENGINE= MYISAM;
INSERT INTO T1 VALUES (1);
INSERT INTO t2 VALUES (1);
-- echo # On master
-- source include/show_binlog_events.inc
-- sync_slave_with_master
-- echo # On slave
-- source include/show_binlog_events.inc
-- connection master
DROP DATABASE mydb;
-- sync_slave_with_master
3. rpl_do_filter-slave.opt
--replicate-do-db=MYDB --replicate-do-table=mydb.T1 --replicate-wild-do-table=mydb.T2 --lower_case_table_names=1
4. rpl_do_filter-master.opt
--lower_case_table_names=1
mysql-test$ ./mtr rpl_do_filter
rpl.rpl_do_filter 'stmt' [ fail ]
Test ended at 2010-09-02 10:46:16
CURRENT_TEST: rpl.rpl_do_filter
=== SHOW MASTER STATUS ===
---- 1. ----
File slave-bin.000001
Position 107
Binlog_Do_DB
Binlog_Ignore_DB
==========================
=== SHOW SLAVE STATUS ===
---- 1. ----
Slave_IO_State Waiting for master to send event
Master_Host 127.0.0.1
Master_User root
Master_Port 13000
Connect_Retry 1
Master_Log_File master-bin.000001
Read_Master_Log_Pos 842
Relay_Log_File slave-relay-bin.000003
Relay_Log_Pos 337
Relay_Master_Log_File master-bin.000001
Slave_IO_Running Yes
Slave_SQL_Running No
Replicate_Do_DB MYDB
Replicate_Ignore_DB
Replicate_Do_Table mydb.T1
Replicate_Ignore_Table
Replicate_Wild_Do_Table mydb.T2
Replicate_Wild_Ignore_Table
Last_Errno 1049
Last_Error Error 'Unknown database 'mydb'' on query. Default database: 'mydb'. Query: 'CREATE TABLE T1 (a INT) ENGINE= MYISAM'