Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-4097

case insensitive hostname search upon graph import

XMLWordPrintable

      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

            Unassigned Unassigned
            richlv richlv
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: