[
https://issues.apache.org/jira/browse/FLINK-40670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18116051#comment-18116051
]
Martijn Visser commented on FLINK-40670:
----------------------------------------
Not a duplicate of FLINK-40288 and not release-2.3 only. Every multi join file
in the planner and
the runtime is identical on master and release-2.3, and release-2.2 runs the
same program. Nothing
to backport. 200 runs on release-2.3 all gave the expected row with the raw
changelog
{{+I[Bob], +I[John], -D[John]}}, so I have no local reproduction.
{{Users4K}} declares {{k1 STRING PRIMARY KEY NOT ENFORCED}} but feeds two
different rows with
{{k1 = 'A1'}}. The join key contains k1, so the state view keeps one record per
join key: John
overwrites Bob without retracting him and the delete of John then drops the
entry. Bob only
survives because his row went out before John arrived.
> MultiJoinSemanticTests[four-way-mixed-join-multi-key-types-shuffled] loses a
> row on release-2.3
> -----------------------------------------------------------------------------------------------
>
> Key: FLINK-40670
> URL: https://issues.apache.org/jira/browse/FLINK-40670
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Affects Versions: 2.3.0
> Reporter: Martijn Visser
> Priority: Major
> Labels: test-stability
>
> {code}
> [ERROR]
> org.apache.flink.table.planner.plan.nodes.exec.stream.MultiJoinSemanticTests.runSteps(TableTestProgram)[16]
> -- Time elapsed: 0.756 s <<< FAILURE!
> java.lang.AssertionError:
> [four-way-mixed-join-multi-key-types-shuffled]
> Expecting actual:
> []
> to contain exactly in any order:
> ["+I[Bob, order2, payment2, null, A1, 200, false, k4_val2]"]
> but could not find the following elements:
> ["+I[Bob, order2, payment2, null, A1, 200, false, k4_val2]"]
> {code}
> https://github.com/apache/flink/actions/runs/34919695234
> https://github.com/apache/flink/actions/runs/34666549602
> Two of the seven release-2.3 runs in the window. It does not appear in any of
> the three cached master nightlies of 2026-09-13 to 2026-09-15, and
> {{MultiJoinSemanticTests}} does not exist on release-1.20.
> Two observations, neither of them a diagnosis. The result is empty where one
> row is expected, so this is a missing row rather than the extra rows
> FLINK-40288 produces, and the two do not always occur together: the
> 2026-09-12 nightly has this one without {{JoinSemanticTests}}. The program
> name ends in {{shuffled}}, so input ordering is part of what it exercises.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
