InternalServerError: materialized set was not finalized! After a big query + Group + bulk Insert

[monsieurpigeon]

• EdgeDB Version: 5.2+93e890a
• EdgeDB CLI Version: 5.0.0+c9dfeec
• OS Version: MacOS 14.4.1 (23E224)

Steps to Reproduce:

1. Users add Channels to their .channels, the Channel is created if it does not exist yet

2. Users click on "Scan" to launch the next query : the point is to find other users with the most matching channels

3. Both Clone and User tables should be updated with the result of the query

4. Query

WITH currentUser := (SELECT User FILTER .email = "maxpige@gmail.com"),
    clones := (
        (FOR channel in currentUser.channels
        UNION channel.<channels[is User]) 
    ),
    cloneResult := (GROUP clones BY .email),
    myClones := (SELECT cloneResult {
        element := (SELECT .elements LIMIT 1){
            email,
        },
        cloneCount := count(.elements)
    } FILTER .element.email != currentUser.email
    ORDER BY .cloneCount DESC
    LIMIT 10)

UPDATE User FILTER .email = currentUser.email
SET {
    clones := (FOR clone in myClones UNION (INSERT Clone {
        element := clone.element,
        cloneCount := clone.cloneCount
    }))
}

5. local UI gives InternalServerError: materialized set was not finalized!

6. nextjs interface gives Error: Can't find materialized set ns~73@@(__derived__::myClones@w~16)

7. If I update the last part to ...

SET {
    clones := { }
}

... It runs entirely with a total cost of 7.39

Schema:

type User { 
    email: str;
    multi channels: Channel;
    multi clones: Clone;
}

type Clone {
    cloneCount: int64;
    element: User;
}

type Channel {
    name: str;
}