[
https://issues.apache.org/jira/browse/ASTERIXDB-3403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Peeyush Gupta resolved ASTERIXDB-3403.
--------------------------------------
Resolution: Fixed
> Compilation error with valid query
> ----------------------------------
>
> Key: ASTERIXDB-3403
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3403
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Peeyush Gupta
> Assignee: Peeyush Gupta
> Priority: Major
> Labels: triaged
>
> The following query fails compilation
> {noformat}
> 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));{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
