You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Sergey Kozlov (JIRA)" <ji...@apache.org> on 2017/05/17 11:36:04 UTC
[jira] [Updated] (IGNITE-5245) MIN returns NULL if a numeric column
of class has NULL values
[ https://issues.apache.org/jira/browse/IGNITE-5245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sergey Kozlov updated IGNITE-5245:
----------------------------------
Description:
1. Use class with the numeric field (e.g. {{Short col_Short_1}})
2. Put a few entries where that fields 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
was:
1. Use class with the numeric field (e.g. {{Short col_Short_1}})
2. Put a few entries where where that fields 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
> MIN 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
> Fix For: 2.1
>
>
> 1. Use class with the numeric field (e.g. {{Short col_Short_1}})
> 2. Put a few entries where that fields 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)