2017-10-30-tidb-weekly.md

title	Weekly update (October 23 ~ October 29, 2017)
date	2017-10-30
summary	Last two weeks, we landed 83 PRs in the TiDB repositories and 46 PRs in the TiKV repositories.
tags	TiDB TiKV TiSpark

Weekly update in TiDB

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

Added

• Support the window function syntax.

Fixed

• Fix an issue when the values builtin function meets the null value.
• Support the signed field option for the numeric type.
• Fix an issue of index reader.
• Fix an issue that the binlog client is not initialized correctly.
• Correct the schema type of ShowStmt.
• The default value length for Join should be changed for column pruning.
• Add retry for dialPumpClient.
• Parse but ignore the REPLICATION CLIENT/SLAVE, USAGE privileges in the GRANT statement.
• Fix an issue with visibility check.
• Fix an issue with renaming tables.
• Parse PARTITION BY RANGE COLUMNS.
• Support the straight_join syntax.
• Support the row_count built-in function.
• Load the column histograms as needed.
• Start safePointChecker before running a worker.
• Truncate the information field for show processlist and support show full processlist.

Improved

• Build the prepared statement plan in the Optimization phase.
• Support the ALTER TABLE t ENGINE = 'string' syntax.
• Remove reorgTableDeleteLimit.
• Fold the true item in the CNF predicator.
• Use max uint64 as the start timestamp for the ANALYZE statement .
• Improve merge join to support all join types.
• Add highlight to log.
• Add the Row interface.
• Simple improvement for range calculation for Primary Key.
• Change the behavior of the the in function.
• Support a plan cache for prepared statements.
• Introduce Chunk to replace the current datum slice Row.
• Introducing OpenTracing into TiDB:
  • For two phase commit.
  • Tracing config and gRPC interceptor middleware.

Weekly update in TiSpark

Added

• Add redundant aggregation elimination.

Fixed

• Fix meta deserialize overflow.
• Fix broken integration test.
• Fix potential time type NPE.
• Fix and upgrade Bazel for CI.
• Fix test dependency in CI.

New Contributor

• Ry

Weekly update in TiKV

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

Added

• Add adjacent region balancing scheduler.
• Add WAL bytes per the sync configuration.
• Flow control based on total writing bytes.
• Implement the in function for coprocessor.
• Filter the stores with lots of pending peers when balancing.
• Add region and hot region scheduling API.
• Record the approximate size of a store in PD.

Fixed

• raftstore: fix an issue with stale peer check.
• Record snapshot metrics in SCHED_STAGE_COUNTER_VEC.
• Fix the illegal JSON format in the hotspot/stores API.

Improved

• Inline get_limit_at_size.
• Group the metrics by namespaces.
• Document defer macro LIFO behavior.
• Remove redundant verbose KV for coordinator.
• Adjust table ID calculation.
• Set stack size to 10 MB for the coprocessor threads.

New contributor

• odeits