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 sessionprobe_limitfor that query without changing the session value. Inautomode, 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 rolesyntax is unchanged. See Role Grant Consistency.DELETE targets with CTEs: When a CTE and a target table alias share a name,
DELETEresolves 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 UPDATErow 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 withSELECT ... FOR UPDATE. See DML Target and Conflict Semantics.