MySQL Bugs: #109547: Query return NO_DATA, when the data is present

Bug #109547	Query return NO_DATA, when the data is present
Submitted:	7 Jan 2023 20:23	Modified:	12 Jun 2024 15:12
Reporter:	Igor Korot	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: C API (client library)	Severity:	S1 (Critical)
Version:	5.7, 8.0	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Hi, team and Happy New Year

I built libmysqlclient DLL on my Windows 8.1 box successfully built my application both using MSVC 2017.

I then run the application and successfully connect to the mySQL server instance of 8.0 running on Linux.

Then I executed following code:

To my surprise I got MYSQL_NO_DATA.

Then I tried to run exactly the same code on Mac where I built version 8.0 and got the same results.

Running the query on Linux from direct connection yields the row.

I'm connecting as root in both cases.

Could someone check what am I doing wrong? Or is this a bug in mySQL?

(Unfortunately it is not possible to build libmysqlclient version 8 on Windows in 32 bit mode with MSVC 2017 - vc15, so I tested the latest version on Mac).

How to repeat:
Build libmysqlclient.
Connect to the server and execute the code above.
No rows will be returned.

Code to reproduce the problem

Attachment: mysql.bug.txt (text/plain), 8.17 KiB.

Please run the attached code with the mySQL.

I wasn't able to submit a bug with the code inside as it was huge.

Thank you.

Its been a long time since the status of this ticket was changed to "Analyzing"

I would expect a reply by now that it is either a bug in the library or in my code.

Thank you.

Hello Igor Korot,

Thank you for the bug report and details. I could not reproduce the issue with the attached code.
Please upgrade to latest version and report us back if issue persist even in latest version along with test case. Thank you.

Regards,
Ashwini Patil

Hi,
After being quiet for 1 year you finally got to this report... :(

It may very well be fixed in the latest version of mySQL. Or not.
I don't know.

What is the latest version the DB anyway? And when will it go into the production? When all Linux distro will pick it up?

And when the latest version of the Connector will become available?

Thank you.