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/04/27 09:51:36 UTC
[GitHub] [shardingsphere] LikeBigCat opened a new issue #5347: count(DISTINCT xx) has problem
LikeBigCat opened a new issue #5347:
URL: https://github.com/apache/shardingsphere/issues/5347
Logic SQL: SELECT count(p.id) as pCount, count(DISTINCT p.store_id) as sCount FROM prescription p
Actual SQL ::: SELECT DISTINCT count(p.id) as pCount, p.store_id as sCount FROM prescription_0 p
The semantics here have changed
----------------------------------------------------------------
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] tristaZero commented on issue #5347: count(DISTINCT xx) has problem
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #5347:
URL: https://github.com/apache/shardingsphere/issues/5347#issuecomment-619899998
@LikeBigCat Hi Thanks for your feedback, but I am sorry this type of SQL is not supported currently. You can look up more in [Supported SQL](https://shardingsphere.apache.org/document/current/en/features/sharding/use-norms/sql/)
----------------------------------------------------------------
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