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.