[ASTERIXDB-2959] Composite atomic-array indexes not ingesting data on creation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: IDX - Indexes
• Assignee: Glenn Justo Galvizo
• Reporter: Glenn Justo Galvizo
• Created: 10/Sep/21 19:57
• Updated: 16/Sep/21 21:25
• Resolved: 16/Sep/21 21:25

Description

The following sequence of events does not deliver the right result. The issue lies with ingestion job created on CREATE INDEX.

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;