Weekly update in TiDB

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

Added

• Support the BENCHMARK() built-in function
• Add count metrics for statistics feedback indicating estimation inaccuracy
• Propose the design for skyline pruning
• Add the privilege check for querying View
• Add the privilege check for creating View
• Add metrics reflecting QPS at the database level
• Add benchmarks utilities for aggregation
• Add the JSON_QUOTE() built-in function

Improved

• Improve the compatibility of the error code with MySQL
• Improve the compatibility of the error message with MySQL
• Handle DNF expressions when computing selectivity
• Reduce the memory usage when inserting many rows in one transaction
• Refine the Explain output for Window functions
• Improve the compatibility of SHOW CREATE TABLE with MySQL
• Handle the enum type in the VALUES() built-in function
• Extract the Scalar function to a Projection operator for computing
• Make the batch gRPC strategy self-adaptable
• Improve the compatibility of DATA_ADD with MySQL

Fixed

• Fix the wrong result when converting “0000” to the year type
• Fix precision of default values of the time type
• Make the hach.String() function safe
• Handle errors when adding an index to a generated column
• Back off when the requested Region epoch is ahead of the Region meta returned from TiKV
• Fix the panic when the Equal condition of Join contains the Scalar function

Weekly update in TiSpark

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

Fixed

• Fix the reading data bug when using an index on the partition table

Weekly update in TiKV and PD

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

Added

• Add checked_add and check_sub Coprocessor pushdown functions
• Add the sub_duration_and_duration Coprocessor pushdown function
• Add code of conduct for contributors

Improved

• Enable auto compactions in the import mode

New contributors (Thanks!)

tidb:

• haplone
• overbool
• u5surf
• wuudjac

tikv:

• caohe

parser:

• eiantee

docs-cn:

• bigzuo