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:35:04 UTC

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

Sergey Kozlov created IGNITE-5245:
-------------------------------------

             Summary: 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 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)