[Bug]: DELETE FROM whole table don't trigger CDC task

[cpegeric]

Is there an existing issue for the same bug?

• [x] I have checked the existing issues.

Branch Name

main

Commit ID

d683b6d968b1dcf34a3f0d6da1332010fff26040

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Delete from whole table doesn't trigger the CDC task.

The reason is that DELETE FROM an entire table internally invoke TRUNCATE, and TRUNCATE does not actually delete data row by row but instead recreates a new table

Expected Behavior

Delete whole table should trigger the cdc task update.

Steps to Reproduce

create cdc task.
insert rows.
and run delete table which will call truncate table.

delete from t;

Additional information

No response