[
https://issues.apache.org/jira/browse/CALCITE-5869?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17746719#comment-17746719
]
Julian Hyde commented on CALCITE-5869:
--------------------------------------
Can you come up with a simple SQL test case? It's difficult to reason about
this unless there's a SQL test. RelDataTypeSystemTest really just checks that
"it does what it does".
> 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
>
> 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)
