[
https://issues.apache.org/jira/browse/IGNITE-4817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15958451#comment-15958451
]
Pavel Tupitsyn commented on IGNITE-4817:
----------------------------------------
[~GuruStron] looks good to me in general. I've fixed a couple minor issues:
* Line length should not exceed 120 chars (not your fault, it wasn't specified
on wiki
https://cwiki.apache.org/confluence/display/IGNITE/Ignite.NET+Development)
* Some simplification in {{CacheQueryParser}} - default parameter is never
used, class and method can be made private
> .NET: Contains fails in LINQ when subquery comes from a variable
> ----------------------------------------------------------------
>
> Key: IGNITE-4817
> URL: https://issues.apache.org/jira/browse/IGNITE-4817
> Project: Ignite
> Issue Type: Bug
> Components: platforms
> Affects Versions: 1.9
> Reporter: Pavel Tupitsyn
> Assignee: Sergey Stronchinskiy
> Priority: Minor
> Labels: .NET, LINQ
> Fix For: 2.0
>
>
> Using Contains with subquery works when subquery is inline:
> {code}
> var res = personsQry.Where(x => orgsQry.Where(o => o.Value.Size <
> 100000).Select(o => o.Key).Contains(x.Value.OrgId));
> {code}
> And fails when extracted into a variable:
> {code}
> var orgIds = orgsQry.Where(o => o.Value.Size < 100000).Select(o => o.Key);
>
> var res = personsQry.Where(x => orgIds.Contains(x.Value.OrgId));
> {code}
> Exception:
> {code}
> Failed to parse query: select _T0._key, _T0._val from "persons-linq".Person
> as _T0 where (_T0.OrgId IN (select _T1._key, _T1._val from
> "orgs-linq".Organization as _T1 ))
> Caused by: org.h2.jdbc.JdbcSQLException: Subquery is not a single column query
> {code}
> This can be reproduced in {{CacheLinqTest.TestContains}} by extracting a
> variable:
> {code}
> var foo = orgCache
> .Where(orgEntry => orgEntry.Value.Name == "Org_1")
> .Select(orgEntry => orgEntry.Key);
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
