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

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

Rahul Challapalli created DRILL-2277:
----------------------------------------

             Summary: COUNT(*) should return 0 instead of an empty result set when there are no records
                 Key: DRILL-2277
                 URL: https://issues.apache.org/jira/browse/DRILL-2277
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
            Reporter: Rahul Challapalli
            Assignee: Daniel Barclay (Drill)
            Priority: Critical


git.commit.id.abbrev=6676f2d

Data Set :
{code}
{
 "id":1
}
{code}

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

Postgres returns 0 in this case.

Marking it as critical since we return an incorrect result



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)