Many-to-Many: Unnecessary Table Join in generated SQL ----------------------------------------------------- Key: JPA-19 URL: http://opensource.atlassian.com/projects/hibernate/browse/JPA-19 Project: Java Persistence API Issue Type: Bug Environment: java version "1.6.0_25" Java(TM) SE Runtime Environment (build 1.6.0_25-b06) Java HotSpot(TM) Client VM (build 20.0-b11, mixed mode, sharing) Reporter: Bernard Attachments: testcase.zip A simple JPQL query produces an unnecessary table join. Please refer to the attached testcase (NetBeans project). JPQL: select object(emp) from Employee emp , in(emp.projects) proj where proj = :project The generated native SQL is: select employee0_.id as id2_, employee0_.name as name2_ from Employee employee0_ inner join Employee_Project projects1_ on employee0_.id=projects1_.Employee_id inner join Project project2_ on projects1_.projects_id=project2_.id where project2_.id=? The generated SQL should have only one join, in other words the project table should not be included. Please refer to the attached testcase if this is useful - you need to set up the required libraries. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira