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)
