ZF2 Paginator Does Not Work with DB2

[kingharrison]

ZF2's Paginator does not currently work with DB2 because DB2 does have the Limit or Offset commands. The Paginator would need to have DB2 specific adaptions so that any ZF2 user could use standard commands.

[ralphschindler]

Can you provide a sample of the ideal paging SQL for DB2?

[kingharrison]

Here's a sample:
SELECT code, name, address
FROM (
SELECT row_number() OVER ( ORDER BY code ) AS rid, code, name, address
FROM contacts
WHERE name LIKE '%Bob%'
) AS t
WHERE t.rid BETWEEN 20 AND 25
FETCH FIRST 6 ONLY OPTIMIZE FOR 6 ROWS;

The last part,
FETCH FIRST 6 ONLY OPTIMIZE FOR 6 ROWS,
is somewhat optional, for performance.

[ezimuel]

@kingharrison I'm working on it, see #6446

[kingharrison]

@ezimuel Thank you!

[kingharrison]

Woohoo!