Weekly update in TiDB

Last week, we landed 72 PRs in the TiDB repository.

Added

• Visualize the trace output using the HTTP interface
• Add the tidb_parse_tso built-in function
• Add the json_depth built-in function
• Close the client connection when the server waiting time exceeds wait_timeout
• Add a constraint propagation framework to be used by partition pruning

Improved

• Release the datum memory after the transaction is finished
• Simplify the session level domain pool
• Record the current database information in the CRUCIAL OPERATION log
• Kill all connections when the server is not gracefully shut down
• Support PREPARE FROM @var_name
• Implement GoString() for TxnState to make the generated log more user-friendly
• Improve the privilege check for set password
• Return scanned rows of Coprocessor operators in EXPLAIN ANALYZE
• Improve the privilege check for use DB
• Improve the MySQL compatibility of SHOW commands
• Do not push down filters containing SetVar or GetVar
• Add a limit to constrain the maximum number of prepared statements
• Prevent Order By table_name.column_name for the Union statement
• Make round work when converting a float string to an integer string
• Add the correctness check for the validate_password_* system variables

Fixed

• Fix a bug of wrong duplicate results in left outer join
• Set a default value for the Enum type correctly when inserting rows
• Fix an error message when the updated value overflows
• Fix a panic when dumping statistics for a dropped column
• Fix wrong result length of Union
• Prohibit the DML execution when TiDB loses connection to etcd
• Fix data race caused by concurrent access to do.infoHandle
• Fix a server hang issue when canceling the Add Index DDL job

Weekly update in TiSpark

Last week, we landed 2 PRs in the TiSpark repository.

Fixed

• Fix NullPointException when counting empty tables

Weekly update in TiKV and PD

Last week, we landed 25 PRs in the TiKV and PD repositories.

Added

• Add support for adding the learner operator to PD
• Add the week_with_mode built-in function
• Add the space built-in function
• Add the SubstringBinary2Args and SubstringBinary3Args built-in functions
• Support modifying TiKV's maximum background jobs
• 2.1 cherry pick: Support ambiguous time

Improved

• Collect component logs

• Improve tombstone command's error message

• Improve tests:

  • Move the tests directory
  • Fix test_follower_slow_split
  • Add more seek and seek_for_prev tests
  • Provide the seeded KV generator

• Improve PD documentation:

  • Update the API document
  • Update the API HTML file

• Abandon the PD vendor directory

Fixed

• Fix the TiKV redundant raftstore heartbeat
• Fix the issue of watching leader with invalid revision in PD
• Fix small bugs of tikv-ctl
• 2.1 cherry pick: Fix tikv-ctl help messages

New contributors (Thanks!)

docs:

• lucperkins

tidb:

• alapha23
• exialin
• leoppro
• pingyu