Skip to content

IvorySQL 4.5

Choose a tag to compare

View all tags
@gaoxueyu gaoxueyu released this 04 Jun 09:39
· 3179 commits to master since this release
IvorySQL_4.5.3
e8f168a
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Version Overview

[Release Date: Jun 4, 2025]

IvorySQL 4.5, based on PostgreSQL 17.5 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

  • PostgreSQL 17.5 Enhancements
  1. Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding.
  2. Handle self-referential foreign keys on partitioned tables correctly.
  3. Avoid data loss when merging compressed BRIN summaries in brin_bloom_union().
  4. Correctly process references to outer CTE names that appear within a WITH clause attached to an INSERT/UPDATE/DELETE/MERGE command that's inside WITH.
  5. Fix ALTER TABLE ADD COLUMN to correctly handle the case of a domain type that has a default.
    For further details, visit PostgreSQL’s release notes.

New Features

  • Upgrade to PG 17.5 kernel: Feature #807

  • MIPS Packaging for All Platforms: Feature #736
    Provides multi-platform media packages for MIPS architecture, supporting both domestic and international mainstream operating systems, including Red Hat, Debian, Kylin, UOS, and NSAR OS, etc.

  • IvorySQL Online trail: Feature #1
    Provide users with a web-based platform to experience IvorySQL V4.5 in an online environment, enabling database interaction directly through a browser interface.

  • Add code of conduct: Feature #808

  • Update the community contribution guide: Feature #121

  • Automate Documentation Build and Website Update via Pull Requests: Feature #115

  • Enhanced Contributor Workflow: Self-Assign Issues by using the '/assign' command: Feature #109

  • IvorySQL Operator V4 has been adapted to support IvorySQL 4.5, with upgrades to system component versions and database extension versions : Feature #79

Fixed Issues

  • Wrong enum value in check_compatible_mode and assign_compatible_mode: Issue #763
  • Wrong test result in GUC Framework: Issue #111
  • Update oracle compatibility parameters: Issue #74
  • Update README path to a hyperlink: PR #156
  • Force the search_path to be re-computed when compatible_mode is changed: Issue #760
  • Rename ModifyTableContext and UpdateContext for better compatibility: PR #794
  • Set identifier_case_switch to value in pg_control file so that configure file value can take effect : Issue #797

Source Code

IvorySQL's development is maintained across two main repositories:

Contributors

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

  • Cary Huang
  • Cédric Villemain
  • Denis Lussier
  • Fawei Zhao
  • Flyingbeecd
  • Ge Sui
  • Grant Zhou
  • Hulin Ji
  • Hope Gao
  • Lily Wang
  • Renli Zou
  • Shawn Yan
  • Shihua Yang
  • Shiji Niu
  • Shoubo Wang
  • Shuntian Jiao
  • Xiangyu Liang
  • Xinjie Lv
  • Zheng Tao
  • Zhenhao Pan
  • Zhuoyan Shi

Complete Changelog

Assets 20
Loading