Bug #15492
closed
No support for LIMIT [PostgreSQL]
Added by Christian Welzel almost 19 years ago.
Updated over 14 years ago.
Category:
Database API (Doctrine DBAL)
Description
class.ux_t3lib_db.php::SELECTquery() does not support the rewriting of LIMIT #,# syntax. This causes a problem with postgresql because this syntax is not supported.
Postgresql needs "LIMIT # OFFSET #" instead.
(issue imported from #M2367)
Files
It doesn't, but exec_SELECTquery() does.
the problem is that some extensions like dam and chc_forum use following to do their queries:
$query = $GLOBALS['TYPO3_DB']->SELECTquery(...);
$GLOBALS['TYPO3_DB']->sql_query($query);
i would swear there are more extensions that use this scheme. and in this case, the missing LIMIT support is a real problem.
this problem with non rewritten limit clause also applies to class.tslib_pibase in line 1101. there $LIMIT is build as "##,##" and then SELECTquery is used in line 1114.
so all extensions using pi_list_query() break in this issue.
- a small reminder to fix this bug as it breaks all plugins using pi_list_query() ###
Committed to
- trunk (rev. 30269) [with unit tests]
- DBAL_1-0 (rev. 30270)
Also available in: Atom
PDF