-
Problem report
-
Resolution: Fixed
-
Trivial
-
None
-
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:
- Code: https://github.com/zabbix/zabbix/blob/release/7.0/ui/include/classes/db/MysqlDbBackend.php
- Line 175
- 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