REL-5_5_3

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.

REL-5_5_2

This release comes with the following changes:

• Support for PostgreSQL 17 and upcoming EDB Postgres Advanced Server 17.
• Refactor README.md file.
• Remove support for legacy drivers.
• Remove support for v11.

REL-5_5_1

This release comes with the following changes:

• Support for PostgreSQL 16 and EDB Postgres Advanced Server 16.
• Fixes boolean expression handling in query document building.
• Various GUCs and table/server level options were added to control Join/Aggregate/Order by pushdowns.
• Remove support for v10.

REL-5_5_0

This release includes the following:

Features:

• Push down ORDER BY to remote MongoDB servers.
  If possible, consider a path that adds the ORDER BY clause to the remote SQL so that we get the ordered result set from the foreign server itself. It might help us to have an efficient merge join.

• Push down LIMIT/OFFSET to remote MongoDB servers.
  Wherever applicable, perform LIMIT and OFFSET operations on the remote server. This reduces network traffic between local PostgreSQL and remote MongoDB servers.

Other improvements and Fixes:

• Save the status of the enable_aggregate_pushdown option for accessing the aggregation path at a later stage, especially in the case of nested join queries.
• Improve the WHERE clause pushdown. Now recursive operator expressions, boolean expressions, Relabel types, and Var's on both sides of an operator are supported.
• Fix server crash caused due to missed Param node handling. (#160)
• Fix typos in autogen.sh and README.md files. (#153)

REL-5_4_0

This release includes the following:

Features:

• Push down aggregates to remote MongoDB servers.
  Push aggregates to the remote MongoDB server instead of fetching all
  of the rows and aggregating them locally. This gives a very good
  performance boost for the cases where aggregates can be pushed down.

• Add support for PostgreSQL 15 and EDB Postgres Advanced Server 15.

• Remove support for v9.6.

Other improvements and Fixes:

• Make Meta the default compilation driver instead of legacy.
• README: Add instructions for driver installation and other cosmetic changes
• Add a new server option use_remote_estimate to estimate the rows.
• Force type modifiers for numeric type.
• Fix data type incompatibility between numeric types. (#95)
• Fix server crash when updating the document with text array element. (#155)
• Fix server crash while updating/deleting with null _id value.
• Add some dummy startup and total default costs.
• Add deprecation notice for the legacy driver in README and autogen.sh.

REL-5_3_0

This release includes the following:

Feature:

Join Push-down - If we have a join between two foreign tables from the same remote server, push that join down to the remote server instead of fetching all the rows for both the tables and performing a join locally.

Other Fixes:

1. Optimizises a few APIs for better performance.
2. Added support for the whole-row reference.

REL-5_2_10

This release mainly includes:

Support for PostgreSQL 14 and EDB Postgres Advanced Server 14.

Apart from this, it has the following additions:

1. Uses environment variables in tests for connection parameters.
2. Fixes the implementation for retrieving and validating the options so that the boolean variables are handled correctly.
3. Allows mongo-c and json-c drivers installation at custom locations.

REL-5_2_9

This release comes with the following major change:

1. Updated autogen.sh to fetch mongo-c-driver 1.17.3 and json-c 0.15. This allows us to support MongoDB server 4.4 now.
2. Support for v9.5 is removed.

Other changes:

1. Fixes crash with the queries involving LEFT JOIN LATERAL.
2. Add JSONC_CFLAGS environment variable to cmake while building json-c library so that a few platform-specific environment variables can be exported.
3. Restrict fetching PostgreSQL-specific system attributes from the remote relation to avoid a server crash.
4. Refactor the WHERE pushdown code a bit to inline with the postgres_fdw code.
5. Correct the exit status in autogen.sh. The script fails upon error and returns a non-zero return code.
6. Fall back to cmake if cmake3 is not present so that the system having only cmake (with version required) can work without failure.

REL-5_2_8

Fix various bugs, compilation warnings, and a server crash.

REL-5_2_7

Supports PG/EPAS v13.