1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
# name: test/fuzzer/duckfuzz/bitstring_agg_unfoldable.test
# description: Bitstring agg with unfoldable parameters
# group: [duckfuzz]
statement ok
PRAGMA enable_verification
statement error
SELECT bitstring_agg(i, i, 42) FROM range(10) t(i);
----
requires a constant min and max argument
statement error
SELECT bitstring_agg(i, 42, i) FROM range(10) t(i);
----
requires a constant min and max argument
# constant but not foldable
statement error
SELECT bitstring_agg(i, 0, (100 + random())::BIGINT) FROM range(10) t(i);
----
requires a constant min and max argument
statement ok
PRAGMA disable_verification
statement error
SELECT bitstring_agg(i, 0, 3) FROM range(10) t(i);
----
outside of provided min and max range
|