Skip to content
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.

Sign up for GitHub

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

Jump to bottom

针对mysql 有replace语句的进行更新优化 #4

Open
baisui1981 opened this issue Aug 8, 2022 · 0 comments
Open

针对mysql 有replace语句的进行更新优化 #4

baisui1981 opened this issue Aug 8, 2022 · 0 comments

Comments

@baisui1981
Copy link
Member

我在实际测试过程中，发现source中 执行update语句操作，根据DynamicPreparedStmt 的执行逻辑 在mysql中也是会根据UPDATE_BEFORE，和UPDATE_AFTER 分成一个 delete 语句和一个 insert语句来实现sink端的 更新，实际上mysql有 replace 只需要一句 就能执行了。

https://github.com/DTStack/chunjun/blob/4ff992cf68ea890161eb42b8c22762c9ea4f1e00/chunjun-connectors/chunjun-connector-jdbc-base/src/main/java/com/dtstack/chunjun/connector/jdbc/sink/DynamicPreparedStmt.java#L134-L155
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@baisui1981