Chenjian created IGNITE-14948: --------------------------------- Summary: Aggregation function `avg` lose precision on decimal column Key: IGNITE-14948 URL: https://issues.apache.org/jira/browse/IGNITE-14948 Project: Ignite Issue Type: Bug Components: sql Affects Versions: 2.10 Environment: Mac os 11. JDK8 and JDK11. Reporter: Chenjian
Use sql to apply avg function on the decimal fields will lose the precision. eg. create table t1(id bigint primary key, val decimal(30, 10)); insert into t1(id, val) values (1, 100000000.000000000), (2, 123456789.987654321); then : select select avg(val) from t1; excepted : 111728394.9938271605 actual returned: 111728394.9938271600 -- This message was sent by Atlassian Jira (v8.3.4#803005)