[DRILL-5595] Casting Floating-point types to Boolean types should be supported

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.11.0
• Component/s: Execution - Data Types, Query Planning & Optimization
• Assignee: Chunhui Shi
• Reporter: Abhishek Girish
• Created: 19/Jun/17 04:25
• Updated: 22/Jun/17 23:39

Description

Today, only Int and BigInt can be casted to Boolean. Casting Float / Double values to Boolean fails:

select cast(1.0 as boolean) from (values(1));
Error: SYSTEM ERROR: IllegalArgumentException: Invalid value for boolean: 1.0

select cast(t.a as boolean) from (select cast(1.0 as float) as a from (values(1))) t;
Error: SYSTEM ERROR: IllegalArgumentException: Invalid value for boolean: 1.0