1. Versions Introduction

[Release Date: February 28, 2022]

IvorySQL 1.2 is based on PostgreSQL 14.2 and includes and incorporates various fixes and new features from IvorySQL 1.1. For information about the new features in major version 1.0, see IvorySQL 1.0 Release Notes

This version is compatible with IvorySQL 1.1 and does not require a data dump/restore for users running IvorySQL 1.1.

Note: Some bugs about possible index corruption have been fixed in PostgreSQL 14.2 (see PostgreSQL 14.2 change log Articles 1 and 2.

​If any of these scenarios apply to you, it is recommended to re-index the affected indexes after updating to IvorySQL 1.2.

For updates and bug fixes in PostgreSQL 14.2, see Official Release Notes for PostgreSQL 14.2

2. Features Introduction

  • Support for Hierarchical Queries Hierarchical queries allow data to be selected in hierarchical order using a hierarchical query clause for tables that contain hierarchical data. View Details

3. Known issues

  • Use of pseudo-columns caused a crash.

4. Fixed issue

  • Fixed an issue where Package Array type variables lost their values after the first execution. Issue Details

  • Fixes an issue where Package functions cannot use user-defined types as their return types. Issue Details

5. Source Code

IvorySQL contains 2 main code repositories, the database IvorySQL code bin, and the IvorySQL blog bin.

6. Contributors

The following individuals have contributed to this release as patch authors, committers, reviewers, testers, or issue reporters.

  • Asif Rehman

  • Grant Zhou

  • Jack Lan

  • Shengbin Zhao

  • Muhammad Usama