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

["Ali Alsuliman (Jira)" <ji...@apache.org>]

Ali Alsuliman created ASTERIXDB-2995:
----------------------------------------

             Summary: NULLs and MISSINGs included in returned result of index-only plan execution
                 Key: ASTERIXDB-2995
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2995
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: *DB - AsterixDB, IDX - Indexes
    Affects Versions: 0.9.5
            Reporter: Ali Alsuliman


The below query unexpectedly includes NULLs and MISSINGs in the returned result.
{noformat}
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;
{noformat}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)