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

Qt application fails to retrieve data from MySQL via ODBC driver while insertion and deletion operations work correctly

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: P1: Critical P1: Critical
    • None
    • 6.5.10
    • SQL Support
    • None
    • Qt Version: 6.5

      • MySQL Version: 8.0.43

      • ODBC Driver Version: 9.2

      • Operating System: macOS 15.6

      I'm encountering an issue where Qt 6.5 can successfully insert and delete data in MySQL 8.0.43 through the ODBC driver (version 9.2), but it cannot retrieve data. When attempting to query data from MySQL tables in Qt, no results are returned, even though the tables definitely contain data. The insert and delete operations via the same ODBC connection in Qt function without any problems. I've checked the ODBC configuration and the connection settings in Qt, and they seem correct. I'm using Qt 6.5, MySQL 8.0.43, and ODBC driver version 9.2.

       

        1. image-2025-09-10-00-48-49-185.png
          image-2025-09-10-00-48-49-185.png
          95 kB
        2. image-2025-09-10-00-50-55-812.png
          image-2025-09-10-00-50-55-812.png
          95 kB
        3. image-2025-09-10-00-51-46-321.png
          image-2025-09-10-00-51-46-321.png
          95 kB
        4. LiveStreamServer.pro
          0.6 kB
        5. LiveStreamServer.pro.user
          16 kB
        6. LiveStreamServer.pro.user.8d27622
          23 kB
        7. main.cpp
          0.2 kB
        8. mysql_test.zip
          245 kB
        9. WechatIMG2641.jpg
          WechatIMG2641.jpg
          95 kB
        10. WechatIMG2676.jpg
          WechatIMG2676.jpg
          95 kB
        11. widget.cpp
          3 kB
        12. widget.h
          0.6 kB
        13. widget.ui
          0.4 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            chehrlic Christian Ehrlicher
            weihaitao wei haitao
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                There are no open Gerrit changes