Test TestDistributedEngineOnlyQueries.testAssignUniqueId fails: incorrect results

[findepi]

Test TestDistributedEngineOnlyQueries.testAssignUniqueId is flaky when the whole class is run.
With @RepeatedTest(1000) is fails 99% the time on current master. The test query produces incorrect results.

Example failure (the actual number returned by the test query varies)

java.lang.AssertionError: For query 20240419_104337_00031_xxkai: 
 SELECT count(*) FROM (SELECT * FROM (   SELECT (SELECT count(*) WHERE c = 1)    FROM (SELECT CASE orderkey WHEN 1 THEN orderkey ELSE 1 END        FROM (SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem UNION ALL SELECT * FROM lineitem)) o(c)) result(a) WHERE a = 1)
not equal
Actual rows (up to 100 of 1 extra rows shown, 1 rows in total):
    [1484773]
Expected rows (up to 100 of 1 missing rows shown, 1 rows in total):
    [1504375]

[findepi]

The problem did not exist before #21583, so no released version is affected.