Hi,

there is a bug in a SQL query:

1. sed -n 380,385p zabbix-1.8.4/src/libs/zbxserver/evalfunc.c
   offset = zbx_snprintf(sql, sizeof(sql),
   "select count(value)"
   " from %s"
   " where itemid=" ZBX_FS_UI64,
   get_table_by_value_type(item->value_type),
   item->itemid);

Select queries with 'count(value)' won't work when column 'value' is of any kind of 'LOB' datatypes:

select count(value) from history_text where itemid=26212 and clock<=1301417122 and clock>1301417122
ORA-00932: inconsistent datatypes: expected - got NCLOB

Changing the query to 'count' would work but may result in a different result set. Adding a condition for LOB columns could be a solution.