MatrixOne v26.4.2.1 Release Notes¶
Release Date: August 27, 2026 MatrixOne Version: v26.4.2.1 (v4.2.1)
MatrixOne v26.4.2.1 introduces the DataStream external table (CREATE EXTERNAL TABLE ... ENGINE = DATASTREAM) and fixes two query-behavior issues: deterministic ordering of floating-point NaN values in ORDER BY, and primary-key filter pushdown for nested AND/OR boolean expressions.
New Features¶
DataStream external table:
CREATE EXTERNAL TABLE ... ENGINE = DATASTREAMmaps a MatrixOne external table to a data source served by a remote DataStream (jstfu) server. The table is read-only, streams rows on demand, and accepts theserver,port, andtableoptions plus the optionalrecheckandapikeyoptions.SHOW CREATE TABLEround-trips the DDL without revealing theapikey.
Behavior Changes¶
Deterministic floating-point
NaNordering:ORDER BYonFLOATandDOUBLEcolumns now sortsNaNvalues after every numeric value (last) in both ascending and descending order, and treats allNaNvalues as peers. Signed zeroes are also treated as peers.
Bug Fixes¶
Nested primary-key
ORbranches preserved: predicates that combine a primary-key range with nestedAND/ORbranches (for examplea <= ? AND (a = ? OR a > ?)) are now pushed down correctly, so queries with these conditions return the correct rows.
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.