Skip to main content
Publication date: March 9, 2022

​
Description

The optimizer can omit ON conditions of joins in query plans, causing incorrect results. The bug has only been observed when queries contained 4 or more joins, but it is possible that queries with fewer joins could be affected. The bug is present in CockroachDB v20.2, v21.1, and v21.2. This issue is fixed in and v21.2.7.

​
Statement

The fix has been applied to maintenance versions and v21.2.7 of CockroachDB.

​
Mitigation

Users of CockroachDB are encouraged to upgrade to a maintenance version with the fix applied.

​
Impact

All deployments up to v20.2.19, v21.1.15, and v21.2.6 are affected. Queries with joins could return incorrect results in rare cases. The bug has only been observed when queries contained 4 or more joins, but it is possible that queries with fewer joins could be affected. Questions about any technical alert can be directed to our support team.