Weekly update in TiDB

Last week, we landed 30 PRs in the TiDB repositories.

Added

• Support BIT_AND/BIT_XOR in the new aggregation framework
• Support COUNT in the new aggregation framework
• Support AVG(DISTINCT) in the new aggregation framework
• Add the GENERATION_EXPRESSION column in information_schema.columns
• Support more syntactic rules regarding the SET syntax
• Support ADMIN SHOW DDL JOBS <NUMBER> to specify the lines of the results
• Support showing AUTO_INCREMENT in information_schema.tables

Fixed

• Fix a bug in INSERT SELECT FROM ON DUPLICATE KEY UPDATE
• Fix the numeric type overflow in the binary protocol
• Fix the results of decimal Minus/Round/Mul

Improved

• Check the schema when the DDL fails
• Refine the explain result format
• Speed up autoAnalyze when data is unchanged

Weekly update in TiKV and PD

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

Added

• Add new builtin UDFs regexp and regexp_binary
• Introduce the loose channel
• Add options to disable replica-checker features
• Support filtering JSON output by calling the external jq

Fixed

• Fix the unexpected behavior of tikv-ctl unsafe-recover command

Improved

• Report approximate_keys instead of approximate_rows
• Add TiKV adopters and Roadmap
• Update rustc and clippy

New contributor (Thanks!)

docs: brunoban