[jira] [Updated] (ASTERIXDB-3471) Computing expected schema fails on repeated expressions

["Ian Maxon (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-3471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ian Maxon updated ASTERIXDB-3471:
---------------------------------
    Labels: triaged  (was: )

> Computing expected schema fails on repeated expressions
> -------------------------------------------------------
>
>                 Key: ASTERIXDB-3471
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3471
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>    Affects Versions: 0.9.9
>            Reporter: Wail Y. Alkowaileet
>            Assignee: Wail Y. Alkowaileet
>            Priority: Major
>              Labels: triaged
>             Fix For: 0.9.10
>
>
> {noformat}
> SELECT ht.name, ht.phone,
> ARRAY_COUNT(ht.reviews) AS num_reviews,
> (SELECT VALUE MIN(ratings.Overall) FROM ht.reviews)[0] AS overall_avg,
> (SELECT VALUE ratings.Overall FROM ht.reviews) AS overall_reviews
> FROM ColumnDataset ht
> WHERE ht.city = 'Los Angeles'
> ORDER BY overall_avg DESC
> LIMIT 5; {noformat}
> Fails with:
> {noformat}
> java.lang.IllegalStateException: Cannot replace OBJECT with ANY {noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)