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)?
;