[
https://issues.apache.org/jira/browse/IGNITE-25235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17948192#comment-17948192
]
Ignite TC Bot commented on IGNITE-25235:
----------------------------------------
{panel:title=Branch: [pull/12038/head] Base: [master] : Possible Blockers
(1)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}Cache 7{color} [[tests
1|https://ci2.ignite.apache.org/viewLog.html?buildId=8411823]]
* IgniteCacheTestSuite7:
WalModeChangeAdvancedSelfTest.testServerRestartNonCoordinator - Test has low
fail rate in base branch 0,0% and is not flaky
{panel}
{panel:title=Branch: [pull/12038/head] Base: [master] : New Tests
(28)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests
4|https://ci2.ignite.apache.org/viewLog.html?buildId=8412066]]
* {color:#013220}IgniteCalciteTestSuite:
DistributedJoinIntegrationTest.testJoinWithBroadcastAggregate[sqlTxMode=NONE] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
DistributedJoinIntegrationTest.testJoinWithBroadcastAggregate[sqlTxMode=RANDOM]
- PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
DistributedJoinIntegrationTest.testJoinWithBroadcastAggregate[sqlTxMode=ALL] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
JoinColocationPlannerTest.joinBroadcastAggregateRehash - PASSED{color}
{color:#00008b}PDS (Compatibility){color} [[tests
24|https://ci2.ignite.apache.org/viewLog.html?buildId=8410629]]
* {color:#013220}IgniteCompatibilityBasicTestSuite:
SnapshotCompatibilityTest.testSnapshotRestore[incrementalSnp=true,
consistentID=f355788f-b0be-4b59-a8ab-843b0a7a68cc, oldNodesCnt=1,
cacheDump=false, customSnpPath=false, testCacheGrp=false] - PASSED{color}
* {color:#013220}IgniteCompatibilityBasicTestSuite:
SnapshotCompatibilityTest.testSnapshotRestore[incrementalSnp=true,
consistentID=f355788f-b0be-4b59-a8ab-843b0a7a68cc, oldNodesCnt=1,
cacheDump=false, customSnpPath=false, testCacheGrp=true] - PASSED{color}
* {color:#013220}IgniteCompatibilityBasicTestSuite:
SnapshotCompatibilityTest.testSnapshotRestore[incrementalSnp=true,
consistentID=f355788f-b0be-4b59-a8ab-843b0a7a68cc, oldNodesCnt=1,
cacheDump=false, customSnpPath=true, testCacheGrp=false] - PASSED{color}
* {color:#013220}IgniteCompatibilityBasicTestSuite:
SnapshotCompatibilityTest.testSnapshotRestore[incrementalSnp=true,
consistentID=f355788f-b0be-4b59-a8ab-843b0a7a68cc, oldNodesCnt=1,
cacheDump=false, customSnpPath=true, testCacheGrp=true] - PASSED{color}
* {color:#013220}IgniteCompatibilityBasicTestSuite:
SnapshotCompatibilityTest.testSnapshotRestore[incrementalSnp=true,
consistentID=f355788f-b0be-4b59-a8ab-843b0a7a68cc, oldNodesCnt=3,
cacheDump=false, customSnpPath=false, testCacheGrp=false] - PASSED{color}
* {color:#013220}IgniteCompatibilityBasicTestSuite:
SnapshotCompatibilityTest.testSnapshotRestore[incrementalSnp=true,
consistentID=f355788f-b0be-4b59-a8ab-843b0a7a68cc, oldNodesCnt=3,
cacheDump=false, customSnpPath=false, testCacheGrp=true] - PASSED{color}
* {color:#013220}IgniteCompatibilityBasicTestSuite:
SnapshotCompatibilityTest.testSnapshotRestore[incrementalSnp=true,
consistentID=f355788f-b0be-4b59-a8ab-843b0a7a68cc, oldNodesCnt=3,
cacheDump=false, customSnpPath=true, testCacheGrp=false] - PASSED{color}
* {color:#013220}IgniteCompatibilityBasicTestSuite:
SnapshotCompatibilityTest.testSnapshotRestore[incrementalSnp=true,
consistentID=f355788f-b0be-4b59-a8ab-843b0a7a68cc, oldNodesCnt=3,
cacheDump=false, customSnpPath=true, testCacheGrp=true] - PASSED{color}
* {color:#013220}IgniteCompatibilityBasicTestSuite:
SnapshotCompatibilityTest.testSnapshotRestore[incrementalSnp=false,
consistentID=f355788f-b0be-4b59-a8ab-843b0a7a68cc, oldNodesCnt=1,
cacheDump=true, customSnpPath=false, testCacheGrp=false] - PASSED{color}
* {color:#013220}IgniteCompatibilityBasicTestSuite:
SnapshotCompatibilityTest.testSnapshotRestore[incrementalSnp=false,
consistentID=f355788f-b0be-4b59-a8ab-843b0a7a68cc, oldNodesCnt=1,
cacheDump=true, customSnpPath=false, testCacheGrp=true] - PASSED{color}
* {color:#013220}IgniteCompatibilityBasicTestSuite:
SnapshotCompatibilityTest.testSnapshotRestore[incrementalSnp=false,
consistentID=f355788f-b0be-4b59-a8ab-843b0a7a68cc, oldNodesCnt=1,
cacheDump=true, customSnpPath=true, testCacheGrp=false] - PASSED{color}
... and 13 new tests
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=8410678&buildTypeId=IgniteTests24Java8_RunAll]
> Calcite engine. Wrong query results for join with broadcast
> -----------------------------------------------------------
>
> Key: IGNITE-25235
> URL: https://issues.apache.org/jira/browse/IGNITE-25235
> Project: Ignite
> Issue Type: Bug
> Reporter: Aleksey Plekhanov
> Assignee: Aleksey Plekhanov
> Priority: Major
> Labels: calcite, ise
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> Reproducer:
> {code:java}
> @Test
> public void testJoinWithBroadcast() {
> sql("CREATE TABLE t(id INT, val VARCHAR, PRIMARY KEY(id)) WITH " +
> atomicity());
> for (int i = 0; i < 1000; i++)
> sql("INSERT INTO t VALUES (?, ?)", i, "val" + i);
> assertQuery("SELECT * FROM t WHERE id IN (SELECT * FROM (VALUES (?),
> (?), (?)))")
> .withParams(10, 20, 30)
> .returns(10, "val10").returns(20, "val20").returns(30, "val30")
> .check();
> }
> {code}
> The plan for the query:
> {noformat}
> IgniteExchange(distribution=[single]): rowcount = 1.0, cumulative cost =
> IgniteCost [rowCount=2019.5, cpu=5028.5, memory=13.0, io=1.0, network=15.0],
> id = 4663
> IgniteProject(ID=[$0], VAL=[$1]): rowcount = 1.0, cumulative cost =
> IgniteCost [rowCount=2018.5, cpu=5027.5, memory=13.0, io=1.0, network=7.0],
> id = 4662
> IgniteMergeJoin(condition=[=($0, $2)], joinType=[inner],
> variablesSet=[[]], leftCollation=[[0 ASC-nulls-first]], rightCollation=[[0
> ASC-nulls-first]]): rowcount = 1.0, cumulative cost = IgniteCost
> [rowCount=2017.5, cpu=5026.5, memory=13.0, io=1.0, network=7.0], id = 4661
> IgniteIndexScan(table=[[PUBLIC, T]], index=[_key_PK_proxy],
> requiredColumns=[{2, 3}], inlineScan=[false], collation=[[2
> ASC-nulls-first]]): rowcount = 1000.0, cumulative cost = IgniteCost
> [rowCount=1001.0, cpu=1001.0, memory=1.0, io=1.0, network=1.0], id = 414
> IgniteExchange(distribution=[affinity[identity=AffinityIdentity
> [affFuncCls=class
> org.apache.ignite.cache.affinity.rendezvous.RendezvousAffinityFunction,
> backups=0, partsCnt=1024, filterCls=class
> org.apache.ignite.configuration.CacheConfiguration$IgniteAllNodesPredicate,
> hash=1953727900], cacheId=-1578586257][0]]): rowcount = 1.5, cumulative cost
> = IgniteCost [rowCount=15.0, cpu=19.5, memory=12.0, io=0.0, network=6.0], id
> = 4660
> IgniteSort(sort0=[$0], dir0=[ASC-nulls-first]): rowcount = 1.5,
> cumulative cost = IgniteCost [rowCount=13.5, cpu=18.0, memory=12.0, io=0.0,
> network=0.0], id = 4659
> IgniteColocatedHashAggregate(group=[{0}]): rowcount = 1.5,
> cumulative cost = IgniteCost [rowCount=12.0, cpu=12.0, memory=6.0, io=0.0,
> network=0.0], id = 4658
> IgniteUnionAll(all=[true]): rowcount = 3.0, cumulative cost =
> IgniteCost [rowCount=9.0, cpu=9.0, memory=0.0, io=0.0, network=0.0], id = 4657
> IgniteProject(EXPR$0=[?0]): rowcount = 1.0, cumulative cost =
> IgniteCost [rowCount=2.0, cpu=2.0, memory=0.0, io=0.0, network=0.0], id = 4654
> IgniteValues(tuples=[[{ 0 }]]): rowcount = 1.0, cumulative
> cost = IgniteCost [rowCount=1.0, cpu=1.0, memory=0.0, io=0.0, network=0.0],
> id = 200
> IgniteProject(EXPR$0=[?1]): rowcount = 1.0, cumulative cost =
> IgniteCost [rowCount=2.0, cpu=2.0, memory=0.0, io=0.0, network=0.0], id = 4655
> IgniteValues(tuples=[[{ 0 }]]): rowcount = 1.0, cumulative
> cost = IgniteCost [rowCount=1.0, cpu=1.0, memory=0.0, io=0.0, network=0.0],
> id = 200
> IgniteProject(EXPR$0=[?2]): rowcount = 1.0, cumulative cost =
> IgniteCost [rowCount=2.0, cpu=2.0, memory=0.0, io=0.0, network=0.0], id = 4656
> IgniteValues(tuples=[[{ 0 }]]): rowcount = 1.0, cumulative
> cost = IgniteCost [rowCount=1.0, cpu=1.0, memory=0.0, io=0.0, network=0.0],
> id = 200
> {noformat}
> There is at least one problem on planning: for some reason {{IgniteValues}}
> nodes have {{single}} distribution instead of {{broadcast}}, and
> {{IgniteExchange}} to affinity distribution is produced instead of
> {{IgniteTrimExchange}}.
> But even with {{IgniteExchange}} results should be correct. There is some
> another problem on mapping: fragment with {{IgniteValues}} is not sent to any
> node, so the result is empty.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
