[bug]DBtable: history.value

[scotti]

Hi,
I'm using zbx-1.1.7, Mysql-4.0.24
Those days I'm using web.page.perf to detect Java GC exception, but I found that there are some inaccurate alerts from zabbix, when I use zabbix_get, I found that It was caused by inappropriate DB setting:

CREATE TABLE history (
  itemid                int(4)          DEFAULT '0' NOT NULL,
  clock                 int(4)          DEFAULT '0' NOT NULL,
  value                 double(16,4)    DEFAULT '0.0000' NOT NULL,
--  PRIMARY KEY (itemid,clock)
  KEY itemidclock (itemid, clock)
) type=InnoDB;

while a returned value is less than 0.0001, an error alert may be generated by trigger: {HOST:web.page.perf[PARAMETER].last(0)}=0