What's New in v19.2.0-rc.2

October 28, 2019

Get future release notes emailed to you:

Thanks!

Downloads

Docker image

$ docker pull cockroachdb/cockroach-unstable:v19.2.0-rc.2

General changes

• Go 1.12.10 is now required to build CockroachDB from source. #41647
• Named ports in URLs are no longer supported due to a URL parsing security fix in Go 1.12.8. Use port numbers instead. #41647

SQL language changes

• Mutations under UNION or UNION ALL are once again supported. #41500
• Added new skip and nullif options for IMPORT ... DELIMITED DATA, which ignore the specified number of lines at the beginning of the file and force all empty string fields to be inserted as NULL in the imported table, respectively. #41656
• It is no longer possible to use IMPORT INTO with an interleaved table. This restriction is temporary and will be lifted in a future release. #41651
• IMPORT is no longer allowed during a rolling upgrade. #41733

Bug fixes

• Fixed multiple bugs relating to COPY FROM PARENT in replication zones. #41677
• The system.replication_stats table no longer incorrectly shows some ranges belonging to table partitions as over-replicated. #41700
• Fixed a bug that resulted in some queries returning an "index join must be against primary index" error. #41723
• Fixed a bug where backfills could lead to certain changefeed row updates never being emitted. #41721
• Fixed a bug that could cause changefeed row updates to be emitted at a timestamp less than or equal to an already forwarded resolved timestamp. #41714
• Fixed a bug in cloud storage sink file naming for changefeeds that could violate ordering in the presence of schema changes. #41693

Performance improvements

• Increased BACKUP parallelism in some cases. #41729
• Improved the performance of generating the system.replication_* tables for large clusters. #41757
• Improved performance of bulk ingestion. #41768

Doc updates

• Clarified that to upgrade to the next major version upgrade path for rolling upgrades, a cluster must be on a production release of the previous version, as opposed to a testing release (alpha/beta). #5644
• Documented the experimental SHOW RANGE FOR ROW statement, which shows information about a range for a particular row of data. This information is useful for verifying how SQL data maps to underlying ranges, and where the replicas for a range are located. #5612
• Improved the usability of the tutorial on deploying a Python To-Do app with Flask, Kubernetes, and CockroachCloud. #5694
• Updated Helm-specific instructions for Kubernetes version 1.16.0 and fixed various errors. #5657, #5659
• Documented the FOR UPDATE locking clause, which is supported in selection queries for database migration compatibility. #5658
• Documented using timezone() and AT TIME ZONE functions to convert a TIMESTAMPTZ into a TIMESTAMP, or vice versa, in a specified timezone. #5614
• Clarified the required privileges for the CONFIGURE ZONE statement. #5609

Contributors

This release includes 32 merged PRs by 19 authors.

Was this helpful?