[
https://issues.apache.org/jira/browse/CALCITE-5869?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17747114#comment-17747114
]
Tanner Clary commented on CALCITE-5869:
---------------------------------------
[~julianhyde] I added a test case, feel free to take a look. The query is
something like {{SELECT IFNULL(MEASURE<DECIMAL>, 0)}} should have the same
return type as the measure given that DECIMAL is less restrictive than INTEGER.
> 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)
