Exception with RemoveDuplicateSysCategoryRecordMms when ONLY_FULL_GROUP_BY is set

[Oktopuce]

With TYPO3 V13, if you run the upgrade wizard, you have this exception if sql_mode=only_full_group_by.

#1055 Doctrine\DBAL\Exception\DriverException

An exception occurred while executing a query: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'uccife.sys_category_record_mm.sorting' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

You are getting this exception because you are trying to execute a query with a GROUP BY clause that does not contain all selected fields and sql_mode=only_full_group_by.

The exception is thrown in file RemoveDuplicateSysCategoryRecordMms, method updateNecessary():

$statement = $queryBuilder->count('*')
  ->addSelect('uid_local', 'uid_foreign', 'tablenames', 'fieldname', 'sorting', 'sorting_foreign')
  ->from('sys_category_record_mm')
  ->groupBy('uid_local', 'uid_foreign', 'tablenames', 'fieldname')
  ->having('COUNT(*) > 1')
  ->executeQuery();

the request must be changed like this:

$statement = $queryBuilder->count('*')
  ->addSelect('uid_local', 'uid_foreign', 'tablenames', 'fieldname', 'sorting', 'sorting_foreign')
  ->from('sys_category_record_mm')
  ->groupBy('uid_local', 'uid_foreign', 'tablenames', 'fieldname', 'sorting', 'sorting_foreign')
  ->having('COUNT(*) > 1')
  ->executeQuery();

This must also be changed in method executeUpdate().