You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Zhaotong Guo (JIRA)" <ji...@apache.org> on 2018/08/17 02:43:00 UTC
[jira] [Created] (CALCITE-2472) {fn IFNULL(value1, value2)} doesn't
work when value1 and value2 are different types
Zhaotong Guo created CALCITE-2472:
-------------------------------------
Summary: {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
{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)