[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3856) Base class alias used where joined subclass alias should have been used.

[Sagar Kar (JIRA)]

Base class alias used where joined subclass alias should have been used.
------------------------------------------------------------------------

                 Key: HHH-3856
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3856
             Project: Hibernate Core
          Issue Type: Bug
          Components: query-sql
    Affects Versions: 3.2.2
         Environment: Windows XP. Hibernate 3.2.2 ga. Database Oracle 10g
            Reporter: Sagar Kar
         Attachments: hibernate issue.zip

We have defined a where clause on the <class name="A" table="A" where="ind = 'A'"> tag in the parent class.
B is a joined subclass of A. B has a one to one relationship to another class X.
When we try the following statement 
      session.get(X.class, 1L);
It generates the following query
Hibernate: 
    /* load hibernate.X */ select
        x0_.ID as ID3_1_,
        x0_.IND as IND3_1_,
        b1_.id as ID1_0_,
        b1_1_.IND as IND1_0_,
        b1_.X_ID as X2_2_0_ 
    from
        X x0_ 
    left outer join
        B b1_ 
            on x0_.ID=b1_.X_ID 
            and (
                b1_1_.ind = 'A'
            )  
    left outer join
        A b1_1_ 
            on b1_.id=b1_1_.ID 
    where
        x0_.ID=?

If you look at the "on " condition for B you will notice that its using b1_1_.ind='A' which is the parent's alias which hasn't been defined yet.
Hence we get a invalid identifier error.
It looks like the generated query is faulty.
Do we already have a fix for this?
I have attached the error log, hbm files, the test class and the oracle table create script.
		

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira