[nhibernate-issues] [NHJIRA] Commented: (NH-2559) NH 3.0 Linq Provider : Issue using multiple filters on the same entity - test case attached

[Justin G. (JIRA) <nh...@gm...>]

    [ http://216.121.112.228/browse/NH-2559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20625#action_20625 ] 

Justin Greene commented on NH-2559:
-----------------------------------

Looking into this more it looks like the issue _may_ be in the DotNode.cs class in the DereferenceCollection method.  This method calls set implied join and it seems to be selecting the wrong FromElement.  

Changing line 340 in DotNode from:
    SetImpliedJoin(elem)
To:
    _impliedJoin = elem

seems to resolve this issue.

Running the unit tests seems to come up with passing test cases; though I am still worried about unintended side effects of this change.  I am attaching another patch with this fix.  I'm hoping someone with more knowledge of nhibernates internals can take a look and see if this will work out.

> NH 3.0 Linq Provider : Issue using multiple filters on the same entity - test case attached
> -------------------------------------------------------------------------------------------
>
>                 Key: NH-2559
>                 URL: http://216.121.112.228/browse/NH-2559
>             Project:  NHibernate
>          Issue Type: Bug
>          Components: Linq Provider
>    Affects Versions: 3.0.0.GA
>            Reporter: Justin Greene
>            Priority: Critical
>         Attachments: ManyToManyAny.patch
>
>
> Exception:
> NHibernate.Test.Linq.ByMethod.AnyTests.ManyToManyAny:
> NHibernate.QueryException : could not resolve property: Description of: NHibernate.DomainModel.Northwind.Entities.Employee [.Where[NHibernate.DomainModel.Northwind.Entities.Order](.Where[NHibernate.DomainModel.Northwind.Entities.Order](NHibernate.Linq.NhQueryable`1[NHibernate.DomainModel.Northwind.Entities.Order], Quote((o, ) => (String.op_Equality(o.Employee.Address.Region, p1))), ), Quote((o, ) => (.Any[NHibernate.DomainModel.Northwind.Entities.Territory](o.Employee.Territories, (t, ) => (String.op_Equality(t.Description, p2)), ))), )]
> Details:
> If you remove the first where clause the query will work properly.  Adding it back in results in the above exception.  I've also run into a separate version of what I believe is the same problem; except that it fails silently and just produces an incorrect subquery.  I am unable to reproduce this second issue in nhibernates test harness.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira