[ASTERIXDB-3403] Compilation error with valid query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: COMP - Compiler
• Labels: triaged
• Assignee: Peeyush Gupta
• Reporter: Peeyush Gupta
• Created: 22/May/24 00:15
• Updated: 28/Jun/24 22:28
• Resolved: 28/Jun/24 22:28

Description

The following query fails compilation

SELECT COUNT(id) AS matches
FROM collection1 AS d
WHERE d.`f1` = 'f1'
  AND (ARRAY_SUM((
      SELECT VALUE i.`cnt`
      FROM d.`x1` AS i
      WHERE i.`date` BETWEEN "01-01-2024" AND "02-02-2024"
        AND i.`item` IN ['1234', '5678'] )) >= 1
    OR ARRAY_SUM((
      SELECT VALUE i.`cnt`
      FROM d.`x2` AS i
      WHERE i.`date` BETWEEN "01-01-2024" AND "02-02-2024"
        AND i.`item` IN ['1234', '5678'] )) >= 1
    OR (ANY e IN d.x3 SATISFIES e.item IN ['i1', 'i2', 'i3']
      AND e.su.`x4` >= 1 END));