MatrixOne Files

Release date: September 10, 2026
MatrixOne version: v4.2.3

MatrixOne 4.2.3 is a patch release on top of 4.2.2, improving query execution, database creation, subscription indexes, and memory ownership under admission failures.

Key Improvements

Query Execution

• Correlated Aggregate Point Lookups: Restrict eligible correlated scalar aggregates to the outer primary-key point domain, avoiding scans of unrelated rows.
• Compute-Pool Routing: Preserve the initiating query's CN labels through internal vector-index SQL and remote execution.

Key Bug Fixes

SQL and Catalog Correctness

• Reset prepared-statement parameter NULL state correctly when parameters are rebound to non-NULL values.
• Handle build-only result columns in ON DUPLICATE KEY UPDATE without indexing the wrong batch.
• Resolve subscribed secondary-index tables using the publisher database identity.
• Make database creation fail closed and retain correct catalog-cache visibility during garbage collection.
• Correct the logical-ID index primary-column type to match the source catalog definition.

Reliability

• Preserve vector Area ownership when memory admission fails, allowing normal cleanup.
• Distinguish internal receiver early-stop from terminal query or connection cancellation.

What's Changed

Selected changes; see the full changelog for all commits.

• fix(optimizer): bound correlated scalar aggregate point scans by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/28353
• fix(colexec): isolate prepared parameter null state (cherry-pick [#26915]) by @ck89119 in https://github.com/matrixorigin/matrixone/pull/28205
• [4.2] fix(dedupjoin): handle build-only ODKU result columns by @VioletQwQ-0 in https://github.com/matrixorigin/matrixone/pull/28075
• [4.2] fix: resolve secondary indexes in subscriptions by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/28280
• [4.2] fix(ddl): make database creation fail closed by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/28287
• fix(vector): preserve Area on admission failure for 4.2-dev by @VioletQwQ-0 in https://github.com/matrixorigin/matrixone/pull/28369
• fix(vector): preserve CN labels for internal SQL by @ck89119 in https://github.com/matrixorigin/matrixone/pull/28204
• fix(compile): keep remote receiver stop non-terminal by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/28128
• [4.2] fix(catalog): correct logical ID index primary column width by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/28526

Full Changelog: https://github.com/matrixorigin/matrixone/compare/v4.2.2...v4.2.3