[shardingsphere] branch master updated: Change oracle alterSystemSetClause syntax (#27954)

[duanzhengqiang]

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 8efcc18e369 Change oracle alterSystemSetClause syntax (#27954)
8efcc18e369 is described below

commit 8efcc18e3698dcaa6ea4181ae311f126c3c5215a
Author: niu niu <zihaoa...@aliyun.com>
AuthorDate: Mon Aug 7 12:28:21 2023 +0800

    Change oracle alterSystemSetClause syntax (#27954)
---
 .../sql/dialect/oracle/src/main/antlr4/imports/oracle/DDLStatement.g4   | 2 +-
 test/it/parser/src/main/resources/case/ddl/alter-system.xml             | 2 ++
 test/it/parser/src/main/resources/sql/supported/ddl/alter-system.xml    | 2 ++
 3 files changed, 5 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 bd09d6fadef..0725a881bb2 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
@@ -2023,7 +2023,7 @@ disableAffinityClause
     ;
 
 alterSystemSetClause
-    : setParameterClause | useStoredOutlinesClause | globalTopicEnabledClause 
| dbRecoveryFileDestSizeClause
+    : setParameterClause | useStoredOutlinesClause | globalTopicEnabledClause 
| dbRecoveryFileDestSizeClause | eventsClause
     ;
 
 alterSystemResetClause
diff --git a/test/it/parser/src/main/resources/case/ddl/alter-system.xml 
b/test/it/parser/src/main/resources/case/ddl/alter-system.xml
index 17fa1fb2452..504827f1b9d 100644
--- a/test/it/parser/src/main/resources/case/ddl/alter-system.xml
+++ b/test/it/parser/src/main/resources/case/ddl/alter-system.xml
@@ -44,4 +44,6 @@
     <alter-system sql-case-id="alter_system_reset_open_cursors_scope_sid" />
     <alter-system sql-case-id="alter_system_set_db_recovery_file_dest_size_g" 
/>
     <alter-system sql-case-id="alter_system_set_parameter_recyclebin_scope" />
+    <alter-system sql-case-id="alter_system_set_events1" />
+    <alter-system sql-case-id="alter_system_set_events2" />
 </sql-parser-test-cases>
diff --git 
a/test/it/parser/src/main/resources/sql/supported/ddl/alter-system.xml 
b/test/it/parser/src/main/resources/sql/supported/ddl/alter-system.xml
index f68cce68182..a8d5c873819 100644
--- a/test/it/parser/src/main/resources/sql/supported/ddl/alter-system.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ddl/alter-system.xml
@@ -44,4 +44,6 @@
     <sql-case id="alter_system_reset_open_cursors_scope_sid" value="ALTER 
SYSTEM RESET OPEN_CURSORS SCOPE=SPFILE SID='prod1'" db-types="Oracle" />
     <sql-case id="alter_system_set_db_recovery_file_dest_size_g" value="ALTER 
SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH SID='*'" 
db-types="Oracle" />
     <sql-case id="alter_system_set_parameter_recyclebin_scope" value="ALTER 
SYSTEM SET recyclebin = ON SCOPE = SPFILE" db-types="Oracle" />
+    <sql-case id="alter_system_set_events1" value="ALTER SYSTEM SET EVENTS 
'CLIENTID_OVERWRITE'" db-types="Oracle" />
+    <sql-case id="alter_system_set_events2" value="ALTER SYSTEM SET EVENTS 
'CLIENTID_OVERWRITE OFF'" db-types="Oracle" />
 </sql-cases>