Release Notes for CockroachDB v19.1.2

Hey folks,

With the release of CockroachDB v19.1.2, we’ve added enterprise edition changes, security improvements, and fixed bug issues. Test out the latest release here.

Release Notes for June 17, 2019

Enterprise edition changes

  • You can now alter the zone configuration for a secondary index partition using the syntax ALTER PARTITION OF INDEX <tablename>@<indexname> CONFIGURE ZONE .... #36883

Bug fixes

  • CockroachDB now computes the result of shifting bit arrays to the right properly and avoids generating invalid bit arrays. #36751
  • SHOW ZONE CONFIGURATION no longer emits invalid ALTER syntax in its output when displaying the zone configuration for a table or index partition that is inheriting from the database or the default configuration. #36883
  • SHOW ZONE CONFIGURATION FOR TABLE t PARTITION p no longer ignores the clause PARTITION p and now properly displays the zone configuration for that partition instead. #36883
  • Automated table statistics no longer encounter "batch timestamp must be after replica GC threshold" errors on configurations with low TTL. #37588
  • Fixed type inference of columns in subqueries for some expressions of the form scalar IN (subquery). #37598
  • Fixed a panic when constructing the error message for an invalid partitioning. #37703
  • Fixed a potential source of (faux) replica inconsistencies that can be reported while running a mixed v19.1 / v2.1 cluster. This error (in that situation only) is benign and can be resolved by upgrading to the latest v19.1 patch release. Every time this error occurs a "checkpoint" is created which will occupy a large amount of disk space and which needs to be removed manually (see <store directory>/auxiliary/checkpoints). #37722
  • Fixed a case in which cockroach quit would return success even though the server process was still running in a severely degraded state. #37722
  • Fixed incorrect results or "incorrectly ordered stream" errors in response to some queries with aggregations, and improved the EXPLAIN output for aggregations. #37792
  • A null right operand now causes the sub-operator expression to return null. #37886
  • The age() function is now correctly marked as impure, causing it to be unavailable in certain contexts. #37922
  • Certain binary encodings of numeric/decimal values no longer result in values that are an order of magnitude off. #37921
  • Fixed a race condition that could cause a panic during query planning. #37974
  • Fixed GROUP BY for empty arrays. #37940
  • Fixed a bug when estimating result set sizes in the optimizer that caused queries involving very large integer ranges to have poor plans. #38038
  • The cockroach command line utilities that internally use a RPC connection (e.g. cockroach quit, cockroach init, etc.) once again properly support passing an IPv6 address literal via the --host argument. #37982
  • The cockroach init command will now always properly report when a cluster is already initialized, even after the node that it's connecting to is restarted. #37593

Security improvement

  • Stack memory used by CockroachDB is now marked as non-executable, improving security and compatibility with SELinux. #38011

Contributors

This release includes 25 merged PRs by 18 authors. We would like to thank the following contributors from the CockroachDB community:

  • Simo Kinnunen (first-time contributor)