[
https://issues.apache.org/jira/browse/IGNITE-18174?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17636557#comment-17636557
]
Andrey Mashenkov commented on IGNITE-18174:
-------------------------------------------
Feature is not supported in Calcite yet.
> 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
> Priority: Major
> Labels: ignite-3
>
> "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)
