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

["Ian Maxon (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ian Maxon reassigned ASTERIXDB-2995:
------------------------------------

    Assignee: Ali Alsuliman

> 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
>            Assignee: Ali Alsuliman
>            Priority: Major
>
> 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)