Project

General

Profile

Actions
Copy link

Bug #17918

closed

Mapping of fieldnames in SQL-functions like MIN(), MAX() or SUM() does not work

Added by Christian Trabold almost 17 years ago. Updated about 15 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Xavier Perseguers
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2007-12-14
Due date:
% Done:

0%

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

Description

If you use SQL-Functions like MIN, MAX or SUM in SQL-Queries the fieldmapping does not work. Example:

SELECT tstamp, script, SUM as calc_sum, count(*) AS qrycount, MAX as error FROM tx_dbal_debuglog

will produce

SELECT tstamp, script, SUM as calc_sum, count(*) AS qrycount, MAX as error FROM tx_dbal_debuglog

even if the mapping for the field "errorFlag" would be "errorflag" (with a small f).

This gets problematic if your database supports only lowercase fieldnames and the fieldname has upper-case letters (eg. tx_dbal_debuglog:errorFlag), because the field can not be found, which results in an error message.

With the attached patch the DBAL knows how to handle fieldnames inside SQL-Functions and maps it correctly to the desired value.

The patch adds a new condition in class.ux_t3lib_db.php->map_sqlParts() which checks for content in "func_content". If a mapping instruction for "func_content" can be found, the mapping will be processed.

Tested on Postgres 8.1.10 with DBAL 0.9.20 on TYPO3 4.1.2
(issue imported from #M6953)

Files

Download all files
class.ux_t3lib_db.php.patch (840 Bytes) class.ux_t3lib_db.php.patch Administrator Admin, 2007-12-14 14:59
bug_6953_trunkrevision_4432.patch (1.34 KB) bug_6953_trunkrevision_4432.patch Administrator Admin, 2009-02-12 14:52
bug_6953_trunkrevision_24646.patch (1.62 KB) bug_6953_trunkrevision_24646.patch Administrator Admin, 2009-09-25 14:22
bug_6953_v4.diff (1.77 KB) bug_6953_v4.diff Administrator Admin, 2009-10-05 19:08
Actions
Copy link

Also available in: Atom PDF