./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.LookupJoinWithMixPushableAndUnpushableFilters}" -Dtests.seed=4A0791B78797EB0C -Dtests.bwc=true -Dtests.locale=os-Cyrl-GE -Dtests.timezone=Australia/Sydney -Druntime.java=25

java.lang.AssertionError: Context: {took=33, completion_time_in_millis=1772450253196, is_partial=false, columns=[{name=id_int, type=integer}, {name=name_str, type=keyword}, {name=extra1, type=keyword}, {name=other1, type=keyword}, {name=other2, type=integer}], expiration_time_in_millis=1772882253009, values=[[4, David, qux, zeta, 6000]], start_time_in_millis=1772450253163, documents_found=2, values_loaded=7}
Expected a list containing
0: expected "Line 2:3: evaluation of [LOOKUP JOIN multi_column_joinable_lookup ON id_int, is_active_bool] failed, treating result as null. Only first 20 failures recorded." but was "Line 3:18: evaluation of [id_int + 5000] failed, treating result as null. Only first 20 failures recorded."
1: expected "Line 2:3: java.lang.IllegalArgumentException: LOOKUP JOIN encountered multi-value" but was "Line 3:18: java.lang.IllegalArgumentException: single-value function encountered multi-value"
2: expected "Line 3:18: evaluation of [id_int + 5000] failed, treating r
[truncated]