Message Title

Nikita Metzger created an issue

Issue Type:	Improvement
Affects Versions:	5.2.0
Assignee:	Unassigned
Attachments:	join_problem.zip
Components:	hibernate-core
Created:	27/Jun/2016 07:43 AM
Priority:	Major
Reporter:	Nikita Metzger

The test case attached.
We have faced with the problem on more complex selects, but the test case contains the simplest one.

So select like:

 
                                                                entityManager.createQuery("from TestEntity t1 "
                + "inner join TestEntity t2 on t1.refId=t2.id "
                + "left outer join t2.subs "
                + "left outer join t1.subs ").getResultList();

produces the following SQL:

 
                                                                select
        testentity0_.id as id1_1_0_,
        subs3_.id as id1_0_1_,
        testentity1_.id as id1_1_2_,
        subs2_.id as id1_0_3_,
        testentity0_.name as name2_1_0_,
        testentity0_.ref_id as ref_id3_1_0_,
        subs3_.test_id as test_id2_0_1_,
        testentity1_.name as name2_1_2_,
        testentity1_.ref_id as ref_id3_1_2_,
        subs2_.test_id as test_id2_0_3_ 
    from
        test_table testentity0_ 
    left outer join
        sub_test_table subs3_ 
            on testentity0_.id=subs3_.test_id 
    inner join
        test_table testentity1_ 
            on (
                testentity0_.ref_id=testentity1_.id
            )
 
                                                            

For main entity it generates a proper join* subs3_* but for joined testentity1_ the join was not generated but appropriate records into select are added:

 
                                                                subs2_.id as id1_0_3_,
subs2_.test_id as test_id2_0_3_

As a result it fails with:

 
                                                                2016-06-27 16:32:52 WARN  SqlExceptionHelper:129 - SQL Error: 42122, SQLState: 42S22
2016-06-27 16:32:52 ERROR SqlExceptionHelper:131 - Column "SUBS2_.ID" not found; SQL statement:

The subs are mapped over @OneToMany annotation.

Add Comment

This message was sent by Atlassian JIRA