Add nanoseconds order to request

XMLWordPrintable

    • Type: Incident report
    • Resolution: Unsupported version
    • Priority: Trivial
    • None
    • Affects Version/s: 2.4.5, 2.4.6
    • Component/s: 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

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

              Created:
              Updated:
              Resolved: