[DRILL-1619] count(boolean) always returns 'true'

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 0.7.0
• Component/s: Functions - Drill
• Assignee: DrillCommitter
• Reporter: Chun Chang
• Created: 31/Oct/14 01:06
• Updated: 09/Dec/14 17:47
• Resolved: 09/Nov/14 00:01

Description

#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)