[jira] [Created] (ASTERIXDB-2959) Composite atomic-array indexes not ingesting data on creation

["Glenn Justo Galvizo (Jira)" <ji...@apache.org>]

Glenn Justo Galvizo created ASTERIXDB-2959:
----------------------------------------------

             Summary: Composite atomic-array indexes not ingesting data on creation
                 Key: ASTERIXDB-2959
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2959
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: IDX - Indexes
            Reporter: Glenn Justo Galvizo
            Assignee: Glenn Justo Galvizo


The following sequence of events does not deliver the right result. The issue lies with ingestion job created on CREATE INDEX.
{noformat}
SET               `compiler.arrayindex` "true";
DROP DATAVERSE    TestDataverse IF EXISTS;
CREATE DATAVERSE  TestDataverse;
USE               TestDataverse;
CREATE TYPE       GenericType AS { _id: bigint  };
CREATE DATASET    TestDataset (GenericType)
PRIMARY KEY       _id;
INSERT INTO       TestDataset [
    { "_id": 100, "f": 1, "a": {"b": [{"c": {"d": 1}}]} },
    { "_id": 101, "f": "a", "a": null },
    { "_id": 102, "f": "a", "a": {"b": null} },
    { "_id": 103, "f": "a", "a": {"b": [{"c": null}]} },
    { "_id": 104, "f": "a", "a": {"b": [{"c": {"d": null}}]} }
    ];
CREATE INDEX      TestIdx
ON                TestDataset (
    f : bigint,
    UNNEST a.b
    SELECT c.d : bigint
);
FROM TestDataset D
UNNEST D.a.b AB
WHERE D.f = 1 AND AB.c.d = 1
SELECT D._id;{noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)