matrixone Releases

v2.0.3

2025-04-03 15:47

MatrixOne-v2.0.3

Release date: March 12, 2025
MatrixOne version: v2.0.3

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

## Key Improvements
1. Support new time hint
2. Minor improve for loop join
3. Implement information_schema.table_constraints 
4. add flush in send prepare response
5. add txn status check

## Bugfix
1. Fix bugs related to oom
2. Resolve the issue of CN hanging during leak check
3. Fix some zm merge bugs
4. Fix bugs related to high-concurrency dropping table

## 更新内容
* Revert "Add recovery window (#21451)" (#21497)
* Add recovery window (#21451)
* mitigate zm merge (#21472)
* minor improve for loop join (#21464)
* Support new time hint (#21466)
* Fix various merge issues (#21467)
* fix memory limitation (#21449)
* fix small object merge (#21436)
* When prepared statement notice a schema change, it should automagical… (#21432)
* add flush in send prepare response && fix table_constraints (#21431)
*  Reduce the frequent calls to the String() method of objectName (#21429)
* fix oom (#21370)
* add txn status check 2.0 (#21385)
* chore: fix mologger reconnect mo in 2.0 (#21374)
* change threshold of realloc (#21376)
* fix bug: panic when drop table (#21357)
* if delete can't rewrite to truncate table, use bind_delete make new pl…
* add ut and fix logs (#21354)
* malloc: fix musl build (#21344)
* fix leak check hung to 2.0 (#21341)
* Fix bug: double free in Top Operator (#21338)

**完整的更新日志**: https://gitee.com/matrixorigin/matrixone/compare/v2.0.2...v2.0.3

Last committed message: Revert "Add recovery window (#21451)" (#21497)

v2.0.2

83164a1

2025-04-03 15:45

MatrixOne-v2.0.2

Release date: January 25, 2025
MatrixOne version: v2.0.2

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

## Key Improvements
1.	Point query performance optimization
2.	Replay implementation optimization to reduce TN restart time
3.	Support querying statistical information of subscribed tables
4.	ETLMerge optimization
5. Optimize logtail reconnection to minimize impact on CN operations and reduce CN downtime
6. Implement json_set

## Bugfix
1.	Fix bugs related to full-text indexing
2.	Resolve the issue of CN hanging during upgrades
3. Fix some operator-related bugs
4. Fix bugs related to high-concurrency DDL
5. Fix bugs in window functions

## 更新内容
* fix top container reset (#21208) (#21335)
* fileservice: return AWS region detection error in ObjectStorageArgume… (#21299)
* lower possibility of failure in receiving logtail 2.0 (#21323)
* bugfix: adjust mo_logger use server side max_allowed_packet config in …
* cleam remote txn when stop cn (#21321)
* fix TestCannotBusyLoopIfWriteCIsFull failed  to 2.0 (#21313)
* restore moerr code (#21309)
* Fix the bug that onBlockSelectedFn does not return error (#21306)
* fileservice: more logs for debugging EOF in Write (#21286)
* add log of stack for retry lock (#21287)
* support dump for vecf32 and vecf64(#2.0-dev) (#21282)
* fix txn client deadlock 2.0 (#21280)
* fix operator of partition (#21274)
* bug fix: Invalid search string converted to empty pattern to panic (#21275)
* fix mo_table_stats task panic and release mpool. (#21273)
* to 2.0: notify global stats when subscribed table. (#21263)
* Revert "malloc: default to malloc (#21211)" (#21262)
* malloc: fix macos build (#21250)
* to 2.0: skip to subscribe to the deleted table when calculating the mo…
* Fix Transient VPool leak (#21247)
* to 2.0: reduce the memory consumption by using pointer as btree item i…
* malloc: tune glibc malloc (#21239)
* [bug] stats: fix hang issue when get stats (#21234)
* fix data copy in replaying from checkpoint (#21232)
* fix TestReplay8 2.0 (#21200)
* fix the err missing when `GetChangedTableList`. (#21224)
* malloc: default to malloc (#21211)
* fix enum type parse stage(#2.0-dev) (#21216)
* fix unlock when version of bind changed (#21206)
* [improvement] proxy: add logs when connect/disconnect (#21190)
* [CherryPick]Fix bug for 21179 (#21191)
* fix a bug that cause panic in shuffle (#21178)
* restore upgrade tenant Code (#21184)
* fix disorder in reconnecting logtail 2.0 (#21175)
* Change the upgraded panic error to fatal (#21170)
* fulltext index bugs port from main to 2.0-dev  (#21139)
* improve catalog (#21166)
* to 2.0: fix partition state pinned by mo table stats and adding some m…
* If the schema version has reached the final version, mark and return (#21165)
* chore: add account filter-condition to speedup etlmerge check-exist  (#21155)
* optimize readers when there is false filter  (#21158)
* [Cherry-pick] use full db.table path in insert stmt (#21152)
* fix bvt (#21147)
* W zr patch 1 (#21142)
* [#21049] Fix-bug-cherry-pick (#21117)
* fix createdInTxn impl 2.0 (#21137)
* fix replay (#21128)
* fix bug: recall NewExpressionExecutor in prepare (#21120)
* fix merge  (#21119)
* fix need retry in engine 2.0 (#21053)

**完整的更新日志**: https://gitee.com/matrixorigin/matrixone/compare/v2.0.1...v2.0.2

Last committed message: fix top container reset (#21208) (#21335)

v2.0.1

25b06b2

2025-04-03 15:42

MatrixOne-v2.0.1

Release date: December 10, 2024
MatrixOne version: v2.0.1

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

## Key Improvements
* Index and Query Optimization
* Memory and Resource Optimization
* Password Management
* Backup and Restore Enhancements
* Experimental support for full text search

## Bugfix
This release addresses several critical bugs that improve the overall stability and reliability of the system. Some of the key bug fixes include:

- **Transaction Management**:
  - Fixed deadlocks and transaction state inconsistencies in distributed environments.
  - Resolved race conditions in transaction handling and session management.
  - Improved error handling for lock conflicts and concurrent delete operations.

- **SQL Execution**:
  - Fixed issues with recursive CTEs, view creation, and `ON DUPLICATE KEY UPDATE` statements.
  - Resolved problems with incorrect row counts and handling of compressed files during `LOAD DATA`.

- **Logtail and Cache**:
  - Addressed data race conditions and performance issues in logtail processing.
  - Fixed issues with cache usage and hit status monitoring.

- **Full-Text Index**:
  - Fixed panics related to full-text index creation and runtime filters.
  - Improved delete operations for tables with full-text indexes.

- **Backup and Restore**:
  - Fixed missing workspace data during the restore process.
  - Resolved errors when restoring tables or databases with special keywords or case-sensitive names.

- **Performance and Stability**:
  - Addressed memory allocation issues in batch processing and deduplication operations.
  - Resolved panics and race conditions in various modules, including query execution and system diagnostics.

Additionally, many other minor bug fixes were implemented to further enhance system reliability. For the full list of changes, refer to the  [What's Changed](#whats-changed).

## 更新内容
* fix restore view with lower case table names equals to 0(#2.0-dev) (#20668)
* delete unsubscribed account in mo_subs (#20676)
* use values stmt instead of union all stmt (#20675)
* fix hung due to deadlock to 2.0 (#20674)
* Optimize workspace dump (#20671)
* use force_update policy in `show table status` (#20658)
* prefetch table meta for slow ranges (#20648)
* fix use panic (#20625)
* fix init mo_table_stats cron task meta. (#20643)
* add debug log (#20627)
* to 2.0: switch the size getter of the show accounts to mo_table_size. (#20629)
* to 2.0: clean temporary files when `disttae.test` UTs are complete. (#20605)
* [bug] logtail: fix data race, a new worker send all requests (#20628)
* fix show index (#20635)
* to 2.0 "make in predicate null rejecting" (#20621)
* fix eating err (#20598)
* fileservice: in minio and qcloud sdk, do not load credentials from env…
* fix show table status of an empty db (#20601)
* to 2.0 "make index scan always tp" (#20587)
* fix checking database id in creating table (#20581)
* to 2.0: fix table stats task panic. (#20568)
* fix txn deadlock during drop account (#20579)
* fix binary execute record sql (#20553)
* [bug] fix the bug when get info from cgroup v1 (#20548)
* add case for sensitive restore(2.0-dev) (#20545)
* fix bug: insert/update sk get incorrect value (#20552)
* fileservice: close idle connections periodically (#20521)
* Add dataX bvt test,base:2.0-dev (#20517)
* Add tenxcloud bvt test,base:2.0-dev (#20525)
* fileservice: retry writes for small objects (#20511)
* fix busy loop in morpc if send queue is full to 2.0 (#20532)
* fix lower_case_table_names in view definition (#20524)
* fix wait done reporting error on 2.0-dev (#20518)
* fix double close atomic batch (#20515)
* use mo_table_rows/size in `show table status` (#20435)
* to 2.0"optimize index plan to support sysbench random ranges benchmark" (#20514)
* fix data race in ut (#20508)
* to 2.0 "reduce memory consumption in bvt shuffle test" (#20503)
* Analyzer adds FileService Cache read and hit statistics (#20451)
* fix bug: update secondary key panic (#20506)
* add backSes Exec lower_case_table_names(#2.0-dev) (#20494)
* remove panic in parsing txn entries (#20495)
* chore: cu price allows 0 in 2.0 (#20482)
* fix ut (#20478)
* quit cdc Start func when pause (#20385)
* fix txn wait active queue leak to 2.0 (#20474)
* [bug] add rpc read timeout for logtail client (#20472)
* fix data race in TestDelete3 (#20427)
* update code of relation exist check2.0 dev (#20454)
* fix hung due to range lock to 2.0 (#20452)

**完整的更新日志**: https://gitee.com/matrixorigin/matrixone/compare/v2.0.0...v2.0.1

Last committed message: fix restore view with lower case table names equals to 0(#2.0-dev) ...

v2.0.0

0bbda66

2025-04-03 15:39

MatrixOne-v2.0.0

We are excited to announce the release of MatrixOne v24.2.0.0!

MatrixOne is a hyper-converged, cloud-native database built for modern data demands. Designed to deliver high performance, scalability, and MySQL compatibility, MatrixOne provides a seamless HTAP (Hybrid Transactional/Analytical Processing) experience, allowing users to efficiently handle transactions, analytics, time-series data, and streaming processing in one unified platform.

## Highlights of this Release

MatrixOne v24.2.0.0 introduces significant enhancements for enterprise-level high availability, disaster recovery, and expanded AIGC support.
This version features robust improvements to support Generative AI applications, including unstructured data processing, full-text search, optimized vector search, and enhanced MySQL compatibility. Key features include external data access, snapshot backups, point-in-time recovery (PITR), CDC, and disaster recovery through log-based replication for primary-standby clusters. MatrixOne continues to evolve as a leading platform for intelligent, AI-driven data management, providing enterprises with the ideal solution for their data infrastructure needs.

## Use Cases

MatrixOne is well-suited for the following application scenarios. We welcome users facing similar challenges to reach out and explore a trial deployment with us.

#### **Generative AI Applications**

MatrixOne’s hyper-converged architecture is ideal for Generative AI, offering comprehensive support for multimodal data, real-time data retrieval, and intelligent data processing. In text and image generation scenarios, MatrixOne facilitates rapid response times and high-quality outputs through efficient data management, vector and hybrid search capabilities, data preprocessing with Python UDFs, and GPU-accelerated real-time inference. MatrixOne’s low-latency architecture supports Generative AI workloads like large-scale data storage, online inference, and adaptive feedback, empowering enterprises to drive innovation with speed and efficiency.

#### **Time-Series Data Applications**

Modern IoT ecosystems generate massive volumes of real-time data from diverse sources like industrial production lines, smart grids, and autonomous systems. MatrixOne is built to handle such demands with millisecond-level, high-concurrency writes and rapid, scalable data retrieval. MatrixOne’s real-time analytics seamlessly integrates with machine learning models, making it an ideal solution for predictive maintenance, energy optimization, and intelligent monitoring.

#### **Mixed Workload Scenarios**

Traditional single-node databases often struggle with the simultaneous processing demands of transactional and analytical workloads in enterprise applications like ERP, CRM, and OA systems. MatrixOne’s support for mixed workloads within a single database enables real-time analytics, continuous reporting, and efficient data-driven decision-making without the need for additional analytical databases or sharding. With MatrixOne’s scalability and high concurrency support, enterprises can confidently meet growing data demands while keeping performance at peak levels.

#### **Enterprise SaaS**

With the rise of enterprise SaaS applications, supporting multi-tenancy while ensuring cost-efficiency and data isolation is essential. MatrixOne’s native multi-tenant architecture provides load isolation, independent scaling, and unified management for each tenant. This architecture reduces management overhead, ensures data separation, and improves operational efficiency, making MatrixOne an optimal database choice for SaaS platforms.

## Key New Features

#### **Multi-mode Data Management**

MatrixOne now supports direct access to external object storage, remote file systems, and local storage through Stage objects, as well as datalink access to files in storage systems. This capability significantly simplifies data pipeline construction for Generative AI applications, reducing development overhead and maintenance costs.

#### **Full-text Indexing for Text and JSON Data**

Full-text indexing on JSON and TEXT columns greatly enhances performance in AIoT applications, especially when combined with MatrixOne’s JSON data type, which minimizes data redundancy and boosts efficiency.
  
#### **Vector Search**

Enhanced vector search capabilities now provide rapid, large-scale vector retrieval, a critical feature for Generative AI applications involving large language models (LLMs) and retrieval-augmented generation (RAG).

#### **Snapshot-based Backup and Recovery**

Cluster and tenant-level data snapshots capture the database state at specific points in time, ensuring rapid recovery while minimally impacting performance. Snapshots support cross-tenant restoration, bolstering MatrixOne’s disaster recovery.

#### **Primary-standby Log Replication for High Availability**

Log replication enables transaction log synchronization between primary and standby databases, supporting high availability and disaster recovery. Standby databases can take over in case of primary database failure, ensuring uninterrupted operations.

#### **Point-in-time Recovery (PITR)**

PITR captures all data changes post-snapshot, allowing precise restoration to a historical moment in case of accidental operations or data loss. This approach reduces storage costs, enhances recovery efficiency, and provides flexibility for critical business continuity and compliance.

#### **MatrixOne to MySQL CDC**

Change Data Capture (CDC) from MatrixOne to MySQL supports real-time disaster recovery for users transitioning from MySQL, maintaining data continuity.

#### **Table-level Publish-Subscribe**

Building on previous database-level publish/subscribe, table-level publish-subscribe in this release enables more granular control over data change synchronization, providing enhanced flexibility for data management.

## Additional Updates

#### **SQL Enhancements**

- Added support for `rename table`, `create pitr`, `drop pitr`, `alter pitr`, `restore pitr`, `show pitrs`.
- Optimized `show publications` and s`how subscriptions`.
- Enhanced `load data infile` command to support user-defined column order.

#### **Data Types**

- Support datalink data type
  
#### **Indexes and Constraints**

- Support Full-text Index

#### **Functions and Operators**

- Support JSON functions: `json_row`, `jq`, `try_jq`, `json_extract_string`, `json_extract_float64` functions.
- Enhanced date manipulation for `now()` function.
  
#### **Tools**

- mo-backup: Supports PiTR management.
- mo_cdc: supports CDC task management.
  
#### **MySQL Compatibility**

- Support Encode()/Decode() function

## Quick Start

Community users and enterprise developers can try MatrixOne with the following command:

```bash
docker pull matrixorigin/matrixone:2.0.0
```

For more details, including architectural insights, installation guides, and tutorials, visit our documentation site. Join our discussions or share feedback on GitHub or in our community WeChat group.

## Known Issues

- Standby clusters currently do not support synchronization of data in external tables or stages.
- Standby clusters support only cold backups and cannot be opened in read-only mode.
- CDC supports only table-level data synchronization.
- Snapshot backups support cluster and tenant levels, with restoration possible at the cluster, tenant, database, or table level.
- Snapshots and PiTR backups cannot recover deleted tenant data.

## 更新内容
* Cherry-pick-fix-19651 (#19705)
* adjust debug log (#19696)
* cp to 2.0 'fix a bug in shuffle which cause panic' (#19694)
* fix drop database without lock table (#19698)
* [bug] logtail/stats: do not unsubscribe table before it finished waited (#19682)
* fix hashbuild / shufflehashbuild / indexbuild / fuzzyfilter reset bug. (#19690)
* [#19649, #19664, #19408]Fix bugs (#19675)
* [cherry-pick-#19660] optimize the pointer allocation for built-in func…
* [Tech Request]: too much cost in perfcounter (#19656)
* fifocache: refine key hash func and optimize evict (#19521)
* add cpu porfile (#19603)
* Compile Reuse For Analyze Module reset (#19654)
* merge sqls generated by tail type changes (#19630)
* fix decimal output (#19633)
* Remove bvt tag 18547 (#19648)
* MergeOperator should get pipeline error if sender failed. (#19642)
* enable shuffle reuse for shuffle join (#19634)
* fileservice: make FileService.List returns iter.Seq2 (#19573)
* Resolve column null property setting errors error in alter (#19639)
* fix a bug will send nil error twice . (#19637)
* fix an expression bug for hashbuild operator. (#19572)
* Snapshot read should not use the List interface of fileservice (#19602)
* fix deleteTable panic due to incosistent partition states (#19644)
* fix a bug will cause hung if operator.Prepare-panic occurs. (#19636)
* inject log for delete table (#19622)
* fifocache: ensure Unlock/RUnlock will be called if panic occurs (#19615)
* fix changes handle (#19629)
* [enhancement] add metric for logservice health (#19632)
* Resolve the issue of missing deepCopy (#19624)
* Revert "refactor txnTable.DeleteByPhyAddrKeys" (#19623)
* refactor txnTable.DeleteByPhyAddrKeys (#19543)
* update the CN transfer in-mem and object tombstones. (#19528)
* fix database error (#19541)
* Recod lock operator wait lock time (#19582)
* fix data race (#19587)
* feat: table statement_info add cu column (#19576)
* [#19408] Fix bug (#19501)
* restore a code about retryable error (#19618)
* Revert "[enhancement] add metric for logservice health; fix a UT (#195…
* workaround 19123 (#19607)
* fix a runOnce() bug may cause query hung when error occurs. (#19600)
* [opt] : when restore, do not perform primary key de-duplication to min…
* fix timestamp setting in checkpoint replay (#19590)
* change the cap of spool-element to uint32 type. (#19604)
*  debug context deadline exceeded (#19361)
* Fold Prepare Parameter in EvalExpression (#19595)
* Supports password complexity authentication policies (#19594)
* optimize runtime filters by converting to composite primary key (#19593)
* prohibited restore database or table by cluster level account (#19489)
* [bug] proxy: close the connection with right method. (#19554)

**完整的更新日志**: https://gitee.com/matrixorigin/matrixone/compare/v1.2.4...v2.0.0

Last committed message: Cherry-pick-fix-19651 (#19705)

v1.2.4

f2dd397

2025-04-03 15:30

MatrixOne-v1.2.4

Release Date: September 23, 2024
MatrixOne Version: v1.2.4

This hotfix addresses several critical issues and includes minor improvements aimed at enhancing stability and performance.

## 更新内容
* cp to 1.2-dev 'fix the condition for runtime filters (#18496)' (#18860)
* fix json extract function(#1.2 hotfix) (#18849)
* cp to 1.2-dev 'fix ndv calculation to make it more accurate' (#18848)
* make query with limit run in single parallel (#18803)
* fix range checkpoint (#18799)
* [bug] proxy: session cannot be transferred after load data local infile (#18787)
* add support rollback running txn to 1.2 (#18775)
* remove the 1024bytes limit for group_concat result. (#18786)
* [tech] pprof: dump malloc profile (#18768)
* cp to 1.2-dev 'fix a bug that cause hashmap data wrong' (#18779)
* support order by limit optimization for non-sorted columns (#18760)
* [bug] proxy: fix panic when kill connection (#18756)
* fix KillRoutineConnections panic (#18726)
* Method for reading query results during upgrade modification (#18731)
* set srv.pu before creating hakeeper client (#18672)
* bug fix: unique key/secondary key get incorrect value (#18711) (#18717)
* fix GetOrCreateTxnWithMeta not get txn error (#18705)
* add summary for txnBlock(1.2-dev only) (#18691)

**完整的更新日志**: https://gitee.com/matrixorigin/matrixone/compare/v1.2.3...v1.2.4

Last committed message: cp to 1.2-dev 'fix the condition for runtime filters (#18496)' (#18...

v1.2.3

f01f07a

2025-04-03 15:24

MatrixOne-v1.2.3

Release Date: September 11, 2024
MatrixOne Version: v1.2.3

Compared to the previous version, v1.2.3 focuses on bug fixes, performance optimizations, and minor feature enhancements, without introducing major new features.

## Improvements

- Memory Optimization: Enhancements in memory usage, particularly for duplicate checks, SEMI Join, and TableScan operations.
- Enhanced Logging: Added logs for account restrictions, account suspensions, and additional operations, improving debugging and monitoring capabilities.
- Performance Enhancements: Optimized handling of LIMIT 0 queries, improved dynamic cache management, and refined query performance for JSON type ordering.

## Bug Fixes

This release addresses multiple issues related to memory usage, transaction handling, proxy connection stability, and more. These fixes improve the overall stability and reliability of MatrixOne.

## 更新内容
* mo-service: fix default cache configs (#18690)
* update CollectDeletesLocked (#18677)
* [bug] logtail: clear the tables in global stats when logtail re-connect (#18674)
* Dealing with duplicate S3 resource statistics issues (#18565)
* fileservice: re-implement memory cache with fifocache (#18584)
* increase the priority of existing txn (#18618)
* fileservice: optimize io merger (#18592)
* fix leak info & load hung (#18622)
* remove unnecessary log print (#18586)
* retry lock without lock table (#18610)
* [bug] proxy: session does not transfer after COM_STMT_CLOSE. (#18613)
* update github.com/parquet-go/parquet-go (#18609)
* Aggr statements with same error msg to keep error msg in 1.2-dev (#18588)
* fileservice: fix object storage semaphore (#18589)
* Upgrade panic bug 1.2 dev (#18529)
* Isolate IOAccessTime When Compile.runOnce (#18546)
* fileservice: log rc operations to help debugging (#18540)
* Io access time consumptionissue 1.2 dev (#18532)
* fileservice: also acquire semaphore in List and Write (#18522)
* remove restriction for top value optimization to 1.2-dev (#18504)
* to 1.2: adding object count metric for accounts (#18485)
* fix drop account error (#18500)
* fix ut TestManyRangeLockInManyGoroutines data race (#18477)
* Fix Ceiling(1.2-dev) (#18480)
* fix delete routine log (#18488)
* fix rename table(#1.2-dev) (#18459)
* fix suspend not effect (#18451)
* fileservice: release semaphore after reader close in objectStorageSema…
* fileservice, cnservice: dynamic cache size  (#18417)
* Fix snapshot refers (#18450)
* Fix Floor/Ceil/Round Decimal (1.2-dev) (#18405)
* add rename to table cases 1.2-dev (#18428)
* fileservice: disk cache fixes (#18409)
* [feature] proxy: broadcast upgrade statement to all cns (#18408)
* fileservice: do disk cache eviction after loading and before writing f…
* add uuid in tmp file to avoid dup filename (#18397)
* QueryService rpc api GOMAXPROCS and FileServiceCache in 1.2-dev (#18334)
* Split the Error generation function in `moerr` package (#18349)
* add case for group by(1.2-dev). (#18372)
* [#17318]CherryPick-fix bug for snapshot read (#18361)
* add bvt tag (#18369)
* add log for record affected rows when restore (#1.2-dev) (#18370)
* [fix] : remove meaningless panic of mpool.Alloc (#18329)
* add restore fk table case (#18342)
* change fs cache (#18344)
* return error to instead panic if orphan found (#18303)
* add case for restore pub-sub(1.2-dev) (#18317)
* rm tag 16709 (#18305)
* add if new lock added in lock result to 1.2 (#18310)
* refactor restore fk on 1.2-dev (#18314)

**完整的更新日志**: https://gitee.com/matrixorigin/matrixone/compare/v1.2.2...v1.2.3

Last committed message: mo-service: fix default cache configs (#18690)

v1.2.2

74f81f7

2024-08-13 12:18

MatrixOne-v1.2.2

Release date: July 12, 2024
MatrixOne version: v1.2.2

Compared with the previous v1.2.1, v1.2.2 doesn't introduce new features but only focuses on bug fixes and minor optimizations.

## Improvements
* Support `GROUP BY 1`, `MAKEDATE`
* Add runtime metrics
* Support reload auto increment cache
* Allow loading file info asynchronously for the disk cache
* Optimize flush and merge

## Bugfix
Fixed bugs related to partition state, proxy, MySQL compatibility, lockservice, stats, and merge memory control. Check the [What's Changed](##What's) section for details.

## What's Changed
* [fix] remove unnecessary values from the second parameter of prefix_in (cp #17111 to 1.2) by @aunjgr in https://github.com/matrixorigin/matrixone/pull/17186
* Add CoreDump when CachedData is nil by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/17219
* memorycache: do not allow nil Data by @reusee in https://github.com/matrixorigin/matrixone/pull/17222
* [bug] proxy: fix the connection id when send request to cn server. by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/17228
* fix unlock fatal when tn restart by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/17237
* fix always return illegal state error on special connection to 1.2 by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/17251
* cherry-pick stats related fix into 1.2-dev by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/17260
* cp 17265 into 1.2-dev by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/17268
* support last_day and makedate (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/17277
* add debug info for remap error by @daviszhen in https://github.com/matrixorigin/matrixone/pull/17256
* cherry-pick: remove compilectx by @daviszhen in https://github.com/matrixorigin/matrixone/pull/17257
* fix show create External table-1.2-dev by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/17172
* Fix show columns compatibility issues1.2 dev by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/17199
* fix bvt test(#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/17284
* cherry-pick to 1.2-dev 'fix a bug that cause wrong parallelism for tpch' by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/17297
* cherry-pick runtime metrics changes by @reusee in https://github.com/matrixorigin/matrixone/pull/17272
* Fix set global var do not work cross cns by @ck89119 in https://github.com/matrixorigin/matrixone/pull/17273
* Cherry-pick-fix-bugs[Dup/WW/Data-corruption] by @triump2020 in https://github.com/matrixorigin/matrixone/pull/17312
* When DDL statement has been executed within a transaction, force the use of a single CN by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/17282
* fix dual by @daviszhen in https://github.com/matrixorigin/matrixone/pull/17279
* cherry-pick to 1.2-dev 'fix a bug that cause tpch performance regression ' by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/17315
* retry lock when cn down by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/17320
* Cherry pick- fix-snapshot-read-bug[txn is stale: timestamp is too small] (#17271) by @triump2020 in https://github.com/matrixorigin/matrixone/pull/17306
* fix data race when get deltaloc on 1.2-dev by @w-zr in https://github.com/matrixorigin/matrixone/pull/17319
* Merge delta loc 1.2 dev by @w-zr in https://github.com/matrixorigin/matrixone/pull/17328
* fix enum type op in one transaction (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/17285
* [pick to 1.2] fix a bug that process's cancel not match to its context by @m-schen in https://github.com/matrixorigin/matrixone/pull/17349
* Fix Location's Extend is 0 when call UpdateTableStats for 1.2 by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/17346
* fix makedate and lastday func(#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/17343
* fileservice: use wrapped standard retryer in AWS sdk (#17250) by @reusee in https://github.com/matrixorigin/matrixone/pull/17267
* update delete by deltaloc by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/17246
* [enhancement] stats: reduce the parallel goroutines to update stats by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/17342
* [bug] stats: fix hang issue by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/17364
* fix cannot restart lockservice by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/17371
* support reload auto increment cache to 1.2 by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/17369
* only create buffer when err is nil by @w-zr in https://github.com/matrixorigin/matrixone/pull/17373
* fileservice: allow loading file infos asynchronously in disk cache by @reusee in https://github.com/matrixorigin/matrixone/pull/17360
* Expansion 1.2.2 Upgrade Package by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/17383
* cp to 1.2-dev "release unused memory in shuffleRange" by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/17386
* add clean commit state log by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/17390
* cp to 1.2-dev "don't calculate stats for limit 0 query" by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/17400
* [enhancement] proxy: remove error logs caused by hearteabt of LB. by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/17401
* [enhancement] stats: add factor to update worker number. by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/17410
* [enhancement] stats: do not update the same key at the same time. by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/17422
* fileservice: set finalizer on read closer to avoid potential leaks by @reusee in https://github.com/matrixorigin/matrixone/pull/17398
* fix change morpc backend state to 1.2 by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/17432
* metric: fix typo and register fsWriteCounter by @reusee in https://github.com/matrixorigin/matrixone/pull/17434
* cherry-pick some fileservice changes from main branch by @reusee in https://github.com/matrixorigin/matrixone/pull/17429
* using process memory usage for background task memory throttle 1.2 by @aptend in https://github.com/matrixorigin/matrixone/pull/17436
* [Cherry-pick] Alter table add column with lower_case_table_names = 0 by @ck89119 in https://github.com/matrixorigin/matrixone/pull/17407
* [plan] support "GROUP BY 1" (cp to 1.2) by @aunjgr in https://github.com/matrixorigin/matrixone/pull/17424
* 1.2 optimize flush and merge prints by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/17437
* [fix] don't push LIMIT clause to index table if main table has filters by @aunjgr in https://github.com/matrixorigin/matrixone/pull/17446
* fix ut Test_saveQueryResultMeta panic by @CJKkkk-315 in https://github.com/matrixorigin/matrixone/pull/17450
* Fix GC MaxConsumed For Backup by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/17464
* remove an info-level log. by @m-schen in https://github.com/matrixorigin/matrixone/pull/17461
* The global checkpoint only collects the node of the last deltaLoc  by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/17440
* Add bvt by @ck89119 in https://github.com/matrixorigin/matrixone/pull/17457
* Fix TestSnapshotMeta data race&failed for 1.2 by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/17460
* sort objects in ascending order by @w-zr in https://github.com/matrixorigin/matrixone/pull/17454
* Fix merge mem contro 1.2 by @aptend in https://github.com/matrixorigin/matrixone/pull/17479
* [enhancement] add concurrency when fetch objects of table by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/17449
* fix makedate and last_day func (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/17473

**完整的更新日志**: https://gitee.com/matrixorigin/matrixone/compare/v1.2.1...v1.2.2

Last committed message: fix makedate and last_day func (#1.2-dev) (#17473)

v1.2.1

27b34c6

2024-07-11 10:55

MatrixOne-v1.2.1

Release date: June 30, 2024
MatrixOne version: v1.2.1

Compared with the previous v1.2.0, v1.2.1 doesn't introduce new features but only focuses on bug fixes and minor optimizations.

## Improvements

*  Memory cache supports multiple memory allocators.
*  Optimize the performance of `show accounts`.
*  Optimize observability metrics for fileservice.
*  Support incremental backup.
*  Optimize TCP packet estimation.
*  Refactor mologging.
*  Support restoration of system tables.
*  Support manual merge based on zonemap.

## Bugfix

Fixed bugs related to snapshot reads, MySQL compatibility, lockservice, runtime filters, and system table upgrades. Check the [What's Changed](##What's) section for details.

## What's Changed
* fix query result by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16266
* fix restore partition table (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16256
* pick #16245 to 1.2 : reduce agg context memory usage. by @m-schen in https://github.com/matrixorigin/matrixone/pull/16253
* sync to 1.2: optimize `show accounts` by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16241
* modify snapshot case syntax(1.2-dev) by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/16233
* fix visit tombstone, cherry-pick #16163 by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/16189
* add debug info & profile interval by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16223
* move some logic from compile to run (#15983) by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/16079
* Fix mo cloud-issue-3298 (#16254) by @triump2020 in https://github.com/matrixorigin/matrixone/pull/16281
* [fix] use runtime filter for multi-row prepared insert stmt (cherry-pick to 1.2-dev) by @aunjgr in https://github.com/matrixorigin/matrixone/pull/16261
* refactor tn handler 1.2 by @aptend in https://github.com/matrixorigin/matrixone/pull/16136
* Support not deleting the checkpoint referenced by the snapshot 1.2 by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/16128
* test restore fk table by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16259
* Extended version upgrade package (#16049) -1.2-dev by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/16271
* handle alter table add column issue (#16122) -1.2-dev by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/16267
* inc ref of new bind in restart cn by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/16294
* fix TestDedup2, cherry-pick #16301 by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/16302
* syn to 1.2: collecting `the mo_database, mo_tables, mo_columns` and cluster table size for non-sys account. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16287
* GC needs to be compatible with the earliest checkpoint for 1.2 by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/16305
* GC tombstone object (#16102) 1.2 by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/16238
* Refactor: change Chan of WaitRegister from *Batch to *Message(contains batch & error) by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/16263
* change keep_user_target_list_in_result default to 1 by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16234
* Improve sql usage 1.2 dev by @w-zr in https://github.com/matrixorigin/matrixone/pull/16277
* fix 11250 on 1.2-dev by @w-zr in https://github.com/matrixorigin/matrixone/pull/16327
* pick 16239 and 16248 to 1.2-dev by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/16257
* convert dup error if txn is orphan to 1.2 by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/16334
* fix TestRemovedCronTask panic on 1.2-dev by @w-zr in https://github.com/matrixorigin/matrixone/pull/16323
* fix restore view table (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16330
* fix can not connect to remote backend when down cn by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/16329
* fileservice: add i/o timeout as retryable error by @reusee in https://github.com/matrixorigin/matrixone/pull/16347
* add case for restore view(1.2-dev) by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/16335
* update save profile by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16356
* fix show create table with fk in other database (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16349
* add some recover logs by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/16363
* fix rollback create table by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/16369
* fix does not unlock deadlock txn by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/16382
* fileservice: more metrics for Read by @reusee in https://github.com/matrixorigin/matrixone/pull/16390
* rm tag 16311 16306 16297(1.2-dev) by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/16396
* sync to 1.2: remove the old fast ranges and update metrics by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16359
* fix force flush timeout by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/16381
* [bug] proxy: do not add to queue multi times when scaling CN by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/16388
* add txn id by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16395
* remove NullComputationWrapper by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16290
* [cherry-pick-16195] : remove lock op for secondary index by @jensenojs in https://github.com/matrixorigin/matrixone/pull/16409
* Fix GetByteSlice out range for 1.2 by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/16418
* Optimize the estimation of tcp packet num send back to client in mo1.2 by @xzxiong in https://github.com/matrixorigin/matrixone/pull/16412
* fix panic during merge on 1.2-dev by @w-zr in https://github.com/matrixorigin/matrixone/pull/16416
* [opt] merge filters on composite primary keys in plan (cp to 1.2-dev) by @aunjgr in https://github.com/matrixorigin/matrixone/pull/16406
* fix 15848, cherry-pick #16435 by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/16436
* sync to 1.2, re-pr: remove the old fast ranges and update metrics by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16444
* Fix fifocache evict for 1.2 by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/16451
* refactor mo logging for rawlog and statement_info in mo1.2 by @xzxiong in https://github.com/matrixorigin/matrixone/pull/16411
* [Cherry-pick] fix snapshot restore fk cross db by @ck89119 in https://github.com/matrixorigin/matrixone/pull/16454
* Optimize QueryResult decoupling from motrace in mo1.2 by @xzxiong in https://github.com/matrixorigin/matrixone/pull/16426
* cherry_pick-Supports Information_Schema `FILES` and is compatible with MySQL (#15… by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/16457
* [cherry-pick-16445] : use ctx instead of proc.ctx for rangesOnePart by @jensenojs in https://github.com/matrixorigin/matrixone/pull/16465
* Fix-RW-Conflict by @triump2020 in https://github.com/matrixorigin/matrixone/pull/16477
* fix txnid by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16458
* [cherry-pick-16424] : add log to track 16273 by @jensenojs in https://github.com/matrixorigin/matrixone/pull/16472
* chore: stable bvt/result_count.sql result check and enable load_data_LOCAL_infile case in mo1.2 by @xzxiong in https://github.com/matrixorigin/matrixone/pull/16478
* pick pr #16452 to 1.2-dev, fix a bug will cause hung if error happens. by @m-schen in https://github.com/matrixorigin/matrixone/pull/16453
* Support upgrading to skip Genesis version functionality-1.2-dev by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/16486
* delay Ranges for partitioned table-1.2-dev by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/16268
* fix stats misuse in some cases to 1.2-dev by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/16500
* [CherryPick] : Fix failed BVT query in Secondary Index (#16429) by @arjunsk in https://github.com/matrixorigin/matrixone/pull/16499
* add test for restore view table and fk table (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16432
* sync to 1.2: supporting reader linear search on unsorted fake pk col by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16461
* add hidden force option for objprune 1.2 by @aptend in https://github.com/matrixorigin/matrixone/pull/16514
* support restore system table  (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16462
* sync to 1.2: skip collecting `mo_tables, mo_databases, mo_columns` and cluster tables for non-sys. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16515
* chore: make sure no aggr in bvt result_count in 1.2 by @xzxiong in https://github.com/matrixorigin/matrixone/pull/16536
* remove log print from automaxprocs to 1.2-dev by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/16547
* malloc: fix log level by @reusee in https://github.com/matrixorigin/matrixone/pull/16509
* fix lock service ut by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/16518
* support merge objects by table id on 1.2-dev by @w-zr in https://github.com/matrixorigin/matrixone/pull/16520
* sync to 1.2: making collect dirty blocks lazily by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16527
* chore: refactor purge_log calling objprune if target_date + 24h <= now (mo1.2) by @xzxiong in https://github.com/matrixorigin/matrixone/pull/16550
* sync to 1.2: filter optimization of the loadDeletes by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16555
* [enhancement] logtail: change the default timeout of sending resp. by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/16561
* [enhancement] proxy: filter CNs that are not in working state. by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/16559
* metric: fix fileservice board by @reusee in https://github.com/matrixorigin/matrixone/pull/16554
* add issue 16178 cases by @heni02 in https://github.com/matrixorigin/matrixone/pull/16545
* fix drop publication if exists statement (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16464
* add case for restore system table(1.2-dev) by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/16481
* clean code by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16571
* rewrite 'insert ... on duplicate key update' to 'replace into' in some case by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/16568
* append log for upgrade and sqlExecutoer1.2 dev by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/16576
* Bvt if disable trace in 1.2 by @xzxiong in https://github.com/matrixorigin/matrixone/pull/16582
* pick #16523 to 1.2-dev by @m-schen in https://github.com/matrixorigin/matrixone/pull/16586
* add bvt tag(#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16590
* fix a remote run bug, rpc stream should be closed after pipeline cleanup. by @m-schen in https://github.com/matrixorigin/matrixone/pull/16588
* cherry-pick fix bvt test by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16579
* fix snapshot name ambiguous (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16580
* GC needs to consume all the mo_snapshot tables for 1.2 by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/16591
* [fix] : fix moc3399 by @jensenojs in https://github.com/matrixorigin/matrixone/pull/16594
* rmTag15901(1.2-dev) by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/16592
* remove log print from automaxprocs to 1.2-dev by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/16599
* fix convert string to timestamp by @ck89119 in https://github.com/matrixorigin/matrixone/pull/16621
* support restore publication db (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16488
* Fix condition to ignore delete booking if no transfer is needed on 1.2-dev by @w-zr in https://github.com/matrixorigin/matrixone/pull/16632
* [Cherry-pick] refactor system variables to support account isolation by @ck89119 in https://github.com/matrixorigin/matrixone/pull/16636
* add case for restore pub_sub(1.2-dev) by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/16603
* add debug info for panic by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16635
* Optimize logs by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/16647
* Support merge policy parameter 1.2 dev by @w-zr in https://github.com/matrixorigin/matrixone/pull/16669
* handle null in convertRowsIntoBatch by @ck89119 in https://github.com/matrixorigin/matrixone/pull/16675
* Fix enum type system variable check by @ck89119 in https://github.com/matrixorigin/matrixone/pull/16692
* [opt] merge filters on composite primary keys in plan (1.2-dev) by @aunjgr in https://github.com/matrixorigin/matrixone/pull/16693
* fix restore pub db (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16668
* sync to 1.2: block reader supports between filter by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16687
* cherry-pick HTTP client and DNS changes to 1.2-dev  by @reusee in https://github.com/matrixorigin/matrixone/pull/16718
* rmTag16601_16597(1.2-dev) by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/16703
* add global system variable and session variable account isolation cases by @heni02 in https://github.com/matrixorigin/matrixone/pull/16695
* Handle Cancel Restore Statement Fail by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/16736
* add issue 16613 cases by @heni02 in https://github.com/matrixorigin/matrixone/pull/16721
* skip stats for create view to 1.2-dev by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/16729
* change LIMIT, OFFSET's data type from int64 to uint64 by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16698
* make add txn error trace async by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/16758
* add issue 16139 cases by @heni02 in https://github.com/matrixorigin/matrixone/pull/16734
* add a code owner for 1.2 by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/16763
* sync to 1.2: refactor the block reader filter to support more expressions. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16755
* [bug] launch: fix timeout mechanism when TN service startup by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/16761
* fileservice: fix fd leak in LocalFS.read by @reusee in https://github.com/matrixorigin/matrixone/pull/16749
* [1.2-dev] fix: respsect filterFn in pluginRouter by @aylei in https://github.com/matrixorigin/matrixone/pull/16689
* handle Restore Duplicate Entry-1.2-dev by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/16743
* Cherry-pick-for-snapshot-read-bug by @triump2020 in https://github.com/matrixorigin/matrixone/pull/16777
* add cases by @heni02 in https://github.com/matrixorigin/matrixone/pull/16783
* [opt] retain IN expression in prepared stmt (cp to 1.2-dev) by @aunjgr in https://github.com/matrixorigin/matrixone/pull/16800
* sync to 1.2: workaround for get col type panic when constructing block reader filter. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16804
* do not rewrite on duplicate key stmt to replace for prepare by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/16793
* add case for issue3302(1.2-dev). by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/16792
* fix panic by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16776
* Refactor view scope execute-1.2-dev by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/16787
* Do not apply delete when aobject merge on 1.2 dev by @w-zr in https://github.com/matrixorigin/matrixone/pull/16789
* add SERVER_MORE_RESULTS_EXISTS judgment by @CJKkkk-315 in https://github.com/matrixorigin/matrixone/pull/16781
* [CherryPick]: Unhex/ Hex Feature Parity with MySQL by @arjunsk in https://github.com/matrixorigin/matrixone/pull/16809
* fix a bug about send notify message to remote node. by @m-schen in https://github.com/matrixorigin/matrixone/pull/16696
* rm tag 16710(1.2-dev) by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/16814
* add error to alloc by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16799
* add deug log by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/16820
* change some UnsafeGetStringAt to GetStringAt by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/16821
* add tag 16709(1.2-dev) by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/16818
* sync to 1.2: fix sysbench random points ranges slow by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16827
* [bug] clusterservice: add lock for refresh() to protect cn services. by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/16840
* add query result count by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16837
* [Cherry-pick] Refactor system variable lower_case_table_names by @ck89119 in https://github.com/matrixorigin/matrixone/pull/16823
* flush object dedup 1.2 by @aptend in https://github.com/matrixorigin/matrixone/pull/16860
* change stats update threshold from 1000 to blocknumber to 1.2-dev by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/16848
* Always push `isnull` to block filters to 1.2-dev by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/16852
* rollback the dedup filters to workaround an execution bug by @aunjgr in https://github.com/matrixorigin/matrixone/pull/16843
* fix validate timeout lock table by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/16862
* add tag 16709(1.2-dev). by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/16833
* [Cherry-pick] case insensitive sys db and table names by @ck89119 in https://github.com/matrixorigin/matrixone/pull/16863
* trace slow flush 1.2 by @aptend in https://github.com/matrixorigin/matrixone/pull/16876
* fix: check protocol quit before CalculateOutTrafficBytes in 1.2 by @xzxiong in https://github.com/matrixorigin/matrixone/pull/16865
* Cherry-pick-for-fix-dup-and-inconsistency by @triump2020 in https://github.com/matrixorigin/matrixone/pull/16874
* update debug log, print appendnodes by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/16890
* [Cherry-pick] support set sys var from toml file by @ck89119 in https://github.com/matrixorigin/matrixone/pull/16891
* Update txn print by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/16894
* fix dump panic(#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16903
* fileservice: refine disk cache error handling codes by @reusee in https://github.com/matrixorigin/matrixone/pull/16901
* print file name for sync error by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/16902
* constant fold for more expr(1.2) by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/16908
* fix show create table  (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16910
* fix show fk by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16914
* sync to 1.2: refactor in memory reader filter and simplify reader filters.  by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16915
* [enhancement] logtail: make table subscription async by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/16887
* change multi clone snapshot op in one op (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16813
* file service: tune http read write timeout by @reusee in https://github.com/matrixorigin/matrixone/pull/16896
* fix desc, show columns from by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16859
* fix memory related by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16920
* [fix]: Add log 3421 by @jensenojs in https://github.com/matrixorigin/matrixone/pull/16907
* Remove list checkpoint meta file (#16723) by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/16918
* Fix-OOM: CN will flush inserts into S3 when its count exceeds  thresholds by @triump2020 in https://github.com/matrixorigin/matrixone/pull/16921
* Fix Visit object meta by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/16927
* load columnlist  by @huby2358 in https://github.com/matrixorigin/matrixone/pull/16935
* fix slow flush 1.2 by @aptend in https://github.com/matrixorigin/matrixone/pull/16937
* add bvt test (#1.2-dev) by @YANGGMM in https://github.com/matrixorigin/matrixone/pull/16945
* change transfer page ttl from 90s to 60s by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/16952
* fix: load data in file with column list error by @huby2358 in https://github.com/matrixorigin/matrixone/pull/16949
* Modify the string of DECIMAL64/128/256 to match the acceptable string when parsing SQL by @CJKkkk-315 in https://github.com/matrixorigin/matrixone/pull/16911
* fix check invalid binds by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/16958
* malloc: port new allocator to 1.2 by @reusee in https://github.com/matrixorigin/matrixone/pull/16670
* sync to 1.2: adding TN deduplication latency metrics. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16934
* sync to 1.2: fix block reader filter case of `pk in () and xxx in ()`. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16961
* fix migrate txn leak & profile name by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16946
* [bug] trace: change the timeout from 30s to 5m by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/16973
* refactor the pipeline's remote run by @m-schen in https://github.com/matrixorigin/matrixone/pull/16923
* Fix Rebuild snapshot's table meta by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/16968
* [bug] txn: do not fatal if the waiter is paused when waiting for the ts. by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/16985
* clean batch  by @daviszhen in https://github.com/matrixorigin/matrixone/pull/16978
* fix truncate by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/16989
* Fix error refers to table meta by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/16998
* fix incorrect use of connection ctx during remote run. by @m-schen in https://github.com/matrixorigin/matrixone/pull/17002
* add log to debug lock table created multi times by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/17010
* fix a bug that caused the remote-run context to lose a deadline by @m-schen in https://github.com/matrixorigin/matrixone/pull/17017
* Refactor UnresolvedName by @ck89119 in https://github.com/matrixorigin/matrixone/pull/17000
* fix snapshot-read bug by @triump2020 in https://github.com/matrixorigin/matrixone/pull/17013
* remove an unnecessary code, modify a log level. by @m-schen in https://github.com/matrixorigin/matrixone/pull/17033
* retry allocate if orphan txn by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/17037
* adding log debug size() by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/17032
* [Cherry-pick] Fix nil pointer in RoutineManager.Closed() by @ck89119 in https://github.com/matrixorigin/matrixone/pull/17036
* adjust the timeout for orphan transactions by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/17045
* sync to 1.2: change all filter related "or" expr from binary function to multi function by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/16991
* add system, busy monitor, by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/17048
* [bug] filter out the CNs with different commit ID. by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/17004
* sync to 1.2: adding logic for prefix_in in case vector items are not unique by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/17042
* debug load local by @daviszhen in https://github.com/matrixorigin/matrixone/pull/17047
* enable & disable checkpoint by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/17043
* Fix a bug in some cases that @m-schen would not call RPC close in https://github.com/matrixorigin/matrixone/pull/17054
* cherry pick stats related fix to 1.2-dev by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/17052
* [bug] stats: fix the leak of goroutine by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/17072
* fix a remoterun bug never close connection. by @m-schen in https://github.com/matrixorigin/matrixone/pull/17079
* Fix memory leak for partition state by @triump2020 in https://github.com/matrixorigin/matrixone/pull/17068
* malloc, fileservice: port main branch changes to 1.2-dev by @reusee in https://github.com/matrixorigin/matrixone/pull/17065
* mo-service: data dir compatibility fixes by @reusee in https://github.com/matrixorigin/matrixone/pull/17063
* preallocate transfer page by @w-zr in https://github.com/matrixorigin/matrixone/pull/17058
* add a metric for the pipeline remote run. by @m-schen in https://github.com/matrixorigin/matrixone/pull/17085
* [enhancement] logtail: change the default send timeout, add logs by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/17060
* fix lock table move failed by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/17091
* Fix rightjoin.sendlast hung by @zengyan1 in https://github.com/matrixorigin/matrixone/pull/17038
* fix RPC metrics by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/17090
* Add handleDiskCleaner for mo_ctl by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/17083
* fix get role name of sys tables by @ck89119 in https://github.com/matrixorigin/matrixone/pull/17102
* fileservice: use noop retryer in aws sdk by @reusee in https://github.com/matrixorigin/matrixone/pull/17096
* [cherry-pick-16310]: mergeDelete on the hidden table should not update `affectedRows` by @jensenojs in https://github.com/matrixorigin/matrixone/pull/17117
* Fix `rightjoin.Free` hung by @zengyan1 in https://github.com/matrixorigin/matrixone/pull/17107
* fix delete page error and some typos by @w-zr in https://github.com/matrixorigin/matrixone/pull/17101
* cherrypick: fix ut failed about race by @daviszhen in https://github.com/matrixorigin/matrixone/pull/17108
* Init snapshot table must consume a global checkpoint by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/17120
* fix memory leak in flushAObjsForSnapshot by @w-zr in https://github.com/matrixorigin/matrixone/pull/17123
* fix can restart cn when tn crashes by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/17114
* Set transfer page limit 1.2 by @aptend in https://github.com/matrixorigin/matrixone/pull/17078
* add metric by @daviszhen in https://github.com/matrixorigin/matrixone/pull/17126
* Cherry pick fix[ ww/dup/datalost] bugs when unsubscribe table by @triump2020 in https://github.com/matrixorigin/matrixone/pull/17099
* Handle information schema tables issue 1.2 dev by @qingxinhome in https://github.com/matrixorigin/matrixone/pull/17119
* Fix ww/dup- caused by lost deletes  in rangesOnePart by @triump2020 in https://github.com/matrixorigin/matrixone/pull/17138
* sync to 1.2: in-memory reader filter workaround for special tables. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/17137
* sync to 1.2: fix `Size()` duplicate counting rows size. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/17147
* Fix panic by @triump2020 in https://github.com/matrixorigin/matrixone/pull/17162
* fileservice: make TLS handshake timeout retryable error by @reusee in https://github.com/matrixorigin/matrixone/pull/17170
* change metadata cache size and policy by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/17187
* cherry pick to 1.2-dev '[Bug]: random points qps in daily regression degrade from 20000+ to 7…' by @badboynt1 in https://github.com/matrixorigin/matrixone/pull/17191
* Fix dead lock  by @triump2020 in https://github.com/matrixorigin/matrixone/pull/17194
* Fix force merge big data bug&objectIO add object size limit by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/17196
* fix bug: do not throw error in remote run by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/17197
* 1.2 support compile service by @m-schen in https://github.com/matrixorigin/matrixone/pull/17209

**完整的更新日志**: https://gitee.com/matrixorigin/matrixone/compare/v1.2.0...v1.2.1

Last committed message: 1.2 support compile service (#17209)

matrixorigin/matrixone .gitee-modal { width: 500px !important; }

Search

matrixorigin/matrixone