Review TYPO3_8-7 Merged

54308[BUGFIX] Do not GROUP BY alias in WorkspaceService

Christian Kuhn CR +2 V +2 Easy +1 −1 updated 10/06/17, 10:53

Commit message

GROUP BY statements are in general evaluated before
SELECT statements. If a DBMS does not implement additional
logic to resolve aliases defined in SELECTS before grouping
the statement will fail. Currently both MSSQL as well as ORACLE
lack these additional implementations. To be safe we should
group by the non-aliased columns.

Review

  • Code review CR +2

    Imported before Forger kept the single votes, the next import adds them.

  • Verified V +2

    Imported before Forger kept the single votes, the next import adds them.

Issues 1

Files 1