[Release Date: February 28, 2022]
IvorySQL 1.2 is based on PostgreSQL 14.2 and contains a variety of fixes and new feature from IvorySQL 1.1. For information about new features in major release 1.0, see IvorySQL 1.0 release notes.
This release is compatible with IvorySQL 1.1 and does not require a dump/restore for those running IvorySQL 1.1
However, a couple of bug have been fixed in PostgreSQL 14.2 around possible index corruption (See first and the second change-log entries of PostgreSQL 14.2 change-log ), If any of those cases apply to you, It is recommended to reindex the affected indexes after updating to IvorySQL 1.2
For updates and bug fixes in PostgreSQL 14.2 please refer to Official PostgreSQL release notes of 14.2.
Support for Hierarchical Queries.
Hierarchical queries allow to select rows in a hierarchical order using the hierarchical query clause for tables that contains the hierarchical data.
Fixed an issue with Package Array type variables losing value after first execution.
Fixed an issue with Package functions fails to use user defined type as their return type.
The following individuals have contributed to this release as patch authors, committers, reviewers, testers, or reporters of issues.
- Asif Rehman
- Grant Zhou
- Jack Lan
- Shengbin Zhao
- Muhammad Usama