spadefoot/kohana-orm-leap — Issue #15: Oracle LIMIT and OFFSET $max_row_to_fetch problem
Author: ekarlso
Created: 2012-01-23 13:18:43+00:00
State: open

If you use this and set $select->offset(10) and then $select->limit(10) it will gives you 1 row to many ?!

string(238) "SELECT * FROM (SELECT "t0".*, ROWNUM AS "rn" FROM (SELECT * FROM "DB_COPY" ORDER BY "STATUS" ASC) "t0" WHERE ROWNUM <= 11) WHERE "rn" >= 1;
Total Pages: 72
Total Rows: 712
Requested Page: 1
Per Page:10
From Row: 1