https://bugzilla.wikimedia.org/show_bug.cgi?id=18863
Summary: SELECT ... LIMIT fails on PostgreSQL
Product: MediaWiki extensions
Version: any
Platform: All
OS/Version: All
Status: NEW
Keywords: patch, postgresql
Severity: minor
Priority: Normal
Component: NewestPages
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=6142)
--> (https://bugzilla.wikimedia.org/attachment.cgi?id=6142)
Rewrite LIMIT #,# to LIMIT # OFFSET #
The current SELECT statement fails on PostgreSQL since it doesn't support LIMIT
#,#, but both MySQL and PostgreSQL do support LIMIT # OFFSET #. The patch
attached should make the SELECT statement work with both MySQL and PostgreSQL.
http://dev.mysql.com/doc/refman/5.1/en/select.html
http://www.postgresql.org/docs/8.3/static/sql-select.html
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
