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

Filtering by name doesn't work in mysql for some special character such as ȼ

XMLWordPrintable

    • Sprint 104 (Sep 2023), Sprint 105 (Oct 2023), Sprint candidates
    • 1

      Steps to reproduce:

      1. Go to Configuration -> Maintenance (or other)
      2. Create new maintenance with name ȼ or ɇ (probably some others)
      3. Type ȼ in filter name field
      4. Apply filter

      Result:
      No data found
      Expected: found maintenance by name

      If you look in debug, the sql query has the character in upper case, maybe this is the problem:

      SQL (0.000298): SELECT m.maintenanceid,m.name,m.maintenance_type,m.active_since,m.active_till,m.description FROM maintenances m WHERE ((UPPER(m.name) LIKE '%Ȼ%' ESCAPE '!')) ORDER BY m.maintenance_type DESC LIMIT 1001
zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerMaintenanceList->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMaintenance->get() → DBselect() in include/classes/api/services/CMaintenance.php:232

            zabbix.dev Zabbix Development Team
            natalja.zabbix Natalja Romancaka
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: