chestnut-c opened a new pull request, #9607: URL: https://github.com/apache/seatunnel/pull/9607
### Purpose of this pull request 1. Optimize and extend each jdbc data source to rewrite `getUpsertStatementByTableSchema` to obtain specific field information of the table schema when generating upsert statements. 2. Fix the problem that the vertica data source does not support the DUAL pseudo table like Oracle when rewriting, 3. Fix the problem that the Vertica jdbc reports the `[Vertica]VJDBC ERROR: Failed to find conversion function from unknown to int` type inference exception by specifying the specific field type when writing with the `MERGE INTO` syntax. fix issue: https://github.com/apache/seatunnel/issues/9534 Refer to `Vertica` official documentation: `https://docs.vertica.com/23.4.x/en/sql-reference/statements/merge/` ### Does this PR introduce _any_ user-facing change? No ### How was this patch tested? Abnormal before modification： <img width="1662" height="474" alt="Clipboard_Screenshot_1753156454" src="https://github.com/user-attachments/assets/9f89146f-891f-4df8-825a-d08f997ad684"; /> Normal operation after modification： <img width="1269" height="305" alt="Clipboard_Screenshot_1753164488" src="https://github.com/user-attachments/assets/8c0c65f8-33ce-445a-81ae-7947a376bc9a"; /> <img width="1378" height="443" alt="Clipboard_Screenshot_1753164506" src="https://github.com/user-attachments/assets/676f69bc-0f9f-477c-a369-0a29a801534c"; /> <img width="810" height="193" alt="Clipboard_Screenshot_1753164581" src="https://github.com/user-attachments/assets/f2b73e3f-faa8-4918-83d3-bc7a4c43e15d"; /> ### Check list * [ ] If any new Jar binary package adding in your PR, please add License Notice according [New License Guide](https://github.com/apache/seatunnel/blob/dev/docs/en/contribution/new-license.md) * [ ] If necessary, please update the documentation to describe the new feature. https://github.com/apache/seatunnel/tree/dev/docs * [ ] If you are contributing the connector code, please check that the following files are updated: 1. Update [plugin-mapping.properties](https://github.com/apache/seatunnel/blob/dev/plugin-mapping.properties) and add new connector information in it 2. Update the pom file of [seatunnel-dist](https://github.com/apache/seatunnel/blob/dev/seatunnel-dist/pom.xml) 4. Add ci label in [label-scope-conf](https://github.com/apache/seatunnel/blob/dev/.github/workflows/labeler/label-scope-conf.yml) 5. Add e2e testcase in [seatunnel-e2e](https://github.com/apache/seatunnel/tree/dev/seatunnel-e2e/seatunnel-connector-v2-e2e/) 6. Update connector [plugin_config](https://github.com/apache/seatunnel/blob/dev/config/plugin_config) -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
