LiHongjian

icon location Hangzhou, China

Results 17 comments of LiHongjian

feature: Supprot DELETE Statement

## Current industry status |Database types that support column storage|Whether delete is supported|remarks| |---|---|---| |MariaDB ColumnStore|Yes|| |SQL Server|Yes|| |Oracle In-Memory Column Store|Yes|| |MySQL HeatWave|No|It is mainly used as an auxiliary...

feature: Supprot DELETE Statement

## Summary of delete schemes for column storage |Database types that support column storage|Underlying storage structure|Delete policy| |---|---|---| |MariaDB ColumnStore|Fixed size data block + Metadata|Mark delete| |SQL Server|Column storage index...

feature: Supprot DELETE Statement

## Implementation flowchart of delete function of Tianmu engine

feature: Supprot DELETE Statement

- #451

bug: explain select straight_join DISTINCT.......The key and rows in the test result is incorrect

ACK

bug: explain select straight_join DISTINCT.......The key and rows in the test result is incorrect

If the key is empty, it means there is no index. It is normal There is a join buffer behind it, which indicates that it is a nested loop

feature: Support (Single-Table Syntax) DELETE FROM tb_name

>We now support single table truncate operation, so the scenario of single table delete all can reuse truncate operation

fix(tianmu): Fix errors in the Q4 (exists subquery) and Q16 query result (#330, #331)

Can this modification be verified by MTR with manually generated data? This also ensures that the correctness of the next modification can be verified.

bug: After upgrading from Stonedb5.7.100 to the Stonedb5.7.101 test version, the old data cannot be read

>I don't think it is necessary to be compatible with the data of the old version for the following reasons: Compatibility with the data of the old version requires the...

bug: After upgrading from Stonedb5.7.100 to the Stonedb5.7.101 test version, the old data cannot be read

## Upgrade scheme of mainstream database ### MySQL |Upgrade method|Applicable scenarios|Time required| |:---:|:---:|:---:| |Logical backup and restore (mysqldump)| When the data volume is small, this method usually does not failIt...