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 c1021b92375 Support Oracle expr().expr() (#27884)
c1021b92375 is described below
commit c1021b92375e6b1f341789ab4d4b04ff96a2a6d6
Author: Zichao <[email protected]>
AuthorDate: Thu Aug 3 21:00:21 2023 +1200
Support Oracle expr().expr() (#27884)
---
.../oracle/src/main/antlr4/imports/oracle/BaseRule.g4 | 7 ++-----
.../src/main/resources/case/dml/select-expression.xml | 19 +++++++++++++++++++
.../resources/sql/supported/dml/select-expression.xml | 1 +
3 files changed, 22 insertions(+), 5 deletions(-)
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 3f288aae428..fc3a8b8db6e 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
@@ -328,7 +328,7 @@ unreservedWord3
| WIDTH_BUCKET | WRAPPED | XID | XMLAGG | XMLATTRIBUTES | XMLCAST |
XMLCDATA | XMLCOLATTVAL | XMLCOMMENT | XMLCONCAT | XMLDIFF
| XMLEXISTS | XMLEXISTS2 | XMLFOREST | XMLINDEX_REWRITE |
XMLINDEX_REWRITE_IN_SELECT | XMLINDEX_SEL_IDX_TBL | XMLISNODE
| XMLISVALID | XMLNAMESPACES | XMLPARSE | XMLPATCH | XMLPI | XMLQUERY |
XMLROOT | XMLSERIALIZE | XMLTABLE | XMLTOOBJECT
- | XMLTRANSFORM | XMLTRANSFORMBLOB | XML_DML_RWT_STMT | XPATHTABLE |
XS_SYS_CONTEXT | X_DYN_PRUNE
+ | XMLTRANSFORM | XMLTRANSFORMBLOB | XML_DML_RWT_STMT | XPATHTABLE |
XS_SYS_CONTEXT | X_DYN_PRUNE | RESULT
;
schemaName
@@ -682,6 +682,7 @@ bitExpr
| bitExpr SLASH_ bitExpr
| bitExpr MOD_ bitExpr
| bitExpr CARET_ bitExpr
+ | bitExpr DOT_ bitExpr
;
simpleExpr
@@ -1715,10 +1716,6 @@ capacityUnit
: ('K' | 'M' | 'G' | 'T' | 'P' | 'E')
;
-tablespaceGroupName
- : identifier
- ;
-
attributeDimensionName
: identifier
;
diff --git a/test/it/parser/src/main/resources/case/dml/select-expression.xml
b/test/it/parser/src/main/resources/case/dml/select-expression.xml
index 5ac327c61df..c888a8913f2 100644
--- a/test/it/parser/src/main/resources/case/dml/select-expression.xml
+++ b/test/it/parser/src/main/resources/case/dml/select-expression.xml
@@ -2715,4 +2715,23 @@
<simple-table start-index="99" stop-index="108" name="warehouses"
/>
</from>
</select>
+
+ <select sql-case-id="select_expr_dot_expr">
+ <projections start-index="7" stop-index="43">
+ <expression-projection start-index="7" stop-index="43"
text="DBURIType('/HR/DEPARTMENTS').getXML()">
+ <binary-operation-expression start-index="7" stop-index="43">
+ <left>
+ <function function-name="DBURIType"
text="DBURIType('/HR/DEPARTMENTS')" />
+ </left>
+ <operator>.</operator>
+ <right>
+ <function function-name="getXML" text="getXML()" />
+ </right>
+ </binary-operation-expression>
+ </expression-projection>
+ </projections>
+ <from>
+ <simple-table start-index="50" stop-index="53" name="DUAL" />
+ </from>
+ </select>
</sql-parser-test-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/dml/select-expression.xml
b/test/it/parser/src/main/resources/sql/supported/dml/select-expression.xml
index 58cc76a8769..c89f80252d6 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/select-expression.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/select-expression.xml
@@ -114,4 +114,5 @@
<sql-case id="select_with_multiset_intersect_expression" value="SELECT
customer_id, cust_address_ntab MULTISET INTERSECT DISTINCT cust_address2_ntab
multiset_intersect FROM customers_demo ORDER BY customer_id;" db-types="Oracle"
/>
<sql-case id="select_with_multiset_union_expression" value="SELECT
customer_id, cust_address_ntab MULTISET UNION cust_address2_ntab multiset_union
FROM customers_demo ORDER BY customer_id;" db-types="Oracle" />
<sql-case id="select_collect_expression" value="SELECT
CAST(COLLECT(warehouse_name ORDER BY warehouse_name) AS warehouse_name_t)
"Warehouses" FROM warehouses;" db-types="Oracle" />
+ <sql-case id="select_expr_dot_expr" value="SELECT
DBURIType('/HR/DEPARTMENTS').getXML() FROM DUAL;" db-types="Oracle" />
</sql-cases>
