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

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

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

Glenn Justo Galvizo closed ASTERIXDB-2959.
------------------------------------------

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