2017-01-08-tidb-weekly.md

title	date	summary	tags
Weekly update (January 02 ~ January 08, 2017)	2017-01-08	Last week, we landed 38 PRs in the TiDB repositories and 15 PRs in the TiKV repositories.	TiDB TiKV

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.