Bug in function evaluate_COUNT()

[BDiE8VNy]

Hi,

there is a (presumable Oracle dependent) bug in a SQL query:

# sed -n 380,385p zabbix-1.8.4/src/libs/zbxserver/evalfunc.c
		offset = zbx_snprintf(sql, sizeof(sql),
				"select [B]count(value)[/B]"
				" 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

[Gomex]

Report bug

It should be reported as bug:

https://support.zabbix.com/browse/ZBX

[BDiE8VNy]

https://support.zabbix.com/browse/ZBX-3671

[Gomex]

good job!

Now, just wait some response