Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-5843

Use of rownum in DBselect PHP function for Oracle

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Minor Minor
    • None
    • 2.0.3
    • Frontend (F)
    • 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

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

              Created:
              Updated:
              Resolved: