[FLINK-31404] Support extracting all mapping of Calc node's input references

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.17.0, 1.17.1
• Fix Version/s: 1.18.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Jane Chan
• Reporter: Jane Chan
• Created: 11/Mar/23 12:01
• Updated: 12/Mar/23 13:24
• Resolved: 12/Mar/23 13:24

Description

Currently, `StreamNonDeterministicUpdatePlanVisitor` only supports extracting a limited kind of RexNode to its input node for the Calc.

• RexInputRef
• RexCall with the operator kind as `AS` and `CAST`

It can be optimized to support all kinds of RexNode by FlinkRexUtil#findAllInputRefs.

cc lincoln.86xy 

Issue Links

• links to: GitHub Pull Request #22160