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: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
