terrymanu commented on issue #28799: URL: https://github.com/apache/shardingsphere/issues/28799#issuecomment-5755400421
Hi @strongduanmu, Support for Oracle's legacy `(+)` outer join syntax in SQL Federation is **not planned**. The parser already recognizes this syntax. The exception occurs later because SQL Federation cannot convert `OuterJoinExpression` into Calcite SQL semantics directly. Supporting it would require an Oracle-specific semantic rewrite from `(+)` predicates to ANSI outer joins, which is outside the current SQL Federation support boundary. The query is already rejected explicitly with `UnsupportedSQLOperationException`, so it will not be executed with incorrect semantics. Please use ANSI `LEFT JOIN` or `RIGHT JOIN` syntax when SQL Federation is required. Therefore, I am closing this issue as **not planned**. -- 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]
