[GitHub] [shardingsphere] young138120 opened a new issue, #25301: sharding table join but not use sharding key

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

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

   I have two sharding table with sharding key named `order_id`, and they are binding table
   
   when i execute the sql , it is will block long time and will be oom after a few min
   ```sql
   select o.order_number from or_rescue_order o left join or_order_task task on task.public_no = o.public_no where o.public_no=530235903497179136;
   ```
   i just know ss proxy server goes to search all of sharding table  in memory ,but why is it do that ?
   ![image](https://user-images.githubusercontent.com/11519151/233917251-dd87aa5f-e4ac-462f-b0f3-31692a8fb21f.png)
   
   i think the ss proxy server should execute the sql on all sharding database , but the server search all of order table in memory at first 
   so all of sql like that sharding table join  should use sharding key , if not the ss proxy server will shutdown ?
   


-- 
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] strongduanmu commented on issue #25301: sharding table join but not use sharding key

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

strongduanmu commented on issue #25301:
URL: https://github.com/apache/shardingsphere/issues/25301#issuecomment-1521452894

   @young138120 Can you provide your sharding configuration? Is `public_no` a sharding key?
   


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