[Bug] SqlServer CDC Reading all historical transaction contents of SQL server results in a long period of reading useless data

[WilliamTan778]

Search before asking

• I searched in the issues and found nothing similar.

Flink version

1.71.1

Flink CDC version

2.4.1

Database and its version

SqlServer 2019

Minimal reproduce step

源表进行insert 1000万数据, 然后delete, 重复上述操作多次
SqlServer-CDC读取的时候会读取之前所有历史的信息,才能继续后续的增量操作,时间跨度太长

What did you expect to see?

希望不需要读取之前所有的历史信息

What did you see instead?

源表进行insert 1000万数据, 然后delete, 重复上述操作多次
SqlServer-CDC读取的时候会读取之前所有历史的信息,才能继续后续的增量操作,时间跨度太长

Anything else?

No response

Are you willing to submit a PR?

• I'm willing to submit a PR!

[GOODBOY008]

@WilliamTan778 Pr #2374 had merged and feel free compile on your local.

[WilliamTan778]

thank you