Window functions over a join with a view treat a null produced by outer join as a null from view, resulting in ifnull() taking values through nested result sets

DROP TABLE IF EXISTS t;

CREATE TABLE t

(

    id    int unsigned not null,

    value int unsigned null

);

INSERT INTO t

values (1, null);

CREATE OR REPLACE VIEW v

as

select 1                 as id,

       ifnull(null, 999) as value

from t

;

select *,

       MIN(t.value) over (PARTITION BY t.id) as min_t,

       MIN(v.value) over (PARTITION BY t.id) as min_v

from t

         left join v

                   on t.id > v.id

;

id value id   value min_t min_v

1  null  null null  null  999

id value id   value min_t min_v

1  null  null null  null  null