1. Version Overview

[Release date: July 11, 2024]

IvorySQL 3.3, based on PostgreSQL 16.3, and Fixed a series of bugs. For a comprehensive list of updates, please visit our documentation site.

2. Enhancements

  • PostgreSQL 16.3 Enhancements

    1. Restrict visibility of pg_stats_ext and pg_stats_ext_exprs entries to the table owner

    2. Fix INSERT from multiple VALUES rows into a target column that is a domain over an array or composite type.

    3. Require SELECT privilege on the target table for MERGE with a DO NOTHING clause.

    4. Fix handling of self-modified tuples in MERGE.

    5. Fix incorrect pruning of NULL partition when a table is partitioned on a boolean column and the query has a boolean IS NOT clause.

    For further details, visit PostgreSQL’s release notes.

3. Fixed Issue

  • Fix issue when SYSDATE is used as the default value for date: Issue #633

  • Fix issue when SYSTIMESTAMP is used as the default value for date: Issue #661

  • Date timestamp precision with nls mask: Issue #634

  • More test case for ivorysql.datetime_ignore_nls_mask: Issue #657

  • Fix incorrect result for timestamp(7) type in Oracle compatible mode: issue #658

  • Support data type VARCHAR2: issue #652

  • Fix IvorySQL related issue in docker_library project: [#4](https://github.com/IvorySQL/docker_library/issues/4)

4. Source Code

IvorySQL’s development is maintained across two main repositories:

5. Contributors

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

  • Cary Huang

  • Chase Wu

  • David Zhang

  • Grant Zhou

  • Hope Gao

  • Håkan Arpfors

  • Imran Zaheer

  • Jiao Ren

  • Lei Shang

  • Leo X.M. Zeng

  • Lily Wang

  • Nan Jia

  • Ruike Sun

  • shanInfo

  • Shawn Yan

  • Shiji Niu

  • Shoubo Wang

  • Shuntian Jiao

  • Xiangyu Liang

  • Xinjie Lv

  • Xinyuan Guo

  • Xiuhua Ruan