8000 Convert SQL Server CDC row data following upstream and expected type · Issue #21896 · risingwavelabs/risingwave · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Convert SQL Server CDC row data following upstream and expected type #21896

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
wcy-fdu opened this issue May 16, 2025 · 0 comments
Open

Convert SQL Server CDC row data following upstream and expected type #21896

wcy-fdu opened this issue May 16, 2025 · 0 comments
Assignees
Labels
type/refactor Type: Refactoring.
Milestone

Comments

@wcy-fdu
Copy link
Contributor
wcy-fdu commented May 16, 2025

Talked with @xiangjinwu offline, For SQL Server CDC, since a third-party library is used to read snapshots, the current schema check does not take into account the schema of the upstream table but only checks the converted schema.

This will cause some problems, such as the upstream Money type will be converted to i64, but we only have this i64 and cannot determine whether the i64 is the upstream i64 or the upstream Money type. We should use the upstream datatype, the intermediate data type, and the target data type to perform schema check. Currently, for this issue, the Money type has been specially judged as a hot fix.

@wcy-fdu wcy-fdu self-assigned this May 16, 2025
@wcy-fdu wcy-fdu added the type/feature Type: New feature. label May 16, 2025
@github-actions github-actions bot added this to the release-2.5 milestone May 16, 2025
@wcy-fdu wcy-fdu added type/refactor Type: Refactoring. and removed type/feature Type: New feature. labels May 16, 2025
@xiangjinwu xiangjinwu changed the title Full schema validation for SQL Server CDC Convert SQL Server CDC row data following upstream and expected type May 16, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/refactor Type: Refactoring.
Projects
None yet
Development

No branches or pull requests

1 participant
0