[GitHub] [superset] zhaoyongjie commented on issue #18670: aggregate grain and filter grain are different so get incorrent results in explore page

[GitBox <gi...@apache.org>]

zhaoyongjie commented on issue #18670:
URL: https://github.com/apache/superset/issues/18670#issuecomment-1035990851


   This query may cause some potential problems. If January 1st is a Friday, then there will be an extra Monday to Tuesday records. 
   
   SQL Engine executed `where clause` is before the `group-by clause`, so some database engines will filter out the appropriate `where data first`, then it calculate `group by` clause. different databases may get different results for such statements. 


-- 
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@superset.apache.org

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



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org