REL-2_9_2

This release comes with the following changes:

• Support for PostgreSQL 17 and upcoming EDB Postgres Advanced Server 17.
• Add support for MYSQL_READ_DEFAULT_FILE option used to read connection details.
• Fix server crash in left join with whole-row reference.
• Map TIMESTAMP to TIMESTAMPTZ in IMPORT FOREIGN SCHEMA processing.
• Set the session timezone to UTC on the MySQL connection.
• Correct pushability of ScalarArrayOpExpr (ANY and ALL) and fix handling of the multidimensional array in its deparsing.
• Refactor README.md file.
• Remove support for v11.

REL-2_9_1

This release comes with the following changes:

• Support for PostgreSQL 16 and EDB Postgres Advanced Server 16.
• Added a few more default entries in mysql_fdw_pushdown.config file.
• Fixes incorrect quoting in generating EXPLAIN query.
• Remove support for v10.

REL-2_9_0

This release includes the following:

Features:

• Add configuration file approach to control the pushdowns. We can now provide the list of operators and functions to be pushed down to the remote server safely.
• Add support for the "import_generated" option in IMPORT FOREIGN SCHEMA to include column's generated expressions in the definitions of foreign tables.
• Add support for the TRUNCATE command to truncate foreign tables.
• Add support for ON CONFLICT DO NOTHING in INSERT. We map it to INSERT IGNORE. (#246)
• Add support for IS [ NOT ] DISTINCT FROM operator. (#251)

Other improvements and Fixes:

• Check the shippability of sort clauses properly by making sure that the sort operator is safe to ship.
• Fix an oversight in assessing pushable ORDER BY clause i.e. don't push when underneath query_pathkeys are not safe to push down.
• Push down the "LIMIT n" clause when OFFSET is NULL.
• Fix unstable ordering in sql/select test. (#254)

REL-2_8_0

This release includes the following:

Features:

• Push down ORDER BY to remote MySQL 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 MySQL servers.
  Wherever applicable, perform LIMIT and OFFSET operations on the
  remote server. This reduces network traffic between local PostgreSQL
  and remote MySQL servers.

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

• Remove support for v9.6.

Other improvements and Fixes:

• Add character_set option. Users can now set it to an appropriate value per MySQL database.
• Introduce import_enum_as_text IMPORT FOREIGN SCHEMA option, when true, mysql_fdw will implicitly map the ENUM column to a TEXT type.
• Add sql_mode option. MySQL server can operate in different SQL modes, this option helps to match that up.
• Force correct type modifiers while converting MySQL value to PostgreSQL.
• Fix text column data truncation when reading very long data.
• Do not push aggregates with VARIADIC array as MySQL does not support the same.
• Use hard-coded values only if environment variables are not set in mysql_init.sh script.

REL-2_7_0

This release includes the following:

Feature:

Aggregate Push-down: Push aggregates to the remote MySQL server instead of fetching all of the rows and aggregating them locally.

Other Fixes:

1. Fixes function expression deparsing implicit/explicit coercion so that we don't send the wrong query to the MySQL server.
2. Fixes import foreign schema failure due to SET type.

REL-2_6_1

This release mainly includes:

Support for PostgreSQL 14 and EDB Postgres Advanced Server 14.

Apart from this, it has the following additions:

1. Adds binary, varbinary data type support for IMPORT FOREIGN SCHEMA.
2. Allows fetch_size to be set per-table or per-server.
3. Adds reconnect option to control automatic reconnection to MySQL server.
4. Fixes crash due to list_concat sharing list substructure.
5. Fixes crash while retrieving more than one record having bytea column.
6. Fixes parameterized query when use_remote_estimates is enabled.
7. Does not push expressions having mutable functions to the remote server to get a stable result.

REL-2_6_0

This release includes the following:

Feature:

1. 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. Fixes crash with IMPORT FOREIGN SCHEMA when executed repeatedly.
2. Restricts fetching of the system attributes from the remote relation.
3. Fixes compiler warning due to clash with MySQL library macro.
4. Costs are not shown in the explain output when the COSTS explain option is OFF.
5. Uses environment variables in tests for connection parameters.
6. No longer supports PG/EPAS version 9.5.

REL-2_5_5

Fix various bugs, compilation warnings, and server crashes.

REL-2_5_4

Supports PG/EPAS v13.

REL-2_5_3

REL-2_5_3