[ASTERIXDB-3490] Could not modify UNORDERED_PARTITIONED exception on query compilation

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: COMP - Compiler
• Labels: triaged
• Assignee: Peeyush Gupta
• Reporter: Peeyush Gupta
• Created: 22/Aug/24 21:01
• Updated: 24/Sep/24 15:58
• Resolved: 24/Sep/24 15:58

Description

The following query fails compilation

SELECT * 
FROM collection1 a1
WHERE (
    SELECT  value count(*) 
    FROM collection2 a2 
    WHERE a1.t=a2.t and a1.p=3 and (
       SELECT value count(*) 
        FROM collection3 a3 
        WHERE a2.t1=a3.t1 and a2.p1=3 and (
            SELECT value count(*) 
                FROM collection4 a4 
                WHERE a3.t2=a4.t2 and a3.p2=3 and (
                    SELECT value count(*) 
                        FROM collection5 a5 
                        WHERE a4.t=a5.t and a4.p=3 and (
                        SELECT value count(*) 
                            FROM collection6 a6 
                            WHERE a5.t1=a6.t1 and a5.p1=3 
                        )[0] >= 1
                    )[0] >= 1
                )[0] >= 1
        )[0] >= 1
    )[0] >= 1;

With exception 

Could not modify UNORDERED_PARTITIONED