You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Andrey Mashenkov (Jira)" <ji...@apache.org> on 2023/02/02 08:08:00 UTC
[jira] [Reopened] (IGNITE-18168) SQL: incorrect sum of several FLOAT values
[ https://issues.apache.org/jira/browse/IGNITE-18168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrey Mashenkov reopened IGNITE-18168:
---------------------------------------
> SQL: incorrect sum of several FLOAT values
> ------------------------------------------
>
> Key: IGNITE-18168
> URL: https://issues.apache.org/jira/browse/IGNITE-18168
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Andrey Khitrin
> Assignee: Andrey Mashenkov
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required, ignite-3
>
> This behavior seems incorrect:
> {code:sql}
> 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
> {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)