What's New in v2.0-alpha.20180129

January 29, 2018

Get future release notes emailed to you:

Thanks!

Downloads

General Changes

• CockroachDB now uses gRPC version 1.9.2 #21600

Enterprise Changes

• Failed RESTORE cleanup no longer causes the RESTORE job to perpetually loop if external storage fails or is removed. #21559
• Non-transactional BACKUP and RESTORE statements are now disallowed inside transactions. #21488

SQL Language Changes

• Reduced the size of system.rangelog entries to save disk space. #21410
• Prevented adding both a cascading referential constraint action and a check constraint to a column. #21690
• Added json_array_length function that returns the number of elements in the outermost JSON or JSONB array. #21611
• Added referential_constraints table to the information_schema. The referential_constraints table contains all foreign key constraints in the current database. #21615
• Replaced BOOL columns in the information_schema with STRING columns to conform to the SQL specification. #21612
• Added support for inverted indexes for JSON. #20941
• DROP SEQUENCE cannot drop a SEQUENCE that is currently in use. #21364
• The IMPORT function now does not require the temp directory and no longer creates a RESTORE job. Additionally, the TRANSFORM_ONLY option for IMPORT has been renamed to TRANSFORM and now takes an argument specifying the target directory. #21490

Command-Line Changes

• cockroach start --background now returns earlier for nodes awaiting the cockroach init command, facilitating use of automated scripts. #21682
• Command-line utilities that print results with the pretty format now use consistent horizontal alignment for every row of the result. #18491

Admin UI Changes

• The Command Queue debug page now displays errors correctly. #21529
• The Problem Ranges debug page now displays all problem ranges for the cluster. #21522

Bug Fixes

• Fixed a crash caused by NULL placeholder in comparison expressions. #21705
• The EXPLAIN (VERBOSE) output now correctly shows the columns and properties of each query node (instead of incorrectly showing the columns and properties of the root). #21527
• Added a mechanism to recompute range stats automatically over time to reflect changes in the underlying logic. #21345

Performance Improvements

• Multiple ranges can now split at the same time, improving our ability to handle hotspot workloads. #21673
• Improved performance for queries that do not read any columns from the key component of the row. #21571
• Improved performance of scans by reducing efforts for non-required columns. #21572
• Improved efficiency of the key decoding operation. #21498
• Sped up the performance of low-level delete operations. #21507
• Prevented the jobs table from growing excessively large during jobs table updates. #21575

Contributors

This release includes 110 merged PRs by 31 authors. We would like to thank the following contributors from the CockroachDB community:

• Constantine Peresypkin
• 何羿宏

Special thanks to first-time contributors Andrew Kimball, Nathaniel Stewart, Constantine Peresypkin and Paul Bardea.