Release Notes for v1.1-alpha.20170720

July 20, 2017

Build changes

  • CockroachDB binary releases are now compatible with older CPUs (previous builds required SSE4.2; new ones only require SSE3). #16949
  • CockroachDB has reverted from jemalloc 5.0.1 to 4.5 due to observed memory leaks. #17055

SQL Language Changes

  • New syntax ORDER BY PRIMARY KEY tbl or ORDER BY INDEX [email protected] can be used as shorthand to sort results by the columns in an index. #17023
  • Parentheses are now optional when calling the current_schema function, improving compatibility with PostgreSQL. #16921
  • The text format of DECIMAL values now uses scientific notation when appropriate. #17029

Command-Line Interface Changes

  • The cockroach sql shell now correctly handles errors that occur once some results have been received. #17042

Admin UI Changes

  • New graphs for "live bytes per store" and "keys written per second per store". #16982

Bug Fixes

  • Fixed spurious errors when updating primary key columns while a schema change is in progress. #16866
  • Fixed issues with diagnostic reporting. #16955
  • Fixed a race in distsql draining. #17012

Performance Improvements

  • The DROP TABLE statement now returns as soon as the table name is no longer in use, instead of waiting for all data to be deleted. #17016
  • Improved batching of disk syncs, improving write throughput and latency. #16942 #16976
  • Queries containing VALUES clauses can now use the distributed SQL engine. #16849
  • Reduced lock contention in node liveness updates. #16918
  • Improved performance of the raft storage layer. #16945
  • Improved performance of large batches spanning multiple ranges. #16946
  • Removed all non-test uses of reflect.DeepEqual. #16960
  • Fixed "context cancellation after 0.0s" log spam. #17014
  • Improved implementation of ALTER TABLE SCATTER. #16249

Enterprise Edition Changes

  • New command cockroach load csv can convert CSV files into a format compatible with RESTORE. #16611
  • Reduced write amplification in RESTORE. #16990 #16924
  • Improved performance of SSTable ingestion. #17018

Doc Updates