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

[Heiko Burchard (JIRA)]

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

Heiko Burchard updated HHH-530:
-------------------------------

    Attachment: HqlWithFiltersTest.patch

Hello,
we were using hibernate 3.2.6 with the above patch apllied for a while now. Last week we moved from postgres 8.2 to postgres 8.3 and this revealed a problem with parameter binding on some hql queries. Those queries all have multiple left outer joins, some of them with filters applied. Then hibernate again confuses parameters.

I tried branch 3.3 and branch 3.2, but there is also a problem. With those versions parameters of the mentioned queries get lost somewhere. 

I supplied a test that reproduces the errors on 3.2.6 with and without patch and branch 3.2. On branch 3.3 it should work, but i did not yet manage to switch to postgres with the new maven build system...

It looks like hsqldb doesn't care about wrong/missing parameters, so the test will not fail with hsqldb.

Thank you for any comment,

Heiko Burchard



> Allow application of filters on subqueries
> ------------------------------------------
>
>                 Key: HHH-530
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-530
>             Project: Hibernate Core
>          Issue Type: Patch
>          Components: core
>            Reporter: Gavin King
>            Assignee: Steve Ebersole
>             Fix For: 3.2.x, 3.3.x, 3.4
>
>         Attachments: HHH-530.3.3.SP1.patch, HHH-530.3.3.SP1.take2.patch, HHH-530.Additional.Subquery.patch, HHH-530.patch, hibernate_filter_fix-3.0.5.patch, hibernate_filter_fix-3.0.5_14.patch, HqlWithFiltersTest.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