m719030572 opened a new issue, #33374:
URL: https://github.com/apache/doris/issues/33374

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Version
   
   master, all branch
   
   ### What's Wrong?
   
   having with grouping_id() is not allow in new planner.
   egg select c1, c2 from t group by rollup(c1, c2) having grouping_id(c1) > 0.
   
   ### What You Expected?
   
   having with grouping_id() should be allowd in sql
   
   ### How to Reproduce?
   
   SET enable_fallback_to_original_planner=false
   SET enable_nereids_planner=true;
   Any SQL like group by rollup having grouping_id() > 0 can reproduce
   
   Code in Analyze, NormalizeAggregate Rule change LogicalHaving to 
LogicalFilter。
   Code in Rewrite, CheckAfterRewrite Rule throw this error
   
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to