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)
