Issue Bug Closed

#24148groupBy and orderBy fails on exec_query

Oguzhan Alan 11/20/10, 18:02 updated 01/31/11, 16:09

Description

dbal/lib/class.ux_t3lib_db.php

LINE 827:
$groupBy = isset($queryParts[‘GROUPBY’]) ? $this->SQLparser->compileWhereClause($queryParts[‘GROUPBY’]) : ‘’;

SHOULD BE:
$groupBy = isset($queryParts[‘GROUPBY’]) ? $this->SQLparser->compileFieldList($queryParts[‘GROUPBY’]) : ‘’;

LINE 828:
$orderBy = isset($queryParts[‘GROUPBY’]) ? $this->SQLparser->compileWhereClause($queryParts[‘ORDERBY’]) : ‘’;

SHOULD BE:
$orderBy = isset($queryParts[‘ORDERBY’]) ? $this->SQLparser->compileFieldList($queryParts[‘ORDERBY’]) : ‘’;

group or order by wont work on native
(issue imported from #M16492)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.