When LATERAL was used, a subquery was regarded as one generated from EXISTS clause even though this was ordinal subquery. This caused an assertion error.
lateral=# create table a (i int);
CREATE TABLE
lateral=# create table b (i int);
CREATE TABLE
lateral=# create incremental materialized view mv(a,b) as select * from a, lateral (select * from b) x;
SELECT 0
lateral=# insert into a values (1);
INSERT 0 1
lateral=# insert into b values (1);
TRAP: FailedAssertion("strvalue != NULL", File: "snprintf.c", Line: 442)
thoshiai
commented
4 years ago
When LATERAL was used, a subquery was regarded as one generated from EXISTS clause even though this was ordinal subquery. This caused an assertion error.