[FLINK-31182] CompiledPlan cannot deserialize BridgingSqlFunction with MissingTypeStrategy

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.17.0, 1.18.0, 1.17.1
• Fix Version/s: 1.17.0, 1.16.2, 1.18.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Timo Walther
• Reporter: Jane Chan
• Created: 22/Feb/23 10:17
• Updated: 06/Mar/23 14:33
• Resolved: 06/Mar/23 14:33

Description

This issue is reported from the user mail list.

The stacktrace is 

Unable to find source-code formatter for language: text. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yamlCaused by: org.apache.flink.table.api.TableException: Could not resolve internal system function '$UNNEST_ROWS$1'. This is a bug, please file an issue.
    at org.apache.flink.table.planner.plan.nodes.exec.serde.RexNodeJsonDeserializer.deserializeInternalFunction(RexNodeJsonDeserializer.java:392)
    at org.apache.flink.table.planner.plan.nodes.exec.serde.RexNodeJsonDeserializer.deserializeSqlOperator(RexNodeJsonDeserializer.java:337)
    at org.apache.flink.table.planner.plan.nodes.exec.serde.RexNodeJsonDeserializer.deserializeCall(RexNodeJsonDeserializer.java:307)
    at org.apache.flink.table.planner.plan.nodes.exec.serde.RexNodeJsonDeserializer.deserialize(RexNodeJsonDeserializer.java:146)
    at org.apache.flink.table.planner.plan.nodes.exec.serde.RexNodeJsonDeserializer.deserialize(RexNodeJsonDeserializer.java:128)
    at org.apache.flink.table.planner.plan.nodes.exec.serde.RexNodeJsonDeserializer.deserialize(RexNodeJsonDeserializer.java:115) 

The root cause is that although ModuleManager can resolve '$UNNEST_ROWS$1', the output type strategy is "Missing"; as a result, FunctionCatalogOperatorTable#convertToBridgingSqlFunction returns empty.

Issue Links

• links to: GitHub Pull Request #22040