EDB Foreign Data Wrappers versions: Hadoop: 2.0.7, Mongo: 5.2.8, MySQL: 2.5.5

This announcement is notifying you of a new software release of EDB Foreign Data Wrappers for Hadoop 2.0.7, MongoDB 5.2.8 and MySQL 2.5.5 versions. EDB Foreign Data Wrappers allow EDB Postgres Advanced Server and PostgreSQL to connect to Hadoop, MongoDB and MySQL enabling you to view, join and manage data holistically.

 

 

Features	Benefits
Support for EDB Postgres Advanced Server and PostgreSQL 13	Enables users to connect to EPAS 13

This release includes fixes for the following issues:

Hdfs_fdw

• Updated LICENSE file.

MySQL_fdw

• Fix crash with COPY FROM and/or foreign partition routing operations - mysql_fdw does not support routable foreign-table partitions and/or executing COPY FROM on foreign tables, so throw an error instead.
• Improvements in enum handling - Support to insert enum value in columns.
• Fix crash when sub-select returns NULL - sub-select or correlated queries use a parameterized plan, and if the parameter value happened to be null because sub-select returned null it caused a crash. Fixed the same.
• Fix crash with LEFT JOIN LATERAL queries - Fixed the lateral_relids to pass correctly to the API which was earlier resulting in a server crash.
• Derive enum column's type from both table and column name - this avoids incompatible type definitions when multiple MySQL tables use the same column name but not the same definition for an ENUM type.
• Fix UPDATE to account BR trigger changes - if any column value which is not present in the UPDATE query but modified in the BEFORE ROW trigger was not updated on the MySQL side. Fixed that by marking all columns as updatable in such cases.
• Fix ReScanForeignScan API to make the parameterized query work correctly - proper working of sub-select or correlated queries uses a parameterized plan.
• Fix compilation warnings with MySQL version less than 8 - it is using my_bool (for bool) resulting in compilation warnings as current code is using bool. Fix that by adding an explicit casting to my_bool for the affected versions.

Mongo_fdw

• Updated LICENSE file.
• Fix crash with COPY FROM and/or foreign partition routing operations - mongo_fdw does not support routable foreign-table partitions and/or executing COPY FROM on foreign tables, so throw an error instead.
• Fix issue where casting target list produces 'NULL' - with this we now get correct results not only when we have an explicit cast but also when we have a function call or operators in the target list.
• Fix ReScanForeignScan API to make the parameterized query work correctly - proper working of sub-select or correlated queries uses a parameterized plan.
• Change the server port option's type from int32 to int16 - meta driver APIs expect port value in unsigned short type which resulted in a compilation warning on some gcc version, so changed that to fix the compilation warnings.

For more details, please review the EDB Foreign Data Wrappers documentation:
https://www.enterprisedb.com/edb-docs/

IS THIS FOR ME?

This announcement is for EDB customers who are using, or are interested in, EDB Foreign Data Wrappers and have a database subscription purchased for:

• Standard Plan
• Enterprise Plan

HOW TO GET THE SOFTWARE

EDB Foreign Data Wrappers for EDB Postgres Advanced Server are available as native packages in the form of RPMs and DEBs, please visit: https://repos.enterprisedb.com/

To request the credentials required to access EnterpriseDB repositories, please visit https://www.enterprisedb.com/repository-access-request