[DRILL-1898] SELECT DISTINCT fails when applied to boolean column

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 0.8.0
• Assignee: Mehant Baid
• Reporter: Julian Hyde
• Created: 19/Dec/14 03:22
• Updated: 28/Dec/14 21:15
• Resolved: 26/Dec/14 05:40

Description

SELECT DISTINCT fails when applied to boolean column.

0: jdbc:drill:zk=local> select distinct `bool_val` from `sys`.`options`;
Query failed: Query failed: Failure while running fragment., Failure finding function that runtime code generation expected.  Signature: compare_to( BIT:OPTIONALBIT:OPTIONAL,  ) returns INT:REQUIRED [ af1536ff-eca4-4592-b0ac-2b625362bf2f on 10.11.4.182:31010 ]
[ af1536ff-eca4-4592-b0ac-2b625362bf2f on 10.11.4.182:31010 ]