inner join problem when use constructor in JPQL ----------------------------------------------- Key: HHH-7303 URL: https://hibernate.onjira.com/browse/HHH-7303 Project: Hibernate ORM Issue Type: Bug Components: entity-manager Affects Versions: 4.1.0 Environment: Spring 3.1.1 Reporter: deng hui I have 2 domain classes: 'Process' and 'Account' they are keeping Many-To-One relationship which means: Process may belongs to one Account or not belongs to any Account, and one Account can own multi-Process. a query in Spring Framework like {code} public interface ProcessRepository extends CrudRepository<Process, Long> { @Query("select distinct new Process(p.id, p.name,p.diversity,p.version,p.account,p.description) from Process p right join p.account where p.name like ?1 and p.state.id=1") List<Process> findProcessByName(String name); } {code} when app is running i got: {code} Hibernate: select distinct process0_.id as col_0_0_, process0_.name as col_1_0_, process0_.diversity as col_2_0_, process0_.version as col_3_0_, process0_.account_id as col_4_0_, process0_.description as col_5_0_ from Process process0_ right outer join Account account1_ on process0_.account_id=account1_.id inner join Account account2_ on process0_.account_id=account2_.id where (process0_.name like ?) and process0_.state_id=1 {code} no record retrieved. if I change to {code} public interface ProcessRepository extends CrudRepository<Process, Long> { @Query("select distinct new Process(p.id, p.name,p.diversity,p.version,p.account,p.description) from Process p where p.name like ?1 and p.state.id=1") List<Process> findProcessByName(String name); } {code} then I got: {code} Hibernate: select distinct process0_.id as col_0_0_, process0_.name as col_1_0_, process0_.diversity as col_2_0_, process0_.version as col_3_0_, process0_.account_id as col_4_0_, process0_.description as col_5_0_ from Process process0_ inner join Account account2_ on process0_.account_id=account2_.id where (process0_.name like ?) and process0_.state_id=1 {code} this(inner join) is also not I want since account may be null in process object. is this a bug? -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira