[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2593) Keyword UNION is prefixed with "this_." in filter conditions

[Frederic Leitenberger (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28334 ] 

Frederic Leitenberger commented on HHH-2593:
--------------------------------------------

Thanks. That's great news (both).

> Keyword UNION is prefixed with "this_." in filter conditions
> ------------------------------------------------------------
>
>                 Key: HHH-2593
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2593
>             Project: Hibernate3
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.2.1
>         Environment: Oracle 10g: org.hibernate.dialect.OracleDialect
> Suse Linux
> Hibernate: 3.2.1.ga
> Hibernate Annotations: 3.2.1.GA
>            Reporter: Frederic Leitenberger
>            Assignee: Steve Ebersole
>            Priority: Trivial
>             Fix For: 3.2.6, 3.3
>
>
> I need to use a UNION-Subquery in a Filter condition unless HHH-298 is solved.
> But anyway, when using the keyword "union" in the Filter condition it is prefixed with "this_.".
> For instance, this ...
> @Filter(name = "resellerFilter", condition = "(select cu.resellerId from Customer cu, GeoNumber gn where (cu.id = gn.customerId and gn.id = this_.geoNumberId) UNION select cu.resellerId  from Customer cu where cu.detemeTemplateId = this_.id) in (null, :resellerIds)")
> ... produces this ...
> select
> ...
> from
>         DeTeMe this_ 
>     where
>         (
>             select
>                 cu.resellerId 
>             from
>                 Customer cu,
>                 GeoNumber gn 
>             where
>                 (
>                     cu.id = gn.customerId 
>                     and gn.id = this_.geoNumberId
>                 ) this_.UNION select
>                     cu.resellerId  
>                 from
>                     Customer cu 
>                 where
>                     cu.detemeTemplateId = this_.id
>             ) in (
>                 null, ?
>             ) 
>             and this_.id = ?

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