[CALCITE-5869] LEAST_RESTRICTIVE does not use inner type of MEASURE for comparisons

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Labels: pull-request-available
• Assignee: Tanner Clary
• Reporter: Tanner Clary
• Created: 24/Jul/23 02:27
• Updated: 23/Jul/24 00:58
• Resolved: 08/Aug/23 22:13

Description

If you have a function with return type LEAST_RESTRICTIVE, that takes two arguments, and one of these arguments is an INTEGER and the other is a MEASURE<DOUBLE> you should expect that the latter is less restrictive. However, the logic in SqlTypeUtil#canCastFrom does not consider the case of measures where the type that should be used for comparisons is nested within. Because the SqlTypeFamily of a measure is ANY, that method will always return TRUE.

I have a small fix I will open a PR for, any comments would be appreciated.

Issue Links

• is related to: CALCITE-4496 Measure columns ("SELECT ... AS MEASURE")
• links to: GitHub Pull Request #3336