aiida-core icon indicating copy to clipboard operation
aiida-core copied to clipboard

`QueryBuilder`: fix projection bug in `Group` joins on `Node`

Open sphuber opened this issue 2 years ago • 1 comments

Fixes #5535

When appending the Node first and the Group second when joining the two, the querybuilder will return a row for each node in the group as opposed to a single row for each unique group. This incorrect behavior disappears when appending the Group before the Node.

sphuber avatar Jun 02 '22 16:06 sphuber

This PR so far just adds the regression test showing the problematic behavior introduced in v2.0. The actual fix still needs to be added. See the issue description for analysis of the bug.

sphuber avatar Jun 02 '22 16:06 sphuber