-
Type:
Incident report
-
Resolution: Duplicate
-
Priority:
Critical
-
None
-
Affects Version/s: 3.4.12
-
Component/s: None
-
None
-
Environment:zabbix3.4.12 mysql8 Linux7（CentOS）
when i in mysql.schema=zabbix use 'desc groups'
err:mysql> desc groups;
ERROR 1064 (42000): 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
desc zabbix.groups
mysql> desc zabbix.groups;
------------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
------------------------------------------------+
| groupid | bigint(20) unsigned | NO | PRI | NULL | |
| name | varchar(255) | NO | MUL | ||
| internal | int(11) | NO | 0 | ||
| flags | int(11) | NO | 0 |
------------------------------------------------+
4 rows in set (0.00 sec)
this is normal
i feel 'groups'(this is key word in mysql8)
how can i resolve thie problem?
- is duplicated by
-
ZBXNEXT-4569 "groups" (8.0.2) and "function" (8.0.1) are reserved words since MySQL 8.0
-
- Closed
-