Release Notes for CockroachDB 1.0.2

Announcements Release Notes
#1

June 15, 2017

General Changes

  • CockroachDB now uses Go 1.8.3 (fixing a security issue when elliptic curve certificates are used, as well as a panic). #16330

SQL Language Changes

  • The BEGIN statement now accepts the READ WRITE modifier for compatibility with the Go lib/pq driver. #16348

Command-Line Interface Changes

  • More node configuration details get logged on node initialization. #16209

Bug Fixes

  • Fixed several bugs with the OFFSET clause, including incorrect results and a panic when it is used without a LIMIT. #16315
  • Fixed the behavior of LIMIT in index joins. #16340
  • Fixed the behavior of DISTINCT with omitted columns. #16318
  • Fixed decoding of very large DECIMAL values. #16284
  • ALTER TABLE...ADD FOREIGN KEY no longer attempts to create an index on the source table. #16333
  • INT2VECTOR is now zero-indexed. #16326
  • Timestamp parsing is now consistent between prepared and non-prepared statements. #16327
  • If a prepared statement is invalidated by a schema change, it now returns an error instead of an incorrect result. #16335
  • The replica allocator will no longer remove replicas from a down node if there are no live nodes to receive them. #16218
  • ConditionalPut failures during initial migrations are now handled gracefully. #16244
  • EXPLAIN (TRACE) and the sql.trace.txn.enable_threshold cluster setting now work even when the trace.debug.enable cluster setting is false (the default). #16217
  • Improved the ability of a cluster to restart with some nodes missing. #16353
  • Backup URLs are now sanitized before being written to the system jobs table. #16386
  • cockroach zone set with an incomplete config for the special system ranges now merges the given config with the default instead of using zeros. #16212

Performance Improvements

  • Improved performance of MVCC garbage collection. #16219 #16231
  • Adjusted timeouts for snapshot throttling. #16328

Doc Updates