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

    • S24-W38/39, S24-W40/41, S24-W42/43, S24-W44/45, S24-W46/47, S24-W48/49, S24-W50/51/52/1
    • 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

            rgontarski Robert Gontarski
            ombr_lcalseverini Lineker Calseverini
            Team B
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 6.25h
                6.25h