Bug #118959 macOS上的MySQL ODBC 9.2.0驱动程序在Qt/QODBC中的SELECT上失败，而iODBC和CLI工作正常
Submitted: 8 Sep 15:56 Modified: 9 Sep 23:52
Reporter: haitao wei Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:8.043 OS:MacOS (15.6)
Assigned to: MySQL Verification Team CPU Architecture:x86

[8 Sep 15:56] haitao wei 
Description:
通过Qt QODBC插件和MySQL ODBC 9.2.0驱动程序成功建立了与MySQL服务器的连接。数据操作语言（DML）操作，如`INSERT`和`DELETE`成功执行，并持续到数据库中。然而，当尝试使用“SELECT”语句检索数据时，Qt应用程序失败，表示“无数据”或“未找到表”。**至关重要的是，在同一台机器上使用iODBC的命令行工具对同一数据库**时，相同的SELECT查询可以完美运行，确认数据存在且可访问。这表明MySQL ODBC驱动程序和macOS上的Qt QODBC插件之间存在特定的不兼容。

How to repeat:
1.  Set up a simple test table on the MySQL 8.0.43 server.
2.  Configure the MySQL ODBC 9.2.0 driver on macOS.
3.  Write a minimal Qt application using `QSqlDatabase` with the QODBC plugin.
4.  Connect and verify the connection is open.
5.  Execute an `INSERT` statement. Verify its success with `isql` or the MySQL CLI.
6.  Immediately execute a `SELECT * FROM` statement on the same table from the Qt application. This will fail.
7.  Run the identical `SELECT` statement using `isql` on the same machine to confirm the data is accessible. This will work.
[9 Sep 23:52] MySQL Verification Team 
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.