This is an automated email from the ASF dual-hosted git repository.
panjuan 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 6d7f6157bff Feat/oralce create tablespace 2 (#27372)
6d7f6157bff is described below
commit 6d7f6157bff3e0e0de8bf25b4e07d11e2452764d
Author: boyjoy1127 <[email protected]>
AuthorDate: Sat Jul 22 22:05:43 2023 +0800
Feat/oralce create tablespace 2 (#27372)
---
.../dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4 | 6 +++++-
test/it/parser/src/main/resources/case/ddl/create-tablespace.xml | 7 +++++++
.../src/main/resources/sql/supported/ddl/create-tablespace.xml | 7 +++++++
3 files changed, 19 insertions(+), 1 deletion(-)
diff --git
a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
index f08dfc868c1..57694e144a2 100644
--- a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
@@ -3534,7 +3534,11 @@ createTablespace
;
permanentTablespaceClause
- : TABLESPACE tablespaceName (ONLINE|OFFLINE)
+ : TABLESPACE tablespaceName (
+ (MINIMUM EXTEND sizeClause)
+ | (BLOCKSIZE INTEGER_ K?)
+ | (ONLINE|OFFLINE)
+ )
;
dropFunction
diff --git a/test/it/parser/src/main/resources/case/ddl/create-tablespace.xml
b/test/it/parser/src/main/resources/case/ddl/create-tablespace.xml
index 980676df748..68526d59fa8 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-tablespace.xml
+++ b/test/it/parser/src/main/resources/case/ddl/create-tablespace.xml
@@ -30,4 +30,11 @@
<create-tablespace
sql-case-id="create_tablespace_with_multi_filespecification" />
<create-tablespace
sql-case-id="create_tablespace_with_filespecification_next" />
<create-tablespace sql-case-id="create_tablespace_with_filespecification"
/>
+ <create-tablespace sql-case-id="create_tablespace_with_minimum_extend_k" />
+ <create-tablespace sql-case-id="create_tablespace_with_minimum_extend_m" />
+ <create-tablespace sql-case-id="create_tablespace_with_minimum_extend_g" />
+ <create-tablespace sql-case-id="create_tablespace_with_minimum_extend_t" />
+ <create-tablespace sql-case-id="create_tablespace_with_minimum_extend_p" />
+ <create-tablespace sql-case-id="create_tablespace_with_minimum_extend_e" />
+ <create-tablespace sql-case-id="create_tablespace_with_blocksize" />
</sql-parser-test-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/create-tablespace.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/create-tablespace.xml
index eb7fe6213a3..a89cbd2d53f 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/create-tablespace.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/create-tablespace.xml
@@ -39,4 +39,11 @@
DATAFILE '/u01/app/oracle/oradata/pdbseed/usertbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
TABLESPACE test_space ONLINE" db-types="Oracle" />
+ <sql-case id="create_tablespace_with_minimum_extend_k" value="CREATE
TABLESPACE test_space MINIMUM EXTEND 1K" db-types="Oracle" />
+ <sql-case id="create_tablespace_with_minimum_extend_m" value="CREATE
TABLESPACE test_space MINIMUM EXTEND 12M" db-types="Oracle" />
+ <sql-case id="create_tablespace_with_minimum_extend_g" value="CREATE
TABLESPACE test_space MINIMUM EXTEND 31G" db-types="Oracle" />
+ <sql-case id="create_tablespace_with_minimum_extend_t" value="CREATE
TABLESPACE test_space MINIMUM EXTEND 13T" db-types="Oracle" />
+ <sql-case id="create_tablespace_with_minimum_extend_p" value="CREATE
TABLESPACE test_space MINIMUM EXTEND 41P" db-types="Oracle" />
+ <sql-case id="create_tablespace_with_minimum_extend_e" value="CREATE
TABLESPACE test_space MINIMUM EXTEND 14E" db-types="Oracle" />
+ <sql-case id="create_tablespace_with_blocksize" value="CREATE TABLESPACE
test_space BLOCKSIZE 8K" db-types="Oracle" />
</sql-cases>
