YSQL Changes
- [YSQL] Framework for expression pushdown. #3297
- [YSQL] Optimize relcache preloading by reducing the number of master RPCs. #3049
- [YSQL][Diesel ORM] Fix crash for nested SELECT with set-returning function and LIMIT. #3811
- [YSQL] Fix error when ybctid value matches the partition boundary. #3833
- [YSQL][Hasura] Fix 'Missing base table ybctid' error for UPDATE with RETURNING clause. #3805
- [YSQL] Update on table with multiple FK tables crashes postgres. #3583
System improvements
- [cdc] Fix DeleteTableWithCDCStream
- Ensure only Tablet leaders can confirm alter table. #2236
- Make OpenSSL usage thread-safe. #3454
- Revert removed timeout from RequestConsensusVote. #3390
- colocation: fix DFATAL on UI tables page (#3726). #3726
- Ignore writes from the same transaction while updating CQL indexes. #3718
- Update setting for default number of compaction threads. #3561
- Add functionality of resolving intents to transaction participant. #1032
- [cdc] Ability to Delete & List CDC Streams in yb-admin. #3638
- Set default manifest preallocation to 64k. #3666
- A workaround for encryption counter overflow. #3707
- Fixed SecureStream OOM during network partition. #3842
- Transactions could hang at transaction participant after write stopped. #3823
- Show backfill progress at master/tasks. #3668
- Fix apply of transaction with deleted tablets. #3828
- Comment out Connection::Shutdown info log. #3842
Platform
- Fix health check failures when YSQL auth is enabled. #3737
- Adding under-replicated tablet servers to the master health check. #1374
- Fix Tab problem when going into Tables page on Yugabyte Cloud. #3749
- Only save usable AWS instance types. #3626
- Added APIs for querying audit table. #3792
- Generate Client Certificate for TLS enabled Universes. #3839
- Onprem - allow specifying homeDir, automatically exclude installing s3cmd and ntp. #3834
- Add sorting by default to the releases list and also a search bar to allow users to quickly access the desired release by entering part of the string. #3563
- Correctly disable ntp install for onprem
Note
Prior to 2.0, YSQL was still in beta. As a result, 2.0 release includes a backward incompatible file format change for YSQL. This means that if you have an existing cluster running releases older than 2.0 with YSQL enabled, then you will not be able to upgrade to version 2.0+. Export from old cluster and import into a new 2.0+ cluster is needed for using existing data.