xavierzhao opened a new issue, #25215: URL: https://github.com/apache/doris/issues/25215
### 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 Git : git://VM-16-12-centos@30d35c414034a82a66ab8064de2076cea77ac38c Version : doris-2.0.1-rc04 BuildInfo : VM-16-12-centos BuildTime : Tue, 29 Aug 2023 10:35:46 UTC ### What's Wrong? Run query failed with error message `[INTERNAL_ERROR]Unknown expr node type: 0` ### What You Expected? Empty set (0.00 sec) ### How to Reproduce? ```sql CREATE TABLE `t0` ( `c0` date NULL COMMENT "" ) ENGINE=OLAP DUPLICATE KEY(`c0`) COMMENT "OLAP" DISTRIBUTED BY HASH(`c0`) BUCKETS 1 PROPERTIES ( "replication_num" = "1", "in_memory" = "false", "storage_format" = "DEFAULT" ); SELECT e.c0 as date, ifnull( count( DISTINCT HOUR ( e.`c0` ) ), 0 ) AS val FROM t0 e GROUP BY date 1105 - errCode = 2, detailMessage = (****)[INTERNAL_ERROR]Unknown expr node type: 0, Time: 0.037000s ``` ### Anything Else? But after deleting the alias the result is correct ```sql SELECT e.c0, ifnull( count( DISTINCT HOUR ( e.`c0` ) ), 0 ) AS val FROM t0 e GROUP BY e.c0 Empty set (0.00 sec) ``` ### Are you willing to submit PR? - [X] 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
