Version 2.9.0 v2

Enhancements, bug fixes, and other changes in MySQL Foreign Data Wrapper 2.9.0 include:

TypeDescription
FeatureAdd a 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.
FeatureAdd support for the import_generated option in IMPORT FOREIGN SCHEMA to include columns generated from expressions in the definitions of foreign tables imported from a foreign server.
FeatureAdd support for the TRUNCATE command to truncate foreign tables.
FeatureAdd support for ON CONFLICT DO NOTHING in INSERT. It is mapping to INSERT IGNORE.
FeatureAdd support for IS [ NOT ] DISTINCT FROM operator.
Bug FixFix an oversight in assessing the pushdown ORDER BY clause. Don't push when underneath query_pathkeys is not safe to push down.
Bug FixFix unstable ordering in the SQL/select test.
Bug FixPush down the LIMIT n clause when OFFSET is NULL.