Weekly update in TiDB

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

Added

• Introduce a new executor to support SQL statements like GRANT roles TO users

Improved

• Refine the ErrEntryTooLarge error message
• Use the unified log format for the server package and the remaining packages
• Make tidb_disable_txn_auto_retry disable retry only for the write conflict
• Enhance the UTF-8 charset upgrade compatibility
• Add the HTTP status host
• Improve NULL count estimation for single-column indexes
• Add the audit plugin extension point

Fixed

• Fix the wrong result of group_concat for cases like select group_concat(123, null)
• Fix the wrong result of count(distinct) when the parameter of count(distinct) is decimal
• Fix the issue that converting decimal to datetime or timestamp is incompatible with MySQL in some cases
• Fix the issue that plugin errors make TiDB exit in some cases
• Fix the issue that results of unix_timestamp()-unix_timestamp(now()) are wrong and not stable
• Fix the issue that date_add and date_sub are incompatible with Mysql in some cases
• Fix the issue that an invalid YEAR string is incompatible with MySQL
• Fix the issue that TIME_FORMAT is incompatible with MySQL
• Fix a wrong limit of MaxInt64
• Fix a panic caused by a shallow copy of JSON
• Fix the issue that set time_zone is incompatible with MySQL
• Fix bugs when a window function meets Prepare in some cases
• Fix the issue that date_add and date_sub are incompatible with MySQL
• Set the correct return field type of the CONVERT() built-in function

Weekly update in TiSpark

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

Added

• Support ShowColumnsCommand

Improved

• Clean up the TiDAGRequest code

Weekly update in TiKV and PD

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

Added

• Add the batch index scan executor
• Add an API to clear tombstone stores
• Implement the is_ipv4_compat and is_ipv4_mapped coprocessor built-in functions

Fixed

• Fix a Region statistics bug caused by a typo
• Fix a store statistics bug caused by a typo
• Fix a bug of GetHotStores
• Fix a log truncation issue during the exiting process

New contributors (Thanks!)

tidb:

• Debiancc

tikv:

• myguyy
• seansu4you87
• xiaobogaga
• yaalsn

pd:

• bradyjoestar

parser:

• wuudjac