Uploaded image for project: 'Openfire'
  1. Openfire
  2. OF-1630

'rank' is now a reserved word in MySQL 8

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.2.3
    • Fix Version/s: 4.3.0
    • Component/s: Database
    • Labels:
      None

      Description

      rank is, as of MySQL 8.0.2, a reserved keyword.  

      https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-R

      The table `ofRosterGroups` uses rank as a column, and on MySQL this will need to escaped when creating and accessing the table.

       

        Attachments

          Activity

            People

            Assignee:
            gdt Greg Thomas
            Reporter:
            gdt Greg Thomas
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: