[jira] [Created] (FLINK-19587) Error result when casting binary type as varchar

[Shang Yuanchun (Jira)]

hailong wang created FLINK-19587:
------------------------------------

             Summary: Error result when casting binary type as varchar
                 Key: FLINK-19587
                 URL: https://issues.apache.org/jira/browse/FLINK-19587
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Planner
    Affects Versions: 1.11.0
            Reporter: hailong wang
             Fix For: 1.12.0, 1.11.0


The result is error when casting binary type as varchar type.

For example,
{code:java}
@Test
def testCast1(): Unit = {
  testSqlApi(
    "CAST(X'68656c6c6f' as varchar)",
    "hello")
}
{code}
The result is
{code:java}
Expected :hello
Actual   :[B@57fae983
{code}
It is right as follow,
{code:java}
@Test
def testCast(): Unit = {
  testSqlApi(
    "CAST(CAST(X'68656c6c6f' as varbinary) as varchar)",
    "hello")
}
{code}
We just need to change 
{code:java}
case (VARBINARY, VARCHAR | CHAR){code}
to 

 
{code:java}
case (BINARY | VARBINARY, VARCHAR | CHAR)
{code}
in ScalarOperatorGens#generateCast.

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)