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)
