Binder Error: Compressed materialization functions are for internal use only! #4321
Description
Issue found by SQLSmith on git commit hash 64314 using seed 190215489.
To Reproduce
create table all_types as select * exclude(small_enum, medium_enum, large_enum) from test_all_types() limit 0;
insert into main.all_types values (
0,
cast(null as tinyint),
cast(null as smallint),
42,
default,
cast(null as hugeint),
cast(null as uhugeint),
abs(
cast(cast(null as utinyint) as utinyint)),
default,
cast(null as uinteger),
cast(null as ubigint),
cast(null as bignum),
default,
case when EXISTS (
select
arg_min_null(
cast(sample_0.blob as blob),
cast((select blob from main.all_types limit 1 offset 42)
as blob)) over (partition by sample_0.int order by sample_0.dec_9_4) as c0,
case when sample_0.varchar ^@ sample_0.varchar then sample_0.timestamp_ms else sample_0.timestamp_ms end
as c1,
sample_0.date as c2,
case when (sample_0.varchar !~~* sample_0.varchar)
or (sample_0.varchar !~~* sample_0.varchar) then (select struct_of_arrays from main.all_types limit 1 offset 3)
else (select struct_of_arrays from main.all_types limit 1 offset 3)
end
as c3,
sample_0.time_tz as c4,
sample_0.bignum as c5,
cast(nullif(__internal_decompress_integral_ubigint(
cast(sample_0.usmallint as usmallint),
cast(sample_0.usmallint as usmallint)),
sample_0.ubigint) as ubigint) as c6,
sample_0.union as c7,
sample_0.array_of_structs as c8,
sample_0.timestamp as c9
from
main.all_types as sample_0 tablesample bernoulli (6.2)
where EXISTS (
select
22 as c0,
sample_0.double as c1,
subq_0.c0 as c2,
sample_1.tinyint as c3,
sample_1.dec_18_6 as c4,
subq_0.c0 as c5,
sample_0.tinyint as c6,
sample_1.int as c7,
sample_0.map as c8
from
main.all_types as sample_1 tablesample system (3.8) ,
lateral (select
sample_1.time_tz as c0
from
main.all_types as ref_0
where (ref_0.varchar ^@ sample_0.varchar)
or (((ref_0.varchar ^@ sample_0.varchar)
or ((sample_1.blob is NULL)
or (sample_0.varchar ~~* sample_0.varchar)))
and (ref_0.varchar ~~ (select varchar from main.all_types limit 1 offset 3)
))) as subq_0
where subq_0.c0 is not NULL
limit 34)
limit 89) then (select time from main.all_types limit 1 offset 5)
else (select time from main.all_types limit 1 offset 5)
end
,
cast(coalesce(cast(null as timestamp),
cast(null as timestamp)) as timestamp),
cast(null as timestamp_s),
cast(null as timestamp_ms),
default,
cast(null as time with time zone),
cast(nullif(cast(null as timestamp with time zone),
cast(null as timestamp with time zone)) as timestamp with time zone),
cast(coalesce(cast(null as float),
cast(null as float)) as float),
cast(null as double),
default,
cast(null as decimal(9,4)),
cast(null as decimal(18,6)),
cast(null as decimal(38,10)),
default,
default,
default,
default,
cast(null as bit),
cast(null as integer[]),
default,
cast(null as date[]),
default,
cast(nullif(cast(null as timestamp with time zone[]),
cast(null as timestamp with time zone[])) as timestamp with time zone[]),
cast(null as varchar[]),
case when 1 then cast(null as integer[][]) else cast(null as integer[][]) end
,
default,
cast(null as struct(a integer[], b varchar[])),
default,
cast(null as map(varchar, varchar)),
default,
cast(null as integer[3]),
(select fixed_varchar_array from main.all_types limit 1 offset 2)
,
cast(null as integer[3][3]),
cast(nullif(cast(null as varchar[3][3]),
cast(null as varchar[3][3])) as varchar[3][3]),
(select fixed_struct_array from main.all_types limit 1 offset 1)
,
cast(null as struct(a integer[3], b varchar[3])),
cast(null as integer[][3]),
(select list_of_fixed_int_array from main.all_types limit 1 offset 1)
);Error Message
Binder Error: Compressed materialization functions are for internal use only!
Stack Trace