search

sraoss / pg_ivm

IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
Other
990 stars 27 forks source link

create_immv allows EXISTS used under an expression other than AND and it doesn't work. #72

Closed yugo-n closed 8 months ago

yugo-n commented 1 year ago

For example, the following view can be created;

select create_immv('mv0', 'select * from t where case exists (select 1 from t1 where t.i=t1.i) when true then false else true end');

But, incremental maintenance of this view doesn't work correctly and it ends in a wrong result.

yugo-n commented 8 months ago

Fixed by #71