Add fuzzers to 03208_buffer_over_distributed_type_mismatch

vdimir · vdimir · commit 4e8d11c48e9a · 2024-08-05T16:46:42.000Z
diff --git a/tests/queries/0_stateless/03208_buffer_over_distributed_type_mismatch.sql b/tests/queries/0_stateless/03208_buffer_over_distributed_type_mismatch.sql
@@ -58,3 +58,19 @@ SELECT amount FROM realtimebuff__fuzz_19 t1
 JOIN realtimebuff__fuzz_19 t2 ON t1.amount = t2.amount
 JOIN realtimebuff__fuzz_19 t3 ON t1.amount = t3.amount
 ; -- { serverError NOT_IMPLEMENTED,AMBIGUOUS_COLUMN_NAME }
+
+
+-- fuzzers:
+
+SELECT
+    toLowCardinality(1) + materialize(toLowCardinality(2))
+FROM realtimebuff__fuzz_19
+GROUP BY toLowCardinality(1)
+FORMAT Null
+;
+
+SELECT intDivOrZero(intDivOrZero(toLowCardinality(-128), toLowCardinality(-1)) = 0, materialize(toLowCardinality(4)))
+FROM realtimebuff__fuzz_19 GROUP BY materialize(toLowCardinality(-127)), intDivOrZero(0, 0) = toLowCardinality(toLowCardinality(0))
+WITH TOTALS ORDER BY ALL DESC NULLS FIRST
+FORMAT Null
+;
