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 36b73178388 feat: support create tablespace statement. (#27230)
36b73178388 is described below
commit 36b73178388b1c819981b2897c25d5b122cd2620
Author: boyjoy1127 <[email protected]>
AuthorDate: Mon Jul 17 21:56:45 2023 +0800
feat: support create tablespace statement. (#27230)
---
.../src/main/antlr4/imports/oracle/DDLStatement.g4 | 8 ++++++
.../sql/parser/autogen/OracleStatement.g4 | 1 +
.../statement/type/OracleDDLStatementVisitor.java | 7 ++++++
.../ddl/OracleCreateTablespaceStatement.java | 29 ++++++++++++++++++++++
.../main/resources/case/ddl/create-tablespace.xml | 3 +++
.../sql/supported/ddl/create-tablespace.xml | 2 ++
6 files changed, 50 insertions(+)
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 bb9549cf8da..7fafe245dc8 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
@@ -3521,6 +3521,14 @@ dropMaterializedZonemap
: DROP MATERIALIZED ZONEMAP zonemapName
;
+createTablespace
+ : CREATE (BIGFILE|SMALLFILE)? permanentTablespaceClause
+ ;
+
+permanentTablespaceClause
+ : TABLESPACE tablespaceName (ONLINE|OFFLINE)
+ ;
+
dropFunction
: DROP FUNCTION (schemaName DOT_)? function
;
diff --git
a/parser/sql/dialect/oracle/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/OracleStatement.g4
b/parser/sql/dialect/oracle/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/OracleStatement.g4
index 5d555325902..09a1c4b562f 100644
---
a/parser/sql/dialect/oracle/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/OracleStatement.g4
+++
b/parser/sql/dialect/oracle/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/OracleStatement.g4
@@ -135,6 +135,7 @@ execute
| dropContext
| alterResourceCost
| alterRole
+ | createTablespace
| dropSequence
| dropProfile
| dropFunction
diff --git
a/parser/sql/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/oracle/visitor/statement/type/OracleDDLStatementVisitor.java
b/parser/sql/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/oracle/visitor/statement/type/OracleDDLStatementVisitor.java
index 4d75eb9e5ae..cf82eb98fe3 100644
---
a/parser/sql/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/oracle/visitor/statement/type/OracleDDLStatementVisitor.java
+++
b/parser/sql/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/oracle/visitor/statement/type/OracleDDLStatementVisitor.java
@@ -85,6 +85,7 @@ import
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.Create
import
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.CreateSequenceContext;
import
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.CreateSynonymContext;
import
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.CreateTableContext;
+import
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.CreateTablespaceContext;
import
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.DisassociateStatisticsContext;
import
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.DropClusterContext;
import
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser.DropColumnSpecificationContext;
@@ -220,6 +221,7 @@ import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.oracle.ddl.Ora
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.oracle.ddl.OracleCreateSequenceStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.oracle.ddl.OracleCreateSynonymStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.oracle.ddl.OracleCreateTableStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.oracle.ddl.OracleCreateTablespaceStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.oracle.ddl.OracleDisassociateStatisticsStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.oracle.ddl.OracleDropClusterStatement;
import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.oracle.ddl.OracleDropContextStatement;
@@ -1078,4 +1080,9 @@ public final class OracleDDLStatementVisitor extends
OracleStatementVisitor impl
public ASTNode visitDropMaterializedZonemap(final
DropMaterializedZonemapContext ctx) {
return new OracleDropMaterializedZonemapStatement();
}
+
+ @Override
+ public ASTNode visitCreateTablespace(final CreateTablespaceContext ctx) {
+ return new OracleCreateTablespaceStatement();
+ }
}
diff --git
a/parser/sql/statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/oracle/ddl/OracleCreateTablespaceStatement.java
b/parser/sql/statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/oracle/ddl/OracleCreateTablespaceStatement.java
new file mode 100644
index 00000000000..6d86482fc31
--- /dev/null
+++
b/parser/sql/statement/src/main/java/org/apache/shardingsphere/sql/parser/sql/dialect/statement/oracle/ddl/OracleCreateTablespaceStatement.java
@@ -0,0 +1,29 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.shardingsphere.sql.parser.sql.dialect.statement.oracle.ddl;
+
+import lombok.Setter;
+import
org.apache.shardingsphere.sql.parser.sql.common.statement.ddl.CreateProcedureStatement;
+import
org.apache.shardingsphere.sql.parser.sql.dialect.statement.oracle.OracleStatement;
+
+/**
+ * Oracle create tablespace statement.
+ */
+@Setter
+public final class OracleCreateTablespaceStatement extends
CreateProcedureStatement implements OracleStatement {
+}
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 c481b152e12..26592d762c0 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
@@ -23,4 +23,7 @@
<create-tablespace sql-case-id="create_tablespace_for_myisam" />
<create-tablespace sql-case-id="create_undo_tablespace_for_innodb" />
<create-tablespace sql-case-id="create_undo_tablespace_for_myisam" />
+ <create-tablespace sql-case-id="create_permanent_tablespace_online" />
+ <create-tablespace sql-case-id="create_permanent_tablespace_offline" />
+
</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 f0a17e3efd0..89db3c6d6c9 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
@@ -23,4 +23,6 @@
<sql-case id="create_tablespace_for_myisam" value="CREATE TABLESPACE
ndb_ts1 ADD DATAFILE 'ndb_ts1.dat' USE LOGFILE GROUP ndb_lg1 MAX_SIZE=10M
ENGINE=MyISAM " db-types="MySQL" />
<sql-case id="create_undo_tablespace_for_innodb" value="CREATE UNDO
TABLESPACE `ts1` ADD DATAFILE '/my/tablespace/directory/ts1.ibd'
Engine=InnoDB;" db-types="MySQL" />
<sql-case id="create_undo_tablespace_for_myisam" value="CREATE UNDO
TABLESPACE ndb_ts1 ADD DATAFILE 'ndb_ts1.dat' USE LOGFILE GROUP ndb_lg1
ENGINE=MyISAM" db-types="MySQL" />
+ <sql-case id="create_permanent_tablespace_online" value="CREATE TABLESPACE
test_space ONLINE" db-types="Oracle" />
+ <sql-case id="create_permanent_tablespace_offline" value="CREATE
TABLESPACE test_space OFFLINE" db-types="Oracle" />
</sql-cases>
