This version of CockroachDB is no longer supported. Cockroach Labs supports the current stable release and two releases prior. Please use one of these supported versions.

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

Yes No