beta-20170209.md

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

Feb 9, 2017

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

Build Changes

• Official binaries for Linux now support older Linux distributions, including RHEL 6. #13102
• CockroachDB now uses RocksDB 5.0.2. #12913

SQL Language Changes

• The unnest() function is now supported. #13154
• It is now possible to join a set-returning function like generate_series() with itself. #13140
• The timestamp parser now accepts an additional format. #13159
• The output of EXPLAIN has been improved. #13216 #13221
• Hex string literals (X'') can now contain byte sequences that are not valid UTF-8. #13287
• COPY now works outside transactions. #13400
• Fixed some edge cases with the IN operator. #13444
• The pg_type table now contains entries with the same names as PostgreSQL, such as int2, int4, and int8 instead of just integer. #13355
• The pg_backend_pid, obj_description, and shobj_description functions and the pg_inherits, pg_foreign_table, and pg_foreign_server tables now have dummy implementations for compatibility with some clients. #13097 #13181

Command-Line Interface Changes

• The --pretty flag of cockroach sql has been removed, and replaced with a --format flag that supports multiple output formats. The command \set display_format can be used to change the format during a session. #13171
• The current database name is now shown in the prompt. #12747 #13379
• Non-interactive usage of cockroach sql is much faster when the input file contains very long lines. #13174

Admin UI Changes

• Introduced a new overview dashboard. #13348
• Improved accuracy of histogram data. #13106

Performance Improvements

• All columns in newly-created tables are placed in the same column family by default. #13198
• Scans with a LIMIT no longer interfere with writes to rows that match the WHERE clause but were not returned due to the LIMIT. #13349
• Performance is more stable during splits. #13208
• Reduced unnecessary disk access in read-only transactions. #13367
• Reduced log spam. #13388

Bug Fixes

• Nodes now retry at startup if they are unable to allocate a node ID. #13148
• Improved gossiping of system configuration data. #13167

Doc Updates

• Added language-specific tutorials on building an app with CockroachDB.
  • The Go tutorial now covers using the Go pq driver or the GORM ORM. #1069
  • The Python tutorial now covers using the psycopg2 driver or the SQLAlchemy ORM. #1079
  • The Ruby tutorial now provides a code sample demonstrating transaction retry logic. #1068
• New documentation on the current methods of importing data into CockroachDB. #1076
• New documentation on how name resolution works in CockroachDB. #1050
• New documentation on using the EXPLAIN statement to analyze the query plan of DELETE, INSERT, SELECT, or UPDATE statements. #1073
• New FAQ on how CockroachDB is both highly available and strongly consistent without violating the CAP theorem. #1061
• Expanded documentation on simple CASE expressions and searched CASE expressions. #1036

Contributors

This release includes 132 merged PRs by 24 authors. We would like to thank the following contributor from the CockroachDB community:

• Panos Mamatsis