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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 2.0
• Fix Version/s: 2.1
• Component/s: sql
• Assignee: Sergey Kalashnikov
• Reporter: Sergey Kozlov
• Created: 17/May/17 11:34
• Updated: 24/May/17 08:23
• Resolved: 24/May/17 08:23

Description

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