Weekly update in TiDB

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

Added

• Add nested loop join.

• Support the UNIX_TIMESTAMP built-in function.

• Support the INTERVAL built-in function.

• Support the FIND_IN_SET built-in function.

• Support the DATEDIFF built-in function.

• Enable pushing down IF expr to TiKV coprocessor

Fixed

• In prepared statement, limit and offset could be parameter marker.

• When creating table, index option could be a list.

• Fix a bug in creating table, some field length is missing.

• Fix a bug about parsing datetime overflow.

• Trim leading zeros before parsing int literal.

• Fix float truncate bug.

Improved

• Improve TiDB schema lease checker.

• Speed up alter table add index statement.

• Refactor system variable related code.

• Refactor built-in function, add function class and function signature: #2361, #2384, #2385, #2389, #2391, #2399, #2410

• Add unique key information into plan's schema, this will be used for plan optimizing.

• Fetch tso and compiling statement concurrently: reduce the latency of small transaction.

• Load data in a batch way: make it easier for loading large data.

• Extract a built-in function factory for date arithmetic operations.

New contributor

• idlesummerbreeze

Weekly update in TiKV

Last week, We landed 15 PRs in the TiKV repositories.

Added

• Support pre vote feature for raft.

• Schedule replicas according to the location of the stores.

• Coprocessor support if, IsNull, IfNull and NullIf.

Fixed

• Check cluseter ID to avoid PD joining different cluster.

Improved

• Return StoreNotMatch error when store ID doesn't match.

• Use upper bound for scanner.

• Unify logger to make the log format the same with TiDB/PD.