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 Kalashnikov (JIRA)" <ji...@apache.org> on 2017/05/23 13:06:04 UTC
[jira] [Assigned] (IGNITE-5245) MIN function 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 Kalashnikov reassigned IGNITE-5245:
------------------------------------------
Assignee: Sergey Kalashnikov
> 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)