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 c543cfc5893 Support parsing Oracle EXPLAIN PLAN sql #27145 (#30164)
c543cfc5893 is described below

commit c543cfc589359507247e0b183e0014a5313b5fa4
Author: ilyas ahsan <[email protected]>
AuthorDate: Sun Feb 18 14:03:17 2024 +0700

    Support parsing Oracle EXPLAIN PLAN sql #27145 (#30164)
    
    * Support parsing Oracle EXPLAIN PLAN sql #27145
    
    * Adding space between pipe
---
 .../sql/dialect/oracle/src/main/antlr4/imports/oracle/DMLStatement.g4  | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git 
a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DMLStatement.g4 
b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DMLStatement.g4
index 6839d945dbe..c94493dceb9 100644
--- a/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DMLStatement.g4
+++ b/parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DMLStatement.g4
@@ -686,7 +686,8 @@ subquery
 modelExpr
     : (numberLiterals ASTERISK_)? ((measureColumn LBT_ (condition | expr) 
(COMMA_ (condition | expr))* RBT_) 
     | (aggregationFunction LBT_ (((condition | expr) (COMMA_ (condition | 
expr))*) | (singleColumnForLoop (COMMA_ singleColumnForLoop)*) | 
multiColumnForLoop) RBT_) 
-    | analyticFunction) (PLUS_ modelExpr | ASTERISK_ numberLiterals (ASTERISK_ 
modelExpr)?)?
+    | analyticFunction) ((PLUS_ | SLASH_) LP_? modelExpr* RP_? | ASTERISK_ 
numberLiterals (ASTERISK_ modelExpr)?)?
+    | expr
     ;
 
 forUpdateClause

Reply via email to