Support Criteria API restriction index-refering functions for many-to-many, indexed
collections
-----------------------------------------------------------------------------------------------
Key: HHH-4954
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4954
Project: Hibernate Core
Issue Type: Improvement
Components: query-criteria
Affects Versions: 3.5.0-CR-2
Reporter: Marius
The problem is that the restrictions from Criteria API can't use hql functions.
I have a many-to-many relation but I want to left join the other side only with the first
index (0).
In HQL(starting from 3.5.0-CR-2 for many-to-many relation) to get the first user's
address I can write:
left join user.addresses address with index(address) = '0'
The generated SQL will look like this:
select * from USER user
left outer join
USER_ADDRESS address1_
on user_.ADDRESS_ID=address1_.USER_ID
and (
address1_.IDX='0'
)
left outer join
ADDRESS address2_
on address1_.ADDRESS_ID=address2_.ADDRESS_ID
where USER_ADDRESS is the table used for many-to-many relation and IDX is the index
column
So I want to be able to write in Criteria like this:
.createAlias("user.addresses", "address", Criteria.LEFT_JOIN,
Restrictions.eq("index(address)", 0))
Or maybe Restrictions.indexEq("address", 0).
Index-refering functions to implement: INDEX(), MININDEX(), MAXINDEX()
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira