[I] SQL syntax exception occurs when I execute `select * from t1,t2 where t1.id(+)=t2.id` with oracle [shardingsphere]

["strongduanmu (via GitHub)" <gi...@apache.org>]

strongduanmu opened a new issue, #28799:
URL: https://github.com/apache/shardingsphere/issues/28799

   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   
   [299fecc](https://github.com/apache/shardingsphere/commit/299fecc718ada7737f77b98d58caf5c3f70eb0f7)
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   ShardingSphere-JDBC
   
   ### Expected behavior
   
   Parse `select * from t1,t2 where t1.id(+)=t2.id` successfully.
   
   ### Actual behavior
   
   ```
   java.sql.SQLException: You have an error in your SQL syntax: select * from t1,t2 where t1.id(+)=t2.id, no viable alternative at input 'select*fromt1,t2wheret1.id(+)' at line 1, position 33, near [@12,33:33=')',<31>,1:33]
   ```
   
   ### Reason analyze (If you can)
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ### Example codes for reproduce this issue (such as a github link).
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] Unsupported SQL operation: unsupported TableSegment type occurs when I execute `select * from t1,t2 where t1.id(+)=t2.id` with oracle [shardingsphere]

["terrymanu (via GitHub)" <gi...@apache.org>]

terrymanu closed issue #28799: Unsupported SQL operation: unsupported TableSegment type occurs when I execute `select * from t1,t2 where t1.id(+)=t2.id` with oracle
URL: https://github.com/apache/shardingsphere/issues/28799


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] Unsupported SQL operation: unsupported TableSegment type occurs when I execute `select * from t1,t2 where t1.id(+)=t2.id` with oracle [shardingsphere]

["github-actions[bot] (via GitHub)" <gi...@apache.org>]

github-actions[bot] commented on issue #28799:
URL: https://github.com/apache/shardingsphere/issues/28799#issuecomment-1817623255

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] Unsupported SQL operation: unsupported TableSegment type occurs when I execute `select * from t1,t2 where t1.id(+)=t2.id` with oracle [shardingsphere]

["terrymanu (via GitHub)" <gi...@apache.org>]

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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org