You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2023/12/25 03:20:40 UTC
(shardingsphere) branch master updated: 29522 (#29524)
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 bdcc9c46372 29522 (#29524)
bdcc9c46372 is described below
commit bdcc9c463725dc62083756b1d45b01c5dfb6e6a2
Author: ilyas ahsan <me...@gmail.com>
AuthorDate: Mon Dec 25 10:20:34 2023 +0700
29522 (#29524)
---
.../oracle/src/main/antlr4/imports/oracle/DDLStatement.g4 | 6 +++++-
test/it/parser/src/main/resources/case/ddl/create-table.xml | 10 ++++++++++
.../src/main/resources/sql/supported/ddl/create-table.xml | 1 +
3 files changed, 16 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 38b77e255fb..3261c446847 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
@@ -29,7 +29,7 @@ createView
;
createTable
- : CREATE createTableSpecification TABLE tableName createSharingClause createDefinitionClause memOptimizeClause createParentClause
+ : CREATE createTableSpecification TABLE tableName createSharingClause createDefinitionClause memOptimizeClause createParentClause createQueueClause
;
createEdition
@@ -256,6 +256,10 @@ createObjectTableClause
oidClause? oidIndexClause? physicalProperties? tableProperties?
;
+createQueueClause
+ : (USAGE QUEUE)?
+ ;
+
relationalProperties
: relationalProperty (COMMA_ relationalProperty)*
;
diff --git a/test/it/parser/src/main/resources/case/ddl/create-table.xml b/test/it/parser/src/main/resources/case/ddl/create-table.xml
index 3875cbeaa84..d068e74876b 100644
--- a/test/it/parser/src/main/resources/case/ddl/create-table.xml
+++ b/test/it/parser/src/main/resources/case/ddl/create-table.xml
@@ -2312,4 +2312,14 @@
<column name="credit_limit" start-index="177" stop-index="188" />
</column-definition>
</create-table>
+
+ <create-table sql-case-id="create_table_with_queue">
+ <table name="t_log" start-index="13" stop-index="17" />
+ <column-definition type="int" primary-key="true" start-index="19" stop-index="36">
+ <column name="id" />
+ </column-definition>
+ <column-definition type="varchar" start-index="39" stop-index="56">
+ <column name="status" />
+ </column-definition>
+ </create-table>
</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/ddl/create-table.xml b/test/it/parser/src/main/resources/sql/supported/ddl/create-table.xml
index b41717e8028..7044f6eddee 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/create-table.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/create-table.xml
@@ -298,4 +298,5 @@
(PARTITION p1 VALUES LESS THAN (1000),
PARTITION p2 VALUES LESS THAN (2500),
PARTITION p3 VALUES LESS THAN (MAXVALUE))" db-types="Oracle" />
+ <sql-case id="create_table_with_queue" value="CREATE TABLE t_log(id int PRIMARY KEY, status varchar(10)) USAGE QUEUE" db-types="Oracle" />
</sql-cases>