-
Problem report
-
Resolution: Unresolved
-
Trivial
-
None
-
Sprint candidates
-
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