[jira] [Created] (IGNITE-4460) .NET: Unhelpful error message for same-table SelectMany in LINQ

[Anton Vinogradov (Jira)]

Pavel Tupitsyn created IGNITE-4460:
--------------------------------------

             Summary: .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
            Priority: Trivial
             Fix For: 2.1


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.4#6332)