[ 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 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 was: 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 > 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 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)