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 880ea9f69e6 Change Oracle commitSwitchoverClause syntax (#27249)
880ea9f69e6 is described below
commit 880ea9f69e6f32b6d64abd17560cf8c409472ba2
Author: niu niu <[email protected]>
AuthorDate: Tue Jul 18 08:09:53 2023 +0800
Change Oracle commitSwitchoverClause syntax (#27249)
---
.../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 8f40340fa22..c2b8c340749 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
@@ -1537,7 +1537,7 @@ registerLogfileClause
commitSwitchoverClause
: (PREPARE | COMMIT) TO SWITCHOVER
- ( TO (((PHYSICAL | LOGICAL)? PRIMARY | PHYSICAL? STANDBY) ((WITH |
WITHOUT) SESSION SHUTDOWN (WAIT | NOWAIT))?
+ ( TO (((PHYSICAL | LOGICAL)? PRIMARY | PHYSICAL? STANDBY) ((WITH |
WITHOUT) SESSION SHUTDOWN (WAIT | NOWAIT)?)?
| LOGICAL STANDBY)
| CANCEL
)?
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 51bfab68e79..02c37a0579c 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
@@ -52,6 +52,7 @@
<alter-database sql-case-id="alter_database_convert_to_snapshot_standby" />
<alter-database
sql-case-id="alter_database_commit_to_switchover_to_primary" />
<alter-database
sql-case-id="alter_database_commit_to_switchover_to_logical_standby" />
+ <alter-database
sql-case-id="alter_database_commit_to_switchover_to_primary_with_session_shutdown"
/>
<alter-database
sql-case-id="alter_database_clear_unarchived_logfile_group_unrecoverable_datafile"
/>
<alter-database sql-case-id="alter_database_archivelog" />
<alter-database sql-case-id="alter_database_clear_logfile_group" />
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 879b418b5e7..e2dab69499e 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
@@ -52,6 +52,7 @@
<sql-case id="alter_database_convert_to_snapshot_standby" value="ALTER
DATABASE CONVERT TO SNAPSHOT STANDBY" db-types="Oracle" />
<sql-case id="alter_database_commit_to_switchover_to_primary" value="ALTER
DATABASE COMMIT TO SWITCHOVER TO PRIMARY" db-types="Oracle" />
<sql-case id="alter_database_commit_to_switchover_to_logical_standby"
value="ALTER DATABASE COMMIT TO SWITCHOVER TO LOGICAL STANDBY"
db-types="Oracle" />
+ <sql-case
id="alter_database_commit_to_switchover_to_primary_with_session_shutdown"
value="ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN"
db-types="Oracle" />
<sql-case
id="alter_database_clear_unarchived_logfile_group_unrecoverable_datafile"
value="ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2 UNRECOVERABLE DATAFILE"
db-types="Oracle" />
<sql-case id="alter_database_archivelog" value="ALTER DATABASE ARCHIVELOG"
db-types="Oracle" />
<sql-case id="alter_database_clear_logfile_group" value="ALTER DATABASE
CLEAR LOGFILE GROUP 3" db-types="Oracle" />
