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] (https://github.com/pingcap/tikv/pull/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.