Weekly update in TiDB

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

Added

• Support subqueries in the SHOW statement
• Add support for the octet_length function
• Introduce Sel to Chunk to indicate which rows are selected
• Add the methods of vectorized data access to Column
• Add opt_rule_blacklist in mysql tables

Improved

• Handle the partitioned table in some HTTP APIs
• Improve compatibility with mysql whendatatime is invalid
• Show CARTESIAN Join explicitly in the results of Explain
• Change the toErr logic in executor/ddl.go
• Reduce the lock conflict between sending message and re-creating streaming clients
• Support more Analyze options
• Reduce the allocation and release of memory for load data and batch insert

Fixed

• Fix the overflow of the built-in add_date/sub_date functions
• Fix the panic when dumping pseudo columns
• Fix the issue that current_timestamp/now are not consistent in one stmt like in MySQL
• Fix the issue that floatStrToIntStr fails in some cases
• Disallow dropping indexes on the auto_increment column
• Fix the bug of uint64 overflow in ConvertJSONToFloat
• Fix the generation of the field name
• Reject the invalid conversion from like to =
• Fix a bug in the column charset and collate when creating tables and modifying columns
• Fix the bug of REVOKE ROLE
• Fix bugs and make the rule of outer join elimination more effective
• Fix the issue that autoid does not handle the float and double types
• Fix the compatibility issue of the auto_increment column in the INFORMATION_SCHEMA.TABLES table

Weekly update in TiSpark

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

Added

• Add the Spark version to TiSpark UDF ti_version()

Weekly update in TiKV and PD

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

Improved

• Add more details about the gRPC ResourceExhausted failure
• Separate the interfaces of Coprocessor statistics
• Rename follower read
• Make the RocksDB aware of jemalloc
• Change the outputs of errors, panics, and logs from Debug to Display
• Use into rather than explicitly using RepeatedField
• Use an individual package for tso
• Use an individual package for the ID allocator
• Return a Region error when TiKV is closing
• Improve rust-rocksdb

Added

• Introduce the trait of Coprocessor Storage
• Add a retry mechanism for join
• Migrate implementation and test for the DateFormatSig RPN Function
• Add the convert * functions to the decimal
• Add the convert * functions to the float

Fixed

• Fix the issue that the merge region API is added
• Fix the wrong constraint check when txn is overlapping
• Fix the scatter range
• Fix a compatibility issue for protos
• Fix ScanRegions
• Remove the remaining references of tikv-importer
• Copy /health and /diagnose to /api/{version} and deprecate the old ones
• Ease the transition to Prost
• Fix the compilation errors when running make fail_release
• Fix the scatter range
• Fix bugs in pd-simulator

New contributors (Thanks!)

tikv:

• lucab
• Luffbee
• jiyingtk

tidb:

• unknwon
• wty4427300

parser:

• gleonid