search

sraoss / pgsql-ivm

IVM (Incremental View Maintenance) development for PostgreSQL
Other
129 stars 12 forks source link

fix restriction of EXISTS subquery #117

Closed thoshiai closed 3 years ago

thoshiai commented 3 years ago

The targetlist must need parent tables column which is contained by exists join condition, to use IVM EXISTS clause.

This restriction will add this fix. In the future, supporting multi-stage subqueries will require more complex processing.

This problem is reported by issues #109 .

thoshiai commented 3 years ago

Thank you for your comments. I fix codes pointed out in the comment

yugo-n commented 3 years ago

Thanks! I'll merge this.