kanha-gupta commented on code in PR #29728:
URL: https://github.com/apache/shardingsphere/pull/29728#discussion_r1452480694
##########
parser/sql/dialect/oracle/src/main/antlr4/imports/oracle/DMLStatement.g4:
##########
@@ -595,7 +595,7 @@ inlineAnalyticView
;
whereClause
- : WHERE expr
+ : WHERE expr pivotInClause?
Review Comment:
Sir it process 'IN' condition. Sql case id explain_for_select_where_colon
uses it
Since I can see in documentation that it appears after Where clause, I have
added it there only. We can add new grammar or use PivotInClause only.
There are 3 ways to process the grammar. Adding it in either of these would
enable parsing.
-Select Queries
-Where clause
-Expr
If where clause is not the appropriate place, I can consider adding it in
other two options
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/IN-Condition.html
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
