riruigit opened a new issue, #25451: URL: https://github.com/apache/doris/issues/25451
### 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 doris 2.0.1 and doris-2.0.2-rc05 version ### What's Wrong?  for example ，all column > 0 , but sum result < 0 。 ### What You Expected? sum result should > 0 ### How to Reproduce? csv data link : https://pan.baidu.com/s/1f8JWCEPdwotnWkaCem-JQw?pwd=fpax 提取码: fpax create table ddl : `CREATE TABLE `doris_decimal_sum_error` ( `FQTY` DECIMAL(23, 10) NULL, `FPRICE` DECIMAL(23, 10) NULL, `FEXCHANGERATE` DECIMAL(23, 10) NULL ) ENGINE=OLAP DUPLICATE KEY(`FQTY`, `FPRICE`) COMMENT 'OLAP' DISTRIBUTED BY HASH(`FQTY`) BUCKETS 10 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "is_being_synced" = "false", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false" );` run sql : `SELECT SUM(FQTY*FPRICE*FEXCHANGERATE) FROM doris_decimal_sum_error WHERE FQTY > 0 and FPRICE > 0 and FEXCHANGERATE > 0` ### 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
