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)
