iwanttobepowerful opened a new issue, #29798: URL: https://github.com/apache/doris/issues/29798
### 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 ### What's Wrong? ` create table test(a DATE,b varchar(100),c varchar (100),d varchar(100),e int,f int) ENGINE=OLAP DUPLICATE KEY( a ) COMMENT "OLAP" DISTRIBUTED BY HASH( e ) BUCKETS auto PROPERTIES ( "replication_num" = "1" ); set experimental_enable_nereids_planner = false; select t1.a,t1.b,t1.c,t1.f,t1.d,t1.e,stddev_pop(t1.d+t1.e) std from test t1 group by t1.f,t1.d,t1.e,t1.a,t1.b,t1.c having t1.b between 'aa' and 'bb'; ` ERROR 1105 (HY000): IllegalStateException, msg: java.lang.IllegalStateException: BetweenPredicate needs to be rewritten into a CompoundPredicate. ### What You Expected? can get result ### How to Reproduce? _No response_ ### 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
