[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3500) Hibernate fails to resolve the correct orderby column in SQL when using inheritance hierarchy

[Joonas Koivunen (JIRA)]

Hibernate fails to resolve the correct orderby column in SQL when using inheritance hierarchy
---------------------------------------------------------------------------------------------

                 Key: HHH-3500
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3500
             Project: Hibernate Core
          Issue Type: Bug
    Affects Versions: 3.3.0.GA
         Environment: Derby 10.4.2.0 (http://db.apache.org)
            Reporter: Joonas Koivunen


I have an inheritance hierarchy:

@Entity("abstractBaseClass")
AbstractBaseClass
 - ConcreteClass1
 - ConcreteClass2
 - ConcreteClass3

AbstractBaseClass has:
 - @Id long id;
 - String name;

@Entity("concreteClass1") ConcreteClass1 has a @OneToMany(mappedBy="concreteClass1") List<ConcreteClass2>

@Entity("concreteClass2") ConcreteClass2 has a @OneToMany(mappedBy="concreteClass2") List<ConcreteClass3> and a reference to @ManyToOne ConcreteClass1.

@Entity("concreteClass3") ConcreteClass3 has a reference to @ManyToOne ConcreteClass2.

After adding a @OrderBy("name") annotation to the getter "List<ConcreteClass3> ConcreteClass2.getConcreteClass3s()" and afterwards accessing the association through an ConcreteClass2 instance I get:

SELECT
  cc3_concrete.cc2_id,
  cc3_concrete.id,
  cc3_base.name,
  cc3_concrete.cc2_id AS cc2_id_2
FROM
  cc3 cc3_concrete
INNER JOIN
  abstractBaseClass cc3_base ON cc3_concrete.id = cc3_base.id
WHERE
  cc3_concrete.cc2_id = ?
ORDER BY
  abstractBaseClass.name asc

(I edited hibernate's naming of entities in SQL to be a bit more clearer).

Ordering by "abstractBaseClass.name" causes the problem here; it's obvious that it should had been "cc3_base.name" but for some reason hib just uses the entityname.column_name in the SQL. 

Another strange thing is that the foreign key column "cc2_id" is being included twice in the results? It is included in the select wheter or not @OrderBy exists.

Inheritance strategy used is javax.persistence.InheritanceType.JOINED.

-- 
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