MatrixOne-v4.2.6

Release date: October 18, 2026
MatrixOne version: v4.2.6

MatrixOne 4.2.6 updates the 4.2 release line with broader vector-search SQL support, lower median aggregation memory overhead, and fixes for backup/restore, SQL and index correctness, full-text parsing, and logtail subscriptions.

Upgrade Notes

• DECIMAL256 Indexes: Existing indexes affected by legacy DECIMAL256 writes require rebuilding from their base tables in a maintenance window before user reads and writes resume. Review the upgrade procedure before upgrading; affected deployments must not mix old and new writers.

Key Improvements

Vector Search and Memory Efficiency

• More Query Shapes: Support IVF-FLAT Top-K through eligible equi-joins and scalar-subquery query vectors with IVF-FLAT and HNSW.
• Median Aggregation: Reduce intermediate-state memory amplification.

Key Bug Fixes

Correctness and Reliability

• Backup and Restore: Preserve historical objects across repeated backups and make account restores repeatable with grants rebound correctly.
• SQL and Indexes: Improve composite-key range pruning and DECIMAL256 index correctness, repair ON DUPLICATE KEY UPDATE metadata ownership, and preserve stored BINARY bytes during SQL replay.
• Logtail: Preserve in-flight subscriptions.
• Full-Text Search: Handle a single double-quote safely in Boolean-mode queries.

What's Changed

Selected changes; the full comparison is linked below.

• [4.2-dev] Backport #29513: composite range pruning and DECIMAL256 safety by @XuPeng-SH in #29518
• [4.2-dev] fix: make account restore repeatable and rebind grants by @gouhongshen in #29431
• [4.2-dev] fix(backup): preserve historical objects across repeated backups by @LeftHandCold in #29504
• [4.2-dev] fix(disttae): preserve in-flight logtail subscriptions by @XuPeng-SH in #29616
• [4.2-dev] Reduce median intermediate-state memory amplification by @LeftHandCold in #29686
• [4.2-dev] Support IVF-FLAT Top-K through equi-joins by @ck89119 in #30013
• [4.2-dev] Support scalar-subquery query vectors with IVF-FLAT and HNSW by @ck89119 in #30012

Full Changelog: v4.2.5...v4.2.6