[ASTERIXDB-2932] Failing to create open array indexes of multiple UNNESTs + record types.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: IDX - Indexes
• Assignee: Glenn Justo Galvizo
• Reporter: Glenn Justo Galvizo
• Created: 16/Jul/21 18:31
• Updated: 26/Jul/21 19:30
• Resolved: 26/Jul/21 19:30

Description

The following CREATE INDEX throws an error:

DROP DATAVERSE    TestDataverse IF EXISTS;
CREATE DATAVERSE  TestDataverse;
USE               TestDataverse;
CREATE TYPE       TestType AS {
  _id: uuid
};
CREATE DATASET    Dataset1 (TestType)
PRIMARY KEY       _id AUTOGENERATED;
CREATE INDEX      d1Idx
ON                Dataset1 ( UNNEST f1.f2
                             SELECT f3 : bigint );

An CREATE INDEX like "UNNEST f1.f2" works, but adding the SELECT throws an error.