Finding the "unlinked" entities for a many-to-many relationship fails

Description

Running a JPA query to find the 'unlinked' entities in a many to many relationship generates invalid SQL statements.

select p from Policy p where :role not in (p.roles) order by p.name

In attachment a maven project showing the issue we have.

Environment

h2, hsqldb, derby

Assignee

Unassigned

Reporter

Bart Cremers

Fix versions

None

Labels

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Minor
Configure