As a development note, this worked in 6.1.0 because we used the primary key of the joined table by default for the entity valued path (secondaryJoin), allowing the database to apply functional dependency to the other selected columns.

We should expand the path to all columns like we do when the path itself is selected in 6.2, avoiding any functional dependency problem.