EmmyMiao87 opened a new pull request #3206: Rewritten subquery in having clause URL: https://github.com/apache/incubator-doris/pull/3206 The subquery in having clause should be rewritten too. If not, ExprRewriteRule will not be apply in subquery. For example: select k1, sum (k2) from table group by k1 having sum(k2) > (select t1 from table2 where t2 between 1 and 2); ```t1 between 1 and 2``` should be rewritten to ```t1 >=1 and t1<=2```. Fixed #3205. TPC-DS 14 will be passed after this commit.
---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
