Add test for #57086

Algunenano · Algunenano · commit 84727e986ea8 · 2023-12-27T17:05:37.000+01:00
diff --git a/tests/queries/0_stateless/02954_analyzer_fuzz_i57086.reference b/tests/queries/0_stateless/02954_analyzer_fuzz_i57086.reference
@@ -0,0 +1,2 @@
+limit w/ GROUP BY	0	0
+limit w/ GROUP BY	0	0
diff --git a/tests/queries/0_stateless/02954_analyzer_fuzz_i57086.sql b/tests/queries/0_stateless/02954_analyzer_fuzz_i57086.sql
@@ -0,0 +1,15 @@
+--https://github.com/ClickHouse/ClickHouse/issues/57086
+SELECT
+    'limit w/ GROUP BY',
+    count(NULL),
+    number
+FROM remote('127.{1,2}', view(
+        SELECT intDiv(number, 2147483647) AS number
+        FROM numbers(10)
+    ))
+GROUP BY number
+WITH ROLLUP
+ORDER BY
+    count() ASC,
+    number DESC NULLS LAST
+    SETTINGS limit = 2, allow_experimental_analyzer = 1;
