[
https://issues.apache.org/jira/browse/DRILL-1619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14191975#comment-14191975
]
Aman Sinha commented on DRILL-1619:
-----------------------------------
+1 for this patch. However, I noticed that the template also allows
Boolean/Bit type for sum/min/max which don't really have meaning. Should we
take those out ?
> count(boolean) always returns 'true'
> ------------------------------------
>
> Key: DRILL-1619
> URL: https://issues.apache.org/jira/browse/DRILL-1619
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 0.7.0
> Reporter: Chun Chang
> Assignee: Venki Korukanti
> Attachments: DRILL-1619.patch
>
>
> #Wed Oct 29 09:57:56 PDT 2014
> git.commit.id.abbrev=2871c3b
> count a boolean column always return the value 'true':
> 0: jdbc:drill:schema=dfs.drillTestDirMondrian> select count(t.bool) from
> `complex.json` t where t.bool = true;
> +------------+
> | EXPR$0 |
> +------------+
> | true |
> +------------+
> 1 row selected (0.145 seconds)
> 0: jdbc:drill:schema=dfs.drillTestDirMondrian> select count(t.bool) from
> `complex.json` t where t.bool = false;
> +------------+
> | EXPR$0 |
> +------------+
> | true |
> +------------+
> 1 row selected (0.169 seconds)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
