Bug #85626 rpl_filter_db_with_special_charset
Submitted: 26 Mar 2017 8:47 Modified: 30 Mar 2017 9:54
Reporter: Ben Chung Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.1,5.5,5.6,5.7, 5.7.17 OS:Any
Assigned to: CPU Architecture:Any
Tags: rpl_filter

[26 Mar 2017 8:47] Ben Chung
Description:
replicate-wild-do-table=<db>.<table>

when <db> has dot, mysql cannot separate <db> and <table> correctly

if we want to replicate table C in db A.B, we set

replicate-wild-do-table=A.B.C

but mysql will also replicate table B.C in db A.

How to repeat:
replicate-wild-do-table=<db>.<table>

when <db> has dot, mysql cannot separate <db> and <table> correctly

if we want to replicate table C in db A.B, we set

replicate-wild-do-table=A.B.C

but mysql will also replicate table B.C in db A.

Suggested fix:
replicate-wild-do-table=<db>.<table>

replicate-do-table=<db>.<table>

support any utf8 characters in <db> & <table>

replicate-wild-do-table:

<db> <table> should escape . \ _ % for parse, such as:

a_b.% => a\_b.%

a.b.c => a\.b.c

replicate-do-table:

<db> <table> should escape only . \ such as:

a.b.c => a.b.c

a\b.c => a\b.c

show slave status

replicate-wild-do-table: <db>.<table> => `<db>`.`<table>`
[30 Mar 2017 9:54] MySQL Verification Team
Hello Ben!

Thank you for the report.

Thanks,
Umesh