Skip to content

REL-2_8_0
Compare
Choose a tag to compare
@jeevanchalke jeevanchalke released this 16 May 07:52
· 36 commits to master since this release
REL-2_8_0
d9860ba

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.
Assets 2
Loading