terrymanu commented on issue #27144: URL: https://github.com/apache/shardingsphere/issues/27144#issuecomment-5329243919
Hi @FlyingZC, thanks for raising this. This has already been implemented, so we can close the issue as completed. PR #29663 added `EXPLAIN PLAN FOR` parsing with test cases covering the scenarios listed here (GROUP BY with SUM, TO_CHAR / TO_TIMESTAMP in WHERE, and schema-qualified tables such as `sh.customers`), and PR #30220 added further cases including multi-column GROUP BY, IN subqueries, and BETWEEN with TO_DATE. The current grammar in `OracleDALStatement.g4` accepts `EXPLAIN PLAN ... FOR` followed by select, insert, update, or delete, and all five example statements in this issue parse successfully on the current master. Closing as completed. Thanks for the contributions. -- 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]
