Skip to content

Binder Error: Compressed materialization functions are for internal use only! #4322

@fuzzerofducks

Description

@fuzzerofducks

Issue found by SQLSmith on git commit hash 06f5a using seed 885641607.

To Reproduce

create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types();
select  
  ref_0.timestamptz_array as c0, 
  ref_0.dec_18_6 as c1, 
  ref_0.time_tz as c2, 
  ref_0.dec_4_1 as c3, 
  case when ref_0.varchar ^@ 
        arg_max(
          cast(ref_0.varchar as varchar),
          cast(version() as varchar)) over (partition by ref_0.struct_of_fixed_array order by ref_0.fixed_int_array) then (select bit from main.all_types limit 1 offset 2)
       else (select bit from main.all_types limit 1 offset 2)
       end
     as c4, 
  case when case when (cast(null as geometry) && cast(null as geometry)) 
          and (ref_0.varchar ~~ ref_0.varchar) then case when 1 then ref_0.bignum else ref_0.bignum end
           else case when 1 then ref_0.bignum else ref_0.bignum end
           end
         is NULL then case when ref_0.struct is not NULL then ref_0.time_tz else ref_0.time_tz end
       else case when ref_0.struct is not NULL then ref_0.time_tz else ref_0.time_tz end
       end
     as c5, 
  ref_0.time as c6, 
  ref_0.double as c7, 
  __internal_compress_integral_ubigint(
    cast(ref_0.hugeint as hugeint),
    cast(ref_0.hugeint as hugeint)) as c8, 
  ref_0.bignum as c9
from 
  main.all_types as ref_0
where (ref_0.smallint is not NULL) 
  and (ref_0.varchar ~~ ref_0.varchar);

Error Message

Binder Error: Compressed materialization functions are 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