-
Incident report
-
Resolution: Fixed
-
Minor
-
1.8.15
when importing graphs, frontend does something like :
SELECT DISTINCT i.itemid FROM items i,hosts h WHERE ((i.itemid BETWEEN 000000000000000 AND 099999999999999)) AND ( (i.key_ IN ('network[3]')) ) AND h.hostid=i.hostid AND (h.host IN ('Template_Windows2')) LIMIT 1 OFFSET 0
SELECT DISTINCT i.*,h.host FROM items i,hosts h WHERE ((i.itemid BETWEEN 000000000000000 AND 099999999999999)) AND ( (i.key_ IN ('network[3]')) ) AND h.hostid=i.hostid AND UPPER(h.host)='TEMPLATE_WINDOWS2'
the second query seems useless given that host names are supposed to be case sensitive