codenohup opened a new issue, #19370: URL: https://github.com/apache/doris/issues/19370
### 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 Apache Doris 1.2.2 RELEASE ### What's Wrong? I'm trying to add Apache Doris support to SQLancer, this may be a logic bug found by @[SQLancer](https://github.com/sqlancer/sqlancer). You can reproduce this error from the following steps. 1. data prepare ``` CREATE DATABASE database0; USE database0; CREATE TABLE t0(c0 DECIMALV3(8,2) NOT NULL) UNIQUE KEY(c0) DISTRIBUTED BY HASH (c0) PROPERTIES ("replication_num" = "1"); INSERT INTO t0 (c0) VALUES (0.44777220487594604); INSERT INTO t0 (c0) VALUES (0.154103085398674); INSERT INTO t0 (c0) VALUES (0.1650441288948059); INSERT INTO t0 (c0) VALUES (0.34528547525405884); INSERT INTO t0 (c0) VALUES (0.1154308021068573); INSERT INTO t0 (c0) VALUES (0.15414485335350037); ``` 2. ```select t0.c0 from t0 group by t0.c0;``` The result of this SQL is as follows, which is correct  3. ```select t0.c0 from t0 group by t0.c0 having t0.c0 is not null;``` But if we add `having` in sql, an internal error occurs  ### What You Expected? SQL ```select t0.c0 from t0 group by t0.c0 having t0.c0 is not null;``` should not throw error, and return correct results. ### 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
