Bug #25257
closed
Query with LIMIT does not work in ux_t3lib_db->exec_query
Added by Werner Wallmeier over 13 years ago.
Updated about 10 years ago.
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)
What is the use case for having a call to exec_query() ? This method should normally not be used.
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?
- 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)?
- 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.
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by