MySQL Bugs: #99752: when sending parameter in multiple statement. odbc return error on 2nd row.

Bug #99752	when sending parameter in multiple statement. odbc return error on 2nd row.
Submitted:	1 Jun 2020 12:28	Modified:	21 Aug 2020 6:30
Reporter:	Anil Sharma	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	8	OS:	Windows
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
i am using vfp with mysql and using odbc 8 to connect the database. 
when i tried to pass on parameters in single row statement its fine. but when i send 2 statements in batch and any of one is having paramter in it. odbc return error on 2nd row.  in vfp we send parameter like  "select * from master where pkid = ?MyPKID_Variable". This row work fine if i send this statement only. if i added any updated statement with it. odbc started returning an error on 2nd statement.

How to repeat:
select * form master where pkid = ?pkID_Parameter ;
update master set name = 'ABC' where pkid = 1;

this statement will give an error if called in a single batch via odbc. if i pass direct value instead of parameter then it works fine too. or if i remove 2nd line that it works fine too.

I hope the Verification Team able to generate the bug?.

Thank you for the bug report. Could you please provide a complete test case sql script for table and code file which hit the issue reported. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".