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

case insensitive hostname search upon graph import

    Details

      Description

      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

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: