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 a620106af79 Change Oracle managedStandbyRecovery syntax (#27250)
a620106af79 is described below
commit a620106af794d46127008afa316dfcb7558e3445
Author: niu niu <[email protected]>
AuthorDate: Tue Jul 18 08:12:53 2023 +0800
Change Oracle managedStandbyRecovery syntax (#27250)
---
.../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 c2b8c340749..60940a481de 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
@@ -1401,7 +1401,7 @@ partialDatabaseRecovery
managedStandbyRecovery
: RECOVER (MANAGED STANDBY DATABASE
- ((USING ARCHIVED LOGFILE | DISCONNECT (FROM SESSION)?
+ ((USING (ARCHIVED | CURRENT) LOGFILE | DISCONNECT (FROM SESSION)?
| NODELAY
| UNTIL CHANGE NUMBER_
| UNTIL CONSISTENT | USING INSTANCES (ALL | NUMBER_) | parallelClause)+
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 02c37a0579c..93818e5213d 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
@@ -43,6 +43,7 @@
<alter-database sql-case-id="alter_database_disable_block_change_tracking"
/>
<alter-database
sql-case-id="alter_database_recover_managed_standby_database_cancel" />
<alter-database
sql-case-id="alter_database_prepare_to_switchover_to_primary" />
+ <alter-database
sql-case-id="alter_database_recover_managed_standby_database_using_current_logfile_disconnect_from_session"
/>
<alter-database
sql-case-id="alter_database_prepare_to_switchover_to_logical_standby" />
<alter-database sql-case-id="alter_database_prepare_to_switchover_cancel"
/>
<alter-database sql-case-id="alter_database_drop_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 e2dab69499e..8e9e3efac5a 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
@@ -43,6 +43,7 @@
<sql-case id="alter_database_disable_block_change_tracking" value="ALTER
DATABASE DISABLE BLOCK CHANGE TRACKING" db-types="Oracle" />
<sql-case id="alter_database_recover_managed_standby_database_cancel"
value="ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL"
db-types="Oracle" />
<sql-case id="alter_database_prepare_to_switchover_to_primary"
value="ALTER DATABASE PREPARE TO SWITCHOVER TO PRIMARY" db-types="Oracle" />
+ <sql-case
id="alter_database_recover_managed_standby_database_using_current_logfile_disconnect_from_session"
value="ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE
DISCONNECT FROM SESSION" db-types="Oracle" />
<sql-case id="alter_database_prepare_to_switchover_to_logical_standby"
value="ALTER DATABASE PREPARE TO SWITCHOVER TO LOGICAL STANDBY"
db-types="Oracle" />
<sql-case id="alter_database_prepare_to_switchover_cancel" value="ALTER
DATABASE PREPARE TO SWITCHOVER CANCEL" db-types="Oracle" />
<sql-case id="alter_database_drop_logfile_group" value="ALTER DATABASE
DROP LOGFILE GROUP 3" db-types="Oracle" />
