Skip to content

Binder Error: sum_no_overflow is for internal use only! #4316

@fuzzerofducks

Description

@fuzzerofducks

Issue found by SQLSmith on git commit hash e120b using seed 297901679.

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
select  
  subq_0.c6 as c0
from 
  (select  
        sample_0.uuid as c0, 
        ref_0.bool as c1, 
        ref_0.timestamp_tz as c2, 
        sample_1.int as c3, 
        ref_0.list_of_fixed_int_array as c4, 
        (select sum_no_overflow(bigint) from main.all_types)
           as c5, 
        sample_0.bit as c6, 
        ref_0.double_array as c7, 
        julian(
          cast(ref_0.timestamp as timestamp)) as c8, 
        sample_1.uint as c9, 
        ref_0.uuid as c10, 
        sample_1.int as c11, 
        sample_1.int as c12
      from 
        main.all_types as ref_0
          left join main.all_types as sample_0 tablesample system (2.2) 
            right join main.all_types as sample_1 tablesample system (0.5) 
            on ((sample_1.varchar !~~ sample_0.varchar) 
                and (sample_0.varchar !~~ sample_1.varchar))
          on ((ref_0.varchar ^@ sample_0.varchar) 
              and (ref_0.varchar ~~~ sample_0.varchar))
      where sample_1.varchar !~~* (select varchar from main.all_types limit 1 offset 1)
          
      limit 101) as subq_0
where subq_0.c5 is not NULL
limit 123;

Error Message

Binder Error: sum_no_overflow is for internal use only!

Stack Trace


Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions