[ASTERIXDB-3471] Computing expected schema fails on repeated expressions

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.9
• Fix Version/s: 0.9.10
• Component/s: COMP - Compiler
• Labels: triaged
• Assignee: Wail Y. Alkowaileet
• Reporter: Wail Y. Alkowaileet
• Created: 30/Jul/24 09:47
• Updated: 25/Aug/24 07:07
• Resolved: 25/Aug/24 07:07

Description

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; 

Fails with:

java.lang.IllegalStateException: Cannot replace OBJECT with ANY