[
https://issues.apache.org/jira/browse/IGNITE-24709?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17934109#comment-17934109
]
Ignite TC Bot commented on IGNITE-24709:
----------------------------------------
{panel:title=Branch: [pull/11909/head] Base: [master] : Possible Blockers
(15)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}Platform .NET (Windows){color} [[tests 0 TIMEOUT , Out Of Memory
Error , Exit Code |https://ci2.ignite.apache.org/viewLog.html?buildId=8338723]]
{color:#d04437}Calcite SQL{color} [[tests
14|https://ci2.ignite.apache.org/viewLog.html?buildId=8338680]]
* IgniteCalciteTestSuite:
CorrelatedNestedLoopJoinPlannerTest.testFilterPushDown - Test has low fail rate
in base branch 0,0% and is not flaky
* IgniteCalciteTestSuite:
TableFunctionPlannerTest.testCorrelatedTableFunctionJoin - Test has low fail
rate in base branch 0,0% and is not flaky
* IgniteCalciteTestSuite:
CorrelatedSubqueryPlannerTest.testCorrelatedDistribution - Test has low fail
rate in base branch 0,0% and is not flaky
* IgniteCalciteTestSuite: CorrelatedSubqueryPlannerTest.test - Test has low
fail rate in base branch 0,0% and is not flaky
* IgniteCalciteTestSuite:
ProjectFilterScanMergePlannerTest.testProjectFilterIdentityMerge - Test has low
fail rate in base branch 0,0% and is not flaky
* IgniteCalciteTestSuite:
ProjectFilterScanMergePlannerTest.testProjectFilterProjectMerge - Test has low
fail rate in base branch 0,0% and is not flaky
* IgniteCalciteTestSuite:
ProjectFilterScanMergePlannerTest.testIdentityFilterProjectMerge - Test has low
fail rate in base branch 0,0% and is not flaky
* IgniteCalciteTestSuite:
ProjectFilterScanMergePlannerTest.testIdentityFilterIdentityMerge - Test has
low fail rate in base branch 0,0% and is not flaky
* IgniteCalciteTestSuite: IndexSearchBoundsPlannerTest.testBoundsWithCorrelate
- Test has low fail rate in base branch 0,0% and is not flaky
* IgniteCalciteTestSuite: IndexSearchBoundsPlannerTest.testBoundsComplex - Test
has low fail rate in base branch 0,0% and is not flaky
* IgniteCalciteTestSuite:
AggregatesIntegrationTest.testMultipleRowsFromSingleAggr[sqlTxMode=ALL] - Test
has low fail rate in base branch 0,0% and is not flaky
... and 3 tests blockers
{panel}
{panel:title=Branch: [pull/11909/head] Base: [master] : New Tests
(1)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests
1|https://ci2.ignite.apache.org/viewLog.html?buildId=8338680]]
* {color:#013220}IgniteCalciteTestSuite:
CorrelatedNestedLoopJoinPlannerTest.testProjectPushDown - PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=8338765&buildTypeId=IgniteTests24Java8_RunAll]
> Add PROJECT_CORRELATE rule to HEP push down list
> ------------------------------------------------
>
> Key: IGNITE-24709
> URL: https://issues.apache.org/jira/browse/IGNITE-24709
> Project: Ignite
> Issue Type: Bug
> Reporter: Maksim Timonin
> Assignee: Maksim Timonin
> Priority: Major
> Labels: ise
> Fix For: 2.18
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> For SQL query
> {code:java}
> select t0.id from t0 where exists (select * from t1 where t0.jid = t1.jid)
> {code}
> SQL engine extracts full rows from T0, but should ignore some columns and use
> only 'id, jid'.
> See plan of the query :
> {code:java}
> IgniteProject(ID=[$0])
> IgniteCorrelatedNestedLoopJoin(condition=[true], joinType=[inner],
> variablesSet=[[$cor0]], variablesSet=[[0]], correlationVariables=[[$cor0]])
> IgniteTableScan(table=[[PUBLIC, T0]])
> IgniteColocatedHashAggregate(group=[{0}])
> IgniteTableScan(table=[[PUBLIC, T1]], filters=[=($cor0.JID, $t0)],
> projects=[[true]], requiredColumns=[{1}])
> {code}
>
> IgniteProject(ID) must be replaced with IgniteTableScan#requiredColumns.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
