Project

General

Profile

Actions

Bug #24148

closed

groupBy and orderBy fails on exec_query

Added by Oguzhan Alan over 13 years ago. Updated over 13 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2010-11-20
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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)


Files

16492.diff (1.12 KB) 16492.diff Administrator Admin, 2010-12-01 00:53
Actions

Also available in: Atom PDF