Skip to content

IvorySQL 5.1

Choose a tag to compare

View all tags
@gaoxueyu gaoxueyu released this 18 Dec 10:38
· 1529 commits to master since this release
IvorySQL_5.1
62069c2
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: Dec 18, 2025]

IvorySQL 5.1 is built on PostgreSQL 18.1 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

Enhancements

  • PostgreSQL 18.1
  1. Check for CREATE privileges on the schema in CREATE STATISTICS.
  2. Avoid integer overflow in allocation-size calculations within libpq.
  3. Prevent “unrecognized node type” errors when a SQL/JSON function such as JSON_VALUE has a DEFAULT clause containing a COLLATE expression.
  4. Avoid incorrect optimization of variable-free HAVING clauses with grouping sets.
  5. Do not use parallelism in hash right semi joins.
  6. Avoid possible division-by-zero when creating ordered-append plans.
  7. Fix planner failure with index types that can do ordered access but not index-only scans.

For further details, visit PostgreSQL’s release notes.

New Features

  • Upgrade to PG 18.1 kernel: Feature #1004
    PostgreSQL kernel upgraded to version 18.1.

  • Online Experience: IvorySQL 5.1: Feature #6
    An interactive, browser-based environment will be launched to allow users to explore and evaluate IvorySQL 5.1 in real time — no installation required.

  • Packaging for All Platforms: Feature #1136
    Provides multi-platform media packages for X86, ARM, MIPS, LoongArch architecture.

  • Containerized Deployment Support
    Supports one-click deployment of standalone or highly available IvorySQL 5.1 clusters via Docker Compose, Podman, Swarm, Helm, and the IvorySQL 5.1 Operator.

  • IvorySQL Cloud 5.1 released (Visual Database Lifecycle Management Platform)
    Offers a fully managed, graphical control plane that handles IvorySQL 5.1 database subscriptions, orchestrates end-to-end lifecycle operations, and integrates surrounding ecosystem services.

  • PostgreSQL Extensions
    Support for 10 Additional PostgreSQL Extensions: pg_cron, pgAudit, PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, system_stats, plpgsql_check, pgvector.

Fixed Issues

  • Clear build warnings: Issue #996
  • PL/iSQL Parser Rejects Parentheses in SELECT INTO Expression: Issue #981
  • Doc:Fix reports missing uuid-ossp during source installation: Issue #198

Source Code

IvorySQL's development is maintained across four main repositories:

Contributors

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

  • Amberwww1
  • Cédric Villemain
  • Fawei Zhao
  • Ge Sui
  • Grant Zhou
  • Oreo Yang
  • Rophy Tsai
  • Shuntian Jiao
  • Steven Niu
  • Xiangyu Liang
  • Xiaohui Liu
  • Xinjie Lv
  • Xueyu Gao
  • Yasir Hussain Shah
  • Yuan Li
  • Zheng Tao
  • Zhenhao Pan
  • Zhe Zhang
  • Zhibin Wang
  • Zhuoyan Shi

Complete Changelog

Assets 18
Loading