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

Query non-conformant to MySQL team's recommendation

XMLWordPrintable

    • Sprint candidates
    • 0.125

      Steps to reproduce:

      1. Code: https://github.com/zabbix/zabbix/blob/release/7.0/ui/include/classes/db/MysqlDbBackend.php
      2. Line 175
      3. If ANSI Mode is enabled (to make any query more compliant), this query will break the Zabbix Front End.

      Result:

      Expected:

      I tried searching if there's anywhere else with a non-compliant SQL Query, but it seems it's only this line of code.

      To make it compliant, any `"` (double quotes) in SQL queries must be changed to `'` (single quote). And I'm pretty sure this is the only non-compliant query.

      Affected versions: 6.0, 6.4, 7.0

            zabbix.dev Zabbix Development Team
            ombr_lcalseverini Lineker Calseverini
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: