Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-4569

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

    Details

    • Team:
      Team A
    • Sprint:
      Sprint 14, Sprint 15, Sprint 16, Sprint 32, Sprint 33, Sprint 34, Sprint 35, Sprint 36
    • Story Points:
      2

      Description

      Trying to install Zabbix 3.2.6, using MySQL 8.0.2 I got this message (among many similar ones):

         ...
          26:20170801:200803.540 completed 86% of database upgrade
          26:20170801:200804.646 completed 87% of database upgrade
          26:20170801:200805.131 completed 88% of database upgrade
          26:20170801:200805.935 [Z3005] 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
       (groupid)' at line 1 [alter table corr_condition_group add constraint c_corr_condition_group_2 foreign key (groupid) references groups (groupid)]
          26:20170801:200805.936 database upgrade failed
      

      I checked, and as per the official MySQL documentation ( https://dev.mysql.com/doc/refman/8.0/en/keywords.html ), "groups" is added as a reserved word since version 8.0.2.

      Also, as the schema.sql is properly backticked - there is a chance this requires a considerable refactoring effort to fix...

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vso Vladislavs Sokurenko
                Reporter:
                ppeterka Peter Pasztor
              • Votes:
                0 Vote for this issue
                Watchers:
                15 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: