./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v9.3.2#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {csv-spec:lookup-join.MvJoinKeyOnTheLookupIndexAfterStats}" -Dtests.seed=57BC9424DE93780C -Dtests.bwc=true -Dtests.locale=sa-Deva-IN -Dtests.timezone=America/Regina -Druntime.java=25

java.lang.AssertionError: Context: {took=34, completion_time_in_millis=1772459093028, is_partial=false, columns=[{name=emp_no, type=integer}, {name=language_code, type=integer}, {name=language_name, type=keyword}], expiration_time_in_millis=1772891092932, values=[[10004, 4, Quenya], [10005, 5, null], [10006, 6, null], [10007, 7, null]], start_time_in_millis=1772459092994, documents_found=4, values_loaded=4}
Expected a list containing
0: expected "Line 5:3: evaluation of [LOOKUP JOIN languages_lookup_non_unique_key ON language_code] failed, treating result as null. Only first 20 failures recorded." but was <missing>
1: expected "Line 5:3: java.lang.IllegalArgumentException: LOOKUP JOIN encountered multi-value" but was <missing>