2017-09-04-tidb-weekly.md

title	date	summary	tags
Weekly update (August 28 ~ September 03, 2017)	2017-09-04	Last week, we landed 42 PRs in the TiDB repositories and 32 PRs in the TiKV repositories.	TiDB TiKV

Weekly update in TiDB

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

Added

• Add JSON into builtin if function.

Fixed

• Fix bugs when doing natural JOIN or JOIN with using clause.
• Check whether date is zero and returns error when casting int as the time type.
• Support date time format when parse duration.
• Fix the issue that SHOW CREATE TABLE COMMENT is not escaped and the issue that FieldType.CompactStr() is escaped.
• Support empty bit-value literal syntax b''.
• Fix the OCT() bug when it meets a binary value.
• Fix float and binary literal bugs.
• Fix index join key incompatible encoded problem.
• EvalDuration supports the time format in int.
• Fix the batch insert bug on duplicate keys.
• Fix the bug for parsing the UTC_TIME/UTC_TIMESTAMP/CUR_TIME/CURRENT_TIME/CURRENT_TIMESTAMP builtin

Improved

• Make NOW() folded in constant folding stage.
• Refine the time stamp index selection.
• Disable auto analyze.
• Support sig pushdown in mocktikv.
• Support more types when getting default FLEN and DECIMAL.
• Refactor the following expressions/builtin-function evaluation framework:
  • GET_LOCK, RELEASE_LOCK
  • FOUND_ROWS, DATABASE, CURRENT_USER, USER, CONNECTION_ID, VERSION
  • STR_TO_DATE
  • BIT_COUNT
  • RLIKE
  • MAKE_SET, QUOTE
  • DATE_FORMAT
  • PERIOD_ADD, PERIOD_DIFF
  • UNIX_TIMESTAMP

Weekly update in TiKV

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

Added

• Use delete range to destroy a replica.
• Add builtin_cast-III for DAG/expression.
• Support decoding Time from tipb.Expr.
• Add statistics for coprocessor.
• Support builtin UnaryMinus* for DAG.
• Add more math functions for DAG.
• Implement eval for expression.
• Support storing weight when balancing data.
• Adjust the decimal parsing interface for coprocessor
• Implement [coalesce] (tikv/tikv#2239) for corprocessor.
• Implement case_when for DAG.

Improved

• Refactor storeInfo.
• Speed up reconnecting to PD leader.
• Use FnvHashMap.
• Cleanup code for coprocessor.
• Add more tests for exprssion/builtin_cast.
• Use RocksDB 5.7.3.
• Add more write statistics.
• Make error message more friendly.
• Refactor replica selector for PD.