Wail Y. Alkowaileet created ASTERIXDB-3471:
----------------------------------------------
Summary: 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
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)
