Tsurugi 1.11.0 - Release Notes (en)

[akirakw]

1.11.0 Release Notes

Overview

Tsurugi 1.11.0 adds support for correlated subqueries as a new SQL feature.

A correlated subquery is a subquery that references columns of the outer query.
In this version, Tsurugi extends the scalar subquery feature introduced in Tsurugi 1.10.0, allowing correlated subqueries to be written.
This makes it possible to describe dynamic subqueries that return different results for each row of the outer query, enabling more advanced conditional evaluation and data extraction.

Tsurugi 1.11.0 also adds official support for the BLOB and CLOB types.

• BLOB (GA version) Usage and Notes (ja)

The BLOB and CLOB types have been available as an experimental feature since Tsurugi 1.3.0, but they came with major restrictions, such as being available only from clients deployed in the same environment as the Tsurugi server, and being supported by only a limited set of client libraries.
This version removes those environment-related restrictions and expands support across client libraries, making the BLOB and CLOB types available for a wider range of use cases.

Tsurugi 1.11.0 also includes feature additions and improvements for Tsurugi UDF, including support for NULL values.
In addition, this version adds experimental support for Ubuntu 26.04.

This version also includes several important bug fixes and stability improvements.
We strongly recommend all users of previous versions to upgrade to this release.

New Features and Improvements

New Features and Improvements - SQL

• Added support for correlated subqueries
  • A correlated subquery is a subquery that references columns of the outer query. This allows subqueries to be written so that they return different results depending on each row of the outer query.
  • The following is an example of a correlated subquery:

    SELECT *
    FROM t1
    WHERE EXISTS (
      SELECT *
      FROM t2
      WHERE t1.k = t2.k -- References the outer t1.k
    );

  • In Tsurugi 1.11.0, correlated subqueries have the following restrictions:
    • Inside a correlated subquery, scalar subqueries, the EXISTS predicate, and IN subqueries cannot be used
    • Inside a correlated subquery, FULL OUTER JOIN cannot be used
    • Inside a correlated subquery, VALUES can only contain exactly one row
    • Correlated subqueries using EXISTS can only be used in top-level filter conditions (directly under WHERE or HAVING, or as conditions combined with AND)
• Added official support for the BLOB and CLOB types
  • The BLOB and CLOB types, which had been provided as an experimental feature since Tsurugi 1.3.0, have been significantly enhanced and are now officially supported. For details, see the following document:
    • BLOB (GA version) Usage and Notes (ja)
  • The main changes from the experimental feature are as follows:
    • Added support for remote connections
      • Previously, only a privileged mode was available, which could be used only from clients deployed in the same local environment as the Tsurugi server. This version adds support for relay mode, which can be used from remote clients.
      • Relay mode transfers BLOB/CLOB data between Tsurugi and clients over gRPC. Starting with this version, it becomes the default mode when using the BLOB and CLOB types from supported client libraries.
    • Expanded client support
      • In addition to Tsubakuro/Java and Iceaxe, which were already supported, the following client libraries and related components are now supported:
        • Tsurugi JDBC
        • tsubakuro-rust-core (Rust API)
        • tsubakuro-rust-ffi (C API)
        • Tsurugi Python DB-API (Python API)
        • Tsurugi MCP Server
      • Tsurugi ODBC Driver is not supported in Tsurugi 1.11.0.

Note

For detailed specifications and current restrictions on SQL features, see the following document in tsurugidb:

• Available SQL features in Tsurugi

New Features and Improvements - Endpoint

• Changed the default values of the following options in the Tsurugi configuration file tsurugi.ini
  • Changed the default value of enable in the [grpc_server] section from true to false
    • Previously, the built-in gRPC server in Tsurugi was enabled by default. Starting with this version, it is disabled by default.
    • The gRPC server is required when using the BLOB and CLOB types in the relay mode described above, and when using the BLOB client for Tsurugi UDF. To use these features, set enable in the [grpc_server] section to true before starting Tsurugi.

New Features and Improvements - Client

• Tsubakuro/Java
  • Added official support for the BLOB and CLOB types
• Iceaxe
  • Added official support for the BLOB and CLOB types. For details, see the following documents:
    • Iceaxe BLOB, CLOB Usage
    • Changes for Iceaxe BLOB and CLOB
• tgsql
  • Added official support for the BLOB and CLOB types
  • Added the --lob-transfer-type option to the tgsql command to specify the LOB transfer type. For details, see the following document:
    • tgsql
• Tsurugi JDBC
  • Added support for the BLOB and CLOB types. For details, see the following document:
    • Tsurugi JDBC BLOB, CLOB Usage
• Tsurugi MCP Server
  • Added support for the BLOB and CLOB types
  • Added the --db-timeout startup option to specify the connection timeout for Tsurugi. For details, see the following document:
    • tsurugi-mcp-server - README.md
• tsubakuro-rust-core (Rust API)
  • Added support for the BLOB and CLOB types. For details, see the following document:
    • tsubakuro-rust-core BLOB, CLOB Usage
• tsubakuro-rust-ffi (C API)
  • Added support for the BLOB and CLOB types
• Tsurugi Python DB-API (Python API)
  • Added support for the BLOB and CLOB types. For details, see the following document:
    • Tsurugi Python DB-API BLOB, CLOB Usage

New Features and Improvements - UDF

• For the release contents of Tsurugi UDF, see the following document:
  • Tsurugi UDF 0.4.0 Release Notes
• The main feature additions since the previous version are as follows:
  • Added support for NULL values
  • Added support for specifying a client timeout when invoking UDFs
  • Added support for specifying grpc_server.endpoint in the UDF plugin configuration file

New Features and Improvements - Distribution

• Added support for Ubuntu 26.04 (experimental support)
• Provides Tsurugi Docker images based on Ubuntu 26.04 (experimental support)
  • https://github.com/project-tsurugi/tsurugidb/pkgs/container/tsurugidb
• Added support for building with CMake 4.2.3 (experimental support)
  • CMake 4.2.3 is the default version of CMake installed by apt install on Ubuntu 26.04.
• Changed the version of Apache Arrow installed into the environment by the installer from 21.0.0 to 24.0.0
  • On Ubuntu 26.04, Apache Arrow version 21.0.0, which is installed by the installer in earlier Tsurugi versions, is not available and causes the installer to fail. If you use the installer on Ubuntu 26.04, use the installer from this version or later, in which the Apache Arrow version has been updated to 24.0.0.

Bug Fixes

Bug Fixes - SQL

• Fixed an issue where executing DDL during DML processing could leave the database in an unstable state
  • This fixes the issue described in Tsurugi 1.10.0 - Known Issues (ja) - TSURUGI-IS-177 DML処理中にDDLを実行するとデータベースが不安定な状態になる, specifically the case where executing DML and DDL simultaneously within the same transaction could result in an unstable state.
• Fixed an issue where executing a query that uses COUNT(DISTINCT ...) multiple times in the HAVING clause could cause the database to terminate abnormally
• Fixed an issue where a query could return incorrect results when a secondary index key column contains NULL and that column is used with an inequality operator in the WHERE clause
• Fixed an issue where specifying a table name instead of an index name in DROP INDEX would incorrectly succeed without an error, leaving the table in an invalid state
• Fixed an issue where a query could return incorrect results when using a range scan on an index created with DESC in CREATE INDEX
• Fixed an issue where a query could return incorrect results when using an IN clause with a subquery against a column containing NULL
• Fixed an issue where a query could return incorrect results when using an IN clause with a subquery whose output column is a secondary index, or a primary index key column or its prefix

Bug Fixes - Transaction

• Fixed an issue where, after running the offline compaction tool tglogutil compaction, the database could fail to start or the database contents could become invalid under certain conditions
  • For the bug report, workarounds, and what to do if this problem occurs, see:
    • limestone#134: fix(compaction): update compaction catalog on offline compaction

Bug Fixes - Endpoint

• Fixed an issue where the Tsurugi startup error message was incorrect when duplicate parameters existed in tsurugi.ini

Bug Fixes - Client

• Fixed an issue in Tsurugi Python DB-API where KeepAlive did not work properly and an established connection could be disconnected after the period configured by session.refresh_timeout on the Tsurugi server (default: 300 seconds)
• Fixed an issue in Iceaxe where specifying 0 as the timeout value caused an immediate timeout instead of disabling the timeout

Bug Fixes - UDF

• Fixed an issue where a .proto file that imports another .proto containing a service definition (service) would be built as an invalid UDF plugin
• Fixed an issue where an error could occur when multiple oneof fields are defined in a message and different types are specified for multiple fields at UDF invocation time
• Fixed an issue where building a .proto that uses the official Protocol Buffers Well-Known Types with udf-plugin-builder could result in an error

Upgrade Notes

Client Compatibility List

Tsurugi 1.11.0 supports the following clients.
Please upgrade each client as needed when upgrading Tsurugi.

Important

With the official support for the BLOB and CLOB types in this version, all clients must be upgraded to the versions shown in the table below.

Important

For Tsurugi UDF, you must regenerate and redeploy UDF plugins using udf-plugin-builder.

Client	Version
Tsubakuro/Java	1.16.0+
Iceaxe	1.16.0+
Tanzawa	1.16.0+
Tsubakuro/Rust	0.10.0+
Tsurugi Python DB-API	0.10.0+
Tsurugi MCP Server	0.8.0+
Tsurugi JDBC	0.5.0+
Tsurugi UDF	0.4.0+

Upgrade Procedure

For instructions on upgrading from previous versions, see:

• Tsurugi Upgrade Guide

Other Information

For a full list of changes in this version, see the Changelog:

• Tsurugi 1.11.0 - Changelog

For known issues and additional information about fixes in this version, see:

• Tsurugi 1.11.0 - Known Issues(en)

---

This discussion was created from the release 1.11.0.