Weekly update in TiDB

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

Added

• Provide the ADMIN SHOW NEXT_ROW_ID SQL interface
• Propose the VIEW design
• Implement outer join elimination in the logical optimization

Improved

• Distinguish internal/general SQL statements for transaction related metrics
• Recover the panic in parallel aggregation and projection
• Add a variable to control the maximum length of the logged query string
• Add a variable to control whether writing _tidb_rowid is allowed
• Return an error on check for the missing user
• Support the plan cache for prepared INSERT/DELETE/UPDATE statements
• Add a variable to control the slow log threshold
• Ensure scan of tikv-client is not out of range

Fixed

• Fix the bug of comparison when a row contains NULL
• Make affected rows of INSERT consistent with MySQL
• Correct the field name when IfNull is eliminated
• Fix the unexpected error for ORDER BY in UNION statements
• Fix a deadlock in the latch scheduler
• Fix a bug of converting duration to timestamp in the statistics component
• Return NULL for the values function in the non-INSERT statement
• Change the default charset and collation from utf8 utf8_bin to utf8mb4 utf8mb4_bin

Weekly update in TiSpark

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

Added

• Add resolveLock implementation

Fixed

• Fix the incorrect tso request generated by PDClient

Weekly update in TiKV and PD

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

Added

• Support the Time function in Coprocessor

Improved

• Add sanity check for the count field of a request
• Record start_ts in the write conflict error
• Add the end_key limit to the kv_scan interface

Fixed

• Fix the issue about the regions/check API
• Fix ScheduleConfig data race

New contributors (Thanks!)

tidb: lindali0331

tidb-operator: kirinse

docs-cn:

• bianxindong
• ppiao