[
https://issues.apache.org/jira/browse/IGNITE-27700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18055929#comment-18055929
]
Ignite TC Bot commented on IGNITE-27700:
----------------------------------------
{panel:title=Branch: [pull/12675/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/12675/head] Base: [master] : New Tests
(3)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests
3|https://ci2.ignite.apache.org/viewLog.html?buildId=8836654]]
* {color:#013220}IgniteCalciteTestSuite: TpchScale100Test.test[queryId=16] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
ProjectFilterScanMergePlannerTest.testCorrelatedFilterWithTrimMerge -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
ProjectFilterScanMergePlannerTest.testAlwaysFalseFilterNotMerged - PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=8830293&buildTypeId=IgniteTests24Java8_RunAll]
> Test TpchScale100Test.test[queryId=20] is flaky
> -----------------------------------------------
>
> Key: IGNITE-27700
> URL: https://issues.apache.org/jira/browse/IGNITE-27700
> Project: Ignite
> Issue Type: Bug
> Reporter: Aleksey Plekhanov
> Assignee: Aleksey Plekhanov
> Priority: Major
> Labels: calcite, ise
> Time Spent: 40m
> Remaining Estimate: 0h
>
> Test TpchScale100Test.test[queryId=20] is flaky. For some reason plans are
> differnt between execution. But main problem: filter is not merged into scan.
> See next plan part after {{trimUnusedFields}}:
> {noformat}
> LogicalProject(L_QUANTITY=[$2])
> LogicalFilter(condition=[AND(=($0, $cor0.PS_PARTKEY), =($1,
> $cor0.PS_SUPPKEY), >=($3, 1994-01-01), <($3, +(1994-01-01, *(12:INTERVAL
> YEAR, 1))))])
> LogicalProject(L_PARTKEY=[$3], L_SUPPKEY=[$4], L_QUANTITY=[$6],
> L_SHIPDATE=[$12])
> IgniteLogicalTableScan(table=[[PUBLIC, LINEITEM]])
> {noformat}
> Filter can't transpose project ({{CoreRules.FILTER_PROJECT_TRANSPOSE}}),
> since it contains correlates. And part of filter condition can't be merged
> into scan ({{FilterScanMergeRule.TABLE_SCAN_SKIP_CORRELATED}}), since project
> node located between filter and scan.
> Plans difference should be investigated separately.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
