[nhibernate-issues] [NHJIRA] Updated: (NH-2692) Using Any() on a collection of components results in invalid SQL: Column of parent ID is used instead of key column

[cremor (JIRA) <nh...@gm...>]

     [ http://216.121.112.228/browse/NH-2692?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

cremor updated NH-2692:
-----------------------

    Attachment: NH2692 Test.zip

> Using Any() on a collection of components results in invalid SQL: Column of parent ID is used instead of key column
> -------------------------------------------------------------------------------------------------------------------
>
>                 Key: NH-2692
>                 URL: http://216.121.112.228/browse/NH-2692
>             Project:  NHibernate
>          Issue Type: Bug
>          Components: Linq Provider
>    Affects Versions: 3.2.0Alpha2
>            Reporter: cremor
>            Priority: Major
>         Attachments: NH2692 Test.zip
>
>
> The attached test shows that using a query like
> var result = session.Query<Parent>()
>   .Where(x => x.ChildComponents.Any())
>   .ToList();
> results in wrongly generated SQL. The subquery tries to select "ChildComponents.<column of parent ID>" instead of "ChildComponents.<key column of child>".

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