julien-duponchelle / julien-duponchelle/python-mysql-replication

QueryEvent doesn't respect only_schemas/ignore_schemas as row events

Open
#248 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
2.4k
Forks
690
PR merge metrics
No merged PRs in 30d

Description

Hi, guys.
First thank you for your great work.

I found that QueryEvent that will create/alter tables in other databases still returns even I set only_schemas. From source code, I can see that only_schemas/ignore_schemas are ignored in QueryEvent.

Expectation:
QueryEvent will respect the filtering arguments passed to BinLogStreamReader.

Contributor guide

Open the contributing guide

Research direction

Start by tracing QueryEvent handling in BinLogStreamReader and compare it with the schema filtering applied to row events. Done means only_schemas and ignore_schemas also filter QueryEvent table changes from other databases, with both filtering behaviors verified.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, python
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.