Tsurugi 1.9.0 - Changelog

[akirakw]

1.9.0 Changelog

Features

• add db_name to configuration (a79d64e)
• compiler: plan info analyzer can handle apply operator. (2f04bd9)
• compiler: SQL compiler accepts APPLY clause. (39cab0d)
• compiler: support common table expressions. (dc11d5b)
• compiler: support compiling truncate table statement. (267bc00)
• data-relay-grpc: output computed tag value in debug log (6af0b6d)
• jogasaki: adapted to apply operator (e332673)
• jogasaki: add user name to altimeter log (4bcb522)
• jogasaki: apply UDF to non-BLOB/CLOB types (eca0be8)
• jogasaki: enable udf tls when secure=true (b7595c3)
• jogasaki: make transport configurable via config file (7155b4b)
• jogasaki: preparation to support UDTF with APPLY (9a4dca9)
• jogasaki: support APPLY clause with table-valued functions (3293dcc)
• jogasaki: support BLOB/CLOB data exchanged by UDTF in APPLY clause (8391875)
• jogasaki: Update UDF supported version to 0.2.0 (20c9af8)
• limestone: add instance_id to configuration (118fba3)
• limestone: integrate altimeter wal_started/wal_stored/wal_shipped logs and tests (1bb0cfe)
• limestone: update configuration path handling and datastore create_channel (68bbc0e)
• mainly update tateyama, and adjust data-relay-grpc and jogasaki accordingly: genericized the gRPC server by separating it from the blob_relay_service (8d07d96)
• tateyama, tateyama-bootstrap and jogasaki: implement configuration_provider, alter database_info to provide instance_id, and add system.instance_id to configuration (85ab1d8)
• tateyama: add instance_id to altimeter log (1d5b0e8)
• tateyama: add username to altimeter log (a1ec495)

Bug Fixes

• compiler: allow parens to join terms. (4ba2ee0)
• compiler: check correlation column names duplication. (1c97aec)
• compiler: check CTE column names duplication. (0b2eb30)
• data-relay-grpc: modify the tag generation method to conform to the specifications (8df6379)
• jogasaki: add instance_id to event logging (09e4fcf)
• jogasaki: add log messages for udf error handling (3a3d8f2)
• jogasaki: apply op. to handle varlen data correctly (f1e0db5)
• jogasaki: apply op. to release memory used for each output record (f2fa9b5)
• jogasaki: error handling improved to process APPLY (f6a141e)
• jogasaki: fix invalid UDF OffsetDatetime fetch (9732110)
• jogasaki: fix metadata for apply UDF (8575457)
• jogasaki: fix udf OFFSETDATETIME offset (3cc97b2)
• jogasaki: improve error handling to avoid server crash by assert fail (b8f1065)
• jogasaki: improve logging messages for udf (1781f54)
• jogasaki: Move UDF files and add semantic mappings (#233) (e7c87dd)
• jogasaki: server crash with aggregate operation when calculated group key happens to be longer than the input record (f518ef2)
• shirakami: ensure that Record GC threshold is non-decreasing (9bf4182)
• shirakami: honor refcount for placeholder on insert cancel (a2e4591), closes project-tsurugi/tsurugi-issues#1408
• tateyama-bootstrap: fix authentication server access (f8379b6)
• tateyama: do not start tsurugidb upon encountering double-start error with gRPC server (aaada54)
• tateyama: improve test stability with task scheduler (2987a46)
• tateyama: re-enable the fix: do not start tsurugidb upon encountering double-start error with gRPC server (f6b8e99)
• tateyama: remove erroneously mixed LOG (cfc504c)
• tateyama: return an error if configuration::configuration_provider cannot be obtained in datastore::resource::bridge::setup() (bac1d48)
• tateyama: revise error logging when unable to create files in /dev/shm during IPC session connection (10acca1)
• tateyama: set GRPC_ARG_ALLOW_REUSEPORT of gRPC server to 0 (off) (6afd0b4)
• tgsql: session shutdown (82daef9)

Documentation

• add APPLY clause to sql-features.md. (e9d71c5)
• add grammar rule of common table expressions. (97aafba)
• jogasaki: update internal docs to explain temporal types (398a700)
• remove SUBSTR from reserved word list. (42110c8)
• revise configuration documents for udf.secure (9d421a2)
• tateyama: update grpc_server and blob_relay section of config parameters docs (2eb288e)
• tgsql: --shutdown-type (8ee2878)

Distribution

• bump tsubakuro, tanzawa to 1.14.0-SNAPSHOT (7dff0a9)
• change java-17-openjdk-headless to java-17-openjdk-devel (fb96087)
• transform only regular archive members when generate archive (196e4f4)

Styles

• jogasaki: change code style in apply operator (32d5156)
• jogasaki: prepare for yield processing APPLY (87425fb)
• jogasaki: rename a function to avoid name collision (0da896d)
• tsubakuro: bump license header to 2026 (416fc79)

Miscellaneous Chores

• data-relay-grpc: add debug log for tag related operations (6b2b870)
• data-relay-grpc: fix typo (c92deab)
• jogasaki: refactoring testcases, docs for apply (a8a8ece)
• jogasaki: update .gitignore file (cdf4790)

Code Refactoring

• data-relay-grpc: provides extensibility for the data-relay-grpc plugins (493e9fa)
• jogasaki,sharksfin: replace calls to deplecated functions of sharksfin with calls to new ones (2e21be9)
• limestone: fix clang-tidy warning in set_data_location (28fbf9d)
• limestone: remove unused generate_reference_tag and related tests (3b5e59d)
• shirakami: follow to limestone API migration (19ee3db)
• tateyama: follow new limestone::api::configuration API (b94f480)

Tests

• jogasaki: fix broken annotations on CI environment (d5b6737)
• jogasaki: fix failing testcases on RelWithDebInfo builds (91c4543)
• jogasaki: fix testcases failing with sharksfin-memory (1640543)
• jogasaki: make blob apply TCs robust and simple (0ffb51b)
• jogasaki: make testcases runnable even after port sharing is disabled (6ea1e51)
• jogasaki: separate testcases in test source files (bb8978d)

Build System

• bump cmake_minimum_required to 3.20 (2ef53b5)
• data-relay-grpc: add missing make_directory (workaround for FTBFS with CMake 3.31) (cad027f)
• harinoki: update to the newest version (build environment change only) (66c3f3f)
• jogasaki: adapt to limestone api change (f0aa80c)
• set CMP0167 to NEW to suppress FindBoost warning (7037482)
• shirakami: fix build problem with -DBUILD_PWAL=OFF (51baf77)
• Upgrade build toolchain to JDK 17 with Java 11 target compatibility (c53eee9)
• workaround for libmpdec dev package installation issue on Debian 13 (16b2c06)

Continuous Integration

• fix if syntax to avoid always-true check (668eb93)
• improvement for utilization and optimization (1f68a33)
• jogasaki: fix duplicate Install_Data_Relay_gRPC step (48daa74)