[jira] [Assigned] (IGNITE-19345) SQL: incorrect NULLIF behavior in some cases

["Pavel Pereslegin (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-19345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pavel Pereslegin reassigned IGNITE-19345:
-----------------------------------------

    Assignee: Pavel Pereslegin

> SQL: incorrect NULLIF behavior in some cases
> --------------------------------------------
>
>                 Key: IGNITE-19345
>                 URL: https://issues.apache.org/jira/browse/IGNITE-19345
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 3.0.0-beta1
>            Reporter: Andrey Khitrin
>            Assignee: Pavel Pereslegin
>            Priority: Major
>              Labels: calcite, ignite-3
>
> During the validation of IGNITE-18167, the following error was found:
> {code:sql}
> sql-cli> SELECT NULLIF(1, 1) IS NULL;
> SQL query execution error
> Exception while executing query [query=SELECT NULLIF(1, 1) IS NULL;]. Error message:From line 1, column 8 to line 1, column 19: Illegal mixing of types in CASE or COALESCE statement
> {code}
> For chars, it works correctly:
> {code:sql}
> sql-cli> SELECT NULLIF('1', '1') IS NULL;
> ╔═════════╗
> ║ EXPR$0  ║
> ╠═════════╣
> ║ true    ║
> ╚═════════╝
> {code}
> For slightly more complex numeric query, it also works correctly:
> {code:sql}
> sql-cli> SELECT x IS NULL FROM (SELECT NULLIF(1, 1) AS x);
> ╔═════════╗
> ║ EXPR$0  ║
> ╠═════════╣
> ║ true    ║
> ╚═════════╝
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)