CREATE TABLE mvtest_t (id int NOT NULL PRIMARY KEY, type text NOT NULL, amt numeric NOT NULL);
INSERT INTO mvtest_t VALUES
  (1, 'x', 2),
  (2, 'x', 3),
  (3, 'y', 5),
  (4, 'y', 7),
  (5, 'z', 11);
CREATE VIEW mvtest_tv AS SELECT type, sum(amt) AS totamt FROM mvtest_t GROUP BY type;

CREATE TABLE mvtest_boxes (id serial primary key, b box);
INSERT INTO mvtest_boxes (b) VALUES
  ('(32,32),(31,31)'),
  ('(2.0000004,2.0000004),(1,1)'),
  ('(1.9999996,1.9999996),(1,1)');

select  
  pg_catalog.array_in(
    cast(cast(coalesce(case when ref_0.checkpoint_write_time < (select stanullfrac from pg_catalog.pg_statistic limit 1 offset 5)
             then case when (false) 
            or (false) then case when ((select totamt from public.mvtest_tv limit 1 offset 1)
                   < cast(null as "numeric")) 
              or ((select pg_catalog.min(subconninfo) from pg_catalog.pg_subscription)
                   !~~ cast(null as text)) then cast(null as cstring) else cast(null as cstring) end
             else case when ((select totamt from public.mvtest_tv limit 1 offset 1)
                   < cast(null as "numeric")) 
              or ((select pg_catalog.min(subconninfo) from pg_catalog.pg_subscription)
                   !~~ cast(null as text)) then cast(null as cstring) else cast(null as cstring) end
             end
           else case when (false) 
            or (false) then case when ((select totamt from public.mvtest_tv limit 1 offset 1)
                   < cast(null as "numeric")) 
              or ((select pg_catalog.min(subconninfo) from pg_catalog.pg_subscription)
                   !~~ cast(null as text)) then cast(null as cstring) else cast(null as cstring) end
             else case when ((select totamt from public.mvtest_tv limit 1 offset 1)
                   < cast(null as "numeric")) 
              or ((select pg_catalog.min(subconninfo) from pg_catalog.pg_subscription)
                   !~~ cast(null as text)) then cast(null as cstring) else cast(null as cstring) end
             end
           end
        ,
      pg_catalog.nameout(
        cast(pg_catalog.getpgusername() as name))) as cstring) as cstring),
    cast((select pg_catalog.min(objoid) from pg_catalog.pg_description)
       as oid),
    cast((select encoding from pg_catalog.pg_database limit 1 offset 1)
       as int4)) as c0, 
  
    pg_catalog.min(
      cast(cast(nullif(case when (select b from public.mvtest_boxes limit 1 offset 4)
               |>> (select b from public.mvtest_boxes limit 1 offset 5)
               then cast(null as tid) else cast(null as tid) end
          ,
        case when (cast(null as tid) = cast(null as tid)) 
            and (ref_0.checkpoint_sync_time > cast(null as float4)) then cast(coalesce(cast(null as tid),
            cast(null as tid)) as tid) else cast(coalesce(cast(null as tid),
            cast(null as tid)) as tid) end
          ) as tid) as tid)) over (partition by ref_0.buffers_backend order by ref_0.maxwritten_clean) as c1
from 
  pg_catalog.pg_stat_bgwriter as ref_0
where true;

ERROR:  cache lookup failed for type 12227