Robert Hou created DRILL-6682: --------------------------------- Summary: Cast integer to binary returns incorrect result Key: DRILL-6682 URL: https://issues.apache.org/jira/browse/DRILL-6682 Project: Apache Drill Issue Type: Bug Components: Execution - Relational Operators Affects Versions: 1.12.0 Reporter: Robert Hou Assignee: Pritesh Maker
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 | +---------+---------+ -- This message was sent by Atlassian JIRA (v7.6.3#76005)