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 2022/04/14 03:13:56 UTC

[GitHub] [shardingsphere] wayinit opened a new issue, #16807: Cannot get result in Association query with single table

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

   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy master
   ### Expected behavior
   got the count
   ### Actual behavior
   got an error
   [C1997][1997] Runtime exception: [All tables must be in the same datasource.]
   ### Reason analyze (If you can)
   I have no idea.
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   SELECT count(0)
   FROM tb_im_current_chat ticc
            LEFT JOIN tb_mem_personal tmp ON tmp.tb_mem_no = ticc.tb_user_id
   tb_im_current_chat is single table
   tb_mem_personal  is sharding table


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


[GitHub] [shardingsphere] terrymanu closed issue #16807: Cannot get result in Association query with single table

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #16807: Cannot get result in Association query with single table
URL: https://github.com/apache/shardingsphere/issues/16807


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


[GitHub] [shardingsphere] terrymanu commented on issue #16807: Cannot get result in Association query with single table

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

   Closed because of no feedback for long time


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


[GitHub] [shardingsphere] terrymanu commented on issue #16807: Cannot get result in Association query with single table

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

   Master always change, can you try to released version?


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