[FLINK-33158] Cryptic exception when there is a StreamExecSort in JsonPlan

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.16.2, 1.17.1
• Fix Version/s: 1.18.1
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Dawid Wysakowicz
• Reporter: Dawid Wysakowicz
• Created: 26/Sep/23 10:40
• Updated: 03/Oct/23 12:51
• Resolved: 03/Oct/23 12:43

Description

CREATE TABLE MyTable (
   a bigint,
   b int not null,
   c varchar,
   d timestamp(3)
with (
   'connector' = 'values',
   'bounded' = 'false'
)

insert into MySink SELECT a, a from MyTable order by b

fails with:

org.apache.flink.shaded.jackson2.com.fasterxml.jackson.databind.JsonMappingException: For input string: "null" (through reference chain: org.apache.flink.table.planner.plan.nodes.exec.serde.JsonPlanGraph["nodes"]->java.util.ArrayList[2])

Issue Links

• links to: GitHub Pull Request #23468