Bug #85626 rpl_filter_db_with_special_charset

• Submitted: 26 Mar 2017 8:47
• Modified: 30 Mar 2017 9:54
• Reporter: Ben Chung
• Status: Verified
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• Version: 5.1,5.5,5.6,5.7, 5.7.17
• OS: Any
• 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