Project

General

Profile

Actions
Copy link

Bug #22115

closed

DISTINCT should not be used as a function

Added by Xavier Perseguers almost 15 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Xavier Perseguers
Category:
-
Target version:
-
Start date:
2010-02-13
Due date:
% Done:

0%

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

Description

While working on #22114, I searched in Core if DISTINCT keyword in query was sometimes wrongly written as a function:

SELECT DISTINCT

instead of the valid definition:

SELECT DISTINCT field

which happens quite often in extensions and is not detected as long as DBAL is not used as MySQL silently understands it anyway.

(issue imported from #M13529)

Files

13529.diff (1.04 KB) 13529.diff Administrator Admin, 2010-02-13 11:19
Actions
Copy link

Also available in: Atom PDF