Mirza Aliev created IGNITE-16554:
------------------------------------

             Summary: Some tests in ItProjectScanMergeRuleTest do not pass
                 Key: IGNITE-16554
                 URL: https://issues.apache.org/jira/browse/IGNITE-16554
             Project: Ignite
          Issue Type: Bug
            Reporter: Mirza Aliev
         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}







--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to