[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-530) Allow application of filters on subqueries

[Shawn Clowater (JIRA)]

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

Shawn Clowater commented on HHH-530:
------------------------------------

Gail, I've added a patch which adds some tests to the DynamicFilterTest suite. (This was against the 3.2.5 release as that is where I have my code patched to currently)

First 2 are relatively straight forward, search with a valid filter find 1, search with an invalid filter find none.

The 3rd one is a little more complex and then the 4th one was supposed to include a subquery within a subquery with filters at both levels.

However, I found an issue with the way I'm getting at the filters to pass to the CriteriaJoinWalker.  I'm casting the criteria to a CriteriaImpl to get at the session but in the nested subquery it's no longer a CriteriaImpl it is a CriteriaImpl$Subcriteria.

There doesn't seem to be a mechanism right now to be able to get at that in all cases, the parent criteria on the Subcriteria doesn't have a reference to the actual session (it was null when I tried it).

> Allow application of filters on subqueries
> ------------------------------------------
>
>                 Key: HHH-530
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-530
>             Project: Hibernate3
>          Issue Type: Patch
>          Components: core
>            Reporter: Gavin King
>            Assignee: Steve Ebersole
>             Fix For: 3.3
>
>         Attachments: HHH-530.patch, hibernate_filter_fix-3.0.5.patch, hibernate_filter_fix-3.0.5_14.patch, SubqueriesWithFiltersTest.patch
>
>
> Currently filter conditions are applied in subselects, they should not be.

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