Tanner Clary created CALCITE-5869:
-------------------------------------
Summary: LEAST_RESTRICTIVE does not use inner type of MEASURE for
comparisons
Key: CALCITE-5869
URL: https://issues.apache.org/jira/browse/CALCITE-5869
Project: Calcite
Issue Type: Bug
Reporter: Tanner Clary
Assignee: Tanner Clary
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, but I am not certain it fully
addresses the problem so any comments would be appreciated.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
