Tsurugi 1.8.0 - Release Notes (en)

[akirakw]

Tsurugi 1.8.0 Release Notes

Overview

Tsurugi 1.8.0 introduces support for User-Defined Functions (UDF) as an experimental feature.

Tsurugi UDF is an extension feature that allows user programs created as gRPC services to be called as SQL functions. You can execute processes implemented in various languages such as Python, Java, and C++ from SQL.

The integration with gRPC enables flexible configurations such as deploying the UDF execution environment on separate nodes, allowing seamless utilization of specialized environments such as GPU-equipped servers. It also supports large-volume data such as BLOB/CLOB types, enabling the construction of highly extensible systems that far exceed traditional Tsurugi usage methods.

For an overview of the UDF feature, see:

• Tsurugi UDF Overview (ja)

This version also introduces optimizations for execution plans of SQL queries containing OR in conditional expressions to improve performance.

In addition, this version 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

• (Experimental feature) Tsurugi UDF: Support for user-defined functions
  • For information on Tsurugi UDF, see:
    • Tsurugi UDF Overview (ja)
    • Tsurugi UDF User Guide (ja)
    • UDF Function Interface Definition (ja)
    • udf-plugin (ja)
    • udf-library (for Python) (ja)
    • Tsurugi UDF Known Issues (ja)
  • For additional details, see the README and linked resources in the tsurugi-udf repository.
• Optimized execution plans for conditional expressions containing OR
  • Implemented optimization for queries that meet the conditions described in the known issue: TSURUGI-IS-139 Conditional expressions containing OR generate inefficient execution plans. Improvements have been made to generate efficient execution plans such as adopting range scans.
• Improved stability of the SQL execution engine output mechanism
  • Cases that previously resulted in errors when significantly increasing the number of parallel executions when using RTX parallel scan or when including many UNION ALL concatenations in queries now operate stably.
• Improved access control for BLOB/CLOB types
  • Validation errors now occur when accessing BLOB/CLOB type columns in improper ways or in ways that would cause inconsistencies.

New Features and Improvements - Transaction

• Improved table/index metadata management methods
  • For future feature enhancements, the management method for table/index metadata between the SQL execution engine and transaction engine has been improved.
  • As a result, the transaction log format has changed, so there are compatibility considerations. For details, see the "Transaction Log Format Changes" section under "Upgrade Notes".
  • Due to this change, information such as table names that was previously included in exception messages like CCException is no longer included. This issue is scheduled to be fixed in a future version.

New Features and Improvements - Service

• Introduction of BLOB relay service
  • The BLOB relay service is a gRPC service for safely and efficiently exchanging BLOB/CLOB type data in Tsurugi with UDF and applications.
    • data-relay-grpc
  • Currently, this is used by the Python library for Tsurugi UDF udf-library (for Python) (ja).
    • In the future, we plan to enable the use of BLOB/CLOB types when using remote TCP from Tsubakuro or Iceaxe using this service.
  • With the introduction of the BLOB relay service, the following sections have been added to the Tsurugi configuration definition file (tsurugi.ini):
    • [grpc_server]: Configures the gRPC server included in Tsurugi.
    • [blob_relay]: Configures the BLOB relay service.
    • For details, see Configuration file parameters.

New Features and Improvements - Client

• Added mechanism to retrieve system information of Tsurugi server from clients
  • Using this feature, support has been added to retrieve and display system information such as the server version provided by the Tsurugi server from each Tsurugi CLI, client library, and driver interface.

Bug Fixes

Bug Fixes - SQL

• Fixed an issue where specifying INT type values for the second and third arguments of the SUBSTR function would result in an error.
• Fixed an issue where specifying IS NULL for BLOB/CLOB type values would cause UNSUPPORTED_COMPILER_FEATURE_EXCEPTION.
• Fixed an issue where placing control codes in identifiers such as table names would not result in restriction errors.

Bug Fixes - Client

• Changed session-associated background threads to daemon threads in Tsubakuro/Java.
• Fixed an issue where Session.isAlive() may not work properly during TCP connections in Tsubakuro/Java.
• Fixed an issue where unintended timeout errors could rarely occur when generating a large number of transactions in Tsubakuro/Java.

Upgrade Notes

Client Compatibility List

Tsurugi 1.8.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.1.0+

Transaction Log Format Changes

In this version, the transaction log format version has been changed to Version 7. When you start version 1.8.0 using a transaction log that was used with version 1.7.0, the transaction log format version will be automatically updated.

As a result, transaction logs started with version 1.8.0 cannot be used with version 1.7.0. Also, please note that backups created with version 1.8.0 or later cannot be restored with version 1.7.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.8.0 - Changelog

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

• Tsurugi 1.8.0 - Known Issues(en)

---

This discussion was created from the release 1.8.0.