[jira] [Resolved] (IGNITE-5245) MIN function returns NULL if a numeric column of class has NULL values

["Sergey Kozlov (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-5245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sergey Kozlov resolved IGNITE-5245.
-----------------------------------
    Resolution: Cannot Reproduce

> MIN function returns NULL if a numeric column of class has NULL values
> ----------------------------------------------------------------------
>
>                 Key: IGNITE-5245
>                 URL: https://issues.apache.org/jira/browse/IGNITE-5245
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.0
>            Reporter: Sergey Kozlov
>            Assignee: Sergey Kalashnikov
>             Fix For: 2.1
>
>
> 1. Use class ({{DefaultTable}}) with the numeric field (e.g. {{Short col_Short_1}})
> 2. Put a few entries where one entry has the field is null
> 3. Run query {{SELECT MIN(col_Short_1) FROM DefaultTable}}
> 4. It returns NULL but for same case h2 returns non-null minimal value



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)