search

apache / shardingsphere

Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases.
Apache License 2.0
19.92k stars 6.73k forks source link

[ OSPP 2022 ] Solve unsupported Oracle SQL about Alter Statement for ShardingSphere Parser #18389

Closed chakkk309 closed 2 years ago

chakkk309 commented 2 years ago

This issue is created to better track my PRs for OSPP 2022, you can view more about my project here.

Background

ShardingSphere Parser Engine helps users parse SQL statements into AST and generate corresponding SQL Statement objects from it.

Process

  1. Compare SQL definitions in Oficial SQL Doc and ShardingSphere SQL Doc.
  2. If there is any difference in ShardingSphere SQL Doc, please correct them by referring to the Official SQL Doc.
  3. Run mvn install the current_file_module.
  4. Check whether there are any exceptions. If indeed, please fix them. (Especially xxxVisitor.class).
  5. Add new corresponding SQL case in SQL Cases and expected parsed result in Expected Statment XML.
  6. Run SQLParserParameterizedTest to make sure no exceptions.

Tasks

This issue is a ref to https://github.com/apache/shardingsphere/issues/6480

strongduanmu commented 2 years ago

@chakkk309 Welcome to OSPP and look forward to your contribution.

strongduanmu commented 2 years ago

Great, all the subtasks have been completed. So I will close this issue.