Closed phdoerfler closed 4 months ago
A perfect reproduction ... many thanks for that.
I'm not really sure what I can do about this though. I think Grackle has to trust your view logic, and it has no independent way of determining how many elements there ought to be in a result list.
I'm definitely open to ideas here, but for now I'm going to close this.
if you close as "not planned", then it's easier to distinguish purple ("some useful work was done") from gray ("nothing to see here").
@som-snytt thanks for the tip!
It is currently possible to reduce the number of returned elements by adding a fragment to the query. For details, see the two new tests added by the PR: https://github.com/phdoerfler/grackle/commit/2693a18fa906bf7e43eea02a5b682a75f8156dfa. This happened because of a mistake where I had used the wrong column in my doobie table. This wrong column would always be null in the case where the fragment applied. If you change
RichText!
intoRichText
in the schema, the number of objects would correctly remain three albeit withnull
as description for the affected element. Changing the view in the .sql file to usec.description
instead of the wrongi.description
avoids this bug.