[
https://issues.apache.org/jira/browse/ASTERIXDB-3403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17849096#comment-17849096
]
ASF subversion and git services commented on ASTERIXDB-3403:
------------------------------------------------------------
Commit 34b917c43c097e34c98b99637141aec714393f6f in asterixdb's branch
refs/heads/master from Peeyush Gupta
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=34b917c43c ]
[ASTERIXDB-3403][COMP] Compilation error with valid query
- user model changes: no
- storage format changes: no
- interface changes: no
Change-Id: I0a2ee2923860a5fe215206eea45421f00b615f40
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18305
Reviewed-by: Ali Alsuliman <[email protected]>
Tested-by: Peeyush Gupta <[email protected]>
> 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
> Priority: Major
>
> 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)
