strongduanmu opened a new pull request, #40207: URL: https://github.com/apache/shardingsphere/pull/40207
Oracle database-link table names can lose their link metadata or include the link in the table-name span, and anonymous PL/SQL blocks omit their internal SQL segments. Changes proposed in this pull request: - Parse remote Oracle procedure/function calls, remote sequence references, schema-qualified %TYPE declarations, and PL/SQL record field defaults. - Preserve anonymous-block SQL statements, variables, cursor loops, tables, and columns in the parsed statement. - Preserve database links and bare table-name spans during parsing and binding; resolve qualified GROUP BY columns against source tables. - Add the corresponding SQL fixtures and DBLink assertions, completing existing XML expectations while preserving the current strict assertions. Validation: | Check | Result | | --- | --- | | Scoped clean install of affected parser/binder modules | Passed | | Binder core unit tests | 369 passed | | Binder integration tests | 111 passed | | Oracle supported/unsupported parser integration tests | 2,035 passed | | SQL federation SimpleTableConverterTest | 3 passed | | File-scoped Spotless and Checkstyle | All 10 changed Java files passed | The full repository `./mvnw clean install -B -T1C -Pcheck` command was not run. --- Before submitting this PR, I confirm that: - [x] My code follows the [code of conduct](https://shardingsphere.apache.org/community/en/involved/conduct/code/) of this project. - [x] I have reviewed my changes. - [x] I have (or in comment I request) added corresponding labels for the pull request. - [ ] I have passed the required local checks: `./mvnw clean install -B -T1C -Pcheck`. - [ ] I have updated the relevant documentation, if applicable. - [x] I have added or updated unit tests for my changes, if applicable. - [ ] I have updated the Release Notes of the current development version, if applicable. For more details, see [Update Release Note](https://shardingsphere.apache.org/community/en/involved/contribute/contributor/). - [ ] I have disclosed the tool and affected files or scope for any material AI assistance, as required by the [AI-assisted contribution policy]. [AI-assisted contribution policy]: https://github.com/apache/shardingsphere/blob/master/AI_POLICY.md -- 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]
