REL-2_9_0
版本发布时间: 2022-12-14 15:18:14
EnterpriseDB/mysql_fdw最新发布版本:REL-2_9_1(2023-07-14 18:08:28)
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)