MatrixOne-v3.0.0

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 #21859
• Revert "s3fifo add ghost fifo (#21653)" main branch by @cpegeric in #21854
• [bug] logservice: fix the snapshot path by @volgariver6 in #21851
• for_debug by @XuPeng-SH in #21865
• fix Test_Replayer11 by @jiangxinmeng1 in #21873
• Bug fix: fix the panic by @Cabbage74 in #21868
• some code cleanup by @XuPeng-SH in #21828
• modify case(main) by @Ariznawlll in #21878
• add 2.2-dev to mergify by @aressu1985 in #21881
• fix rollup bvt tag by @iamlinjunhong in #21891
• remove stale compatibility code by @jiangxinmeng1 in #21883
• enable EXPLAIN to show analyze info for background SQLs by @aunjgr in #21858
• fileservice: make DiskCacheCallbacks a context.Context to eliminate usages of context.WithValue by @reusee in #21811
• introduce err2 as local variable to prevent race by @cpegeric in #21889
• colexec/external: ensure symlink is valid in TestReadDirSymlink by @reusee in #21906
• Fix bug: get error result in binary execute with nil by @XuPeng-SH in #21928
• fix mpool freed -1 by @jiangxinmeng1 in #21927
• fix tombstone vacuum check by @aptend in #21918
• [Bug]: Remove bvt tag by @Cabbage74 in #21937
• filter and prune of partition table by @iamlinjunhong in #21899
• Fix bug : can not alter user in some case by @ouyuanning in #21945
• fix 21952 for main by @XuPeng-SH in #21957
• fix bug: user can create user without permission by @ouyuanning in #21958
• [#21864] Fix bug by @triump2020 in #21944
• remove dummy prints by @XuPeng-SH in #21963
• update cdc sinker by @jiangxinmeng1 in #21969
• make create index support partition by @zhangxu19830126 in #21346
• fix the data race in fulltextIndexMatch. by @gouhongshen in #21983
• offline tool to handle checkpoint meta file by @XuPeng-SH in #21989
• change some interface of CompilerContext by @ouyuanning in #21984
• Feature: Support filter with T.TS by @Cabbage74 in #21992
• fix TestBuildMulti race by @XuPeng-SH in #22010
• checkpoint tool II by @XuPeng-SH in #22014
• Update transfer page by @jiangxinmeng1 in #21845
• add debug log by @jiangxinmeng1 in #22013
• Fix TestAppendAndGC2 by @LeftHandCold in #22027
• add debug tool by @jiangxinmeng1 in #21821
• show create partition table by @iamlinjunhong in #22028
• GC can be arbitrarily suspended and resumed by @LeftHandCold in #22012
• optimize cdc table detector by @XuPeng-SH in #22033
• cdc support truncate by @Cabbage74 in #22032
• ast string with quote identifier by @iamlinjunhong in #22046
• make runtime filter work on non-PK column by @aunjgr in #22045
• GC can be reset by @LeftHandCold in #22042
• db and table filter on scanloop in cdc by @Cabbage74 in #22048
• fulltext disable pushdown limit by @cpegeric in #22063
• bug fix index cache return index destroyed error when NewAlgo in one thread and Remove by another thread by @cpegeric in #22023
• make alter table index support partition by @zhangxu19830126 in #22047
• refactor alter inplace mode by @aptend in #22062
• Optimize update cdc watermark by @XuPeng-SH in #22066
• fix noop match arm in alter builder by @aptend in #22075
• removed the object expansion logic in the workspace. by @gouhongshen in #22080
• remove an unwanted typecast in binder by @aunjgr in #22069
• update code owners by @XuPeng-SH in #22079
• control sync frequency of cdc task by @Cabbage74 in #22082
• add case for replace by @Ariznawlll in #22085
• [fix] always assign column name to runtime filter by @aunjgr in #22091
• enable new DML plan for tables with vector columns by @aunjgr in #22092
• enhance expr format by @XuPeng-SH in #22089
• cdc frequency fix + createSql build bug fix by @Cabbage74 in #22093
• cdc truncate fix by @Cabbage74 in #22100
• do column-pruning for VALUE_SCAN node by @aunjgr in #22105
• add case for replace by @Ariznawlll in #22106
• cleanup log 1 by @XuPeng-SH in #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 #22118
• parse binary in strToSigned by @Cabbage74 in #22084
• make partition support index write by @zhangxu19830126 in #22124
• add case for #5763 #5762 #5345 by @Ariznawlll in #22127
• GC can handle different table share same object by @LeftHandCold in #22068
• fix prints. by @gouhongshen in #22133
• update usearch by @cpegeric in #22119
• fix create pitr if exists by @iamlinjunhong in #22132
• fix force gckp for main by @XuPeng-SH in #22145
• make internal sql executor support prepared statement by @zhangxu19830126 in #22136
• testutil: use testing.T.TempDir in NewFS by @reusee in #22128
• create database/table with shallow copy and replace the insert into select in the restore statement. by @gouhongshen in #22041
• enhance const fold pushdown by @Cabbage74 in #22152
• cleanup compact related code by @XuPeng-SH in #22160
• partitioned tables support index queries by @zhangxu19830126 in #22158
• Fix catalog gc by @LeftHandCold in #22169
• fix the logic TS missing when cloning tables across accounts. by @gouhongshen in #22162
• Refactor the alter implementation to better support non-copying scenarios. by @aptend in #22155
• ivfflat search better error handling by @cpegeric in #22138
• Bytes with atomic reference counter not guarantee to deallocate memory and memory still accessible even memory w...

MatrixOne-v2.2.2-hotfix-20250822

Release date: Aug 22 2025
MatrixOne version: v2.2.2-hotfix-20250822

Bugfix

Fix SEMI join: don't skip probe when runtime filter fails
Fix cn panic as context deadline not set

What's Changed

• [fix] SEMI join: don't skip probe when runtime filter fails (2.2-dev) by @aunjgr in #22359
• fix context deadline not set by @jiangxinmeng1 in #22370
• fix cdc_scanner by @jiangxinmeng1 in #22376
• fix cdc sinker and handle new table by @jiangxinmeng1 in #22390

Full Changelog: v2.2.2-hotfix-20250817...v2.2.2-hotfix-20250822

MatrixOne-v2.2.2-hotfix-20250817

Release date: Aug 17 2025
MatrixOne version: v2.2.2-hotfix-20250817

Bugfix

Fix fuzzyfilter

What's Changed

• rm tag 8848(2.2-dev) by @Ariznawlll in #22236
• Fix fuzzyfilter 2.2 by @XuPeng-SH in #22353

Full Changelog: v2.2.2-hotfix-20250731...v2.2.2-hotfix-20250817

MatrixOne-v1.2.2-yidao-hotfix-20250816

Release date: Aug 16 2025
MatrixOne version: v1.2.2-yidao-hotfix-20250816

Bugfix

Fix semi join

What's Changed

• to 1.2.2-yidao: Fix semi join by @gouhongshen in #22345

Full Changelog: v1.2.2-yidao...v1.2.2-yidao-hotfix-20250816

MatrixOne-v2.2.2-hotfix-20250731

Release date: July 31 2025
MatrixOne version: v2.2.2-hotfix-20250731

MatrixOne v2.2.2-hotfix-20250731 introduces bug fixes. Below are the major updates.

Bugfix

Fix ON UPDATE for INSERT ON DUPLICATE UPDATE
Fix union all select fulltext

What's Changed

• Modify S3 write operations to use off-heap memory batches 2.2 by @aptend in #22271
• trigger ON UPDATE for INSERT ON DUPLICATE UPDATE 2.2-dev by @aunjgr in #22265
• fix union all select fulltext by @iamlinjunhong in #22276

Full Changelog: v2.2.2-hotfix-20250725...v2.2.2-hotfix-20250731

MatrixOne-v2.2.2-hotfix-20250725

Release date: July 25 2025
MatrixOne version: v2.2.2-hotfix-20250725

MatrixOne v2.2.2-hotfix-20250725 introduces bug fixes. Below are the major updates.

Bugfix

Fix cdc sync timing
Fix cdc json

What's Changed

• not lock insert select table by @iamlinjunhong in #22154
• bug fix:can not create database in some case (#22164) by @ouyuanning in #22183
• Fix replay mpool leak by @LeftHandCold in #22184
• Fix cdc json 2.2 by @XuPeng-SH in #22205
• Remove try gc during replay by @LeftHandCold in #22210
• for 2.2: cdc sync timing by @Cabbage74 in #22212

Full Changelog: v2.2.2...v2.2.2-hotfix-20250725

MatrixOne-v2.2.2

Release date: July 17 2025
MatrixOne version: v2.2.2

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

Key Improvements

1. CDC support frequency

Bugfix

Optimize memory issues
Fix any value for json
Fix gc mpool leak
Fix force gckp

What's Changed

• Fix any value for json by @XuPeng-SH in #22109
• Cdc for 2.2 by @Cabbage74 in #22113
• Open commit inject logging by @XuPeng-SH in #22116
• bugfixes cherrypick to 2.2-dev by @aunjgr in #22111
• clean log and open debug for commit by @XuPeng-SH in #22123
• workaround txn commit failed but tn handled by @iamlinjunhong in #22140
• fix gc mpool leak by @LeftHandCold in #22146
• fix force gckp by @XuPeng-SH in #22143
• to 2.2: fix prints by @gouhongshen in #22134
• Revert 22092 changes in 2.2-dev due to oom by @XuPeng-SH in #22157

Full Changelog: v2.2.1...v2.2.2

MatrixOne-v2.2.1

Release date: July 03 2025
MatrixOne version: v2.2.1

MatrixOne 2.2.1 introduces a series of bug fixes that enhance system performance, stability, and usability. Below are the major updates.

Bugfix

Optimize memory issues
Fix shuffle join for recursive cte
Fix error checking in rpc handler
Fix create index with keywords
Fix lock hung

What's Changed

• [fix] put non-PK runtime filter in Filter operator by @aunjgr in #22026
• fix merge log by @aptend in #22029
• fix lock hung and remove big log lock by @iamlinjunhong in #22031
• [taskservice] bug: add Created condition when filter tasks by @volgariver6 in #22040
• fix create index with keywords by @iamlinjunhong in #22036
• remove some debug log for gc by @LeftHandCold in #22018
• reduce memory usage and IO in DML plan with vector index by @aunjgr in #22044
• enable CHAR_LENGTH to accept TEXT by @aunjgr in #22051
• [fix] don't use index if it has all PK columns by @aunjgr in #22054
• fix shuffle join for recursive cte by @iamlinjunhong in #22056
• disable pushdown limit for 2.2-dev by @cpegeric in #22065
• fix varchar length bump check by @aptend in #22067
• fix error checking in rpc handler 2.2 by @aptend in #22071
• to 2.2: fix transfer tombstone failed when drop pitr bvt. by @gouhongshen in #22072
• to 2.2: remove some prints. by @gouhongshen in #22077
• bump 2.2 release date by @aptend in #22083
• to 2.2: fix failed BVT cases. by @gouhongshen in #22095

Full Changelog: v2.2.0...v2.2.1

MatrixOne-v1.2.2-yidao

Release date: July 09 2025
MatrixOne version: v1.2.2-yidao

Bugfix

Fix shuffle join for recursive cte

What's Changed

• fix shuffle join for recursive cte by @iamlinjunhong in #22055

Full Changelog: v1.2.2-20240715...v1.2.2-yidao

MatrixOne-v2.2.0

Release date: June 18, 2025
MatrixOne version: v2.2.0

MatrixOne 2.2.0 introduces a series of bug fixes that enhance system performance, stability, and usability. Below are the major updates.

Bugfix

Fix cdc bug
Fix the bug of enum
Fix duplicate pk due to big delete
Fix rollup with having by
Fix join order for DML plan

What's Changed

• sync verfied 2.0 merge changes to 2.1 by @aptend in #21528
• modify mergify config to adapt 2.1-dev by @guguducken in #21536
• improve the performance of cleaning up the deleted table stats from the stats table. by @gouhongshen in #21541
• fix: ignore some test in prepare.test by @huby2358 in #21545
• fix read ckp meta by @jiangxinmeng1 in #21548
• malloc: fix VSS leaks by @reusee in #21543
• Small refactor ckp by @XuPeng-SH in #21559
• fix potential memory leak by @XuPeng-SH in #21563
• fix the prepare.test BVT case. by @gouhongshen in #21568
• fix timeout - main by @XuPeng-SH in #21571
• spherical kmeans for sparse vector and bug fix by @cpegeric in #21529
• fix adding incorrect delete entris to partition state index by @aptend in #21558
• fix: AnalyzeExecPlan bug which cause sysbench10w update panic by @huby2358 in #21549
• Fix get snapshot "file not found" error by @LeftHandCold in #21581
• Unify the snapshot read and latest read-1 by @triump2020 in #21441
• [improvement] logservice: add some logs in truncation of logservice. by @volgariver6 in #21583
• fix change handle by @jiangxinmeng1 in #21579
• add wasm support for merge mo-ctl by @aptend in #21586
• [opt] merge multiple filters on primary key by @aunjgr in #21593
• Fix workspace delete - main by @XuPeng-SH in #21597
• fix an invalid memory access by @aunjgr in #21600
• fix wasm dir to avoid grep check by @aptend in #21604
• Fix collectObjects for updateTableInfo by @LeftHandCold in #21612
• fix data race by @jiangxinmeng1 in #21544
• vector array remove unncessary cast from []float32 to []float64. by @cpegeric in #21576
• update ckp cluster column by @jiangxinmeng1 in #21613
• Fix cdc issues main by @XuPeng-SH in #21625
• merge small insert/delete bat to full batch in workspace. by @gouhongshen in #21587
• Fix the bug of enum.Formt missing value by @LeftHandCold in #21628
• Fix cdc ddl error by @LeftHandCold in #21631
• refactor cn s3 writer. by @gouhongshen in #21522
• fix bug: panic in replace statement by @ouyuanning in #21633
• update CDC change handle by @jiangxinmeng1 in #21636
• better expr print for debug by @XuPeng-SH in #21642
• fix bug: prefix_in not sorted in prepare stmt by @ouyuanning in #21643
• fix the TestRemoveRunningTaskNotExists. by @gouhongshen in #21646
• fix TestGlobalCheckpoint7 by @jiangxinmeng1 in #21648
• reduce goroutines used calculating stats by @XuPeng-SH in #21650
• fix bug: dot not upgrade BM25 by @ouyuanning in #21661
• update cdc sinker and changes handle by @jiangxinmeng1 in #21665
• fix the object sort key index mismatch when CN flush objects. by @gouhongshen in #21660
• [opt] convert BETWEEN filter to PREFIX_BETWEEN on composite keys by @aunjgr in #21673
• [fix] properly handle sing-column CLUSTER BY by @aunjgr in #21671
• fix checkpoint UT by @jiangxinmeng1 in #21675
• Fix TestKill data race by @LeftHandCold in #21683
• merge small insert batch into full batch in the workspace. by @gouhongshen in #21639
• fix collect softdelete objects in TN by @XuPeng-SH in #21688
• fix abort mark active txn by @iamlinjunhong in #21692
• fix CN OOM by S3Writer in big data test. by @gouhongshen in #21694
• [Refactoring]: IVFFLAT better error handling by @cpegeric in #21621
• fix dynamic rpath error for darwin by @guguducken in #21697
• fileservice: delete temp files if write error by @reusee in #21662
• fix mergeTxnWorkspaceLocked by @jiangxinmeng1 in #21705
• add check local timeout txn by @iamlinjunhong in #21703
• BVT cases for the replace statements in the workspace. by @gouhongshen in #21707
• fix TestAppend2 by @jiangxinmeng1 in #21717
• fix bug: agg push down panic by @ouyuanning in #21709
• fix ExportStats by @jiangxinmeng1 in #21719
• use variables ORIGIN instead of absolute paths by @guguducken in #21710
• Fix TestCkpLeak (#21572) by @LeftHandCold in #21723
• add debug log by @jiangxinmeng1 in #21724
• fix the compaction of objects by deletion when merging the TXN workspace. by @gouhongshen in #21727
• Fix TestPitrMeta by @LeftHandCold in #21635
• fix merge alloc by @aptend in #21731
• Fix data race in TestDoHeartbeatInvalidTask by @Cabbage74 in #21735
• [opt] improve join order and enable runtime filter for fulltext UPDATE by @aunjgr in #21733
• Fix the block filter not work when where sortKey = ''. by @gouhongshen in #21741
• add debug log by @jiangxinmeng1 in #21745
• feat: alter user lock by @ouyuanning in #21737
• Fix the file service not found error when CN flushes objects. by @gouhongshen in #21746
• Improve the performance of the apply deletes in the workspace writes. by @gouhongshen in #21627
• fix the duplicated entry issue caused by merging deletion on the uncommitted objects. by @gouhongshen in #21753
• refactor some cdc code - phase 1 by @XuPeng-SH in #21656
• fix duplicate pk due to big delete by @XuPeng-SH in #21757
• [#21676]revert commid 6fbbd by @triump2020 in #21749
• Fix cdc mo to mo invalid connection by @LeftHandCold in #21755
• chore: remove bvt test tag #14293 by @xzxiong in #21752
• retry when remote lock i/o timeout by @iamlinjunhong in #21761
• Fix mo_cdc_task does not exist by @LeftHandCold in #21765
• small updates for the workspace. by @gouhongshen in #21766
• fix txn mistakenly aborted duo to deadlock by @iamlinjunhong in #21750
• remove bvt tag by @ouyuanning in #21770
• clean some code in the workspace. by @gouhongshen in #21725
• fix bug: panic in order by uuid column by @ouyuanning in #21775
• improve txn leak checker by @zhangxu19830126 in #21780
• Support changing the product name into OmniFabric by @Cabbage74 in #21777
• Remove the wrong sql by @Cabbage7...