[DRILL-2277] COUNT(*) should return 0 instead of an empty result set when there are no records

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.0.0
• Component/s: Functions - Drill
• Assignee: Mehant Baid
• Reporter: Rahul Kumar Challapalli
• Created: 20/Feb/15 21:15
• Updated: 18/Sep/15 17:41
• Resolved: 27/Apr/15 20:53

Description

git.commit.id.abbrev=6676f2d

Data Set :

{
 "id":1
}

Query :

select count(*) from `temp.json` where uid < 1;
+------------+
|   EXPR$0   |
+------------+
+------------+

Postgres returns 0 in this case.

Marking it as critical since we return an incorrect result

Issue Links

• duplicates: DRILL-2398 IS NOT DISTINCT FROM predicate returns incorrect result when used as a join filter
• duplicates: DRILL-2411 Scalar SUM/AVG over empty result set returns no rows instead of NULL
• requires: DRILL-2870 Fix return type of aggregate functions to be nullable