Andrey Khitrin created IGNITE-18167:
---------------------------------------
Summary: SQL: incorrect NULLIF behavior
Key: IGNITE-18167
URL: https://issues.apache.org/jira/browse/IGNITE-18167
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 3.0.0-beta1
Reporter: Andrey Khitrin
A SQL spec says the following:
??NULLIF (V1 , V2) is equivalent to the following <case specification>: CASE
WHEN V1 = V2 THEN NULL ELSE V1 END??
When I try to run it, the rule above is true only for the simplest cases.
{code:sql}
select NULLIF(25, 25); --> null (OK)
select NULLIF(24, 25); --> 24 (OK)
select NULLIF('test', 'abc'); --> 'test' (OK)
select NULLIF('test', 'test'); --> '' (should be null!)
select NULLIF(24 + 1, 26 - 1); --> error IGN-SQL-27 (should be null!)
{code}
Probably, there are two defects: one is for wrong return value in case of
textual data, and another one is for error when expression within NULLIF is
used.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
