[FLINK-19587] Error result when casting binary type as varchar

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.11.0
• Fix Version/s: 1.11.3, 1.12.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: hailong wang
• Reporter: hailong wang
• Created: 12/Oct/20 15:15
• Updated: 29/Oct/20 04:22
• Resolved: 29/Oct/20 04:22

Description

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

For example,

@Test
def testCast1(): Unit = {
  testSqlApi(
    "CAST(X'68656c6c6f' as varchar)",
    "hello")
}

The result is

Expected :hello
Actual   :[B@57fae983

It is right as follow,

@Test
def testCast(): Unit = {
  testSqlApi(
    "CAST(CAST(X'68656c6c6f' as varbinary) as varchar)",
    "hello")
}

We just need to change 

case (VARBINARY, VARCHAR | CHAR)

to 

case (BINARY | VARBINARY, VARCHAR | CHAR) 

in ScalarOperatorGens#generateCast.

 

Issue Links

• links to: GitHub Pull Request #13612