Actions
Bug #17117
closed
Allow empty $from_table in SELECTquery()
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2007-03-13
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
4.1
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
The following query will fail:
$TYPO3_DB->exec_SELECTquery( 'SELECT 1', '', '');
because it builds a query like:
SELECT DATE_FORMAT( SUBDATE, "%d.%m.%Y" );
FROM
The above example is kind of stupid, but it can make sense to use queries without a table, e.g. when using MySQL for date handling.
The attached patch will handle an empty $from_table correctly, by omitting the "FROM".
(issue imported from #M5215)
Files
Updated by
Actions