-
Type:
Incident report
-
Resolution: Duplicate
-
Priority:
Blocker
-
None
-
Affects Version/s: 3.4.12
-
Component/s: None
-
None
when i in mysql8 use zabbix database
desc groups
mysql> use zabbix
Database changed
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
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)
i feel 'groups' is key word in mysql8
how can i resolve this problem?
- is duplicated by
-
ZBXNEXT-4569 "groups" (8.0.2) and "function" (8.0.1) are reserved words since MySQL 8.0
-
- Closed
-