[CALCITE-3151] RexCall's Monotonicity is not considered in determining a Calc's collation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.21.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Zhenghua Gao
• Created: 27/Jun/19 11:53
• Updated: 10/Sep/19 21:36
• Resolved: 30/Jun/19 20:31

Description

In FLINK-12999 I found a case that the planner can't generate a valid execution plan for a sample query:

SELECT UUID() FROM (VALUES(1, 2, 3)) T(a, b, c)

I made an investigation and found the root case was: RexCall's Monotonicity is not considered in determining a Calc's collation( should do the same as Project).

Issue Links

• causes: FLINK-12999 Can't generate valid execution plan for "SELECT uuid() FROM (VALUES(1,2,3)) T(a, b, c)"
• links to: GitHub Pull Request #1282