Weekly update in TiDB

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

Added

• Add system tables for the upcoming RBAC feature
• Add the log_bin system variable
• Implement the skyline pruning optimization
• Add the FlushTiDBPlugin support
• Add the ShowCreateView support
• Support the NAME_CONST built-in function
• Add the SHOW CREATE USER support
• Support the ROW_NUMBER() window function
• Add an HTTP API to control whether the check is enabled when the inserted column data is 4-byte UTF-8 characters
• Support ALTER TABLE ALGORITHM = INPLACE/INSTANT

Improved

• Add the table ID into statistics of columns
• Improve the compatibility of RAND with MySQL
• Improve the compatibility of DDL errors with MySQL
• Control the number of rows returned by TopN/Sort in one chunk
• Support row framed window functions
• Control the number of rows returned by Limit in one chunk
• Change the cost formula for join reordering
• Handle Cancel properly for DDL jobs
• Push down the check condition to TiKV for the Prewrite request
• Refactor constant folding for IF/IFNULL
• Handle PARTITION BY RANGE COLUMNS for a single column
• Collect the Coprocessor runtime statistics for EXPLAIN ANALYZE

Fixed

• Get the correct SHOW CREATE TABLE result when adding an index
• Merge the statement buffer in BatchGetValues
• Show the correct port used by the TiDB server
• Fix the unique key constraint check for CREATE TABLE
• Make the value of tidb_force_priority consistent with the configuration value
• Fix a panic caused by the ORDER BY clause
• Fix a panic caused by the timestamp in range partition
• Check the unique key constraint for ALTER TABLE ADD INDEX on partitioned tables
• Fix a wrong default value for the timestamp in multiple time zones

Weekly update in TiSpark

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

Added

• Change the default spark.version to 2.3.3

Fixed

• Fix the issue of building key ranges with the XOR expression

Weekly update in TiKV and PD

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

Added

• Prewrite only when keys do not exist
• Support encryption for the data stored in the disk

Improved

• Bind the port lazily when it is configured
• Make the batch strategy fairer

New contributors (Thanks!)

tidb:

• aliiohs
• ltg001

tikv:

• JoeWrightss

docs-cn:

• ZhaoQi99
• pcqz