Tsurugi 1.9.0 - Release Notes (en)

[akirakw]

1.9.0 Release Notes

Overview

Tsurugi 1.9.0 adds support for the WITH clause (Common Table Expressions: CTE) as a new SQL feature.
The WITH clause is a syntax for defining named sub-queries within a SQL query, allowing complex queries to be broken down into readable, step-by-step expressions that improve readability and reusability.

This version also extends UDF functionality with support for User-Defined Table-valued Functions (UDTF).
UDTFs can return multi-row, multi-column tabular results, and are invoked within the FROM clause using the APPLY operator.

In addition, this version resolves the restriction that prevented deploying multiple UDF plugins containing the tsurugidb.udf message type.
Note that this fix involves a partial change to the udf-plugin-builder specification.

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 the WITH clause (Common Table Expressions: CTE)
  • The WITH clause is a syntax for defining named sub-queries within a SQL query. Multiple sub-queries can be defined, and subsequent sub-queries can reference the results of previously defined ones.
  • By using the WITH clause, complex queries can be divided and described step by step, enabling the creation of highly readable and reusable queries.

  WITH
    cte1 AS (SELECT id, name FROM users WHERE age >= 18),
    cte2 AS (SELECT id, name FROM cte1 WHERE name LIKE 'A%')
  SELECT id FROM cte2
  

  • For details on SQL syntax related to the WITH clause, see:
    • Available SQL features in Tsurugi - Queries
  • Note: The WITH RECURSIVE clause (recursive CTEs) is not supported in this version. Support is planned for a future release.
• Added support for specifying JOIN precedence using parentheses
  • Added support for syntax such as t1 JOIN (t2 JOIN t3 ON ...) ON ..., which covers the conditions described in the known issue TSURUGI-IS-863 Cannot specify JOIN clause join priority. This allows join precedence to be explicitly specified.

New Features and Improvements - UDF

• Added support for User-Defined Table-valued Functions (UDTF)
  • UDTF is an extension feature similar to the User-Defined Functions (UDF) introduced in version 1.8.0, allowing user programs created as gRPC services to be called as SQL functions. Unlike UDF, UDTF can return multi-row, multi-column tabular results.
  • UDTFs are invoked within the FROM clause using the Tsurugi SQL extension syntax APPLY operator.

    SELECT i.image_id, d.label, d.score, d.x, d.y, d.width, d.height
    FROM images AS i
    APPLY DetectObjects(i.image_data) AS d
  

  • Since UDTFs can output tabular data, they are well-suited for providing functions that handle complex processing. UDTFs also leverage gRPC server streaming, making them designed to operate efficiently for particularly intensive processing and large-volume data.
  • For details on UDTFs, see:
    • User-Defined Table-valued Functions (UDTF) (ja)
• Resolved the restriction that prevented deploying multiple UDF plugins containing the tsurugidb.udf message type
  • In Tsurugi 1.8.0, deploying multiple UDF plugins that use the tsurugidb.udf message type would result in an error at Tsurugi startup. This restriction has been resolved in this version.
  • Related to this fix, the behavior and specification of the UDF plugin generation tool udf-plugin-builder have been partially changed. The main changes are as follows:
    • Changed to always generate one shared library file (.so) per .proto file. The --name option has been removed accordingly.
    • The --proto-file option has been renamed to --proto.
    • The --proto-path option has been renamed to -I (--include). When specifying multiple paths, use the option multiple times (e.g., -I /path_1 -I path_2).
  • UDF plugins generated with Tsurugi 1.8.0 cannot be used with Tsurugi 1.9.0. You must regenerate and redeploy UDF plugins using udf-plugin-builder with the above changes in mind.
  • For details on udf-plugin-builder, see udf-plugin - udf-plugin-builder (ja).

New Features and Improvements - Distribution

• Added support for CMake version 3.30 and later within the CMake 3.x series used when installing Tsurugi
  • Operation with CMake version 4.x or later has not been verified at this time.
• Raised the minimum required CMake version to 3.20 for Tsurugi installation

Bug Fixes

Bug Fixes - SQL

• Fixed an issue where executing a query containing a GROUP BY clause with multiple grouping columns under certain conditions caused the database to terminate abnormally.

Bug Fixes - UDF

• Fixed an issue where the offset_seconds field contained an incorrect value when passing a value with a non-UTC time_zone_offset of type tsurugidb.udf.OffsetDatetime to the gRPC service.

Bug Fixes - Client

• Fixed an issue where sessions used by tgsql could remain unclosed on the server side after tgsql exits.
  • This issue has been confirmed to occur more frequently when using SQL execution mode (tgsql --exec) with IPC connections.
  • Related to this fix, the options --shutdown-type and --shutdown-timeout have been added to specify the session shutdown behavior when tgsql closes a connection. For details, see:
    • tgsql (ja)

Upgrade Notes

Client Compatibility List

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

Client	Version
Tsubakuro/Java	1.13.0+
Iceaxe	1.13.0+
Tanzawa	1.13.0+
Tsubakuro/Rust	0.7.0+
Tsurugi MCP Server	0.5.0+
Tsurugi JDBC	0.2.0+
Tsurugi UDF	0.2.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.9.0 - Changelog

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

• Tsurugi 1.9.0 - Known Issues(en)

---

This discussion was created from the release 1.9.0.