What's New in v2.1.0-beta.20181015

October 15, 2018

Get future release notes emailed to you:

Thanks!

Downloads

SQL language changes

• The output of SHOW JOBS now reports ongoing jobs first in start time order, followed by completed jobs in finished time order. #31005
• CockroachDB now supports more customizations from PostgreSQL client drivers when initially setting up the client connection. #31021
• Columns that are part of a table's PRIMARY KEY can no longer be specified as STORING columns in secondary indexes on the table. #31032
• The output of SHOW ZONE CONFIGURATIONS and SHOW ZONE CONFIGURATION FOR now only shows the zone name and the SQL representation of the config. #31089

Command-line changes

• It is now possible to provide initial/default values for any customizable session variable in the client connection URL. #31021

Admin UI changes

• Leveraged PopperJS positioning engine to automate the positioning of tooltips. #30476
• Added a graph of the average QPS per store to the Replication dashboard. Note that this uses an exponentially weighted moving average, not an instantaneous measurement. It is primarily of interest because it's the data that's used when making load-based rebalancing decisions. #30889
• Added a bar chart to the memory and capacity usage columns on the Node List. These columns sort by percentage used. #31070
• Added a debug page with a form that lets users manually enqueue a range in one of the various store-level replica queues on a specified store. This feature is intended for advanced users only. #31092

Bug fixes

• Lookup joins no longer omit rows in certain circumstances during limit queries. #30836
• Fixed a panic due to malformed placeholder values. #30860
• The cockroach start command now prints a hint about waiting for a join or cockroach init only when starting nodes for a new cluster, not when adding nodes to an existing cluster. #30953
• Fixed a possible crash when using filters with <tuple> IN <tuples> expressions. #30968
• Prevented an edge case in load-based rebalancing where the cluster could transfer the lease for a range to a replica that isn't keeping up with the other replicas, causing brief periods where no replicas think they're leaseholder for the range and thus no requests can be processed for the range. #30972
• CockroachDB now properly ignores non-alphanumeric characters in encoding names passed to functions like convert_from() and client_encoding(), for compatibility with PostgreSQL. #31021
• CockroachDB now properly recognizes the value of extra_float_digits provided by clients as a connection parameter. #31021
• CockroachDB now properly recognizes two-part values for the DateStyle session variable and connection parameter, for compatibility with PostgreSQL. #31021
• CockroachDB now reports all server status parameters supported by PostgreSQL when setting up a session. This is expected to improve compatibility with some drivers. #31021
• CockroachDB now properly uses the client-provided default values when using the RESET statement (or SET ... = DEFAULT). #31021
• CockroachDB now properly fills the columns boot_val and reset_val in pg_catalog.pg_settings, for better compatibility with PostgreSQL. #31021
• CockroachDB now properly supports renaming a column that's also stored in an index. #31074
• During password login, "user does not exist" and "invalid password" cases now produce the same error message. #30935

Performance improvements

• CockroachDB now avoids acquiring an exclusive lock when checking replica status in the write proposal path. #30920

Doc updates

• Added a tutorial demonstrating essential performance tuning tutorial techniques for getting fast reads and writes in CockroachDB, starting with a single-region deployment and expanding into multiple regions. #3854
• Added a tutorial demonstrating the importances of serializable transactions. #3844
• Added documentation on index name resolution. #3830.
• Updated the documentation on set-returning functions (SRFs). #3810
• Update the example on how auto-incrementing is not always sequential. #3832

Contributors

This release includes 40 merged PRs by 19 authors.