Tsurugi 1.7.0 - Release Notes (en)

[akirakw]

Tsurugi 1.7.0 Release Notes

Overview

Tsurugi 1.7.0 now supports JDBC, the standard database connection API for Java.
With this update, we have released Tsurugi JDBC, a JDBC driver based on JDBC 4.3.

• https://github.com/project-tsurugi/tsurugi-jdbc

By using Tsurugi JDBC, compatibility is greatly improved with the rich Java ecosystem, including ORM frameworks, application servers, and development tools, as well as with Java applications developed for other RDBMSs, including legacy systems.
In addition, many Tsurugi-specific features are also available through connection options and other means.

Tsurugi has traditionally provided Iceaxe as a high-level Java API.
Iceaxe is a library designed to make it easy to develop high-performance applications while maximizing the use of Tsurugi-specific features (especially Tsurugi's transaction-related features).
Due to this direction, Iceaxe's API provides a unique interface that differs from JDBC.

Tsurugi JDBC and Iceaxe complement each other as database connection libraries with different purposes. Please select the appropriate library according to your use case.

On the server side, we have added and adjusted compatibility features for JDBC support, as well as fixed important bugs and improved stability.
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 inequality operator !=
  • This has the same functionality as the previously provided inequality operator <>.
• Added processing for AtomType.UNKNOWN in the SQL execution engine
  • When the client cannot determine the AtomType, this AtomType can be used to manipulate NULL values only.

New Features and Improvements - Transaction

• Improved the GC target detection algorithm in the transaction engine and reduced GC processing overhead

New Features and Improvements - Client

• Started providing Tsurugi JDBC
  • For information on using Tsurugi JDBC, see:
    • Tsurugi JDBC - README
    • How to Use Tsurugi JDBC (ja)
    • Tsurugi JDBC Limitations (ja)
  • Tsurugi JDBC also includes a Dialect for Hibernate ORM. For usage instructions, see:
    • Tsurugi Hibernate - README
• Added tgctl config
  • tgctl config is a command that displays a list of Tsurugi database configuration settings. For details, see:
    • tgctl config (ja)

New Features and Improvements - Distribution

• Changed the version of Apache Arrow installed in the environment by the installer from 16.1.0 to 21.0.0
• Removed the currently unused module Ogawayama Bridge from the installation configuration

Bug Fixes

Bug Fixes - SQL

• Fixed an issue where the database could abnormally terminate when processing large BLOB/CLOB in parallel immediately after database startup
• Fixed an issue where a query with binary operations between REAL types would result in an error and no response would be returned to the client
• Fixed an issue where error messages could become unexpected errors when an arithmetic error occurred in operations between DECIMAL types

Bug Fixes - Transaction

• Fixed an issue where tgctl restore backup would fail between different file systems on Ubuntu 22.04

Bug Fixes - Endpoint

• Fixed an issue where the database could rarely abnormally terminate due to inconsistencies when storing connection information in shared memory when using IPC connections

Bug Fixes - Client

• Fixed an issue where Tsubakuro/Java could rarely experience incorrect timeouts
• Fixed an issue where the database would remain improperly running if tgctl backup create failed when executed while the database was stopped
• Fixed an issue where Tsubakuro/Java would frequently timeout incorrectly when calling FutureResponse.await() with a timeout of 0
• Fixed an issue where the database could rarely abnormally terminate when closing a FutureResponse without calling get when using TCP connections in Tsubakuro/Java

Upgrade Notes

Client Compatibility List

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

Client	Version
Tsubakuro/Java	1.11.0+
Iceaxe	1.11.0+
Tanzawa	1.11.0+
Tsubakuro/Rust	0.5.0+
Tsurugi MCP Server	0.3.0+
Tsurugi JDBC	0.1.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.7.0 - Changelog

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

• Tsurugi 1.7.0 - Known Issues (en)

---

This discussion was created from the release 1.7.0.