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

The Views join plugin configuration operator property is now used correctly. Previously, the operator was ignored and an equals, =, was always used.
If you want the join to keep using the = operator, remove the operator setting from your join configuration since this defaults to using =.

For example, in this Views join plugin configuration the operator is "<>".

    $configuration = [
      'left_table' => 'views_test_data',
      'left_field' => 'uid',
      'table' => 'users_field_data',
      'field' => 'uid',
      'adjusted' => TRUE,
      'operator' => '<>',
    ];

Previously, the resulting query was 

SELECT 
FROM
{views_test_data} "views_test_data"
LEFT JOIN {users_field_data} "users_field_data" ON views_test_data.uid = users_field_data.uid

And now the resulting query is

SELECT 
FROM
{views_test_data} "views_test_data"
LEFT JOIN {users_field_data} "users_field_data" ON views_test_data.uid <> users_field_data.uid
Impacts: 
Module developers