You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/09/08 07:57:16 UTC

[GitHub] [shardingsphere] chana71 opened a new issue #7326: can not find owner from table when select from a,b with where condition

chana71 opened a new issue #7326:
URL: https://github.com/apache/shardingsphere/issues/7326


   ## Bug Report
   This type SQL `select from (subquery)a, (subquery)b where a.id=b.aid` will report the error below. It should work as `join ... on`. Will this be fixed? Thx
   ![image](https://user-images.githubusercontent.com/31340809/92448162-ccde8d80-f1ea-11ea-8971-1736ba37c2e7.png)
   
   ### Which version of ShardingSphere did you use?
   master 
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   proxy
   ### Expected behavior
   
   ### Actual behavior
   
   ### 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.

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

[GitHub] [shardingsphere] kimmking commented on issue #7326: can not find owner from table when select from a,b with where condition

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #7326:
URL: https://github.com/apache/shardingsphere/issues/7326#issuecomment-688724644


   It's doesn't support now, and no plan for enhancement.
   refer: https://shardingsphere.apache.org/document/current/cn/features/sharding/use-norms/sql/#%E4%B8%8D%E6%94%AF%E6%8C%81%E7%9A%84sql


----------------------------------------------------------------
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.

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

[GitHub] [shardingsphere] kimmking closed issue #7326: can not find owner from table when select from a,b with where condition

Posted by GitBox <gi...@apache.org>.
kimmking closed issue #7326:
URL: https://github.com/apache/shardingsphere/issues/7326


   


----------------------------------------------------------------
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.

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

[GitHub] [shardingsphere] chana71 commented on issue #7326: can not find owner from table when select from a,b with where condition

Posted by GitBox <gi...@apache.org>.
chana71 commented on issue #7326:
URL: https://github.com/apache/shardingsphere/issues/7326#issuecomment-688794981


   @kimmking sorry I don't figure out which one belongs to my case in your ref.
   Besides how about this one `select from (subquery)a join (subquery)b on a.id = b.id where a.id=?`.  Report the same error. will this be fixed?


----------------------------------------------------------------
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.

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