Release Notes: CockroachDB v2.1.0-beta.20180904

releasenotes

(jessica) #1

Happy Tuesday!

As mentioned last week, we have now transitioned into the CockroachDB 2.1 Beta phase and will be releasing weekly until the GA release.

Upgrade your version of CockroachDB here and let us know what you think!
 
Cheers,

The Cockroach Labs Team

Enterprise edition changes

SQL language changes

  • CockroachDB now hides more information from the statement statistics in diagnostics reporting. #28906
  • CockroachDB now preserves the distinction between different column types for string values like in PostgreSQL, for compatibility with 3rd party tools and ORMs. #29006
  • The SET CLUSTER SETTING statement can no longer be used inside a transaction. It also now attempts to wait until the change has been gossiped before allowing subsequent statements. #29082
  • The ALTER TABLE ... SPLIT AT statement now produces an error if executed while the merge queue is enabled, as the merge queue is likely to immediately discard any splits created by the statement. #29082

Command-line changes

  • Improved the error message printed when cockroach quit is run on a node that has not yet been initialized. #29152
  • The cockroach start command now emits the PID of the server process to the file specified by the --pid-file flag as soon as it is ready to accept network connections but possibly before it is done bootstrapping (i.e., before cockroach init completes). To wait for SQL readiness, use the --listen-url-file flag instead. #29160

Bug fixes

  • CockroachDB now populates the data_type column of information_schema.columns like PostgreSQL, for compatibility with 3rd party tools and ORMs. #29006
  • The cockroach dump command can once again operate across multiple CockroachDB versions. #29006
  • CockroachDB now distinguishes CHAR and VARCHAR, as mandated by the SQL standard and PostgreSQL compatibility. When a width is not specified (e.g., CHAR(3)), the maximum width of VARCHAR remains unconstrained whereas the maximum width of CHAR is 1 character. #29006
  • CockroachDB now properly checks the width of strings inserted in a collated string column with a specified width. #29006
  • Improve the handling of jobs run prior to a cluster upgrade. #29019
  • CockroachDB once again prefers using an IPv4 listen address if a hostname with both IPv4 and IPv6 addresses is provided to --host/--listen-addr/--advertise-addr. #29158
  • Fixed a memory leak when contended queries time out. #29099
  • When the --background flag is specified, the cockroach start command now avoids printing messages to standard output after it has detached to the background. #29160

Contributors

This release includes 41 merged PRs by 16 authors.