MatrixOne Files

Release date: Aug 26 2025 MatrixOne version: v3.0.0

MatrixOne 3.0.0 introduces a improvement and bug fixes that enhance system performance, stability, and usability. Below are the major updates.

Key Improvements

1.Implement Fast-Shallow-Copy of table data 2.Support the new CLONE syntax, enabling rapid shallow copying of data at cluster, tenant, database, and table levels. 3.Schema changes now consume significantly less memory. 4.Implement RIGHT DEDUP join to reduce memory usage for big insert 5.Support strcmp function 6.Support make create index support partition

Bugfix

1.Fix cdc some bugs 2.Fix fuzzyfilter 3.Fix the snapshot some bugs 4.Fix SEMI join, shuffle join 5.Fix union all select fulltext 6.Fix some partition bugs

What's Changed

• fix data race in moerr & merge scheduler by @aptend in https://github.com/matrixorigin/matrixone/pull/21859
• Revert "s3fifo add ghost fifo (#21653)" main branch by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21854
• [bug] logservice: fix the snapshot path by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/21851
• for_debug by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21865
• fix Test_Replayer11 by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21873
• Bug fix: fix the panic by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/21868
• some code cleanup by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21828
• modify case(main) by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/21878
• add 2.2-dev to mergify by @aressu1985 in https://github.com/matrixorigin/matrixone/pull/21881
• fix rollup bvt tag by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/21891
• remove stale compatibility code by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21883
• enable EXPLAIN to show analyze info for background SQLs by @aunjgr in https://github.com/matrixorigin/matrixone/pull/21858
• fileservice: make DiskCacheCallbacks a context.Context to eliminate usages of context.WithValue by @reusee in https://github.com/matrixorigin/matrixone/pull/21811
• introduce err2 as local variable to prevent race by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21889
• colexec/external: ensure symlink is valid in TestReadDirSymlink by @reusee in https://github.com/matrixorigin/matrixone/pull/21906
• Fix bug: get error result in binary execute with nil by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21928
• fix mpool freed -1 by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21927
• fix tombstone vacuum check by @aptend in https://github.com/matrixorigin/matrixone/pull/21918
• [Bug]: Remove bvt tag by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/21937
• filter and prune of partition table by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/21899
• Fix bug : can not alter user in some case by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/21945
• fix 21952 for main by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21957
• fix bug: user can create user without permission by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/21958
• [#21864] Fix bug by @triump2020 in https://github.com/matrixorigin/matrixone/pull/21944
• remove dummy prints by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21963
• update cdc sinker by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21969
• make create index support partition by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/21346
• fix the data race in fulltextIndexMatch. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21983
• offline tool to handle checkpoint meta file by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21989
• change some interface of CompilerContext by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/21984
• Feature: Support filter with T.TS by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/21992
• fix TestBuildMulti race by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22010
• checkpoint tool II by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22014
• Update transfer page by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21845
• add debug log by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/22013
• Fix TestAppendAndGC2 by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22027
• add debug tool by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21821
• show create partition table by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/22028
• GC can be arbitrarily suspended and resumed by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22012
• optimize cdc table detector by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22033
• cdc support truncate by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/22032
• ast string with quote identifier by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/22046
• make runtime filter work on non-PK column by @aunjgr in https://github.com/matrixorigin/matrixone/pull/22045
• GC can be reset by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22042
• db and table filter on scanloop in cdc by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/22048
• fulltext disable pushdown limit by @cpegeric in https://github.com/matrixorigin/matrixone/pull/22063
• bug fix index cache return index destroyed error when NewAlgo in one thread and Remove by another thread by @cpegeric in https://github.com/matrixorigin/matrixone/pull/22023
• make alter table index support partition by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/22047
• refactor alter inplace mode by @aptend in https://github.com/matrixorigin/matrixone/pull/22062
• Optimize update cdc watermark by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22066
• fix noop match arm in alter builder by @aptend in https://github.com/matrixorigin/matrixone/pull/22075
• removed the object expansion logic in the workspace. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22080
• remove an unwanted typecast in binder by @aunjgr in https://github.com/matrixorigin/matrixone/pull/22069
• update code owners by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22079
• control sync frequency of cdc task by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/22082
• add case for replace by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/22085
• [fix] always assign column name to runtime filter by @aunjgr in https://github.com/matrixorigin/matrixone/pull/22091
• enable new DML plan for tables with vector columns by @aunjgr in https://github.com/matrixorigin/matrixone/pull/22092
• enhance expr format by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22089
• cdc frequency fix + createSql build bug fix by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/22093
• cdc truncate fix by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/22100
• do column-pruning for VALUE_SCAN node by @aunjgr in https://github.com/matrixorigin/matrixone/pull/22105
• add case for replace by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/22106
• cleanup log 1 by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22102
• BUG FIX: index generated by for loop didn't pass as go function argument leads to undetermined index and some race conditions by @cpegeric in https://github.com/matrixorigin/matrixone/pull/22118
• parse binary in strToSigned by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/22084
• make partition support index write by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/22124
• add case for [#5763] [#5762] [#5345] by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/22127
• GC can handle different table share same object by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22068
• fix prints. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22133
• update usearch by @cpegeric in https://github.com/matrixorigin/matrixone/pull/22119
• fix create pitr if exists by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/22132
• fix force gckp for main by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22145
• make internal sql executor support prepared statement by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/22136
• testutil: use testing.T.TempDir in NewFS by @reusee in https://github.com/matrixorigin/matrixone/pull/22128
• create database/table with shallow copy and replace the insert into select in the restore statement. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22041
• enhance const fold pushdown by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/22152
• cleanup compact related code by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22160
• partitioned tables support index queries by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/22158
• Fix catalog gc by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22169
• fix the logic TS missing when cloning tables across accounts. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22162
• Refactor the alter implementation to better support non-copying scenarios. by @aptend in https://github.com/matrixorigin/matrixone/pull/22155
• ivfflat search better error handling by @cpegeric in https://github.com/matrixorigin/matrixone/pull/22138
• Bytes with atomic reference counter not guarantee to deallocate memory and memory still accessible even memory was deallocated. by @cpegeric in https://github.com/matrixorigin/matrixone/pull/22171
• CI: use ustc ubuntu mirror by @guguducken in https://github.com/matrixorigin/matrixone/pull/22088
• fix TestDedupSnapshot3 by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/22181
• hashtable,hashmap: add MarshalBinary/UnmarshalBinary by @reusee in https://github.com/matrixorigin/matrixone/pull/22163
• fix rename column: delete table with old metadata by @aptend in https://github.com/matrixorigin/matrixone/pull/22182
• Fix Inconsistent SQL Query Results for the MO System Version. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22176
• Update GC filter by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22178
• colexec/aggexec: add AggFuncExec.Size by @reusee in https://github.com/matrixorigin/matrixone/pull/22187
• fix add cdc task by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/22192
• Revert 22171 due to performance degradation by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22194
• fifocache: fix potential double-free by @reusee in https://github.com/matrixorigin/matrixone/pull/22196
• improvement: skip pk dedup in alter copy mode if pk is not changed by @aptend in https://github.com/matrixorigin/matrixone/pull/22189
• fix cdc with json by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22204
• colexec/external: log file system events in TestReadDirSymlink by @reusee in https://github.com/matrixorigin/matrixone/pull/22206
• Refactor show recovery window. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22188
• Fix snapshot read in multiple statements. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22209
• skip experimental index flag check in clone statements. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22216
• add hashmap/hashtable.WriteTo/UnmarshalFrom by @reusee in https://github.com/matrixorigin/matrixone/pull/22220
• Add GCInMemoryTTL config for GC Catalog by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22222
• resolve variable function passed from parent proc to internal sql exe and check index in Create Table by @cpegeric in https://github.com/matrixorigin/matrixone/pull/22190
• support strcmp by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/22221
• for cdc : inject some faults and fix some bugs by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/22186
• [opt] implement RIGHT DEDUP join by @aunjgr in https://github.com/matrixorigin/matrixone/pull/22179
• supports s3 write of index table data for partitioned tables by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/22228
• Adding basic starlark exec function. by @fengttt in https://github.com/matrixorigin/matrixone/pull/22167
• Fix TestPitrMeta by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22229
• [opt] eliminate memory copy in RIGHT DEDUP join by @aunjgr in https://github.com/matrixorigin/matrixone/pull/22230
• change unsigned cast rule by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/22225
• rm tag 8848 by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/22235
• fix partition affected rows not work by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/22232
• Add DefaultGlobalVersionInterval config by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22238
• Change starlark runtime function return to res, err by @fengttt in https://github.com/matrixorigin/matrixone/pull/22231
• adding more err msg for UT TestIssue19551 by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22234
• Fix file is not found after clone database by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22243
• rewrite the SQL in BVT to avoid full scanning of the statement_info. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22233
• [opt] enable range shuffle for RIGHT DEDUP join by @aunjgr in https://github.com/matrixorigin/matrixone/pull/22244
• cleanup mo log 2 by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22245
• improvement: skip unique idx dedup in alter copy mode if those idxs remain unchanged by @aptend in https://github.com/matrixorigin/matrixone/pull/22224
• fix shuffle RIGHT DEDUP join by @aunjgr in https://github.com/matrixorigin/matrixone/pull/22253
• make sure the snapshot read TS greater than the TXN TS when create snapshot or clone. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22252
• add debug log by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/22257
• CN can flush small objects by fault injection. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22223
• Clean mo log 3 by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22260
• trigger ON UPDATE for INSERT ON DUPLICATE UPDATE by @aunjgr in https://github.com/matrixorigin/matrixone/pull/22262
• Correct tombstone handling in merge simulator by @aptend in https://github.com/matrixorigin/matrixone/pull/22259
• fix some partition bugs by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/22248
• colexec/external: use os temp dir in TestReadDirSymlink by @reusee in https://github.com/matrixorigin/matrixone/pull/22254
• fix Test_CheckpointChaos3 by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/22269
• remove all table retention-related code. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22261
• add debug log by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/22268
• make sure the MO service started before running the MO stats task. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22270
• Support 'where tuple in tupleList' by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/22249
• fifocache: add ghost queue by @reusee in https://github.com/matrixorigin/matrixone/pull/22247
• Generate_random_int64/float64 table functions. by @fengttt in https://github.com/matrixorigin/matrixone/pull/22267
• fix string bigint(20) unsigned by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/22273
• fileservice: add FileService.NewReader/NewWriter by @reusee in https://github.com/matrixorigin/matrixone/pull/22240
• Fix Snapshot read by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22279
• colexec/aggexec: implement marshal/unmarshal for distinctHash; export special agg ids by @reusee in https://github.com/matrixorigin/matrixone/pull/22237
• Optimize s3writer by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22281
• Fix runningTasks deadlock by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22283
• add case for restore ignore experimental flags. by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/22289
• add release 3.0 to mergify by @heni02 in https://github.com/matrixorigin/matrixone/pull/22290
• Pick 22284 22293 to 3.0-dev by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22295
• fix shuffle join (cp [#22282]) by @aunjgr in https://github.com/matrixorigin/matrixone/pull/22305
• to 3.0: memory throttler for CN-flush-S3, workspace and merge. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22306
• Fix 22307 pick to 3.0 by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22314
• add cases 18667 by @heni02 in https://github.com/matrixorigin/matrixone/pull/22311
• fix empty unique index after altering 3.0 by @aptend in https://github.com/matrixorigin/matrixone/pull/22315
• update GlobalVersionInterval for ut by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22316
• fix 'db not selected' error in alter table 3.0 by @aptend in https://github.com/matrixorigin/matrixone/pull/22325
• to 3.0: Fix the foreign key reference mismatch in clone statements. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22320
• flushing objects in chunks 3.0 by @aptend in https://github.com/matrixorigin/matrixone/pull/22331
• to 3.0: some simple restrictions on clone privilege. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22330
• to 3.0: restrict MO_CTL execution of cn merge within explicit transactions by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22333
• container/hashtable: use longer than 16 bytes keys in tests by @reusee in https://github.com/matrixorigin/matrixone/pull/22355
• to 3.0: Fix the appendable tombstone object clone logic. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22344
• pick Left/Inner join produces better chunks (#22351) to 3.0-dev by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/22356
• fix obj list without tomestone by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/22361
• optimize top operator's batch processing 3.0 by @aptend in https://github.com/matrixorigin/matrixone/pull/22403
• to 3.0: report the error when the subscription table fails. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22406
• to 3.0: Try snapshot read if the subscription does not exist. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/22412

Full Changelog: https://github.com/matrixorigin/matrixone/compare/v2.2.2...v3.0.0