laixiong opened a new issue, #57883: URL: https://github.com/apache/doris/issues/57883
### 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 2.1.8 ### What's Wrong? When using COALESCE(a, b), a simple SELECT query returns the correct value of a. However, during INSERT INTO ... SELECT COALESCE(a, b), the result column may unexpectedly contain NaN values, especially when the dataset is large. This issue is not always reproducible — it appears probabilistically depending on batch size and data distribution. 当使用 COALESCE(a, b) 表达式时，直接执行 SELECT 查询结果是正确的（返回 a 的值）。 但在执行 INSERT INTO ... SELECT COALESCE(a, b) 时，结果列中会出现 随机的 NaN 值，尤其是在数据量较大时。 该问题 并非必现，而是在一定规模的数据或特定执行路径下才出现。 This behavior occurs intermittently, especially with larger data sets or complex query plans. 在数据量较小或简单查询下通常正常，而在数据量大或复杂查询计划下更容易复现。 ### What You Expected? When b contains NaN, the inserted results sometimes become NaN instead of a. 当 b 中包含 NaN 时，插入表的结果列有时变成 NaN，而不是 a 的值。 ### 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: [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]
