Binder Error: sum_no_overflow is for internal use only! #4320
Description
Issue found by SQLSmith on git commit hash 7292e using seed 565006829.
To Reproduce
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
select
subq_0.c0 as c0,
subq_0.c2 as c1,
multiply(
cast(
sum_no_overflow(
cast((select bigint from main.all_types limit 1 offset 5)
as bigint)) over (partition by subq_0.c1 order by subq_0.c1,subq_0.c0,subq_0.c0) as hugeint),
cast(case when (select date from main.all_types limit 1 offset 4)
is not NULL then cast(coalesce((select count_if(bool) from main.all_types)
,
cast(null as hugeint)) as hugeint) else cast(coalesce((select count_if(bool) from main.all_types)
,
cast(null as hugeint)) as hugeint) end
as hugeint)) as c2,
subq_0.c3 as c3,
cast(coalesce(subq_0.c1,
subq_0.c1) as uinteger) as c4,
subq_0.c3 as c5
from
(select
ref_1.dec_18_6 as c0,
sample_0.uint as c1,
(select uhugeint from main.all_types limit 1 offset 5)
as c2,
ref_1.list_of_fixed_int_array as c3
from
main.all_types as ref_0
inner join main.all_types as sample_0 tablesample system (5.3)
on ((ref_0.varchar !~~ ref_0.varchar)
and ((select varchar from main.all_types limit 1 offset 67)
~~ cast(null as varchar)))
inner join main.all_types as ref_1
inner join main.all_types as sample_1 tablesample bernoulli (7.2)
on (1)
on ((1)
or (sample_1.int is not NULL))
where ref_1.blob is not NULL
limit 138) as subq_0
where subq_0.c2 is not NULL;Error Message
Binder Error: sum_no_overflow is for internal use only!
Stack Trace