[
https://issues.apache.org/jira/browse/IGNITE-16554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-16554:
--------------------------------------
Component/s: sql
> Some tests in ItProjectScanMergeRuleTest do not pass
> ----------------------------------------------------
>
> Key: IGNITE-16554
> URL: https://issues.apache.org/jira/browse/IGNITE-16554
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Mirza Aliev
> Priority: Major
> Labels: ignite-3
> Attachments: _Integration_Tests_Module_Runner_1651.log
>
>
> The following tests fail on TC and local runs:
> {{ItProjectScanMergeRuleTest#testProjects}} and
> {{ItProjectScanMergeRuleTest#testNestedProjects}}.
> {{ItProjectScanMergeRuleTest#testProjects}} fails with
> {noformat}
> java.lang.AssertionError: Invalid plan:
> IgniteExchange(distribution=[single]): rowcount = 10000.0, cumulative cost =
> IgniteCost [rowCount=20000.0, cpu=20000.0, memory=0.0, io=0.0,
> network=40000.0], id = 21
> IgniteTableScan(tableId=[24bcfc5f-5932-467a-b89f-6faa4eade77e],
> requiredColumns=[{5}]): rowcount = 10000.0, cumulative cost = IgniteCost
> [rowCount=10000.0, cpu=10000.0, memory=0.0, io=0.0, network=0.0], id = 18
> Expected: a string contains once
> ".*Ignite(Table|Index)Scan\\(table=\\[\\[PUBLIC, PRODUCTS\\]\\].*"
> but: was "IgniteExchange(distribution=[single]): rowcount = 10000.0,
> cumulative cost = IgniteCost [rowCount=20000.0, cpu=20000.0, memory=0.0,
> io=0.0, network=40000.0], id = 21
> IgniteTableScan(tableId=[24bcfc5f-5932-467a-b89f-6faa4eade77e],
> requiredColumns=[{5}]): rowcount = 10000.0, cumulative cost = IgniteCost
> [rowCount=10000.0, cpu=10000.0, memory=0.0, io=0.0, network=0.0], id = 18
> "
> {noformat}
> {{ItProjectScanMergeRuleTest#testNestedProjects}} fails with
> {noformat}
> java.lang.AssertionError: Invalid plan:
> IgniteProject(NAME=[$2]): rowcount = 375.0, cumulative cost = IgniteCost
> [rowCount=50375.0, cpu=319313.2429526658, memory=80000.0, io=0.0,
> network=80000.0], id = 16044
> IgniteMergeJoin(condition=[=($1, $3)], joinType=[inner], variablesSet=[[]],
> leftCollation=[[1]], rightCollation=[[0]]): rowcount = 375.0, cumulative cost
> = IgniteCost [rowCount=50000.0, cpu=318938.2429526658, memory=80000.0,
> io=0.0, network=80000.0], id = 16043
> IgniteSort(sort0=[$1], dir0=[ASC]): rowcount = 5000.0, cumulative cost =
> IgniteCost [rowCount=20000.0, cpu=177757.8978712436, memory=60000.0, io=0.0,
> network=60000.0], id = 16039
> IgniteExchange(distribution=[single]): rowcount = 5000.0, cumulative
> cost = IgniteCost [rowCount=15000.0, cpu=45000.0, memory=0.0, io=0.0,
> network=60000.0], id = 16038
> IgniteTableScan(tableId=[97c7efca-c87c-4bc1-abbd-79a7ba85f723],
> filters=[>($t0, 2)], requiredColumns=[{0, 2, 5}]): rowcount = 5000.0,
> cumulative cost = IgniteCost [rowCount=10000.0, cpu=40000.0, memory=0.0,
> io=0.0, network=0.0], id = 149
> IgniteSort(sort0=[$0], dir0=[ASC]): rowcount = 2500.0, cumulative cost =
> IgniteCost [rowCount=22500.0, cpu=111180.34508142219, memory=20000.0, io=0.0,
> network=20000.0], id = 16042
> IgniteSingleHashAggregate(group=[{0}]): rowcount = 2500.0, cumulative
> cost = IgniteCost [rowCount=20000.0, cpu=50000.0, memory=10000.0, io=0.0,
> network=20000.0], id = 16041
> IgniteExchange(distribution=[single]): rowcount = 5000.0, cumulative
> cost = IgniteCost [rowCount=15000.0, cpu=45000.0, memory=0.0, io=0.0,
> network=20000.0], id = 16040
> IgniteTableScan(tableId=[97c7efca-c87c-4bc1-abbd-79a7ba85f723],
> filters=[>($t0, 1)], requiredColumns=[{2}]): rowcount = 5000.0, cumulative
> cost = IgniteCost [rowCount=10000.0, cpu=40000.0, memory=0.0, io=0.0,
> network=0.0], id = 178
> Expected: a string contains once
> ".*Ignite(Table|Index)Scan\\(table=\\[\\[PUBLIC,
> PRODUCTS\\]\\],.*requiredColumns=\\[\\{(\\d|\\W|,)+\\}\\].*"
> but: was "IgniteProject(NAME=[$2]): rowcount = 375.0, cumulative cost =
> IgniteCost [rowCount=50375.0, cpu=319313.2429526658, memory=80000.0, io=0.0,
> network=80000.0], id = 16044
> IgniteMergeJoin(condition=[=($1, $3)], joinType=[inner], variablesSet=[[]],
> leftCollation=[[1]], rightCollation=[[0]]): rowcount = 375.0, cumulative cost
> = IgniteCost [rowCount=50000.0, cpu=318938.2429526658, memory=80000.0,
> io=0.0, network=80000.0], id = 16043
> IgniteSort(sort0=[$1], dir0=[ASC]): rowcount = 5000.0, cumulative cost =
> IgniteCost [rowCount=20000.0, cpu=177757.8978712436, memory=60000.0, io=0.0,
> network=60000.0], id = 16039
> IgniteExchange(distribution=[single]): rowcount = 5000.0, cumulative
> cost = IgniteCost [rowCount=15000.0, cpu=45000.0, memory=0.0, io=0.0,
> network=60000.0], id = 16038
> IgniteTableScan(tableId=[97c7efca-c87c-4bc1-abbd-79a7ba85f723],
> filters=[>($t0, 2)], requiredColumns=[{0, 2, 5}]): rowcount = 5000.0,
> cumulative cost = IgniteCost [rowCount=10000.0, cpu=40000.0, memory=0.0,
> io=0.0, network=0.0], id = 149
> IgniteSort(sort0=[$0], dir0=[ASC]): rowcount = 2500.0, cumulative cost =
> IgniteCost [rowCount=22500.0, cpu=111180.34508142219, memory=20000.0, io=0.0,
> network=20000.0], id = 16042
> IgniteSingleHashAggregate(group=[{0}]): rowcount = 2500.0, cumulative
> cost = IgniteCost [rowCount=20000.0, cpu=50000.0, memory=10000.0, io=0.0,
> network=20000.0], id = 16041
> IgniteExchange(distribution=[single]): rowcount = 5000.0, cumulative
> cost = IgniteCost [rowCount=15000.0, cpu=45000.0, memory=0.0, io=0.0,
> network=20000.0], id = 16040
> IgniteTableScan(tableId=[97c7efca-c87c-4bc1-abbd-79a7ba85f723],
> filters=[>($t0, 1)], requiredColumns=[{2}]): rowcount = 5000.0, cumulative
> cost = IgniteCost [rowCount=10000.0, cpu=40000.0, memory=0.0, io=0.0,
> network=0.0], id = 178
> "
> {noformat}
> https://ci.ignite.apache.org/buildConfiguration/ignite3_Test_RunAllTests/6417776?logFilter=debug
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
