What's New in v2.0.4

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

July 16, 2018

Get future release notes emailed to you:


SQL Language Changes

  • CHECK constraints are now checked when updating a conflicting row in INSERT ... ON CONFLICT DO UPDATE statements. #26699
  • An error is now returned to the user instead of panicking when trying to add a column with a UNIQUE constraint when that column's type is not indexable. #26728

Command-Line Changes

  • CockroachDB now computes the correct number of replicas on down nodes. Therefore, when decommissioning nodes via the cockroach node decommission command, the --wait=all option no longer hangs indefinitely when there are down nodes. As a result, the --wait=live option is no longer necessary and has been deprecated. #27158

Bug Fixes

  • Fixed a typo on Node Map screen of the Admin UI. #27129
  • Fixed a rare crash on node decommissioning. #26717
  • Joins across two interleaved tables no longer return incorrect results under certain circumstances when the equality columns aren't all part of the interleaved columns. #26832
  • Successes of time series maintenance queue operations are no longer counted as errors in the Metrics dashboard of the Admin UI. #26820
  • Prevented a situation in which ranges repeatedly fail to perform a split. #26944
  • Fixed a crash that could occur when distributed LIMIT queries were run on a cluster with at least one unhealthy node. #26953
  • Failed IMPORTs now begin to clean up partially imported data immediately and in a faster manner. #26986
  • Alleviated a scenario in which a large number of uncommitted Raft commands could cause memory pressure at startup time. #27024
  • The pg-specific syntax SET transaction_isolation now supports settings other than SNAPSHOT. This bug did not affect the standard SQL SET TRANSACTION ISOLATION LEVEL. #27047
  • The DISTINCT ON clause is now reported properly in statement statistics. #27222
  • Fixed a crash when trying to plan certain UNION ALL queries. #27233
  • Commands are now abandoned earlier once a deadline has been reached. #27215
  • Fixed a panic in IMPORT when creating a table using a sequence operation (e.g., nextval()) in a column's DEFAULT expression. #27294

Doc Updates


This release includes 22 merged PRs by 17 authors. We would like to thank the following contributors from the CockroachDB community, with special thanks to first-time contributors Emmanuel.

  • Emmanuel
  • neeral
YesYes NoNo