[GitHub] [incubator-doris] EmmyMiao87 opened a new issue #3377: The incorrect result of having clause with subquery

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

EmmyMiao87 opened a new issue #3377:
URL: https://github.com/apache/incubator-doris/issues/3377


   **Describe the bug**
   1. SELECT k1 FROM test GROUP BY k1 HAVING EXISTS(SELECT k1 FROM baseall GROUP BY k1 HAVING SUM(test.k1) = k1);
   Expect : empty when having predicate is not satisfied.
   See error: return the result of select stmt without having predicate
   
   2. select k1, count(*) cnt from test group by k1 having k1 in (select k1 from baseall order by k1 limit 2) order by k1 limit 5 offset 3;
   Expect: empty
   See error: return the result of select stmt without offset.
   
   3. create view tt as select k1, count(*) cnt from test group by k1 having k1 in (select k1 from baseall order by k1 limit 2) order by k1;
   Expect: success
   ERROR 1064 (HY000): errCode = 2, detailMessage = failed to init view stmt
   


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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org