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

Bug #118951	Qt application fails to retrieve data from MySQL via ODBC driver while insertion and deletion operations work correctly
Submitted:	7 Sep 9:06	Modified:	7 Sep 11:06
Reporter:	haitao wei	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	8.043	OS:	MacOS (15.6)
Assigned to:		CPU Architecture:	x86

Description:
使用Qt版本6.5，MySQL版本8.0.43，ODBC版本9.2。Qt通过ODBC成功连接到MySQL。数据可以插入和删除，但数据无法检索。Qt版本：6.5• MySQL版本：8.0.43• ODBC驱动程序版本：9.2• 操作系统：macOS
The error reported in Qt is:
数据库连接成功
数据库类型: "QODBC"
QODBCDriver::tables failed to retrieve table/view list: ( -1 , "[iODBC][Driver Manager]Optional feature not implemented" )
可用表: QList()
QODBCDriver::tables failed to retrieve table/view list: ( -1 , "[iODBC][Driver Manager]Optional feature not implemented" )
未找到people表，需要创建
创建表失败: "[MySQL][ODBC 9.2(w) Driver][mysqld-8.0.43]Table 'people' already exists QODBC: Unable to execute statement"

How to repeat:
The Qt application successfully connects to MySQL database using ODBC driver and can perform INSERT and DELETE operations without issues. However, when attempting to retrieve data (SELECT queries), no data is returned despite the queries executing successfully without error messages.

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php 

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.  

Thank you for your interest in MySQL.