We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Steps to Reproduce:
Users add Channels to their .channels, the Channel is created if it does not exist yet
Users click on "Scan" to launch the next query : the point is to find other users with the most matching channels
Both Clone and User tables should be updated with the result of the query
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 })) }
local UI gives InternalServerError: materialized set was not finalized!
InternalServerError: materialized set was not finalized!
nextjs interface gives Error: Can't find materialized set ns~73@@(__derived__::myClones@w~16)
Error: Can't find materialized set ns~73@@(__derived__::myClones@w~16)
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; }
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Steps to Reproduce:
Users add Channels to their .channels, the Channel is created if it does not exist yet
Users click on "Scan" to launch the next query : the point is to find other users with the most matching channels
Both Clone and User tables should be updated with the result of the query
Query
local UI gives
InternalServerError: materialized set was not finalized!
nextjs interface gives
Error: Can't find materialized set ns~73@@(__derived__::myClones@w~16)
If I update the last part to ...
... It runs entirely with a total cost of 7.39
Schema:
The text was updated successfully, but these errors were encountered: