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 48e52034b57 29489 (#29490)
48e52034b57 is described below
commit 48e52034b5754f063777b44f15288a9a59fde8d6
Author: ilyas ahsan <[email protected]>
AuthorDate: Fri Dec 22 11:27:29 2023 +0700
29489 (#29490)
---
.../src/main/antlr4/imports/oracle/DDLStatement.g4 | 2 +-
.../src/main/resources/case/ddl/create-table.xml | 20 ++++++++++++++++++++
.../resources/sql/supported/ddl/create-table.xml | 2 ++
3 files changed, 23 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 0b1a055eff9..57e00966e79 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 createMemOptimizeClause createParentClause
+ : CREATE createTableSpecification TABLE tableName createSharingClause
createDefinitionClause memOptimizeClause createParentClause
;
createEdition
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 cda25f3bcac..3875cbeaa84 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
@@ -234,6 +234,26 @@
</column-definition>
</create-table>
+ <create-table sql-case-id="create_table_without_optimize_read">
+ <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>
+
+ <create-table sql-case-id="create_table_without_optimize_write">
+ <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>
+
<create-table sql-case-id="create_table_with_parent">
<table name="t_log" start-index="13" stop-index="17" />
<column-definition type="int" primary-key="true" start-index="19"
stop-index="36">
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 399c87bb8e3..b41717e8028 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
@@ -39,6 +39,8 @@
<sql-case id="create_table_with_sharing_none" value="CREATE TABLE t_log
SHARING = NONE (id int PRIMARY KEY, status varchar(10))" db-types="Oracle" />
<sql-case id="create_table_with_optimize_read" value="CREATE TABLE
t_log(id int PRIMARY KEY, status varchar(10)) MEMOPTIMIZE FOR READ"
db-types="Oracle" />
<sql-case id="create_table_with_optimize_write" value="CREATE TABLE
t_log(id int PRIMARY KEY, status varchar(10)) MEMOPTIMIZE FOR WRITE"
db-types="Oracle" />
+ <sql-case id="create_table_without_optimize_read" value="CREATE TABLE
t_log(id int PRIMARY KEY, status varchar(10)) NO MEMOPTIMIZE FOR READ"
db-types="Oracle" />
+ <sql-case id="create_table_without_optimize_write" value="CREATE TABLE
t_log(id int PRIMARY KEY, status varchar(10)) NO MEMOPTIMIZE FOR WRITE"
db-types="Oracle" />
<sql-case id="create_table_with_parent" value="CREATE TABLE t_log(id int
PRIMARY KEY, status varchar(10)) PARENT t_log_parent" db-types="Oracle" />
<sql-case id="create_object_table" value="CREATE TABLE t_log OF
t_log_type" db-types="Oracle" />
<sql-case id="create_table_with_char_varing" value="CREATE TABLE t_log(id
char varying (20))" db-types="Oracle" />
