-- Regression test for the count check in tdigest_add_double_count_trimmed, -- the transition function of the trimmed aggregates accepting an explicit -- number of occurrences of a value. -- -- The count says how many times the value is added to the digest, so it -- has to be a positive value. \set VERBOSITY terse -- zero count SELECT tdigest_avg(v, 0::bigint, 100, 0.0, 1.0) FROM (VALUES (1.0)) AS t(v); ERROR: invalid count value 0, must be a positive value SELECT tdigest_sum(v, 0::bigint, 100, 0.0, 1.0) FROM (VALUES (1.0)) AS t(v); ERROR: invalid count value 0, must be a positive value -- negative count SELECT tdigest_avg(v, -1::bigint, 100, 0.0, 1.0) FROM (VALUES (1.0)) AS t(v); ERROR: invalid count value -1, must be a positive value SELECT tdigest_sum(v, -1::bigint, 100, 0.0, 1.0) FROM (VALUES (1.0)) AS t(v); ERROR: invalid count value -1, must be a positive value -- the smallest valid count has to work SELECT tdigest_avg(v, 1::bigint, 100, 0.0, 1.0) FROM (VALUES (1.0)) AS t(v); tdigest_avg ------------- 1 (1 row) SELECT tdigest_sum(v, 1::bigint, 100, 0.0, 1.0) FROM (VALUES (1.0)) AS t(v); tdigest_sum ------------- 1 (1 row)