Project

General

Profile

Actions
Copy link

Bug #24148

closed

groupBy and orderBy fails on exec_query

Added by Oguzhan Alan about 14 years ago. Updated almost 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Xavier Perseguers
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
Copy link
 #1

Updated by Xavier Perseguers almost 14 years ago

According to code found in compileSelectParameters(), you're right!

Actions
Copy link
 #2

Updated by Xavier Perseguers almost 14 years ago

Committed to:

- DBAL trunk (rev. 40690)
- DBAL_1-1 (rev. 40691)

thanks for pointing out and your "patch".

Actions
Copy link

Also available in: Atom PDF