You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2015/02/20 22:16:11 UTC
[jira] [Created] (DRILL-2277) COUNT(*) should return 0 instead of
an empty result set when there are no records
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)