[IGNITE-18055] Sql. Support index scans with NULL conditions.

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: sql
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Andrey Mashenkov
• Created: 01/Nov/22 22:50
• Updated: 15/Nov/22 10:04
• Resolved: 15/Nov/22 10:04

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.

Issue Links

• duplicates: IGNITE-17748 Enrich InternalTable.scan API in order to support index scans
• is caused by: IGNITE-17748 Enrich InternalTable.scan API in order to support index scans