[ https://issues.apache.org/jira/browse/IGNITE-18055?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrey Mashenkov updated IGNITE-18055: -------------------------------------- Description: Query {{SELECT * FROM T1 WHERE val IS NULL}} look fine, but next cases has to be fixed. * {{SELECT * FROM T1 WHERE val IS NOT NULL}} - returns nothing. * {{SELECT * FROM T1 WHERE (val <= 5) or (val IS NULL)}} - returns duplicate rows. Startpoint is ItSecondaryIndexTest. was: Query {{SELECT * FROM T1 WHERE val is null}} look fine, but next cases has to be fixed. * {{SELECT * FROM T1 WHERE val is not null}} - returns nothing. * {{SELECT * FROM T1 WHERE (val <= 5) or (val is null)}} - returns duplicate rows. Startpoint is ItSecondaryIndexTest. > Sql. Support index scans with NULL conditions. > ---------------------------------------------- > > Key: IGNITE-18055 > URL: https://issues.apache.org/jira/browse/IGNITE-18055 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Andrey Mashenkov > Priority: Major > Labels: ignite-3 > > Query {{SELECT * FROM T1 WHERE val IS NULL}} look fine, but next cases has to > be fixed. > * {{SELECT * FROM T1 WHERE val IS NOT NULL}} - returns nothing. > * {{SELECT * FROM T1 WHERE (val <= 5) or (val IS NULL)}} - returns duplicate > rows. > Startpoint is ItSecondaryIndexTest. -- This message was sent by Atlassian Jira (v8.20.10#820010)