What's New in v1.1-alpha.20170720

Jul 20, 2017

Get future release notes emailed to you:

Thanks!

Downloads

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 tbl@idx 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

• New RFCs: monitor jobs from SQL (#16688), resume interrupted backup/restore jobs (#16633)
• Updated the sample secure Kubernetes configuration. #16740
• Added docs on the cluster and version details that are printed upon connecting the built-in SQL shell to a node. #1714
• Improved the UX of the Install CockroachDB page. #1711
• Completed documentation on the UPDATE statement. #1707
• Published a video demo of cross-cloud deployment and migration. #1702