[OSPP 2023 ]Solve unsupported PostgreSQL about SQL dialect for ShardingSphere Parser

[wang-qingyang]

This issue is created to better track my PRs for OSPP 2023, 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.

How is a SQL parsed? SQL definition file ->(Parse to) AST ->(Visit it) SQLStatment

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 referring to Official SQL Doc
3. refer to PostgreSql source code
4. Run mvn install the current_file_module
5. Check whether there are any exceptions. If indeed, please fix them. (Especially xxxVisitor.class)
6. Add new corresponding SQL case in SQL Cases and expected parsed result in Expected Statment XML
7. Run InternalPostgreSQLParserIT and InternalUnsupportedSQLParserIT to make sure no exceptions.

Tasks

• [x] EXECUTE

• [ ] CREATE TEMPORARY

• [ ] CREATE TALBE AS SELECT

• [ ] CREATE TEMP TABLE AS SELECT

• [ ] INSERT INTO VALUES WITH SPECIAL FUNCTION

• [ ] SELECT PROJECTION WITH SPECIAL FUNCTION

• [ ] EXPLAIN

• [ ] CRATE FUNCTION

• [x] ALTER TYPE

• [ ] INSERT INTO SELECT

• [ ] MERGE INTO

• [ ] FUNCTION

• [ ] PROCEDURE

• [ ] CREATE TABLE

• [ ] CREATE TRIGGER

• [ ] CREATE USER

• [ ] CREATE VIEW

This issue is a ref to https://github.com/apache/shardingsphere/issues/14104 and https://github.com/apache/shardingsphere/issues/18496

[github-actions[bot]]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.

[github-actions[bot]]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.

[github-actions[bot]]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.