Details
Improvement
Open
Minor
Description
Currently, using MEMBER OF for a ManyToMany collection does a join on the table of the related entity, whereas all it needs is in the join table.
Using the following DQL:
SELECT p FROM Player p WHERE NOT :team MEMBER OF p.targetedBy
Here is the current generated SQL:
WHERE NOT EXISTS (SELECT 1 FROM player_team p1_ INNER JOIN Team t2_ ON p1_.team_id = t2_.id WHERE p1_.player_id = p0_.id AND t2_.id = ?)
whereas it could drop the join:
WHERE NOT EXISTS (SELECT 1 FROM player_team p1_ WHERE p1_.player_id = p0_.id AND p1_.team_id = ?)