Uploaded image for project: 'FishEye'
  1. FishEye
  2. FE-7232

Support MySQL 8

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Unresolved
    • None
    • Runtime platform
    • None

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      According to this page https://www.mysql.com/support/supportedplatforms/database.html MySQL 8 is supported on all major operating systems and MySQL 5.6 and 5.7 are no longer supported on some versions (e.g. RedHat Enterprise Linux 8, Windows 2019 Server).

      Add support for MySQL 8 in Fisheye and Crucible.

      Atlassian Update – 1 June 2023

      Hi everyone,

      Our development team checked possibility of adding support for MySQL 8. It turned out that it's impossible without updating the MySQL JDBC Connector driver, the Active Objects library (it's being used to persist data by plugins) and rewriting database upgrade tasks. Unfortunately, the Active Objects library depends on the Atlassian Platform (a set of Atlassian and third party libraries on which all products are built). Active Objects cannot be upgraded without upgrading the platform itself, which is a breaking-change (all third party plugins must be re-built and possibly some parts of them re-written) and because of this requires a platform release of Fisheye/Crucible - v 5.0.0.

      While we have this feature request on the long-term roadmap, it won't be done sooner than end of 2024, if not later.

      Kind regards
      Marek Parfianowicz
      Development Team Lead

            [FE-7232] Support MySQL 8

            Marek Parfianowicz added a comment -

            Hi Łukasz, thank you for sharing results of your testing. There is a problem with escaping reserved keywords. E.g. the 'groups' became a reserved keyword in MySQL 8.

            Marek Parfianowicz added a comment - Hi Łukasz, thank you for sharing results of your testing. There is a problem with escaping reserved keywords. E.g. the 'groups' became a reserved keyword in MySQL 8.

            Łukasz Chrobak added a comment - - edited

            I'm doing some testing with 5.x JDBC connector and 8.0 server backend, and the most critical thing failing so far is startup, because utf8 was changed into utf8mb3.

            Łukasz Chrobak added a comment - - edited I'm doing some testing with 5.x JDBC connector and 8.0 server backend, and the most critical thing failing so far is startup, because utf8 was changed into utf8mb3 .

              Unassigned Unassigned
              mparfianowicz Marek Parfianowicz
              Votes:
              14 Vote for this issue
              Watchers:
              16 Start watching this issue

                Created:
                Updated: