Weekly update in TiDB

Last week, we landed 47 PRs in the TiDB repository.

Added

• Propose the design for the SQL plan management
• Support the interactive_timeout system variable
• Add a batch commit session variable for large transactions

Improved

• Print the error log if the transaction state is unexpected when calling Commit
• Raise an error or warning for unsupported isolation levels
• Support ALTER TABLE TRUNCATE PARTITION
• Support altering the character set to utf8 or utf8mb4

Fixed

• Make the join reorder solver stateless
• Fix the unexpected data truncation error when the plan cache is enabled
• Do not build dual for AntiSemiJoin when the condition is constant false
• Fix the wrong result when the client uses comStmtSendLongData
• Fix the optimizer failure for generating a plan when the TIDB_SMJ hint is specified
• Fix the wrong result caused by the abs function pushdown
• Fix the panic when adding an index of the generated column
• Preserve the precision information of timestamp columns in the plan cache
• Fix data race caused by the flag of JSON columns
• Move some session variables to the statement context for the correct retry

Weekly update in TiSpark

Last week, we landed 2 PRs in the TiSpark repository.

Added

• Support the desc table command

Fixed

• Fix the issue that ScanIterator fails to read from adjacent empty Regions

Weekly update in TiKV and PD

Last week, we landed 36 PRs in the TiKV and PD repositories.

Added

• Add rpad and rpad_binary built-in functions
• Add year_week_with_mode and year_week_without_mode built-in functions

Improved

• Change the default PD node name to pd-{hostname}
• Fix the redundant header when PD sends commands to TiKV
• Check and report undefined PD configuration items

Fixed

• Set retryable instead of the abort error when TiKV exits
• Fix the issue that PD RaftCluster cannot be stopped
• Fix a bug about Region merge when the Raftstore thread is very slow

New contributors (Thanks!)

tikv:

• AbnerDBFan

parser:

• feloxx
• haplone