From f73a9ebdb7a4e76deb8d2c5f2f3b2f41d9030878 Mon Sep 17 00:00:00 2001 From: alex Date: Tue, 27 Nov 2007 11:10:59 +0000 Subject: - [DEV-84] fixed previous commit (Alexei) git-svn-id: svn://svn.zabbix.com/trunk@5106 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- src/libs/zbxdbhigh/db.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src') diff --git a/src/libs/zbxdbhigh/db.c b/src/libs/zbxdbhigh/db.c index 22c47fd5..3d914cb5 100644 --- a/src/libs/zbxdbhigh/db.c +++ b/src/libs/zbxdbhigh/db.c @@ -311,7 +311,7 @@ void get_latest_event_status(zbx_uint64_t triggerid, int *prev_status, int *late triggerid); /* Object and objectid are used for efficient sort by the same index as in wehere condition */ - zbx_snprintf(sql,sizeof(sql),"select eventid,value,clock,object,objectid from events where source=%d and object=%d and objectid=" ZBX_FS_UI64 " order by object desc,objectid desc,clock desc", + zbx_snprintf(sql,sizeof(sql),"select eventid,value,clock,object,objectid from events where source=%d and object=%d and objectid=" ZBX_FS_UI64 " order by object desc,objectid desc,eventid desc", /* The SQL is inefficient */ /* zbx_snprintf(sql,sizeof(sql),"select eventid,value,clock from events where source=%d and object=%d and objectid=" ZBX_FS_UI64 " order by clock desc",*/ EVENT_SOURCE_TRIGGERS, -- cgit