qunqingrihe opened a new pull request, #725: URL: https://github.com/apache/incubator-seata-go/pull/725
<!-- Thanks for sending a pull request! --> **What this PR does**: This PR addresses the SQL generation and parameter handling issues in the MySQL Insert On Duplicate Key Update undo log builder. It improves the handling of primary key conditions, parameter type safety, and fixes spacing issues in SQL generation. **Which issue(s) this PR fixes**: Fixes #704 **Special notes for your reviewer**: - The changes focus on improving internal logic and maintaining backward compatibility. - Although extensive changes were made, they are confined to the MySQL undo log builder and should not affect other components. - The original code had deficiencies in SQL generation and parameter handling, which could lead to errors when dealing with complex MySQL Insert On Duplicate Key Update scenarios. Refactoring improves code readability and maintainability. - To support more edge cases and complex multi-row insert scenarios, the existing logic needed to be extended and optimized. - The previous implementation had some known bugs, and this modification aims to resolve these issues to ensure correct functionality. - Although performance has not been fully optimized, improving logic and reducing unnecessary checks can enhance performance to some extent. - Improved handling of parameter types ensures consistency and safety across different database operations. Through these improvements, I aim to provide a more robust and efficient solution to meet the project's development needs. If you encounter any issues with the refactoring, please feel free to contact me. **Does this PR introduce a user-facing change?**: ```release-note NONE -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@seata.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@seata.apache.org For additional commands, e-mail: notifications-h...@seata.apache.org