[ZBX-14598] –Error in query [SELECT g.groupid,g.name FROM groups g... - ZABBIX SUPPORT

XML

Word

Printable

Type: Incident report
Status: Closed
Priority: Major
Resolution: Duplicate
Affects Version/s: None
Fix Version/s: None
Component/s: None
Labels:
None
Environment:
CentOS Linux release 7.4.1708 (Core);
mysql-community-server-8.0.11-1.el7.x86_64;
zabbix_server (Zabbix) 3.4.11 Revision 82160;

Steps to reproduce:

After installed mysql and Zabbix-server, once start Zabbix-server;
tail -f /var/log/zabbix/zabbix_server.log ==>
... query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups' at line 1 .[+select groupid,name from groups+]..
i've run " mysql -uzabbix -p " to query manually, the same error. The "groups" looks like keyword. i have to use "select groupid,name from zabbix.groups";

Result:
See screenshot...
Expected:

is duplicated by

ZBXNEXT-4569 "groups" (8.0.2) and "function" (8.0.1) are reserved words since MySQL 8.0