What's New in v1.2-alpha.20171026

Oct 26, 2017

Get future release notes emailed to you:

Thanks!

Downloads

Backwards-Incompatible Changes

• Casts from BYTES to STRING have been changed and now work the same way as in PostgreSQL. New functions encode() and decode() are available to replace the former functionality. #18843

General Changes

• CockroachDB now requires Go 1.9. #18459
• Release binaries now link against libtinfo dynamically. Building CockroachDB from source now requires libtinfo (or ncurses) development packages. #18979
• Building the web UI now requires Node version 6 and Yarn version 0.22.0 or newer. #18830
• Most dependencies have been updated to their latest versions. #17490
• Release docker images are now based on Debian 8.9. #18748

SQL Language Changes

• DROP DATABASE now defaults to CASCADE, restoring the 1.0 (and PostgreSQL-compatible) behavior. #19182
• The INET column type and related functions are now supported. #18171 #18585
• The ANY, SOME, and ALL functions now support subquery and tuple operands. #18094 #19266
• current_schemas(false) behaves more consistently with PostgreSQL. #18108
• SET CLUSTER SETTING now supports prepared statement placeholders. #18377
• SHOW CLUSTER SETTINGS is now only available to root. #19031
• A new cluster setting cloudstorage.gs.default.key can be used to store authentication credentials to be used by BACKUP and RESTORE. #19018
• The RESTORE DATABASE statement is now supported. #19182
• IMPORT now reports progress incrementally. #18677
• IMPORT now supports the into_db option. #18899
• The date_trunc() function is now available. #19297
• New function gen_random_uuid() is equivalent to uuid_v4() but returns type UUID instead of BYTES. #19379
• The extract function now works with TIMESTAMP WITH TIME ZONE in addition to plain TIMESTAMP and DATE. #19045
• TIMESTAMP WITH TIME ZONE values are now printed in the correct session time zone. #19081
• PostgreSQL compatibility updates: The pg_namespace.aclitem column has been renamed to nspacl. pg_class now has a relpersistence column. New functions pg_encoding_to_char, pg_get_viewdef, and pg_get_keywords. The pg_tablespace table is now available. The type name "char" (with quotes) is recognized as an alias for CHAR. Session variable server_version_num is now available. #18530 #18618 #19127 #19150 #19405

Command-Line Interface Changes

• A new flag --temp-dir can be used to set the location of temporary files (defaults to a subdirectory of the first store). #18544
• Many bugs in the interactive SQL shell have been fixed by switching to libedit for command-line input. The normalize_history option has been removed. #18531 #19125
• New command cockroach load show displays information about available backups. #18434
• cockroach node status and cockroach node ls no longer show nodes that are decommissioned and dead. #18270
• The cockroach node decommission command now has less noisy output. #18458

Bug Fixes

• Fixed issues when meta2 ranges split, lifting the ~64TB cluster size limitation. #18709 #18970
• More errors now return the same error codes as PostgreSQL. #19103
• ROLLBACK can no longer return a "transaction aborted" error. #19167
• Fixed a panic in SHOW TRACE FOR SELECT COUNT(*). #19006
• Escaped backslashes are now supported in regexp_replace substitution strings. #19168
• extract(quarter FROM ts) now works correctly. #19298
• The node liveness system is now more robust on a heavily-loaded cluster. #19279
• Added debug logging when attempting to commit a non-existent intent. #17580

Performance Improvements

• New cluster setting timeseries.resolution_10s.storage_duration can be used to reduce the storage used by built-in monitoring. #18632
• Foreign key checks are now performed in batches. #18730
• Raft ready processing is now batched, increasing performance of uncontended single-range write workloads. #19056 #19164
• The leaseholder cache is now sharded to improve concurrency and uses less memory. #17987 #18443
• Finding split keys is now more efficient. #18649 #18718
• STDDEV and VARIANCE aggregations can now be parallelized by the distributed SQL engine. #18520
• Store statistics are now updated immediately after rebalancing. #18425 #19115
• Raft truncation is now faster. #18706
• Replica rebalancing is now prioritized over lease rebalancing. #17595
• IMPORT and RESTORE are more efficient. #19070
• Restoring a backup no longer creates an extra empty range. #19052
• Improved performance of type checking. #19078
• The replica allocator now avoids adding new replicas that it would immediately try to undo. #18364
• Improved performance of the SQL parser. #19068
• Cache strings used for stats reporting in prepared statement. #19240
• Reduced command queue contention during intent resolution. #19093
• Transactions that do not use the client-directed retry protocol and experience retry errors are now more likely to detect those errors early instead of at commit time. #18858
• Commands that have already exceeded their deadline are now dropped before proposal. #19380
• Reduced the encoded size of some internal protocol buffers, reducing disk write amplification. #18689 #18834 #18835 #18828 #18910 #18950
• Reduced memory allocations and GC overhead. #18914 #18927 #18928 #19136 #19246