[Proofread SQL Definition][MySQL]Proofread the g4 files of SQL definitions

tuichenchuxin commented 2 years ago

Hi community,

This issue is to proofread the SQL definitions of MySQL. Therefore, we can support parsing more SQLs. We need your interaction! If you

Be familiar with g4 file of Antlr (The grammars are RegularExpression-like) Understand the MySQL grammars

then welcome!

Background

How is a SQL parsed?

SQL definition file ->(Parse to) AST ->(Visit it) SQLStatment

Process

Compare SQL definitions in Oficial SQL Doc and ShardingSphere SQL Doc If there is any difference in ShardingSphere SQL Doc, please correct them referring to Official SQL Doc You can also refer to MySQL source code Run mvn install the current_file_module Check whether there are any exceptions. If indeed, please fix them. (Especially xxxVisitor.class) Add new corresponding SQL case in SQL Cases and expected parsed result in Expected Statment XML Run SQLParserParameterizedTest to make sure no exceptions.

Notice

Left recursion can not work well in Antlr4,
```
a
: b
| a b
;
b
: a c
;
c
: ...
;
```
you can consider the following one,
```
a
: b*
;
b
: a c
;
c
: ...
;
```
Here is a Chinese version for reference.

subtask
Data Definition Statements
[ ] ALTER DATABASE Statement
[ ] ALTER EVENT Statement
[ ] ALTER FUNCTION Statement
[ ] ALTER INSTANCE Statement
[ ] ALTER LOGFILE GROUP Statement
[ ] ALTER PROCEDURE Statement
[ ] ALTER SERVER Statement
[ ] ALTER TABLE Statement
[ ] ALTER TABLESPACE Statement
[ ] ALTER VIEW Statement
[ ] CREATE DATABASE Statement
[ ] CREATE EVENT Statement
[ ] CREATE FUNCTION Statement
[ ] CREATE INDEX Statement
[ ] CREATE LOGFILE GROUP Statement
[ ] CREATE PROCEDURE and CREATE FUNCTION Statements
[ ] CREATE SERVER Statement
[ ] CREATE SPATIAL REFERENCE SYSTEM Statement
[ ] CREATE TABLE Statement
[ ] CREATE TABLESPACE Statement
[ ] CREATE TRIGGER Statement
[ ] CREATE VIEW Statement
[ ] DROP DATABASE Statement
[ ] DROP EVENT Statement
[ ] DROP FUNCTION Statement
[ ] DROP INDEX Statement
[ ] DROP LOGFILE GROUP Statement
[ ] DROP PROCEDURE and DROP FUNCTION Statements
[ ] DROP SERVER Statement
[ ] DROP SPATIAL REFERENCE SYSTEM Statement
[ ] DROP TABLE Statement
[ ] DROP TABLESPACE Statement
[ ] DROP TRIGGER Statement
[ ] DROP VIEW Statement
[ ] RENAME TABLE Statement
[ ] TRUNCATE TABLE Statement
Data Manipulation Statements
[ ] CALL Statement
[ ] DELETE Statement
[ ] DO Statement
[ ] HANDLER Statement
[ ] IMPORT TABLE Statement
[ ] INSERT Statement
[ ] LOAD DATA Statement
[ ] LOAD XML Statement
[ ] REPLACE Statement
[ ] SELECT Statement
[ ] Subqueries
[ ] TABLE Statement
[ ] UPDATE Statement
[ ] VALUES Statement
[ ] WITH (Common Table Expressions)
Transactional and Locking Statements
[ ] START TRANSACTION, COMMIT, and ROLLBACK Statements
[ ] Statements That Cannot Be Rolled Back
[ ] Statements That Cause an Implicit Commit
[ ] SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements
[ ] LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements
[ ] LOCK TABLES and UNLOCK TABLES Statements
[ ] SET TRANSACTION Statement
[x] XA Transactions
Replication Statements
[ ] SQL Statements for Controlling Source Servers
[ ] SQL Statements for Controlling Replica Servers
[ ] SQL Statements for Controlling Group Replication
Prepared Statements
[ ] PREPARE Statement
[ ] EXECUTE Statement
[ ] DEALLOCATE PREPARE Statement
Compound Statement Syntax
[ ] BEGIN ... END Compound Statement
[ ] Statement Labels
[ ] DECLARE Statement
[ ] Variables in Stored Programs
[ ] Flow Control Statements
[ ] Cursors
[ ] Condition Handling
[ ] Restrictions on Condition Handling
Database Administration Statements
[ ] Account Management Statements
[ ] Resource Group Management Statements
[ ] Table Maintenance Statements
[ ] Component, Plugin, and Loadable Function Statements
[ ] CLONE Statement
[ ] SET Statements
[ ] SHOW Statements
[ ] Other Administrative Statements
Utility Statements
[x] DESCRIBE Statement
[x] EXPLAIN Statement
[x] HELP Statement
[x] USE Statement

roodkcab commented 2 years ago

XA Transaction is supported here

totalo commented 2 years ago

I will finish DESCRIBE Statement, EXPLAIN Statement,HELP Statement,USE Statement

totalo commented 2 years ago

I will finish DESCRIBE Statement, EXPLAIN Statement,HELP Statement,USE Statement

USE Statement has already supported.

totalo commented 2 years ago

I will finish Database Administration Statements.

github-actions[bot] commented 1 year ago

Hello , this issue has not received a reply for several days. This issue is supposed to be closed.

strongduanmu commented 1 year ago

This issue has not been finished, so I will reopen it.

github-actions[bot] commented 6 months ago

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

strongduanmu commented 2 months ago

Since this issue is too big, we will split it into new issues, so I will close it.

apache / shardingsphere