[ https://issues.apache.org/jira/browse/CALCITE-5869?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867912#comment-17867912 ]
Julian Hyde commented on CALCITE-5869: -------------------------------------- I revised the fix in [bb94122|https://github.com/apache/calcite/commit/bb94122fa43df86a2ef57fa375e3dc7792666eac]. > 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 > Priority: Major > Labels: pull-request-available > Fix For: 1.36.0 > > > 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. -- This message was sent by Atlassian Jira (v8.20.10#820010)