What's New in beta-20170209

Feb 9, 2017

Get future release notes emailed to you:


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 placeholder 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


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

  • Panos Mamatsis
YesYes NoNo