You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This query is being string built because when it was JSON input it took forever to run and now the string built version is actually performant. So the select (insert Patron...) { fee } part used to be a for over JSON.
It worked fine when it was JSON. Now I get that error. Despite fee being float32 - unclear why it doesn't like the type?
I'm working to refactor the query to hopefully fix this but unclear why it's even an issue.
The text was updated successfully, but these errors were encountered:
In this case, my refactor was to remove the computed property and change the final select to total := sum((select patrons { fee := .event.fee }).fee). The tricky part here of course being that patrons.event.fee won't work because the events ends up as an intermediate set that is implicitly distinct. Which I believe was what I was trying to dodge back when I originally wrote this.
Thanks for the help. I could see supporting this being mildly useful but not nearly important enough if there's tricky stuff under the hood.
Coming from:
This query is being string built because when it was JSON input it took forever to run and now the string built version is actually performant. So the
select (insert Patron...) { fee }
part used to be afor
over JSON.It worked fine when it was JSON. Now I get that error. Despite
fee
beingfloat32
- unclear why it doesn't like the type?I'm working to refactor the query to hopefully fix this but unclear why it's even an issue.
The text was updated successfully, but these errors were encountered: