You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by ch...@apache.org on 2025/07/25 11:02:58 UTC

(shardingsphere) branch master updated: Add support for COLON_ parameter marker in Oracle

This is an automated email from the ASF dual-hosted git repository.

chengzhang 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 95429a501e8 Add support for COLON_ parameter marker in Oracle
95429a501e8 is described below

commit 95429a501e89f56ee70fad157e9a4db92638109b
Author: Cong Hu <ia...@gmail.com>
AuthorDate: Fri Jul 25 19:02:52 2025 +0800

    Add support for COLON_ parameter marker in Oracle
    
    Add support for COLON_ parameter marker in Oracle
---
 RELEASE-NOTES.md                                                     | 1 +
 parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4 | 3 ++-
 2 files changed, 3 insertions(+), 1 deletion(-)

diff --git a/RELEASE-NOTES.md b/RELEASE-NOTES.md
index 1ad5b27a391..8e8d74f49b8 100644
--- a/RELEASE-NOTES.md
+++ b/RELEASE-NOTES.md
@@ -66,6 +66,7 @@
 1. SQL Parser: Support Hive TRUNCATE TABLE statement parse - [#36049](https://github.com/apache/shardingsphere/pull/36049)
 1. SQL Parser: Support Hive ALTER TABLE statement parse - [#36066](https://github.com/apache/shardingsphere/pull/36066)
 1. SQL Binder: Fix is unable to find the outer table in the ExistsSubqueryExpressionBinder - [#36068](https://github.com/apache/shardingsphere/pull/36068)
+1. SQL Parser: Add support for COLON_ parameter marker in Oracle - [#36076](https://github.com/apache/shardingsphere/pull/36076)
 
 ### Bug Fixes
 
diff --git a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4 b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
index 4dfdd772c76..b8808083074 100644
--- a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/BaseRule.g4
@@ -21,6 +21,7 @@ import Symbol, Keyword, OracleKeyword, Literals;
 
 parameterMarker
     : QUESTION_
+    | COLON_ (identifier | INTEGER_)
     ;
 
 literals
@@ -569,7 +570,7 @@ jsonOnNullClause
 jsonReturnClause
     : RETURNING VARCHAR2 (LP_ INTEGER_ ( BYTE | CHAR)? RP_)?
     ;
-    
+
 jsonObjectKeyValue
     : (KEY? expr VALUE expr) (FORMAT JSON)?
     ;