MatrixOne-v3.0.12

Release date: May 18 2026
MatrixOne version: v3.0.12

MatrixOne 3.0.12 introduces significant SQL compatibility improvements, data branch features, and critical stability fixes. This release enhances MySQL compatibility with new date/time functions, adds support for Hive-style partitioned Parquet external tables, and brings important data branch snapshot protection capabilities to the 3.0-dev branch.

Key Improvements

SQL Compatibility Enhancements

• Date/Time Functions: Added support for YEARWEEK() function and enhanced WEEK() function with mode parameter compatibility
• Interval Expression Parsing: Improved parsing for parenthesized modulo in interval expressions
• MySQL Type Compatibility: Reimplemented and enhanced MySQL type compatibility for YEAR, DECIMAL256, and SET types on 3.0-dev
• Query Safety: Prevented panic scenarios in resetDateFunctionArgs when handling invalid interval expressions

External Table Features

• Hive-Style Partitioned Parquet: Added support for Hive-style partitioned Parquet external tables, enabling seamless integration with existing data lake architectures

Data Branch & Snapshot Protection

• Branch Protect Snapshot: Backported Branch Protect Snapshot feature to 3.0-dev, enhancing data protection capabilities for branch operations
• Diff/Merge Range Collection: Unified diff/merge collect-range functionality over arbitrary DAG depth for improved data branch operations

Query Optimization

• Index Optimization: Optimized regular index order-by limit operations for better query performance
• Join Operations: Improved join result vector handling after empty probe operations

Key Bug Fixes

Data Loading & Storage

• Load Data Compatibility: Backported load data and Parquet compatibility improvements for enhanced reliability
• Object I/O: Fixed partial read cache data release on error conditions in object I/O operations

Locking & Concurrency

• Remote Lock Handling: Fixed issue where remote lock callers were not properly woken on response write failures

Logtail & Replication

• Consumer Backlog: Reduced consumer backlog pressure in logtail operations for improved stability

Data Integrity

• Geometry Validation: Enforced geometry subtype validation at INSERT/UPDATE bind time for better data integrity
  Memory Protection: Implemented bounded retry for TransferPage write operations to prevent DN OOM under IO fault conditions

What's Changed

• fix: support YEARWEEK function (Fixes #24234) by @LeftHandCold in #24238
• fix: WEEK() function mode parameter support (Fixes #24236) by @LeftHandCold in #24239
• fix: parse interval parenthesized modulo (Fixes #24235) by @LeftHandCold in #24242
• fix(plan): prevent panic in resetDateFunctionArgs with invalid interval expression by @jiangxinmeng1 in #24283
• fix: close interval and week compatibility gaps by @LeftHandCold in #24302
• fix: reset reused join result vectors after empty probe by @LeftHandCold in #24273
• fix: reimplement MySQL type compatibility for 3.0-dev by @ck89119 in #24204
• fix(objectio): release partial read cache data on error by @LeftHandCold in #24311
• fix(logtail): reduce consumer backlog pressure by @LeftHandCold in #24323
• fix: optimize regular index order-by limit by @LeftHandCold in #23966
• feat(external): support Hive-style partitioned Parquet external tables by @iamlinjunhong in #24329
• fix: backport load data and parquet compatibility by @LeftHandCold in #24332
• fix: wake remote lock callers on response write failure by @LeftHandCold in #24345
• to 3.0: feat(data-branch): backport Branch Protect Snapshot to 3.0-dev by @gouhongshen in #24347
• fix: enforce geometry subtype validation at INSERT/UPDATE bind time by @ck89119 in #24353
• fix: bounded retry for TransferPage write to prevent DN OOM under IO faults by @jiangxinmeng1 in #24337
• fix: close MySQL type compatibility gaps for YEAR/DECIMAL256/SET on 3.0-dev by @ck89119 in #24342
• to 3.0: fix(data-branch): unify diff/merge collect-range over arbitrary DAG depth by @gouhongshen in #24377

Full Changelog: v3.0.11...v3.0.12