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

Add nanoseconds order to request

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 2.4.5, 2.4.6
    • Frontend (F)

      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

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

              Created:
              Updated: