-
Incident report
-
Resolution: Unresolved
-
Trivial
-
None
-
2.4.5, 2.4.6
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