[hibernate-issues] [Hibernate-JIRA] Created: (HHH-7303) inner join problem when use constructor in JPQL

[deng hui (JIRA)]

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