You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2014/12/04 02:01:54 UTC
[jira] [Commented] (DRILL-1619) count(boolean) always returns
'true'
[ https://issues.apache.org/jira/browse/DRILL-1619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14233738#comment-14233738 ]
Chun Chang commented on DRILL-1619:
-----------------------------------
verified fix
#Wed Dec 03 20:22:10 UTC 2014
git.commit.id.abbrev=58994af
0: jdbc:drill:schema=dfs.drillTestDirMondrian> select count(t.bool) from `complex.json` t where t.bool = true;
+------------+
| EXPR$0 |
+------------+
| 500561 |
+------------+
> 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: DrillCommitter
> 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)