MatrixOne v26.4.1.2 Release Notes

Release Date: July 20, 2026 MatrixOne Version: v26.4.1.2 (v4.1.2)

MatrixOne v26.4.1.2 is a patch release that adds COPY GRANTS support for the CREATE TABLE ... CLONE statement and fixes scalar subquery support in INNER JOIN ON conditions.

New Features

  • CLONE COPY GRANTS (#25812): CREATE TABLE ... CLONE now supports an optional COPY GRANTS clause that copies explicit table-level privilege grants from the source table to the cloned target table. Only direct table-object grants are copied; broader grants (db.*, *.*) are not expanded. The WITH GRANT OPTION attribute is preserved. COPY GRANTS cannot be used together with TO ACCOUNT or when cloning across different accounts. When combined with IF NOT EXISTS and the target table already exists, the existing grants are left unchanged.

Bug Fixes

  • Scalar subquery in INNER JOIN ON condition (#25359): Scalar subqueries are now supported in INNER JOIN ON conditions. Subqueries found in INNER JOIN ON predicates are lowered to FILTER nodes, allowing queries such as SELECT ... FROM t1 JOIN t2 ON t2.col = (SELECT MAX(col) FROM t3 WHERE t3.key = t1.key) to execute correctly. Note that this only applies to INNER JOIN; subqueries in LEFT JOIN ON conditions are not supported.

Compatibility Notes

  • The COPY GRANTS clause is an optional addition to CREATE TABLE ... CLONE. Existing CLONE statements without COPY GRANTS continue to work as before.

  • Scalar subqueries in INNER JOIN ON conditions that previously failed with an error will now execute successfully.

About This Document

This document is generated by the docs sync agent based on the MatrixOne source diff and reviewed by humans via pull request.

Full Changelog

v4.1.1…v4.1.2