(shardingsphere) branch master updated: Added and updated syntax parsing rules to support MySQL tablespace modification operations. (#31047)

[du...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git


The following commit(s) were added to refs/heads/master by this push:
     new 280c2c70388 Added and updated syntax parsing rules to support MySQL tablespace modification operations. (#31047)
280c2c70388 is described below

commit 280c2c703888d35f9606a2aa5894c22fbc8cc8d4
Author: zhuruixuan <14...@users.noreply.github.com>
AuthorDate: Mon Apr 29 08:01:38 2024 +0800

    Added and updated syntax parsing rules to support MySQL tablespace modification operations. (#31047)
---
 .../sql/dialect/mysql/src/main/antlr4/imports/mysql/DDLStatement.g4 | 6 ++++--
 test/it/parser/src/main/resources/case/ddl/alter-tablespace.xml     | 4 ++++
 .../src/main/resources/sql/supported/ddl/alter-tablespace.xml       | 4 ++++
 3 files changed, 12 insertions(+), 2 deletions(-)

diff --git a/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DDLStatement.g4 b/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DDLStatement.g4
index 06264b80739..e7a11ad48e8 100644
--- a/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DDLStatement.g4
+++ b/parser/sql/dialect/mysql/src/main/antlr4/imports/mysql/DDLStatement.g4
@@ -377,8 +377,10 @@ alterTablespace
 
 alterTablespaceNdb
     : ALTER UNDO? TABLESPACE tablespace=identifier
-      (ADD | DROP) DATAFILE string_
-      (INITIAL_SIZE EQ_ fileSizeLiteral)?
+      ((ADD | DROP) DATAFILE string_)?
+      (INITIAL_SIZE EQ_? fileSizeLiteral)?
+      (AUTOEXTEND_SIZE EQ_? fileSizeLiteral)?
+      (ENGINE_ATTRIBUTE EQ_? string_)?
       WAIT? (RENAME TO renameTableSpace=identifier)?
       (ENGINE EQ_? identifier)?
     ;
diff --git a/test/it/parser/src/main/resources/case/ddl/alter-tablespace.xml b/test/it/parser/src/main/resources/case/ddl/alter-tablespace.xml
index 7c9dccc0ec1..cc570547409 100644
--- a/test/it/parser/src/main/resources/case/ddl/alter-tablespace.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-tablespace.xml
@@ -149,4 +149,8 @@
     <alter-tablespace sql-case-id="alter_tablespace_add_tempfile_size_m_reuse">
         <tablespace start-index="17" stop-index="22" name="lmtemp" />
     </alter-tablespace>
+    
+    <alter-tablespace sql-case-id="alter_tablespace_with_initial_size">
+        <tablespace start-index="17" stop-index="20" name="ts_1" />
+    </alter-tablespace>
 </sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/ddl/alter-tablespace.xml b/test/it/parser/src/main/resources/sql/supported/ddl/alter-tablespace.xml
index 395fefe68c7..42104be12fb 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/alter-tablespace.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-tablespace.xml
@@ -62,4 +62,8 @@
     <sql-case id="alter_tablespace_add_datafile_size_m" value="ALTER TABLESPACE lmtbsb ADD DATAFILE '/u02/oracle/data/lmtbsb02.dbf' SIZE 1M" db-types="Oracle" />
     <sql-case id="alter_tablespace_nologging" value="ALTER TABLESPACE tbs_03 NOLOGGING" db-types="Oracle" />
     <sql-case id="alter_tablespace_add_tempfile_size_m_reuse" value="ALTER TABLESPACE lmtemp ADD TEMPFILE '/u02/oracle/data/lmtemp02.dbf' SIZE 18M REUSE" db-types="Oracle" />
+    <sql-case id ="alter_tablespace_with_initial_size" value="ALTER TABLESPACE ts_1
+        ADD DATAFILE 'data_2.dat'
+        INITIAL_SIZE 48M
+        ENGINE NDB" db-types="MySQL" />
 </sql-cases>