[
https://issues.apache.org/jira/browse/IGNITE-4460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15970963#comment-15970963
]
Pavel Tupitsyn commented on IGNITE-4460:
----------------------------------------
Simple validation added: all FROM clauses must be {{IQueryable}}
> .NET: Unhelpful error message for same-table SelectMany in LINQ
> ---------------------------------------------------------------
>
> Key: IGNITE-4460
> URL: https://issues.apache.org/jira/browse/IGNITE-4460
> Project: Ignite
> Issue Type: Bug
> Components: platforms
> Reporter: Pavel Tupitsyn
> Assignee: Pavel Tupitsyn
> Priority: Trivial
> Labels: .NET, LINQ
> Fix For: 2.0
>
>
> The following LINQ is not supported ({{RegionToRole}} is a collection, which
> is not understood by SQL):
> {code}
> users.Where(w => w.Value.ID == userId && !w.Value.IsDeleted)
> .SelectMany(sm => sm.Value.RegionToRole)
> {code}
> However, LINQ engine proceeds to generate an invalid query, which fails later
> in SQL engine:
> {code}
> Failed to parse query: select _T0._key, _T0._val from "User".User as _T0 ,
> "User".User as _T0 where ...
> {code}
> We should detect invalid LINQ early and throw an error with explanation.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
