[DRILL-6682] Cast integer to binary returns incorrect result

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.12.0
• Component/s: Execution - Relational Operators
• Assignee: Karthikeyan Manivannan
• Reporter: Robert Hou
• Created: 10/Aug/18 21:13
• Updated: 14/Aug/18 17:10

Description

This query returns an empty binary string:
select cast(123 as binary) from (values(1));

The same problem occurs for bigint, float and double.
Casting works if the data type is date, time, timestamp, interval, varchar and binary.

select cast(date '2018-08-10' as binary) from (values(1));

select length(string_binary(cast(123 as binary))), length(string_binary(cast(date '2018-08-10' as binary))) from (values(1));
----------------+

EXPR$0

EXPR$1

----------------+

0

10

----------------+