Weekly update in TiDB

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

Added

• Support the first_value and last_value window functions
• Change all the MySQL versions from 5.7.10 to 5.7.25
• Handle the default frame for window functions
• Support the show pump status and show drainer status statements

Improved

• Add a new logger to help log connID and recvTs
• Improve the str_to_date built-in function compatibility
• Refine the rollback logic of canceling modifying a column and adding and dropping a foreign key
• Convert SemiJoin to InnerJoin in more cases
• Control the chunk size for StreamAgg and HashAgg
• Refactor the code related to join reorder
• Validate fsp for datetime and timestamp if they are used as the default value
• Upgrade to Go 1.12
• Update ddl_slow_threshold

Fixed

• Fix the error message that the table does not exist in Inner Join
• Fix the git describe error in some cases
• Fix an unexpected error when using window functions and View
• Fix the error when setting variable=''
• Fix the issue that etcd clients lost connection with the PD cluster in some cases
• Quote the database name before running SQL statements
• Fix the issue that the behavior of aggregation in subqueries is incompatible with MySQL
• Fix the error occurred when canceling dropping a table or database in some cases
• Fix the issue that the outer table is chosen wrongly when both tables are specified in TIDB_INLJ

Weekly update in TiSpark

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

Improved

• Skip LockResolverTest when the PD client is not present

Weekly update in TiKV and PD

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

Added

• Introduce the VectorLike enum for the endpoint
• Add checks for the SSE4.2 support
• Add the communication section in README
• Implement sub_datetime_and_duration and sub_datetime_and_string
• Add functions to build batch executors

Improved

• Unify the log format in the Raftstore module
• Validate the scheduler name in the PD configuration
• Remove extern crate statements
• Remove message boxing and message unboxing
• Publish the important configuration to metrics
• Use the address instead of the store ID for metrics
• Make the heartbeat more reasonable in the simulator

Fixed

• Fix the issue that the low space store cannot be added in PD
• Fix several typos
  • #1451
  • #4305

New contributors (Thanks!)

tikv:

• wujunze

pd:

• blankstars

parser:

• sunxiaoguang