2017-08-07-tidb-weekly.md

layout	title
post	Weekly Update

Weekly update in TiDB

2017-08-07

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

Added

• Support natural join.
• Add a switch for enabling cost-based optimizor.
• Assign low priority for SQL with full table scan and high priority for SQL with point get.
• Support \N which is the shotcut of null.
• Support TIMESTAMP in the get_format function.
• Add a flag to enable TCP keep-alive.
• Support DISTINCTROW.

Fixed

• Truncate the trailing spaces for "CHAR[(M)]" types
• Fix float point parsing with leading dot.

Improved

• Refactor the row structure: to reduce memory allocation.
• Refactor the following expression/builtin-function evaluation framework:
  • trim
  • rtrim
• Check schema changing more precisely.
• Adjust the cost of index join.

Weekly update in TiKV

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

Added

• Add priority for coprocessor thread pool.
• Add ceil_real function for coprocessor.
• Add remove function for JSON.
• Dynamically set label by PD API.
• Support delete member by id.
• Add more util functions.

Fixed

• Stop the resolver thread explicitly.

Improved

• Refactor the storage configuration field.
• Deny the http prefix for PD addresses.
• Refactor the properties collector.
• Improve the storage test.
• Use the MinOverlappingRatio compaction priority by default.