[jira] [Created] (IGNITE-18174) SQL: implement expanded NULL predicate

["Andrey Khitrin (Jira)" <ji...@apache.org>]

Andrey Khitrin created IGNITE-18174:
---------------------------------------

             Summary: SQL: implement expanded NULL predicate
                 Key: IGNITE-18174
                 URL: https://issues.apache.org/jira/browse/IGNITE-18174
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Andrey Khitrin


"Expanded NULL predicate" is referenced in SQL standard as F481 feature. It allows to use something other than a column reference as row value expression.

The following query works in AI2:
{code:sql}
create table tmp_simple_table (key_field INT PRIMARY KEY,x INT,y INT,z INT);
insert into tmp_simple_table (key_field,x,y,z) values (1, 1,1,1);
insert into tmp_simple_table (key_field,x,y,z) values (2, 2,2,2);
insert into tmp_simple_table (key_field,x,y,z) values (3, null,3,null);
insert into tmp_simple_table (key_field,x,y,z) values (4, 4,null,null);
insert into tmp_simple_table (key_field,x,y,z) values (5, null,null,null);
select x, y, z from tmp_simple_table t 
  where (select x, z from tmp_simple_table where x=t.x and y=t.y and z=t.z) is not NULL;  -- expanded NULL predicate
{code}
But in AI3 beta1 it's not implemented yet.



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