beta-20161208.md

title	toc	summary
What's New in beta-20161208	false	Additions and changes in CockroachDB version beta-20161208.

Dec 8, 2016

Get future release notes emailed to you:

<script> hbspt.forms.create({ css: '', cssClass: 'install-form', portalId: '1753393', formId: '39686297-81d2-45e7-a73f-55a596a8d5ff', formInstanceId: 1, target: '.install-form-1' }); </script>

Binaries

Mac Linux

SQL Language Changes

• The pg_catalog and information_schema databases now include information about the current database only, unless the user is root. #11694
• The pg_catalog.pg_range table is now supported. #11725
• The pg_get_userbyid function is now supported. #12162
• The SHOW TABLES, SHOW DATABASES, SHOW GRANTS and SHOW COLUMNS statements are now aliases for queries on the information_schema database. #10196
• Empty passwords are no longer allowed in the CREATE USER WITH PASSWORD statement. #11781

Command-Line Interface Changes

• Log file names have changed. The new format is cockroach.kenabook.kena.2016-11-28T20_00_35Z.009524.ERROR.log. #11666

Admin UI Changes

• On the Cluster Overview page, added a Summary section showing total nodes and capacity used, and updated the overall navigation and style. #11696 #11754
• Several "allocator" metrics have been replaced with a new "underreplicated range" metric. #11733 #11983
• The "ranges available" metric has been replaced with a "ranges unavailable" metric, which is computed differently. #11760
• New metrics have been added for the replication queue and replica GC queue. #11753 #11785
• New metrics have been added for RPCs. #11711
• New metrics have been added to track commands that have been stuck for a long time. #12106

Performance Improvements

• Range leases are now balanced across the nodes in a cluster. #11757
• Raft heartbeats are once again coalesced into one message per pair of nodes instead of per range. #11757
• Persisting the applied index is now faster. #9993
• The replication queue no longer tries to reprocess the same range repeatedly. #11982
• Limited frequent reprocessing of ranges for time series maintenance and consistency checks. #10665
• The time series maintenance queue no longer sends commands when it has nothing to do. #11762
• The pow() function is now faster when small numbers are raised to very large powers. #11738
• JOIN queries now only scan the columns they need. #11736
• Micro-optimized logging and removed some noisy log events. #11778

Bug Fixes

• Fixed a panic when sending a raft message fails. #11985
• Fixed a memory spike that could occur during asymmetric partitions. #12100
• DROP DATABASE now works when foreign key constraints are present. #12036
• DROP DATABASE no longer hangs when subqueries have been used. #11730
• Requests no longer get stuck forever after a timeout. #12000
• Comparisons of SQL tuples now work for all types. #10475

Contributors

This release includes 101 merged PRs by 19 authors. We would like to thank the following contributors from the CockroachDB community.

• songhao
• yznming