Bug #25257
closed
Query with LIMIT does not work in ux_t3lib_db->exec_query
0%
Description
The queryParts for LIMIT get lost in exec_query (LINE 923)
$limit = isset($queryParts['LIMIT']) ? $this->SQLparser->compileWhereClause($queryParts['LIMIT']) : '';
should be for MySQL
$limit = isset($queryParts['LIMIT']) ? $queryParts['LIMIT'] : '';
Postgres may need special treatment for OFFSET part
(issue imported from #M17866)
Updated by Xavier Perseguers over 13 years ago
What is the use case for having a call to exec_query() ? This method should normally not be used.
Updated by Werner Wallmeier over 13 years ago
I didn't call it myself. exec_query is called by extbase when using a local MySQL database.
Tx_Extbase_Persistence_Storage_Typo3DbBackend->getObjectDataByQuery executes a query by calling
$result = $this->databaseHandle->sql_query($sql)
"$this->databaseHandle" is a ux_t3lib_DB object.
ux_t3lib_DB->sql_query calls mysql_query when handler type = native
Is it a extbase problem?
Updated by Alexander Opitz over 10 years ago
- Status changed from New to Needs Feedback
- Target version deleted (
0) - TYPO3 Version set to 4.5
- Is Regression set to No
Hi,
as this issue is very old. Does the problem still exists within newer versions of TYPO3 CMS (6.2.3)?
Updated by Alexander Opitz about 10 years ago
- Status changed from Needs Feedback to Closed
No feedback within the last 90 days => closing this issue.
If you think that this is the wrong decision or experience this issue again, then please write to the mailing list typo3.teams.bugs with issue number and an explanation or open a new ticket and add a relation to this ticket number.