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/05/25 03:03:43 UTC

[GitHub] [shardingsphere] prefect1005 opened a new issue #5773: parse sql suggestion

prefect1005 opened a new issue #5773:
URL: https://github.com/apache/shardingsphere/issues/5773


   if query sql contains "user.id = order.userId" and specify "order.userId = xxx",
   at this moment, sql parse by "order.userId = xxx" to confirm table "order" actual query, 
   but table "user" don't filter by any condition, that cause full physical table "user" will be query 
   
   whether or not we can parse sql automatic add "user.id = xxx" and the same parameters  in order to reduce the size of query table "user".


----------------------------------------------------------------
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 #5773: parse sql suggestion

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


   


----------------------------------------------------------------
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 #5773: parse sql suggestion

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


   If user.id is sharding key, you should explicitly set user.id=1234 to let sql parser know how to shard. A parser don't know a deep calculation such as a=b and b=1234.


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