[ASTERIXDB-2995] NULLs and MISSINGs included in returned result of index-only plan execution

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.5
• Component/s: *DB - AsterixDB, IDX - Indexes
• Assignee: Ali Alsuliman
• Reporter: Ali Alsuliman
• Created: 07/Dec/21 03:54
• Updated: 17/Dec/21 18:11

Description

The below query unexpectedly includes NULLs and MISSINGs in the returned result.

DROP DATAVERSE test IF EXISTS;
CREATE DATAVERSE test;
USE test;

CREATE TYPE t1 AS { id: int, s_f1: string, s_f2: string?, i_f: int? };
CREATE DATASET ds7(t1) PRIMARY KEY id;

CREATE INDEX idx1 ON ds7(s_f2);

INSERT INTO ds7 [
{"id": 1, "s_f1": "s",   "s_f2": "s",   "i_f": 1 },
{"id": 2, "s_f1": "2",   "s_f2": "2",   "i_f": 2 },
{"id": 3, "s_f1": "3.5", "s_f2": "3.5", "i_f": 3 },
{"id": 4, "s_f1": "4",   "s_f2": "4",   "i_f": 4 },
{"id": 5, "s_f1": "5",   "s_f2": null,   "i_f": null },
{"id": 6, "s_f1": "" }
];

// index idx1 will be used
set `compiler.indexonly` "true";
SELECT id, s_f2 FROM ds7 WHERE s_f2 < "4" ORDER BY id;