Release notes for v19.2.1

Hi all,

Yesterday we released v19.2.1. Included in this release you will find SQL language changes, command-line changes, bug fixes and performance improvements.

To download the release click here.

Release Notes for November 25, 2019

SQL language changes

Command-line changes

  • When restarting a node, CockroachDB now provides a hint to ensure that all cockroach start commands include the --join flag. #42325

Bug fixes

  • Reduced the likelihood of out-of-memory errors during histogram collection. #42370
  • Fixed an out-of-memory error that could occur when collecting statistics on tables with a string index column. #42380
  • Fixed some casts from OID to TEXT. #42257
  • OUTER HASH joins are now executed correctly via the vectorized engine when NULL values are present. #42438
  • Fixed a bug in the crdb_internal.encode_key() built-in function that could cause SHOW RANGE FOR ROW statements on tables with dropped indexes to return incorrect results or an error. #42461
  • Prevented memory leaks when counting rows during BACKUP. #42535

Performance improvements

  • The ./cockroach debug check-store command is now faster. #42150
  • Improved statistics estimation during query planning for columns with many NULL values. #42436

Contributors

This release includes 12 merged PRs by 8 authors.