[
https://issues.apache.org/jira/browse/CALCITE-2472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16585138#comment-16585138
]
Zhaotong Guo commented on CALCITE-2472:
---------------------------------------
[https://calcite.apache.org/docs/reference.html#system]
I saw the function here. Where can I see the spec for this function?
> {fn IFNULL(value1, value2)} doesn't work when value1 and value2 are different
> types
> -----------------------------------------------------------------------------------
>
> Key: CALCITE-2472
> URL: https://issues.apache.org/jira/browse/CALCITE-2472
> Project: Calcite
> Issue Type: Bug
> Reporter: Zhaotong Guo
> Assignee: Julian Hyde
> Priority: Major
>
> {quote}
> {code:java}
> select {fn IFNULL(value1, value2)} from table1 where id = 3{code}
> {quote}
> When value1 and value2 are the same types, it works.
> When value1 can be cast to value2, for example, value1 is an int and value2
> is a double, both of them are not null. It will return value1 which is cast
> to double.
> When value1 and value2 are different types, it doesn't work.
> I use Calcite 1.17.0.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
