# Technical Advisory 76522

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 v21.1.16 and v21.2.7.

## Statement

This issue is resolved in CockroachDB by #76334. The fix has been applied to maintenance versions v21.1.16 and v21.2.7 of CockroachDB.

This public issue is tracked as #76522.

## 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.