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. widget.ui
          0.4 kB
        2. widget.h
          0.6 kB
        3. widget.cpp
          3 kB
        4. WechatIMG2676.jpg
          WechatIMG2676.jpg
          95 kB
        5. WechatIMG2641.jpg
          WechatIMG2641.jpg
          95 kB
        6. mysql_test.zip
          245 kB
        7. main.cpp
          0.2 kB
        8. LiveStreamServer.pro.user.8d27622
          23 kB
        9. LiveStreamServer.pro.user
          16 kB
        10. LiveStreamServer.pro
          0.6 kB
        11. image-2025-09-10-00-51-46-321.png
          image-2025-09-10-00-51-46-321.png
          95 kB
        12. image-2025-09-10-00-50-55-812.png
          image-2025-09-10-00-50-55-812.png
          95 kB
        13. image-2025-09-10-00-48-49-185.png
          image-2025-09-10-00-48-49-185.png
          95 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