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.