]
Steve Ebersole updated HHH-2593:
--------------------------------
Assignee: Steve Ebersole
Fix Version/s: 3.3
3.2.6
Component/s: (was: query-sql)
(was: query-hql)
core
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: