[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-151) Traversing several joined-subclasses in where clause leaves out inner joins for superclasses

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Sander Verbruggen
    Created: Fri, 27 Jun 2003 3:48 AM
       Body:
It seems that this works fine when a property of the second joined-subclass is used in the query.

If my query only contains
where procureur.jurist.persoon.naam = ?

Hibernate fails, but if my query contains

where procureur.jurist.einddatum = ? 
and procureur.jurist.persoon.naam = ?

then everything is fine. It seems that the parser interpretes the path-expression incorrectly if too many entities are used...
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-151


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-151
    Summary: Traversing several joined-subclasses in where clause leaves out inner joins for superclasses
       Type: Bug

     Status: Unassigned
   Priority: Critical

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.1

   Assignee: 
   Reporter: Sander Verbruggen

    Created: Thu, 26 Jun 2003 3:05 AM
    Updated: Thu, 26 Jun 2003 3:05 AM
Environment: WSAD 5.0.1, JDK 1.3.1, Oracle 9i, Windows 2000

Description:
Class-diagram:
a-->b  a inherits from b
a==b   a has relationship to b

(Sorry, classnames are in Dutch)

Persoon == Beroepsuitoefening
Beroepsuitoefening <-- Jurist
Jurist == Bevoegdheid
Bevoegdheid <-- Beediging <-- Procureurschap

If my query contains 'where jurist.persoon.naam like ?', the generated SQL looks like this (which is OK):

select count(*) as x0_0_ 
from jurist persiste0_ 
	inner join beroepsuitoefening persiste0__1 on persiste0_.beg_id=persiste0__1.id, 
persoon persiste1_ 
where (
	(
		persiste1_.naam like ?  
		and persiste0__1.psn_id=persiste1_.id
	)
)


However, if I start one level deeper in the hierarchy ('where procureurschap.jurist.persoon.naam like ?') the SQL query looks like this:

select count(*) as x0_0_ 
from procureurschap persiste0_ 
	inner join beediging persiste0__1 on persiste0_.bvh_id=persiste0__1.bvh_id 
	inner join bevoegdheid persiste0__2 on persiste0_.bvh_id=persiste0__2.id, 
jurist persiste1_, 
persoon persiste2_ 

where (
	(
		persiste2_.naam=?  
		and persiste0__2.beg_id=persiste1_.beg_id 
		and persiste1__1.psn_id=persiste2_.id
	)
)

[Queries are indented to show outline]

As you can see, the last clause references persiste1__1, which isn't listed in the from clause. It's intended to, because the pattern matches with the previous example (_1 begin the first innerjoin for persiste1_). It should be an alias for beroepsuitoefening just as it is in the previous example.


---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira