[jira] [Created] (DRILL-6682) Cast integer to binary returns incorrect result

["Robert Hou (JIRA)" <ji...@apache.org>]

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)