Bug #15492
closed
No support for LIMIT [PostgreSQL]
0%
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
Updated by Karsten Dambekalns almost 19 years ago
It doesn't, but exec_SELECTquery() does.
Updated by Christian Welzel almost 19 years ago
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.
Updated by Christian Welzel almost 19 years ago
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.
Updated by Christian Welzel over 18 years ago
- a small reminder to fix this bug as it breaks all plugins using pi_list_query() ###
Updated by Xavier Perseguers over 14 years ago
Committed to
- trunk (rev. 30269) [with unit tests]
- DBAL_1-0 (rev. 30270)