[Hibernate-issues] [Hibernate-JIRA] Closed: (HB-563) Bad join in HQL queries

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

Message:

   The following issue has been closed.

   Resolver: Gavin King
       Date: Wed, 17 Dec 2003 8:15 AM

This is intended, the only way to respect the semantics of "or". If you want some other behavior, use an explicit join the in from clause.
---------------------------------------------------------------------
View the issue:

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


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-563
    Summary: Bad join in HQL queries
       Type: Bug

     Status: Closed
   Priority: Major
 Resolution: REJECTED

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.1

   Assignee: Gavin King
   Reporter: William Drai

    Created: Wed, 17 Dec 2003 8:08 AM
    Updated: Wed, 17 Dec 2003 8:15 AM

Description:
I have the following (simplified) mapping :

<class name="Cat" table="CAT_T">
  <id .. />
  <many-to-one name="sex" class="Sex" column="sex_id" />
  <many-to-one name="color" class="Color" column="color_id" />
</class>

<class name="Sex" table="SEX_T">
  <id .. />
  <property name="name" type="string" />
</class>

<class name="Color" table="COLOR_T">
  <id .. />
  <property name="name" type="string" />
</class>


The HQL query :
select cat 
from cat in class Cat 
where cat.sex.name = 'female'
or cat.color.name = 'black'

is translated to something like :
select cat
from CAT_T cat, SEX_T sex, COLOR_T color
where 
(cat.sex_id = sex.id and sex.name = 'female')
or
(cat.color_id = color.id and color.name = 'black')

That means that I get a cartesian product of 
all cats with sex female by all colors
and all cats with color black by all sexes. 
That is a lot more results than the female or black cats.

What I expected was :
select cat
from CAT_T cat, SEX_T sex, COLOR_T color
where
cat.sex_id = sex.id
and cat.color_id = color.id
and (sex.name = 'female' or color.name = 'black')


I don't know whether this is really a bug or this is wanted for
some reason but it seems rather strange.


William



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