Skip to main content

IvorySQL Release - 1.1


Release Notes

[Release Date: January 25, 2022]


IvorySQL 1.1 is based on PostgreSQL 14.1 and contains a variety of fixes from 1.0. For information about new features in major release 1.0, see IvorySQL 1.0 release notes.

For updates and bug fixes in PostgreSQL 14.1 please refer to Official PostgreSQL release notes of 14.1.


  • Automatically load Orafce at initdb Orafce extension gets installed automatically with IvorySQL server, So All Oracle compatible objects and types works out of box.

  • Support Oracle Compatible Number(p,s) type Add support for Oracle compatible Number data type with configurable precision and scale NUMBER[(precision [, scale])]

  • Allow Oracle compatible objects without schema qualification. Details

  • Add DROP PACKAGE BODY support Add a support for dropping the package body without dropping the complete package. Details

  • Bug fixes

  • Fixed Oracle compatible documentation issue details

  • SELECT sysdate FROM dual not working out of the box issue details

  • Fixed handling of CHAR, VARCHAR, VARCHAR2, and NVARCHAR2 data types issue details: 1 2

  • Allow log collector to collect PACKAGE DDL statements. issue details

  • Fixed issue with VARCHAR2 comparison operator. issue details

  • Fixed regression issue with make check-world issue details

  • Fixed issue with Cursors defined in Package Body were not getting closed when Package body was dropped. issue details


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

  • Asif Rehman
  • Andy Qinshy
  • Bing Ao
  • Denis Lussier
  • Grant Zhou
  • Haruka Takatsuka
  • Huajianjin
  • Japin Li
  • Jack Lan
  • Shengbin Zhao
  • Muhammad Usama

Complete Changelog