[IGNITE-18168] SQL: incorrect sum of several FLOAT values

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0-beta1
• Component/s: sql
• Labels: calcite calcite2-required calcite3-required ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Andrey Mashenkov
• Reporter: Andrey Khitrin
• Created: 16/Nov/22 05:38
• Updated: 02/Feb/23 08:47
• Resolved: 02/Feb/23 08:47

Description

This behavior seems incorrect:

create table xx (key_field INT PRIMARY KEY,field2 FLOAT);
insert into xx (key_field,field2) values (1, 100000);
insert into xx (key_field,field2) values (2, 50000);
insert into xx (key_field,field2) values (3, 30000);
insert into xx (key_field,field2) values (4, 55555.1);
insert into xx (key_field,field2) values (5, 30000);
insert into xx (key_field,field2) values (6, 40000);
insert into xx (key_field,field2) values (7, 20000);
insert into xx (key_field,field2) values (8, 80000);
insert into xx (key_field,field2) values (9, 30000);
insert into xx (key_field,field2) values (10,90000);
insert into xx (key_field,field2) values (11,90000);
SELECT SUM(field2) FROM xx;                                
--> returns 615555.1015625, expected 615555.1