tristaZero opened a new issue #9426: URL: https://github.com/apache/shardingsphere/issues/9426
### Target - Collate SQL definition of `SET ROLE` to make SQL definition of `Apache ShardingSphere` the same with Oracle's. - Add a test case ### How 1. Compare `SET ROLE` definition in [Official SQL Doc](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SET-ROLE.html#GUID-863F9B6F-82B4-4C49-8E3A-3BA33AE79CAB) and [ShardingSphere SQL Doc](https://github.com/apache/shardingsphere/tree/master/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-oracle/src/main/antlr4/imports/oracle) 2. If there is any difference in ShardingSphere SQL Doc, please correct them referring to Official SQL Doc (**g4 file of ANTLR**) 3. Run `mvn install shardingsphere-sql-parser-oracle` 4. Check whether there are any exceptions. If exists, please fix them. (Please pay attention to `xxxVisitor.class`) 5. Add new corresponding SQL case in `shardingsphere-sql-parser/shardingsphere-sql-parser-test/src/main/resources/sql` and expected parsed result in `shardingsphere-sql-parser/shardingsphere-sql-parser-test/src/main/resources/case` 6. Run SQLParserParameterizedTest (`shardingsphere-sql-parser/shardingsphere-sql-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/engine/SQLParserParameterizedTest.java`). ### Tips - Since this issue is a similar one wit #9018 , whose PRs will give you some examples or hints. ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected]
