TiCDC cannot filter DDL statements

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: ticdc 不能过滤DDL语句

| username: leoones

[Overview] Scenario + Problem Overview
ticdc pushing data to downstream Kafka cannot filter DDL.
ticdc changefeed.toml

Problem Description:
Executing the following statements causes all table data to be pushed to the Kafka topic:
alter table product_asin_event modify item_height DECIMAL (27, 15) UNSIGNED NOT NULL;
alter table product_asin_event modify item_length DECIMAL ( 27, 15 ) UNSIGNED NOT NULL;
alter table product_asin_event modify item_width DECIMAL ( 27, 15 ) UNSIGNED NOT NULL;
alter table product_asin_event modify item_weight DECIMAL ( 27, 15 ) UNSIGNED NOT NULL;
alter table product_asin_event modify package_height DECIMAL ( 27, 15 ) UNSIGNED NOT NULL;
alter table product_asin_event modify package_length DECIMAL ( 27, 15 ) UNSIGNED NOT NULL;
alter table product_asin_event modify package_width DECIMAL ( 27, 15 ) UNSIGNED NOT NULL;
alter table product_asin_event modify package_weight DECIMAL ( 27, 15 ) UNSIGNED NOT NULL;

How can I avoid pushing all rows of the table data?

[TiDB Version]
tidb v5.4.0
ticdc v5.4.0

| username: Min_Chen | Original post link

Hello, ticdc currently does not support filtering DDL. I couldn’t reproduce the issue where an alter table causes all data in the table to be pushed down locally.

Additionally, ticdc has removed cyclic replication starting from version 5.3.0. For reference, see TiCDC 简介 | PingCAP 文档中心

| username: leoones | Original post link

I just executed the following statement againimage

Then I went to consume the Kafka topic and found that the number of rows in the entire table was pushed down.

| username: ZhaoYilin-PingCAP | Original post link

Hello.
TiCDC will support the DDL filtering feature in version v6.2.0.
Additionally, the issue you mentioned about TiCDC pushing down the entire table after executing certain DDLs is a known defect and will be fixed in future versions. Filtering related DDLs cannot solve the problem.

| username: Tank001 | Original post link

Not supported.

| username: system | Original post link

This topic will be automatically closed 60 days after the last reply. No new replies are allowed.