Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-95639

MariaDB 10.6 prepared queries metadata cache causes breakage in mysql driver

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: P1: Critical
    • Resolution: Done
    • Affects Version/s: 5.15.2
    • Fix Version/s: 5.12.12, 6.2.0 Beta3, 6.3.0 Alpha
    • Component/s: SQL Support
    • Labels:
      None
    • Environment:
      Linux x86_64
    • Platform/s:
      Linux/X11
    • Commits:
      549ee216fd5bf2b3810e940bcbd4bbd8c64ac73f (qt/qtbase/dev) 94d22e0bcc893448d53b718f4a2732bd13fc21e4 (qt/qtbase/6.2) b3e0cdedc681c27e9b2b2dcdd4f1e1420adf5a73 (qt/qtbase/5.12)

      Description

      MariaDB 10.6 introduced cached metadata for prepared queries:

      https://github.com/MariaDB/server/commit/295f3e4cfb4a8f132f36d53475efc92f2487aa97

      This has been identified to cause breakage in applications using Qt's mysql driver:

      digikam:

      https://bugs.archlinux.org/task/71582

      https://bugs.kde.org/show_bug.cgi?id=440296

      mythtv:

      https://bugs.archlinux.org/task/71753

      https://github.com/MythTV/mythtv/issues/373

      Note that, due to QTBUG-95071, this is not noticeable in unpatched Qt, because the two bugs "cancel each other out": QTBUG-95071 causes MariaDB 10.6 to be identified as an old version not supporting prepared queries, so these issues don't happen (but that's obviously just an accident)

       

        Attachments

          Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            Activity

              People

              Assignee:
              thiago Thiago Macieira
              Reporter:
              arojas Antonio Rojas
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Gerrit Reviews

                  There is 1 open Gerrit change