EnterpriseDB/mongo_fdw REL-5_5_3

on GitHub

This release comes with the following changes:

• Added support for PostgreSQL 18, upcoming Postgres Extended 18, and upcoming EDB Postgres Advanced Server 18.
• Added support to build mongo_fdw from contrib directory
• Updated mongoc-driver(1.30.2) and json-c(0.18-20240915) libraries to support MongoDB 8.
• Add new log_remote_query GUC to control logging of remote MongoDB queries. Intended for debugging purposes only.
• Fixed an issue where incorrect variable names were generated within the MongoDB query pipeline when querying nested fields (sub-columns).
• Fix incorrect appending of WHERE clause in mongo_query_document to prevent "invalid array detected" issues.
• Fixed an issue where ORDER BY pushdown failed or produced incorrect results when sorting by columns from a table participating on the inner side of a join.
• Fixed an issue where the FDW pushed down joins with full document or whole row references, which could lead to incorrect output. The FDW now avoids this specific pushdown to ensure data correctness.
• Remove support for PostgreSQL 12, Postgres Extended 12, and EDB Postgres Advanced Server 12.