By daffie on
Change record status: 
Published (View all published change records)
Project: 
Drupal core
Introduced in branch: 
8.2.x
Introduced in version: 
8.2.0
Issue links: 
https://www.drupal.org/node/2011500
Description: 

SelectInterface::rightJoin() creates SQL right outer joins, but SQLite does not support right outer joins. Right outer joins are not used in Drupal core. Any contrib module that uses this functionality will not work with a SQLite database. SelectInterface::rightJoin() is deprecated in 8.2.x for this reason.

There is a workaround: 

db_query('A')->rightJoin('B')

can easily be rewritten to
db_query('B')->leftJoin('A')

Impacts: 
Module developers