1751524 - [MYSQL8] The groups table in Bugzilla conflicts with reserved keyword in MySQL 8.x

Status: RESOLVED FIXED

(bugzilla.mozilla.org :: General, enhancement)

Description

[David Lawrence [:dkl]]

Will need to investigate workaround on changing the groups table name in all the places.

Comment 1

[:glob ✱]

MySQL supports backticks to quote table names, this should avoid conflicts with reserved words.

eg.

    $object_data = $dbh->selectrow_hashref(
      qq{
            SELECT $columns FROM `$table`
             WHERE $id_field = ?}, undef, $id
    );

Comment 2

[David Lawrence [:dkl]]

Attachment: GitHub Pull Request

Comment 3

[David Lawrence [:dkl]]

Merged to master.
https://github.com/mozilla-bteam/bmo/commit/5dc1b8c85c4e90c3467fd82cab9fca05fe2be74a