MatrixOne-v3.0.15

Release date: June 17 2026
MatrixOne version: v3.0.15

MatrixOne 3.0.15 builds on 3.0.14 with expanded SQL and MySQL compatibility (string functions, date/time functions, POSITION), decimal and planning fixes, Data Branch improvements, Parquet external table fixes, and stability fixes across transactions, execution, CDC, security, and fulltext index rewrites.

Key Improvements

SQL Compatibility & Query

• String Functions: Added RIGHT and QUOTE for broader MySQL function coverage
• Date & Time Functions: Cherry-picked date and time function improvements
• POSITION: Added parser support for POSITION(substr IN str)
• Decimal: Fixed truncate behavior for decimal integer division
• Planning: Aligned COALESCE decimal scale and added decimal256 comparison support

External Table Features

• Parquet: Fixed Parquet datetime load and remote empty marker handling

Data Branch

• Clone SQL: Fixed data branch create table clone SQL on 3.0
• Result Conversion: Fixed data branch result conversion on 3.0-dev

Execution & Compilation

• Remote Run: Fold variable expressions before remote run
• Shuffle Dispatch: Allowed local notify streams for shuffle dispatch

Index & Query Optimization

• Fulltext Index: Supported fulltext index rewrite for joins
• System Views: Optimized statistics view catalog joins

Security & Frontend

• Table Grants: Honor global table grant option
• Role Rules: Aligned role rule merge semantics

Key Bug Fixes

Transaction & Reliability

• Close txn operator on cleanup rollback failure

CDC

• Aligned CDC pause visible state

DDL

• Restored database delete skip for already deleted relations (3.0)

What's Changed

• 3.0: fix: restore database delete skip for already deleted relations by @gouhongshen in #24749
• test: cover hive partition auto inference (3.0-dev) by @Ariznawlll in #24745
• fix: truncate decimal integer division by @jiangxinmeng1 in #24707
• add right by @daviszhen in #24694
• cherrypick: date & time function by @daviszhen in #24757
• add quote by @daviszhen in #24753
• fix(parser): support POSITION(substr IN str) by @jiangxinmeng1 in #24775
• fix: close txn operator on cleanup rollback failure by @LeftHandCold in #24781
• fix: fold variable expressions before remote run by @LeftHandCold in #24802
• fix: align CDC pause visible state by @jiangxinmeng1 in #24804
• fix(sysview): optimize statistics view catalog joins by @iamlinjunhong in #24856
• fix(plan): align coalesce decimal scale and support decimal256 comparison by @ck89119 in #24841
• compile: allow local notify streams for shuffle dispatch (#24159) by @LeftHandCold in #24854
• fix: support fulltext index rewrite for joins by @iamlinjunhong in #24886
• fix(frontend): honor global table grant option by @ck89119 in #24752
• fix(frontend): align role rule merge semantics by @ouyuanning in #24936
• 3.0: fix data branch create table clone SQL by @gouhongshen in #24958
• to 3.0: Fix data branch result conversion on 3.0-dev by @gouhongshen in #24876
• fix parquet datetime load and remote empty marker by @iamlinjunhong in #24938

Full Changelog: v3.0.14...v3.0.15