[BUGFIX] Add sorting to group by for SQL compatibility 74/53674/2
authorSusanne Moog <susanne.moog@typo3.com>
Fri, 11 Aug 2017 08:16:01 +0000 (10:16 +0200)
committerAndreas Fernandez <typo3@scripting-base.de>
Fri, 11 Aug 2017 09:19:13 +0000 (11:19 +0200)
commit4ae10c81e81ce3a3d95f8a36c25109fef226ff0d
tree2220ce40d0f4b7319c4e4b98a3b6903d21e0cee3
parent929c02c7fc6b4d0740f823e5a3a876d01fb9a081
[BUGFIX] Add sorting to group by for SQL compatibility

Page module, view module and edit document selected data
with an incomplete group by statement, missing the sorting
column. This resulted in an error on mssql servers.

The sorting field was added to the relevant queries.

Change-Id: If1fb314542e0f27cdf18989fa2b8427c1e31e2d3
Resolves: #79298
Releases: master, 8.7
Reviewed-on: https://review.typo3.org/53674
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Joerg Boesche <typo3@joergboesche.de>
Tested-by: Joerg Boesche <typo3@joergboesche.de>
Reviewed-by: Christian Kuhn <lolli@schwarzbu.ch>
Tested-by: Christian Kuhn <lolli@schwarzbu.ch>
Reviewed-by: Andreas Fernandez <typo3@scripting-base.de>
Tested-by: Andreas Fernandez <typo3@scripting-base.de>
typo3/sysext/backend/Classes/Controller/EditDocumentController.php
typo3/sysext/backend/Classes/Controller/PageLayoutController.php
typo3/sysext/viewpage/Classes/Controller/ViewModuleController.php