Weekly update in TiDB

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

Added

• Add the ALLOW_INVALID_DATES SQL mode support
• Support the PARTITION syntax for selecting partition tables
• Support the aggregate window function without the frame in the executor
• Support SHOW CREATE TABLE for View
• Support the OR REPLACE syntax for CREATE VIEW
• Support restoring deleted tables

Improved

• Improve error messages for MySQL compatibility
• Cut the scan range by Region before sending requests to TiKV
• Handle the optimizer hint properly for Cartesian Join
• Enable the plugin framework in TiDB
• Support the Window function with the frame in the planner
• Send gRPC messages to TiKV in batch
• Disallow ALTER TABLE on View
• Use constraint propagation in partition pruning
• Print the column character set in SHOW CREATE TABLE
• Return an error when INSERT/UPDATE/ANALYZE/DELETE a View
• Modify the max length limit of the VARCHAR type
• Support the reverse raw scan on TiKV
• Build a new histogram using range information

Fixed

• Fix a false negative result of ADMIN CHECK TABLE
• Make the statistics worker recover from the panic correctly
• Fix a wrong result of MergeJoin
• Fix a panic caused by parsing the CSV input
• Fix an incorrect behavior under the NO_ZERO_DATE SQL mode

Weekly update in TiSpark

Last week, we landed 1 PR in the TiSpark repository.

Fixed

• Fix the possible null version in pom

Weekly update in TiKV and PD

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

Added

• Add the add_time_duration_null Coprocessor pushdown function
• Verify the TiDB range in Coprocessor Endpoint
• Add multi-thread RaftStore

Improved

• Pass db options to ldb in tikv-ctl

Fixed

• Fix the potential nil panic in the AdjacentRegion scheduler after PD leader is changed
• Fix the month_name Coprocessor pushdown function
• Fix the epollex error on MacOS

New contributors (Thanks!)

tidb:

• ariesdevil
• kamijin-fanta

tikv:

• JaySon-Huang
• ariesdevil

tispark:

• ariesdevil

parser:

• GunaYX
• cgcgbcbc