Project

General

Profile

Actions
Copy link

Bug #15535

closed

SELECT COUNT(DISTINCT(xxx)) produces wrong field name

Added by MarcelGsteiger over 18 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Karsten Dambekalns
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2006-01-29
Due date:
% Done:

0%

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

Description

The DBAL translates the above mentioned request to

SELECT COUNT`)

instead of

SELECT COUNT)

This problem leads to a malfunction in the tt_news extension.

Regards
--Marcel

(issue imported from #M2438)

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Bug #16710: COUNT(DISTINCT col) only works when the column is prefixed with the table nameClosedKarsten Dambekalns2006-11-10

Actions
Actions
Copy link
 #1

Updated by Martin Kutschker over 17 years ago

I think this can be closed as COUNT) seems to be standard SQL and is supported by DBAL.

Actions
Copy link
 #2

Updated by Karsten Dambekalns almost 17 years ago

Is fixed according to my memory and #4496.

Actions
Copy link
 #3

Updated by Karsten Dambekalns almost 17 years ago

Checked this, it is not fixed.

Actions
Copy link
 #4

Updated by Karsten Dambekalns almost 17 years ago

Works now (fixed in SVN), but be aware that DISTINCT is not a function, so don't use parentheses.

Actions
Copy link

Also available in: Atom PDF