You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vyacheslav Koptilin (Jira)" <ji...@apache.org> on 2021/10/12 12:14:00 UTC
[jira] [Updated] (IGNITE-15615) Inconsistent sql result for "select
min/max" on single and multiple nodes with nulls
[ https://issues.apache.org/jira/browse/IGNITE-15615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vyacheslav Koptilin updated IGNITE-15615:
-----------------------------------------
Labels: IEP-71 (was: )
> Inconsistent sql result for "select min/max" on single and multiple nodes with nulls
> ------------------------------------------------------------------------------------
>
> Key: IGNITE-15615
> URL: https://issues.apache.org/jira/browse/IGNITE-15615
> Project: Ignite
> Issue Type: New Feature
> Reporter: Maksim Timonin
> Priority: Major
> Labels: IEP-71
>
> select min(price) from Price.
>
> Put data to Price.price: (null, null, 10, 30)
>
> 1. Start on single node - it returns null
> 2. Start on multiple nodes - it returns 10
> Signle node query doesn't start reduce phase, that filter null values in H2. So result is consistent.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)