[ASTERIXDB-2791] Enable storing nulls in secondary indexes

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.5
• Fix Version/s: 0.9.7
• Component/s: IDX - Indexes, STO - Storage
• Assignee: Ali Alsuliman
• Reporter: Ali Alsuliman
• Created: 26/Oct/20 04:14
• Updated: 17/Feb/22 17:54
• Resolved: 17/Feb/22 17:54

Description

Currently, nulls and missings keys are not stored in secondary indexes. This applies across all index types. For B-Tree indexes, it should be possible to accept nulls and missings keys (for example, to enable using secondary indexes for prefix searches). For other index types, they should determine how to deal with UNKNOWNs in a proper way.

• Make sure array indexes handle NULLs/MISSINGs
• Make sure inverted indexes handle NULLs/MISSINGs
• Make sure R-Tree indexes handle NULLs/MISSINGs

Issue Links

• relates to: ASTERIXDB-2920 Set null flags properly in SimpleTupleWriter
• relates to: ASTERIXDB-2923 Remove null/missing filter from insert and load statements
• relates to: ASTERIXDB-2938 Inverted index should handle NULLs/MISSINGs keys
• relates to: ASTERIXDB-2939 Make sure array indexes handle NULLs/MISSINGs
• relates to: ASTERIXDB-3019 Make sure R-tree indexes handle NULLs/MISSINGs