Use of rownum in DBselect PHP function for Oracle

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Minor
    • None
    • Affects Version/s: 2.0.3
    • Component/s: Frontend (F)
    • Environment:
      Oracle 11g

      function DBselect has a line such as this:

      $query = 'SELECT * FROM ('.$query.') WHERE rownum BETWEEN '.intval($offset).' AND '.intval($till);

      This is supposed to be imitating LIMIT, but could return no rows when lower bound is > 1.

      http://www.oracle.com/technetwork/issue-archive/2006/06-sep/o56asktom-086197.html

            Assignee:
            Unassigned
            Reporter:
            Mikhail Dobrinin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: