[PHOENIX-3054] Counting zero null rows returns an empty result set

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.7.0
• Fix Version/s: 4.9.0, 4.8.1
• Labels: count count(*) null sql
• Assignee: Ankit Singhal
• Reporter: Kevin Liew
• Created: 06/Jul/16 22:02
• Updated: 28/Sep/16 05:15
• Resolved: 06/Sep/16 05:47

Description

Execute the following query on a table with zero null cells.

select count(*) from table where column1 = null

The result set should consist of one cell with the value `0` but the result set is empty.