apache / apache/shardingsphere
Support Oracle merge statement convert to SqlMerge to improve sql federation support
- Dominant language
- Java
- Stars
- 20.8k
- Forks
- 6.9k
- Avg merge
- 11h 35m
- Merged PRs (30d)
- 326
Description
## Background
On the master branch, [SQLNodeConverterEngine](https://github.com/apache/shardingsphere/blob/master/kernel/sql-federation/core/src/main/java/org/apache/shardingsphere/sqlfederation/compiler/converter/SQLNodeConverterEngine.java) already supports the conversion of most SelectStatement statements, which provides a good foundation for sql federation. In order to improve the support of sql federation for merge statement, we need to support the conversion of MergeStatement in SQLNodeConverterEngine.
Oracle merge statement doc - https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/MERGE.html#GUID-5692CCB7-24D9-4C0E-81A7-A22436DC968F
## Task
- [ ] add MergeStatementConverter implement
- [ ] add MergeStatementConverter call logic in SQLNodeConverterEngine
- [ ] add merge statement convert test case in `resources/converter` directory
Contributor guide
Assessment
This issue has not been assessed yet.