Config `case-sensitive` Not affecting eventFilter.

[asddongmen]

What did you do?

1. create a changefeed with config as fllow:

case-sensitive = false
[filter]
rules = ['test.t']
[[filter.event-filters]]
matcher = ['test.t'] 
ignore-event = ["delete"] # filter out delete event of table `test.t` 

2. Delele a row of test.T in upstream TiDB.

What did you expect to see?

TiCDC ignores the DELETE event.

What did you see instead?

TiCDC replicated the DELETE event.

Versions of the cluster

Upstream TiDB cluster version (execute SELECT tidb_version(); in a MySQL client):

(paste TiDB cluster version here)

Upstream TiKV version (execute tikv-server --version):

(paste TiKV version here)

TiCDC version (execute cdc version):

master

[asddongmen]

The root cause of this issue is that the eventFilter is not affected by the case-sensitive = false config, which contradicts the official documentation: https://arc.net/l/quote/hyfhxvkb

[flowbehappy]

Will only fix in the new release version, starting from v9.0. For previous version, we can workaround by exact match.

[wlwilliamx]

Will only fix in the new release version, starting from v9.0. For previous version, we can workaround by exact match.

Fixed in new TiCDC: https://github.com/pingcap/ticdc/pull/1810, close it.