fix issue with outerjoin when there are repeated tables

toluaina / pgsync

Postgres to Elasticsearch/OpenSearch sync

https://pgsync.com

MIT License

1.1k stars 172 forks source link

fix issue with outerjoin when there are repeated tables #494

Open JonathanRaiman opened 9 months ago

JonathanRaiman commented 9 months ago

This is a fix for https://github.com/toluaina/pgsync/issues/243, we notice that outer joins are disabled when any child has a filter applied, however, if a table is repeated then outerjoins should always be used when performing updates.

JonathanRaiman commented 9 months ago

@toluaina is this fix to merge?