2017-10-23-tidb-weekly.md

title	Weekly update (October 9 ~ October 22, 2017)
date	2017-10-23
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 two weeks, we landed 83 PRs in the TiDB repositories.

Added

• Support writing slow query log into separate files.
• Dummy implementation for the SHOW PROFILES statement.
• Add metrics for automatic analyzing.
• Support the operation of cancel DDL jobs.
• Add a new http status API to get meta regions.

Removed

• Remove the self field in baseBuiltinFunc completely.
• Remove foldable from baseBuiltinFunc.

Fixed

• Fix a bug occurred in select sum(float col)*0.1
• Cast types for the expression of assignments of updateList.
• Fix a PhysicalReader range bug when data is MaxInt64.
• Add unsigned and zerofill flags to field type year.
• Fix a select distinct bug.
• Fix a bug when auto_increment meets unsigned.
• Change the DNV of default null column to 0.
• Correct the signature building of Values.
• Add schema state check when executing the show create table or analyze statistic statement.
• Set missing result field Org_table and Database to Navicat for MySQL compatibility.
• Fix a bug in the copy function.
• Fix a bug when converting time to scalar.
• Fix a bug when building histograms for columns.
• Fix a bug when merging sample collectors.
• Fix ineffectual assignments.
• Fix the issue that the show grants statement displays empty entries.
• Set proper parent for newly projection-eliminated child.
• Put RPC handler in response instead of returning it.
• Quit the builtin function SLEEP when it is killed.
• Fix the issue that the unsigned integer column length is not consistent with MySQL.
• Add the ParseErrorWith function to make the parse error compatible with MySQL.

Improved

• Rename the DDL job state variable.
• Rename the package inspectkv to admin.
• Change reorg wait time from 1ms to 50ms.
• Support int1, int2, int3, int4, int8 type syntax.
• Estimate NDV more precisely.
• Return MySQL error code for Unsafe SafePoint.
• Estimate NDV as pseudo when its value is zero.
• Make some builtin functions foldable.
• Return NULL when error is not nil.
• Improvement for multi-delete.
• Split the detach process from BuildRange.
• Use single method to set parent and children.
• Use pattern match to check dbRecord in mysql.db.
• Check sc.IgnoreZeroInDate when parsing the string or number type to date/datetime/timestamp.
• Enforce errcheck in Makefile.
• Open auto analyze by default.
• Improve the fold constant.
• Avoid type assertion for ast.ExprNode.
• Avoid come assertion for StmtNode.
• Use ParseTimeFormNum instead of ParseTime.
• Support plan cache for the SELECT statement.

Weekly update in TiSpark

Added

• Add support for explain

Fixed

• Fix tispark-sql table alias problem

Weekly update in TiKV

In the last two weeks, We landed 46 PRs in the TiKV repositories.

Added

• Register classifiers by name when using namespace.
• Add the operator priority mechanism.
• Support setting a region to tombstone status.
• Add MVCC scan support to debug API.
• Support fail point.
• Support removing table_id/store_id from namespace.
• Persist scheduler list to etcd.
• Support namespace(experimental).
• Support health check in pd-ctl.
• Store case-insensitive labels.
• Support adding/removing region peer in pd-ctl.

Fixed

• Fixes typos in raft.
• Fix table namespace classifier.
• Fix split check tests.

Improved

• Refactor clusterInfo.
• Refactor the debug API for tikv-ctl.
• Adjust scheduler interface.
• Reduce allocation in Raft.
• Report read statistics to pd-worker directly.
• Move out the PD work from raftstore.
• Use try shorthand.
• Move significant send to Raft router.
• Adjust label checks.
• Optimize approximate region size for region heartbeat.
• Flow control based on current writing KV count.