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 6fef88ee7d2 Change Oracle supplementalIdKeyClause syntax (#27247)
6fef88ee7d2 is described below
commit 6fef88ee7d2c876623e58846514855a7eccc50fb
Author: niu niu <[email protected]>
AuthorDate: Tue Jul 18 08:08:35 2023 +0800
Change Oracle supplementalIdKeyClause syntax (#27247)
---
.../sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4 | 2 +-
test/it/parser/src/main/resources/case/ddl/alter-database.xml | 1 +
test/it/parser/src/main/resources/sql/supported/ddl/alter-database.xml | 1 +
3 files changed, 3 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 19b594951f1..8f40340fa22 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
@@ -1247,7 +1247,7 @@ supplementalLogGrpClause
;
supplementalIdKeyClause
- : DATA LP_ (ALL | PRIMARY KEY | UNIQUE | FOREIGN KEY) (COMMA_ (ALL |
PRIMARY KEY | UNIQUE | FOREIGN KEY))* RP_ COLUMNS
+ : DATA LP_ (ALL | PRIMARY KEY | UNIQUE INDEX? | FOREIGN KEY) (COMMA_ (ALL
| PRIMARY KEY | UNIQUE INDEX? | FOREIGN KEY))* RP_ COLUMNS
;
alterSession
diff --git a/test/it/parser/src/main/resources/case/ddl/alter-database.xml
b/test/it/parser/src/main/resources/case/ddl/alter-database.xml
index 61c8b8a6ea2..51bfab68e79 100644
--- a/test/it/parser/src/main/resources/case/ddl/alter-database.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-database.xml
@@ -57,6 +57,7 @@
<alter-database sql-case-id="alter_database_clear_logfile_group" />
<alter-database
sql-case-id="alter_database_clear_unarchived_logfile_group" />
<alter-database
sql-case-id="alter_database_activate_logical_standby_database_finish_apply" />
+ <alter-database
sql-case-id="alter_database_add_supplemental_log_data_primary_key_unique_index_columns"
/>
<alter-database sql-case-id="alter_database_clear_logfile" />
<alter-database
sql-case-id="alter_database_activate_physical_standby_database" />
<alter-database
sql-case-id="alter_database_add_standby_logfile_thread_size_m" />
diff --git
a/test/it/parser/src/main/resources/sql/supported/ddl/alter-database.xml
b/test/it/parser/src/main/resources/sql/supported/ddl/alter-database.xml
index c1dfc985b58..879b418b5e7 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/alter-database.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-database.xml
@@ -57,6 +57,7 @@
<sql-case id="alter_database_clear_logfile_group" value="ALTER DATABASE
CLEAR LOGFILE GROUP 3" db-types="Oracle" />
<sql-case id="alter_database_clear_unarchived_logfile_group" value="ALTER
DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2" db-types="Oracle" />
<sql-case
id="alter_database_activate_logical_standby_database_finish_apply" value="ALTER
DATABASE ACTIVATE LOGICAL STANDBY DATABASE FINISH APPLY" db-types="Oracle" />
+ <sql-case
id="alter_database_add_supplemental_log_data_primary_key_unique_index_columns"
value="ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX)
COLUMNS" db-types="Oracle" />
<sql-case id="alter_database_clear_logfile" value="ALTER DATABASE CLEAR
LOGFILE 'diskc:log3.log'" db-types="Oracle" />
<sql-case id="alter_database_activate_physical_standby_database"
value="ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE" db-types="Oracle" />
<sql-case id="alter_database_add_standby_logfile_thread_size_m"
value="ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 SIZE 500M" db-types="Oracle"
/>
