October 21, 2019
Warning:
A denial-of-service (DoS) vulnerability is present in CockroachDB v19.2.0 - v19.2.11 due to a bug in protobuf. This is resolved in CockroachDB v19.2.12 and later releases. When upgrading is not an option, users should audit their network configuration to verify that the CockroachDB HTTP port is not available to untrusted clients. We recommend blocking the HTTP port behind a firewall.
For more information, including other affected versions, see Technical Advisory 58932.
Get future release notes emailed to you:
Downloads
Docker image
$ docker pull cockroachdb/cockroach-unstable:v19.2.0-rc.1
SQL language changes
INTERVAL(6)
is now supported as an alias forINTERVAL
, for compatibility with third-party tools. #41447- Added the
pg_available_extensions
table, for compatibility with third-party tools. #41447 - The
pg_attrdef()
andpg_get_indexdef()
built-in functions no longer include type annotations on default expressions, andpg_get_indexdef()
now includes the index method in the returnedCREATE INDEX
statement, for compatibility with third-party tools. #41447
Bug fixes
- The
generate_subscripts()
built-in function now behaves properly onint2vector
andoidvector
types. #41447 - Fixed a bug causing the
cluster_logical_timestamp()
built-in function to sometimes return incorrect results. #41439 - Prevented an unlikely race condition where a WAL pending recycling could be deleted, leading to a crash. This bug was present in past 19.2 alphas/betas only, not in any earlier release. #41523
Performance improvements
- Metadata queries that use the
'string'::regclass
form are now much more efficient in the presence of a large number of tables. #41447 - The
pg_get_coldesc()
built-in function now retrieves comments more efficiently. #41447
Doc updates
- Clarified epoch-based vs. expiration-based leases in the Replication Layer architecture documentation. #5578
- Updated the list of Enterprise features. #5599
- Documented the new
--geo-partitioned-replicas
flag of thecockroach demo
command, which starts a 9-node in-memory cluster with the Geo-Partitioned Replicas data topology applied to themovr
database. This lets you quickly simulate one of the most effective data topology patterns for getting low latency in a multi-region cluster. #5587
Contributors
This release includes 12 merged PRs by 10 authors.