Fix flaky test: remove tied NaN values in Float64 test data

murphy-4o · murphy-4o · commit cdf1f2e67c91 · 2026-04-02T08:17:40.000Z
The NaN test had two groups (b and d) both with nan, causing
non-deterministic ordering under random settings. Changed d from nan
to 150 so all aggregate values are distinct.

Made-with: Cursor
diff --git a/tests/queries/0_stateless/03467_topn_aggregation.reference b/tests/queries/0_stateless/03467_topn_aggregation.reference
@@ -201,51 +201,51 @@ g195	9995
 -- NaN DESC: optimized
 c	300
 f	200
-a	100
+d	150
 -- NaN DESC: reference
 c	300
 f	200
-a	100
+d	150
 -- NaN ASC: optimized
 e	50
 a	100
-f	200
+d	150
 -- NaN ASC: reference
 e	50
 a	100
-f	200
+d	150
 -- NaN DESC NULLS LAST: optimized
 c	300
 f	200
-a	100
+d	150
 -- NaN DESC NULLS LAST: reference
 c	300
 f	200
-a	100
+d	150
 -- NaN ASC NULLS FIRST: optimized
 b	nan
-d	nan
 e	50
+a	100
 -- NaN ASC NULLS FIRST: reference
 b	nan
-d	nan
 e	50
+a	100
 -- NaN DESC level 2: optimized
 c	300
 f	200
-a	100
+d	150
 -- NaN DESC level 2: reference
 c	300
 f	200
-a	100
+d	150
 -- NaN ASC level 2: optimized
 e	50
 a	100
-f	200
+d	150
 -- NaN ASC level 2: reference
 e	50
 a	100
-f	200
+d	150
 -- nullable key DESC NULLS LAST: optimized
 a	2024-01-05 00:00:00
 f	2024-01-04 00:00:00
diff --git a/tests/queries/0_stateless/03467_topn_aggregation.sql b/tests/queries/0_stateless/03467_topn_aggregation.sql
@@ -420,7 +420,7 @@ ENGINE = MergeTree ORDER BY grp;
 
 INSERT INTO t_topn_nan SELECT
     arrayJoin(['a','b','c','d','e','f']) AS grp,
-    multiIf(grp='a', 100, grp='b', 0.0/0.0, grp='c', 300, grp='d', 0.0/0.0, grp='e', 50, 200) AS val;
+    multiIf(grp='a', 100, grp='b', 0.0/0.0, grp='c', 300, grp='d', 150, grp='e', 50, 200) AS val;
 
 SELECT '-- NaN DESC: optimized';
 SELECT grp, max(val) AS m
