[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-708) Restrictions.in could not be used properly on composite-ids

[Max R. A. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-708?page=comments#action_23080 ] 

Max Rydahl Andersen commented on HHH-708:
-----------------------------------------

open a new issue and add a *patch* and a test that show it fails.

> Restrictions.in could not be used properly on composite-ids
> -----------------------------------------------------------
>
>          Key: HHH-708
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-708
>      Project: Hibernate3
>         Type: Bug

>   Components: core
>     Versions: 3.0.5
>  Environment: Oracle 9i, org.hibernate.criterion.InExpression
>     Reporter: Holger Bartnick
>      Fix For: 3.1 beta 1

>
>
> Restrictions.in could not be used properly on composite-ids
> for a composite-id with the attributes key and station
> the resulting sql is like: 
>   [where key in (?,?...) and station in (?,?...)]
> it should result in an sql like: 
>   [where (key, station) in ((?,?),(?,?)...)]
> otherwise the result would be a scalar product 
> example:
> key       station
> 1         1
> 2         1
> 2         2
> 3         2
> [where key in (1,2,3) and station in (1,2)]
> would return all values
> [where (key, station) in ((1,1),(2,1),(3,2))]
> would omit the record (2,2)

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