tiflow
tiflow copied to clipboard
eventFilter incorrectly affects update events
What did you do?
- create a changefeed with config
[filter]
rules = ['test.*']
[[filter.event-filters]]
matcher = ['test.t']
ignore-event = ["delete"] # filter out delete event of table `test.t`
- run sql
create table t (a int primary key);
insert into t values (1),(2);
update t set a = 3 where a = 1;
What did you expect to see?
data should be equivalent
What did you see instead?
The following tables contains inconsistent data
+------------+---------+--------------------+----------------+---------+-----------+
| TABLE | RESULT | STRUCTURE EQUALITY | DATA DIFF ROWS | UPCOUNT | DOWNCOUNT |
+------------+---------+--------------------+----------------+---------+-----------+
| `test`.`t` | succeed | true | +0/-1 | 2 | 3 |
+------------+---------+--------------------+----------------+---------+-----------+
fix sql:
DELETE FROM `test`.`t` WHERE `a` = 1 LIMIT 1;
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