When you execute a query using the RIGHT JOIN syntax, SQL does two things: It returns all of the records from both tables that contain matching values, as defined by the ON clause.

When I looked at CockroachDB 1.1.3 at the beginning of 2018, its SQL JOIN implementation was limited to hash joins and a heuristic planner; its query performance often scaled linearly but was ...