Skip to content

REL-2_9_0

Compare
Choose a tag to compare
@jeevanchalke jeevanchalke released this 14 Dec 07:18
· 24 commits to master since this release

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)