What's New in v19.2.0-rc.1

This version of CockroachDB is no longer supported. For more details, see the Release Support Policy.

October 21, 2019


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:


Docker image

$ docker pull cockroachdb/cockroach-unstable:v19.2.0-rc.1

SQL language changes

  • INTERVAL(6) is now supported as an alias for INTERVAL, for compatibility with third-party tools. #41447
  • Added the pg_available_extensions table, for compatibility with third-party tools. #41447
  • The pg_attrdef() and pg_get_indexdef() built-in functions no longer include type annotations on default expressions, and pg_get_indexdef() now includes the index method in the returned CREATE INDEX statement, for compatibility with third-party tools. #41447

Bug fixes

  • The generate_subscripts() built-in function now behaves properly on int2vector and oidvector 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


This release includes 12 merged PRs by 10 authors.

YesYes NoNo