Overview of Changes

[IMPORTANT] This version includes a backward incompatible file format change for YSQL. This means that if you have an existing cluster with
YSQL schema, then you will not be able to connect to the YSQL database after upgrading to v1.2.4. There are two ways to work around this problem:

• If you don't care about preserving your existing data, then you can delete your older cluster, upgrade to v1.2.4 and create a new cluster.
• If you want to continue using your existing data, then please save your older data (in the form of SQL statements), delete the older cluster, upgrade to v1.2.4, create a new cluster and then load the previously saved data.

YSQL Changes

• Added support for primary keys. It is now possible to create a table with a primary key. #955
• Added support for temporary tables. #805
• Added support for CYCLE option in CREATE SEQUENCE statement. #993
• Enabled SET TRANSACTION READ WRITE statement. #1081
• Support RelationType in TableInfo to distinguish between system tables, user tables and user indexes. #906

Bug Fixes

• Fixed a crash in tserver that is observed while inserting null value into an indexed column. #945
• Fixed a bug where indexes on system catalog tables were not being updated during DDL. #1083
• Fixed detection of single row transactions on tables that have primary keys.
• Fixed MiniMaster startup race condition in test infrastructure. #1040

System Improvements

• Reduce per-connection overhead for cache preloading. #1090 #1091
• Faster release of sending buffers to reduce memory consumption when leader sends large updates to followers who are lagging behind. #1079
• Parallelize DNS resolution while filling system.peers and system.local tables #1000
• Script for post-processing test results and generating JSON-based result files.
• Improve stability of QLTransactionTest.IntentsCleanupAfterRestart. #1102

Key Commits

• [f2ecaa1] [YSQL] Fix single-row-txn detection after primary key change
• [90680ca] [#1102]: Improve stability of QLTransactionTest.IntentsCleanupAfterRestart
• [a4c614f] JSON-based test reports
• [33835b0] [#1079]: Release sending buffers as soon as possible
• [1bc77da] ENG-4682 (#906): Support RelationType (user table, index, system table) in TableInfo
• [1dedcd1] ENG-4943 #945 [YSQL] Correct handling for NULL value in indexed column
• [465b6d6] [YSQL] #1090 #1091 Reduce per-connection overhead for cache preloading
• [382b89c] [YSQL] ENG-4601 (#805): Add support for temporary tables
• [5165f01] #1081 [YSQL] Enable READ WRITE transaction
• [9f31c41] ENG-4927: #1040: Fix MiniMaster startup race condition
• [be0908b] [YSQL] #955: Handle primary key as an index
• [4b48e25] ENG-4872: #1000: Parallel DNS resolution while filling system.peers and system.local tables
• [4096f59] ENG-4900: Add external mini cluster test with TLS support
• [34ee0fc] [YSQL] #1083: Handle sys catalog index updates
• [ac52116] #993: [YSQL] Add support for CYCLE option in CREATE SEQUENCE
• [3149f36] ENG-4363, #668: Support JSON operator on INSERT (Part 1 - Refactoring)
• [a3ea483]
• [b3a60ee] [yb-docker-ctl] Save initdb log (#1087)
• [b131fbc] ENG-4888: #1031: Make YCQL index name optional
• [9d333f7] #1064: Fix data race with YQL permissions cache
• [4a56fe1] #1038: Change FLAGS_remote_boostrap_rate_limit_bytes_per_sec to FLAGS_remote_bootstrap_rate_limit_bytes_per_sec
• [56a6029] #752: Add TLS encryption support to yb-admin.
• [d9b6385] [YSQL] #1066: Fix memory leak in ResourceOwner
• [fb4c1a2] Added yb-docker-ctl to CE (#1077)
• [046b4b6] ENG-4855: #977: Handle restart read in YSQL
• [30725bf] ENG-4343: #655: Pick transaction read time at tablet server when possible
• [0341b29] [YSQL] #1067: Buffer create index write operations only for initdb
• [78ca75a] [#1050]: Add Tablet Server capabilities
• [9d724d5] ENG-4790: Removing most of yb-loadtester from repo due to migration to standalone yb-sample-apps repo
• [bbcc67b] ENG-4891: Removing the SQL RPCs button.
• [14279cc] [YCQL] #1042: Fix ASAN issue in YCQL executor restart
• [cc3584f] ENG-4800: #952: Use call buffer for receive from socket
• [8715be3] [YSQL] #1051: Bulk insert in initdb
• [987abc6] ENG-4877 (#1009): yb-ctl enhancements
• [0f261a9] [YSQL] 1049 ASAN reported memory leaks in Postgres
• [9eaf15b] Add a new pattern for NFS directories: /Volumes/net
• [3a61698] [#1041]: Skip dumping of finished call
• [a322d95] [YSQL] #711 Add support for all datatypes
• [7e2c89c] [#1030]: Add transactional retry writes tests 2) Second
• [request]licated. Fixed by returning AlreadyPresent status and handling it in
• [callbac] not handled correctly. For instance when request cannot be processed because of service shutdown, we could stop retrying to apply the operation. Fixed by correct handling of such errors.
• [509c5a2] #921: Fixed: [YCQL] improve error messages related to index DDL
• [e48b7da] ENG-4468: Always perform only one server rpc call for readiness check.
• [0f8fdd9] [YSQL] ENG-4831 (#969): Enable drop cascade
• [85836b5] Allow spaces around equality sign in @RunWith(value=SomeClass) annotation
• [e533efc] ENG-4844, #949: Treat TUPLE as a keyword
• [40dd31f] [#984]: Allow running C++ test by specifying only gtest_filter
• [9cb4f10] ENG-4746: #925: Implement change_blacklist & get_universe_config commands in yb-admin
• [9e28eee] [YSQL] #995: Raise error on unsupported WHERE condition with secondary index
• [9fd097e] [#965] Reduce the number of concurrent connections to YB masters and tservers from PostgreSQL backend processes
• [7ea3cd0] [YSQL] ENG-4839 (#976): Handle postgres session termination correctly in YB mode
• [f55f1c0] #991: Fixed TestRpc.TestDisconnect
• [aa8c4ec] #999: [YSQL] SELECTing directly from a sequence throws an error
• [8d226ce] ENG-4852: Do not pass Datum data types to ybc_pgate
• [f702d72] [YSQL] #979: Fix ORDER BY query using secondary index
• [66a94f3] ENG-4840 (#987): Fix incorrect count for system tablet leader count
• [c847562] #964: Change compaction and remote bootstrap rate defaults.
• [5ed041c] #788 Optimize select statements where a clustering-key needs to be in a given range
• [0c00885] [#933]: Leader lease revocation
• [03b996d] ENG-4746: #925: Migrate missing java yb-cli functionality to yb-admin (Preparation)