MatrixOne v26.4.2.8 Release Notes

MatrixOne Version: v26.4.2.8 (v4.2.8)

This release adds a per-query IVF probe option and corrects role-grant, DELETE target, auto-increment INSERT, and ON DUPLICATE KEY UPDATE behavior.

New Features

  • Query-level IVF probe count: BY RANK WITH OPTION 'nprobe=N' accepts an integer from 1 through 80000, alone or with a ranking mode. It overrides the session probe_limit for that query without changing the session value. In auto mode, the planner may widen the base probe count. See Query-level IVF Probe Count.

Behavior Changes

  • Concurrent role grants: A role grant that would form an inheritance cycle is rejected even when role membership changes are submitted concurrently. The GRANT role TO role syntax is unchanged. See Role Grant Consistency.

  • DELETE targets with CTEs: When a CTE and a target table alias share a name, DELETE resolves the target to the table alias. An actual CTE target does not delete the same-named base table, and multi-target statements validate all targets before deletion. See DML Target and Conflict Semantics.

  • AUTO_INCREMENT inserts: Inserts into an auto-increment primary-key table avoid incorrect conflict retries in the tested case with many small stored objects. INSERT syntax is unchanged. See DML Target and Conflict Semantics.

  • ON DUPLICATE KEY UPDATE row locking: On a UNIQUE-key conflict, the statement locks the existing row resolved by that conflict, including when its primary key differs from the incoming row. It waits for a transaction holding that row with SELECT ... FOR UPDATE. See DML Target and Conflict Semantics.

Full Changelog

v4.2.7…v4.2.8