Postgres backend produces incorrect results for empty fold lists

Question

Postgres backend produces incorrect results for empty fold lists

Closed this issue 4 years ago · 2 comments

Turning on integrations tests in #953 uncovered a bug. This db-fiddle is modeled after the current output of this integration test. For Animal 4, we expect to see the result {child_names: []}, but instead get no results for Animal 4.

Answer 1 · 2020-10-20T21:27:40.000Z

I think this can be solved with a LEFT JOIN from the main selectable to the folded subquery? That is actually what we have written up in #535, but in implementation we used a JOIN instead. See this db-fiddle. If so, the fix is a super easy change here! @bojanserafimov @obi1kenobi let me know what you think!

Answer 2 · 2020-10-20T21:44:33.000Z

Looks good to me! Let's go for it 🙌