[ASTERIXDB-3409] Query failing compilation when run twice on columnar collections

• 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: 29/May/24 20:39
• Updated: 07/Jun/24 21:38
• Resolved: 07/Jun/24 21:38

Description

SELECT COUNT(DISTINCT R3.id) AS count
FROM (
SELECT t.*
FROM R AS t
WHERE ((ARRAY_SUM((
        SELECT VALUE i.`count`
        FROM t.`a1` AS i)) >= 3 ))) AS R3

throws

java.lang.IllegalStateException: Cannot replace ARRAY with ANY
at org.apache.asterix.optimizer.rules.pushdown.schema.ObjectExpectedSchemaNode.replaceChild(ObjectExpctedSchemaNode.java:70)

The reason is that irreplaceable root types doesn't ignore modifications (e.g., adding a child)