[CALCITE-4390] SqlMatchRecognize returns wrong operand list

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.27.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Dawid Wysakowicz
• Created: 10/Nov/20 08:51
• Updated: 03/Jun/21 22:32
• Resolved: 12/Nov/20 10:07

Description

The SqlMatchRecognize does not return full list of its operands. The method SqlMatchRecognizeOperator#createCall expects 12 operands whereas SqlMatchRecognize#getOperandList returns only 10. It misses rowsPerMatch and interval.

It results that the SqlShuttle and more concretely the CallCopyingArgHandler does not work with SqlMatchRecognize.

Issue Links

• causes: FLINK-20077 Cannot register a view with MATCH_RECOGNIZE clause
• links to: GitHub Pull Request #2254