---
title: What's New in v20.1.3
toc: true
summary: Additions and changes in CockroachDB version v20.1.3 since version v20.1.2
---

## June 29, 2020

This page lists additions and changes in v20.1.3 since v20.1.2.

- For a comprehensive summary of features in v20.1, see the [v20.1 GA release notes](v20.1.0.html).
- To upgrade to the latest production release of CockroachDB, see this [article](../stable/upgrade-cockroach-version.html).

Get future release notes emailed to you:

<div class="hubspot-install-form install-form-1 clearfix">
    <script>
        hbspt.forms.create({
            css: '',
            cssClass: 'install-form',
            portalId: '1753393',
            formId: '39686297-81d2-45e7-a73f-55a596a8d5ff',
            formInstanceId: 1,
            target: '.install-form-1'
        });
    </script>
</div>

### Downloads

<div id="os-tabs" class="clearfix">
    <a href="https://binaries.cockroachdb.com/cockroach-v20.1.3.darwin-10.9-amd64.tgz"><button id="mac" data-eventcategory="mac-binary-release-notes">Mac</button></a>
    <a href="https://binaries.cockroachdb.com/cockroach-v20.1.3.linux-amd64.tgz"><button id="linux" data-eventcategory="linux-binary-release-notes">Linux</button></a>
    <a href="https://binaries.cockroachdb.com/cockroach-v20.1.3.windows-6.2-amd64.zip"><button id="windows" data-eventcategory="windows-binary-release-notes">Windows</button></a>
    <a href="https://binaries.cockroachdb.com/cockroach-v20.1.3.src.tgz"><button id="source" data-eventcategory="source-release-notes">Source</button></a>
</div>

### Docker image

{% include copy-clipboard.html %}
~~~shell
$ docker pull cockroachdb/cockroach-unstable:v20.1.3
~~~


### Security updates

- HTTP endpoints beginning with `/debug/` now require a valid [`admin`](../v20.1/authorization.html) login session. [#50487][#50487]

### Enterprise edition changes

- [Full cluster restore](../v20.1/restore.html#full-cluster) is now more resilient to transient transaction retry errors during restore. [#50004][#50004]
- The default flush interval for [changefeeds](../v20.1/change-data-capture.html) that do not specify a `RESOLVED` option is now 5s instead of 200ms to more gracefully handle higher-latency sinks. [#50251][#50251]

### SQL language changes

- Previously, using `infinity` evaluated to a negative, i.e., "-292277022365-05-08T08:17:07Z". This has been fixed to be the maximum supported timestamp in PostgreSQL that is not infinity. Likewise, `-infinity` is the smallest supported value. Note this does currently does not behave exactly like `infinity` in PostgreSQL (this is a work in progress and may be resolved later). [#50365][#50365]

### Bug fixes

- Previously, `extract(epoch from timestamptz)` from a session time zone not in UTC would return a value which was incorrectly offset by the session time zone. This is now fixed. [#50075][#50075]
- Previously, the parallel importer could get stuck due to a race between emitted import batches and checking for context cancellation (either due to an unforeseen error, or due to explicit context cancallation). This is now fixed. [#50089][#50089]
- Previously, using separate groups for producer and consumer could lead to a situation where consumer would exit (due to an error, or explicit context cancellation) without the producer realizing, leading to a deadlock. Producer and consumer are now correctly linked during data import. [#50089][#50089]
- Casting to width-limited strings now works correctly for strings containing Unicode characters. [#50159][#50159]
- Fixed some cases in which casting a string to a width-limited string array was not truncating the string. [#50168][#50168]
- Fixed a bug in which restarting CockroachDB with the Pebble storage engine after a crash during write-ahead logging could, in some rare cases, return an "unexpected EOF" error. [#50282][#50282]
- Previously, the [Admin UI Statements page](../v20.1/admin-ui-statements-page.html) was incorrectly displaying information about whether or not a statement was distributed (it was always `Yes`). This is now fixed. [#50347][#50347]
- Fixed a RocksDB bug that could result in inconsistencies in rare circumstances. [#50397][#50397]
- Fixed a bug that broke the data distribution [Advanced Debug page](../v20.1/admin-ui-debug-pages.html) in the Admin UI on clusters that had upgraded from 19.2 to 20.1. [#49987][#49987]
- Previously, when a [changefeed](../v20.1/change-data-capture.html) would fail to set up its flows due to a node draining, the changefeed would be marked as failed. These errors are now retriable. [#50088][#50088]

### Performance improvements

- CockroachDB now optimizes reading of files when doing backups and storage-level compactions of files. This should deliver a performance improvement for some read-heavy operations on an IOPS-constrained device. [#50105][#50105]
- Limited [`SELECT`](../v20.1/select-clause.html) statements now do a better job avoiding unnecessary contention with [`UPDATE`](../v20.1/update.html) and [`SELECT FOR UPDATE`](../v20.1/select-for-update.html) statements. [#50119][#50119]
- Improved the [optimizer](../v19.2/cost-based-optimizer.html)'s estimation of the selectivity of some filters involving a disjunction (`OR`) of predicates over multiple columns. This results in more accurate cardinality estimation and enables the optimizer to choose better query plans in some cases. [#50470][#50470]

### Build changes

- Release Docker images are now built on Debian 9.12. [#50482][#50482]

### Doc updates

- Updated guidance on [node decommissioning](../v20.1/remove-nodes.html). [#7304][#7304]
- Added node density guidance to the [Production Checklist](../v20.1/recommended-production-settings.html#node-density-testing-configuration). [#7514][#7514]
- Renamed "whitelist/blacklist" terminology to "allowlist/blocklist". [#7535][#7535]
- Updated the Releases navigation in the sidebar to expose the latest Production and Testing releases. [#7550][#7550]
- Fixed scrollbar visibility on Chrome. [#7487][#7487]

### Contributors

This release includes 22 merged PRs by 15 authors.

[#49987]: https://github.com/cockroachdb/cockroach/pull/49987
[#50004]: https://github.com/cockroachdb/cockroach/pull/50004
[#50075]: https://github.com/cockroachdb/cockroach/pull/50075
[#50088]: https://github.com/cockroachdb/cockroach/pull/50088
[#50089]: https://github.com/cockroachdb/cockroach/pull/50089
[#50105]: https://github.com/cockroachdb/cockroach/pull/50105
[#50119]: https://github.com/cockroachdb/cockroach/pull/50119
[#50159]: https://github.com/cockroachdb/cockroach/pull/50159
[#50168]: https://github.com/cockroachdb/cockroach/pull/50168
[#50216]: https://github.com/cockroachdb/cockroach/pull/50216
[#50251]: https://github.com/cockroachdb/cockroach/pull/50251
[#50282]: https://github.com/cockroachdb/cockroach/pull/50282
[#50347]: https://github.com/cockroachdb/cockroach/pull/50347
[#50365]: https://github.com/cockroachdb/cockroach/pull/50365
[#50397]: https://github.com/cockroachdb/cockroach/pull/50397
[#50470]: https://github.com/cockroachdb/cockroach/pull/50470
[#50482]: https://github.com/cockroachdb/cockroach/pull/50482
[#50487]: https://github.com/cockroachdb/cockroach/pull/50487
[48d02125b]: https://github.com/cockroachdb/cockroach/commit/48d02125b
[#7304]: https://github.com/cockroachdb/docs/pull/7304
[#7550]: https://github.com/cockroachdb/docs/pull/7550
[#7535]: https://github.com/cockroachdb/docs/pull/7535
[#7487]: https://github.com/cockroachdb/docs/pull/7487
[#7514]: https://github.com/cockroachdb/docs/pull/7514