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

MySQL returns invalid value if IFNULL or COALESCE is used

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Not Evaluated
    • Resolution: Incomplete
    • Affects Version/s: 5.15.2
    • Fix Version/s: None
    • Component/s: SQL Support
    • Labels:
      None
    • Platform/s:
      Windows

      Description

      Hi guys.

      Have found another strange one.

      For last few years I was using MySQL 5.6.xx and all was good but today I've even then MySQL Workbench started returning the wrong numbers if IFNULL or COALESCE were used in the query.

      So I've though that it's 5.6.xx's fauld and have removed it and installed the latest 8.0.26.
      And now the Workbench is returning the right numbers, but Qt still doesn't.
      Now take notice that MySQL plugin was build against the 5.6. So maybe rebuilding it with 8.0 code will solve the issue.

      Anyway check the image to get the feeling of what I'm talking about.

      On the left side (at the bottom in the watch window you will see the invalid values returned).

      I'll ping you if the latest 5.15 and latest MySQL rebuild does the same thing.

      BrW

        Attachments

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

          Activity

            People

            Assignee:
            mabrand Mark Brand
            Reporter:
            waldemarh Waldemar Haszlakiewicz
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Gerrit Reviews

                There are no open Gerrit changes