[ 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)