https://bugzilla.wikimedia.org/show_bug.cgi?id=17028
Roan Kattouw <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #6 from Roan Kattouw <[email protected]> 2009-01-14 23:01:43 UTC --- (In reply to comment #5) > LIMIT isn't standard. DB2 has a FETCH FIRST 10 ROWS ONLY statement. SQL Server > has a SELECT TOP 10 statement. Oracle has nothing built-in, but LIMIT can be > approximated using nested selects and a row number function in the inner one. > > The MediaWiki database API has a limitResult($sql, $limit, $offset) function > that works around most of these issues, but only if it's used.:-) > Can't you just rewrite LIMIT 50 to FETCH FIRST 50 ROWS ONLY transparently, like DatabaseMySQL rewrites USE INDEX(foo) to FORCE INDEX(foo) ? -- 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
