[ASTERIXDB-3145] Query w/ Composite array index fails to compile with samples present

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.8.1
• Fix Version/s: 0.9.8.1
• Component/s: COMP - Compiler, IDX - Indexes
• Labels: triaged
• Assignee: Glenn Justo Galvizo
• Reporter: Ian Maxon
• Created: 17/Mar/23 17:00
• Updated: 01/May/23 22:37
• Resolved: 27/Mar/23 07:59

Description

If you run ANALYZE DATASET on the datasets in the test-suite array-index/composite-index-queries, the 9th query in the suite:

FROM      Dataset2 D2,
          Dataset1 D1
WHERE     D1.field1 /* +indexnl */ = TO_BIGINT(D2.field1) AND
          ( SOME D1I IN D1.items
            SATISFIES D1I.field2 /* +indexnl */ = TO_BIGINT(D2.field2) AND
                      D1I.field3 /* +indexnl */ = TO_BIGINT(D2.field3) ) AND
          D1.field4 /* +indexnl */ = TO_BIGINT(D2.field4)
SELECT    D2.field1, D2.field2, D2.field3, D2.field4
ORDER BY  D2.field1, D2.field2, D2.field3, D2.field4;

Will fail to compile with the following message:

ASX1079: Compilation error: Could not infer type for variable '$$85'.