Flaky test: 02967_parallel_replicas_joins_and_analyzer #100869
Description
Important: This issue was automatically generated and is used by CI for matching failures. DO NOT modify the body content. DO NOT remove labels.
Test name: 02967_parallel_replicas_joins_and_analyzer
Failure reason: y
CI report: Stateless tests (amd_msan, WasmEdge, parallel, 1/2)
Failing test history: cidb
Test output:
2026-03-27 02:24:17 Reason: result differs with reference:
2026-03-27 02:24:17 --- /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02967_parallel_replicas_joins_and_analyzer.reference 2026-03-27 02:17:47.895474641 +0300
2026-03-27 02:24:17 +++ /home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/tests/queries/0_stateless/02967_parallel_replicas_joins_and_analyzer.gen.4680.stdout 2026-03-27 02:24:17.059132579 +0300
2026-03-27 02:24:17 @@ -773,32 +773,35 @@
2026-03-27 02:24:17 sub2 as (select y, z from tab2 where y != 4),
2026-03-27 02:24:17 sub3 as (select l.x, l.y, r.y, r.z as z from sub2 r any right join sub1 l on l.y = r.y),
2026-03-27 02:24:17 sub4 as (select z, a from tab3 where z != 8),
2026-03-27 02:24:17 sub5 as (select x, l.y, y, z, rr.z, a from sub3 ll any left join sub4 rr on ll.z = rr.z)
2026-03-27 02:24:17 select * from sub5;
2026-03-27 02:24:17 Union
2026-03-27 02:24:17 Expression
2026-03-27 02:24:17 Expression
2026-03-27 02:24:17 Join
2026-03-27 02:24:17 Expression
2026-03-27 02:24:17 - Join
2026-03-27 02:24:17 - Expression
2026-03-27 02:24:17 - Expression
2026-03-27 02:24:17 - ReadFromMergeTree
2026-03-27 02:24:17 + Expression
2026-03-27 02:24:17 Expression
2026-03-27 02:24:17 - BuildRuntimeFilter
2026-03-27 02:24:17 + Join
2026-03-27 02:24:17 + Expression
2026-03-27 02:24:17 + Expression
2026-03-27 02:24:17 + Expression
2026-03-27 02:24:17 + ReadFromMergeTree
2026-03-27 02:24:17 Expression
2026-03-27 02:24:17 Expression
2026-03-27 02:24:17 - ReadFromMergeTree
2026-03-27 02:24:17 + Expression
2026-03-27 02:24:17 + ReadFromMergeTree
2026-03-27 02:24:17 Expression
2026-03-27 02:24:17 Expression
2026-03-27 02:24:17 - ReadFromMergeTree
2026-03-27 02:24:17 + Expression
2026-03-27 02:24:17 + ReadFromMergeTree
2026-03-27 02:24:17 Expression
2026-03-27 02:24:17 ReadFromRemoteParallelReplicas
2026-03-27 02:24:17 --
2026-03-27 02:24:17 -- RIGHT JOIN in sub5: sub5 -> WithMergableStage
2026-03-27 02:24:17 with sub1 as (select x, y from tab1 where x != 2),
2026-03-27 02:24:17 sub2 as (select y, z from tab2 where y != 4),
2026-03-27 02:24:17 sub3 as (select l.x, l.y, r.y, r.z as z from sub1 l any left join sub2 r on l.y = r.y),
2026-03-27 02:24:17 sub4 as (select z, a from tab3 where z != 8),
2026-03-27 02:24:17 sub5 as (select z, a, x, y, r.y, ll.z from sub4 rr any right join sub3 ll on ll.z = rr.z)
2026-03-27 02:24:17 select * from sub5 order by x;
2026-03-27 02:24:17 @@ -823,34 +826,38 @@
2026-03-27 02:24:17 sub3 as (select l.x, l.y, r.y, r.z as z from sub1 l any left join sub2 r on l.y = r.y),
2026-03-27 02:24:17 sub4 as (select z, a from tab3 where z != 8),
2026-03-27 02:24:17 sub5 as (select z, a, x, y, r.y, ll.z from sub4 rr any right join sub3 ll on ll.z = rr.z)
~~~~~ truncated 52 lines ~~~~~