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

Add nanoseconds order to request

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Open
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 2.4.5, 2.4.6
    • Fix Version/s: None
    • Component/s: Frontend (F)

      Description

      Need to add nanoseconds column to order in request "last data" items.

      now request is:
      SELECT h.* FROM history_uint h WHERE h.itemid='123' AND h.clock>='1441031585' AND h.clock<='1441035195' ORDER BY h.itemid DESC,h.clock DESC LIMIT 1000 OFFSET 0

      but mast be:
      SELECT h.* FROM history_uint h WHERE h.itemid='123' AND h.clock>='1441031585' AND h.clock<='1441035195' ORDER BY h.itemid DESC,h.clock DESC,h.ns DESC LIMIT 1000 OFFSET 0

      it critical if item get more than one value per second
      p.s. and ordering by h.itemid not needed

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            tor Max
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: