You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Tupitsyn (Jira)" <ji...@apache.org> on 2021/01/12 07:18:00 UTC
[jira] [Issue Comment Deleted] (IGNITE-13754) .NET: LINQ provider emits incorrect table alias for queries with JOIN and GROUP BY combined

     [ https://issues.apache.org/jira/browse/IGNITE-13754?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pavel Tupitsyn updated IGNITE-13754:
------------------------------------
    Comment: was deleted

(was: {panel:title=Branch: [pull/8638/head] Base: [master] : Possible Blockers (10)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}ZooKeeper (Discovery) 1{color} [[tests 2|https://ci.ignite.apache.org/viewLog.html?buildId=5822401]]
* ZookeeperDiscoverySpiTestSuite1: ZookeeperDiscoveryMiscTest.testSetConsistentId - Test has low fail rate in base branch 0,0% and is not flaky
* ZookeeperDiscoverySpiTestSuite1: ZookeeperDiscoveryMiscTest.testAuthentication - Test has low fail rate in base branch 0,0% and is not flaky

{color:#d04437}SPI{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=5822394]]
* IgniteSpiTestSuite: IgniteDiscoveryMassiveNodeFailTest.testMassiveFail - Test has low fail rate in base branch 0,0% and is not flaky

{color:#d04437}Java Client{color} [[tests 0 TIMEOUT , Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=5822383]]

{color:#d04437}Platform .NET (Core Linux){color} [[tests 1 TC_SERVICE_MESSAGE |https://ci.ignite.apache.org/viewLog.html?buildId=5822440]]
* dll: ProjectFilesTest.TestAllCsharpFilesAreIncludedInProject - Test has low fail rate in base branch 0,0% and is not flaky

{color:#d04437}Cache 1{color} [[tests 2 TIMEOUT , Out Of Memory Error , Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=5822420]]
* IgniteBinaryCacheTestSuite: IgniteCacheConnectionRecovery10ConnectionsTest.testConnectionRecovery - Test has low fail rate in base branch 0,0% and is not flaky
* IgniteBinaryCacheTestSuite: DataStreamerImplSelfTest.testAddDataFromMap - Test has low fail rate in base branch 0,0% and is not flaky

{color:#d04437}Cache (Failover) 2{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=5822413]]
* IgniteCacheFailoverTestSuite2: GridCacheColocatedFailoverSelfTest.testPessimisticReadCommittedTxTopologyChange - Test has low fail rate in base branch 0,0% and is not flaky

{color:#d04437}Platform .NET (Integrations){color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=5822442]]
* dll: IgniteSessionStateStoreProviderTest.TestCaching - Test has low fail rate in base branch 0,0% and is not flaky

{panel}
{panel:title=Branch: [pull/8638/head] Base: [master] : New Tests (18)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Platform .NET (Core Linux){color} [[tests 18|https://ci.ignite.apache.org/viewLog.html?buildId=5822440]]
* {color:#013220}dll: CacheLinqTest.TestGroupByWithReverseJoinAndAnonymousProjectionWithRename - PASSED{color}
* {color:#013220}dll: CacheLinqTestSimpleName.TestGroupByWithReverseJoinAndAnonymousProjectionWithRename - PASSED{color}
* {color:#013220}dll: CacheLinqTestSqlEscapeAll.TestGroupByWithReverseJoinAndAnonymousProjectionWithRename - PASSED{color}
* {color:#013220}dll: CacheLinqTestSqlEscapeAll.TestGroupByWithJoin - PASSED{color}
* {color:#013220}dll: CacheLinqTestSqlEscapeAll.TestGroupByWithReverseJoin - PASSED{color}
* {color:#013220}dll: CacheLinqTestSimpleName.TestGroupByWithReverseJoinAndProjectionWithRename - PASSED{color}
* {color:#013220}dll: CacheLinqTestSqlEscapeAll.TestGroupBySubQuery - PASSED{color}
* {color:#013220}dll: CacheLinqTestSqlEscapeAll.TestGroupByWithReverseJoinAndProjection - PASSED{color}
* {color:#013220}dll: CacheLinqTestSqlEscapeAll.TestGroupByWithReverseJoinAndProjectionWithRename - PASSED{color}
* {color:#013220}dll: CacheLinqTest.TestGroupByWithReverseJoinAndProjection - PASSED{color}
* {color:#013220}dll: CacheLinqTest.TestGroupByWithReverseJoinAndProjectionWithRename - PASSED{color}
... and 7 new tests

{panel}
[TeamCity *--&gt; Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=5822464&amp;buildTypeId=IgniteTests24Java8_RunAll])

> .NET: LINQ provider emits incorrect table alias for queries with JOIN and GROUP BY combined
> -------------------------------------------------------------------------------------------
>
>                 Key: IGNITE-13754
>                 URL: https://issues.apache.org/jira/browse/IGNITE-13754
>             Project: Ignite
>          Issue Type: Bug
>          Components: platforms
>            Reporter: Pavel Tupitsyn
>            Assignee: Pavel Tupitsyn
>            Priority: Major
>              Labels: .NET
>             Fix For: 2.10
>
>         Attachments: Meeting.cs, MeetingAttachment.cs, Program.cs
>
>          Time Spent: 1h 10m
>  Remaining Estimate: 0h
>
> See the attached reproducer. Generated SQL is:
> {code}
> select _T0.MEETINGID, max (_T0.AttachmentDate)  from USERSCHEMA.MEETING as _T0 inner join USERSCHEMA.MEETINGATTACHMENT as _T1 on (_T1.MEETINGID = _T0.MEETINGID) group by (_T0.MEETINGID)
> {code}
> {{_T0.AttachmentDate}} should be {{_T1.AttachmentDate}} here.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)