Issue Bug Closed

#95045Double field sorting with different sort direction breaks on mssql

Stefan Bürk 08/31/21, 07:45 updated 09/07/21, 07:31

Description

Determistic sorting for impexp breaks mssql.

There was 1 error:
1) TYPO3\CMS\Impexp\Tests\Functional\ImportExportTest::importExportPingPongSucceeds
Doctrine\DBAL\Exception: An exception occurred while executing 'SELECT * FROM [sys_log] WHERE [pid] = ? ORDER BY [uid] DESC, [uid] ASC' with params [1]:
SQLSTATE [42000, 169]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.

Reviews 2