empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rainer Döbele (JIRA) <empire-db-...@incubator.apache.org>
Subject [jira] [Created] (EMPIREDB-192) Implement limitRows and skipRows for Oracle
Date Fri, 13 Sep 2013 10:34:51 GMT
Rainer Döbele created EMPIREDB-192:

             Summary: Implement limitRows and skipRows for Oracle
                 Key: EMPIREDB-192
                 URL: https://issues.apache.org/jira/browse/EMPIREDB-192
             Project: Empire-DB
          Issue Type: Improvement
    Affects Versions: empire-db-2.4.2
            Reporter: Rainer Döbele
            Assignee: Rainer Döbele

Currently only limitRows is supported for Oracle with the limitation of a potentially incorrect
order of the rows.
Properly implement limitRows and skipRows by wrapping the select command like follows:
for limit rows only:
  SELECT .... ORDER BY ...
) row_ WHERE rownum<={limit}

for limitRows and skipRows:
SELECT * FROM (SELECT row_.*, rownum rownum_ FROM (
)) row_ WHERE rownum<={skip+limit}) WHERE rownum_>{skip}

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

View raw message