[#ZBX-6117] {ITEM.LASTVALUE} is not correctly expanded in trigger names

[ZBX-6117] {ITEM.LASTVALUE} is not correctly expanded in trigger names Created: 2013 Jan 14 Updated: 2017 May 30 Resolved: 2013 Jan 16
Status:	Closed
Project:	ZABBIX BUGS AND ISSUES
Component/s:	Frontend (F)
Affects Version/s:	2.0.5rc1, 2.1.0
Fix Version/s:	2.0.5rc1, 2.1.0

Type:

Incident report

Priority:

Critical

Reporter:

Alexey Pustovalov

Assignee:

Unassigned

Resolution:

Fixed

Votes:

Labels:

regression

Remaining Estimate:

Not Specified

Time Spent:

Not Specified

Original Estimate:

Not Specified

Environment:

Issue happens only on ORACLE backend!!

Issue Links:

Duplicate

Description

It happens because $item['new_value'] is not null in Oracle database in resolveItemLastvalueMacro function.

Comments

Comment by Eduards Samersovs (Inactive) [ 2013 Jan 15 ]

When we read varchar value from Oracle we don't now why represent it as empty string not a NULL.
DBfetch() line:586
$value = (str_in_array($field_type, array('varchar', 'varchar2', 'blob', 'clob')) && is_null($value)) ? '' : $value;

Comment by Eduards Samersovs (Inactive) [ 2013 Jan 15 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-6117

Comment by Pavels Jelisejevs (Inactive) [ 2013 Jan 16 ]

TESTED.

Comment by Eduards Samersovs (Inactive) [ 2013 Jan 16 ]

Fixed in versions pre-2.1.0 (beta) r32811, pre-2.0.5rc1 r32810

Generated at Fri Apr 26 13:57:16 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.

[ZBX-6117] {ITEM.LASTVALUE} is not correctly expanded in trigger names Created: 2013 Jan 14 Updated: 2017 May 30 Resolved: 2013 Jan 16