What's New in v19.1.4

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

August 13, 2019

This page lists additions and changes in v19.1.4 since v19.1.3.


Cockroach Labs has discovered a bug relating to incremental backups, for CockroachDB v19.1.0 - v19.1.11. If a backup coincides with an in-progress index creation (backfill), RESTORE, or IMPORT, it is possible that a subsequent incremental backup will not include all of the indexed, restored or imported data.

For more information, including other affected versions, see Technical Advisory 63162.

Get future release notes emailed to you:


Docker image

$ docker pull cockroachdb/cockroach:v19.1.4

Enterprise edition changes

  • The new skip_missing_views option for RESTORE skips restoring views that cannot be restored because their dependencies are not being restored at the same time. #38773

SQL language changes

  • CockroachDB now ignores non-fatal errors updating jobs during DROP TABLE. #38821
  • The first statement of a transaction no longer returns a transaction retry error if it is an UPDATE or DELETE (this was already true for INSERT). #39087

Bug fixes

  • Fixed a bug that prevented inverted indexes from being created on JSONB columns containing NULL values. #38747
  • Ranges consisting of only one row (and historical versions of that row) are now correctly up-replicated. #38588
  • Fixed a planning error that caused valid queries to fail with the error "rowCount passed in was too small". #38793
  • Fixed incorrect results, or "unordered span" errors, in some cases involving exclusive inequalities with non-numeric types. #38896
  • Fixed a bug in the cost-based optimizer causing a bad index for lookup joins in some cases. #39028
  • Fixed a potential infinite loop in queries involving reverse scans. #39101
  • UPSERTs planned by the cost-based optimizer that use lookup joins run during column mutations on the table being updated no longer cause crashes or other issues. #38917
  • crdb_internal.ranges can now be used inside views. Note that such views can become invalid in future releases if crdb_internal.ranges changes. #39213


This release includes 15 merged PRs by 11 authors.

YesYes NoNo