Release Notes for CockroachDB v19.1.4

Hi,

This week’s v19.1.4 release features several bug fixes and SQL improvements. Perform a no-down-time upgrade to this stable version to benefit from these changes.

Release Notes for August 14, 2019

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

Contributors

This release includes 15 merged PRs by 11 authors.