MySQL Bugs: #78944: Input string was not in a correct format in ExecuteNoQuery

Bug #78944	Input string was not in a correct format in ExecuteNoQuery
Submitted:	23 Oct 2015 14:11	Modified:	21 Sep 2022 15:49
Reporter:	Greg Ogrod	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	6.9.7.0, 6.9.8	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
During execute stored procedure with ExecuteNoQuery exception "Input string was not in a correct format" raised when procedure returns nothing (e.g. rollback was called in stored procedure).

How to repeat:
Execute stored procedure that raised sqlexception that call rollback on transaction.

Suggested fix:
Implement try-catch in MySql.Data.Types.MySqlDateTime.ParseMySql method to return default value or use TryParseInt32 instead of ParseInt32 in this method.

Hello Greg Ogrod,

Thank you for the bug report.
I tried to reproduce the issue at my end using Visual Studio 2013 (C#.Net), MySQL Connector/Net 6.9.7 and EF6.1.3 but not seeing any issue in procedure returns nothing.
Could you please provide repeatable test case (exact create table statements, procedure, sample data, etc - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.

Hello Greg Ogrod,

Thank you for your feedback and test case.
Verified this behavior on Visual Studio 2013 (C#.Net) with  MySQL Connector/Net 6.9.8.

Thanks,
Chiranjeevi

screenshot.

Attachment: 78944.PNG (image/png, text), 128.08 KiB.

Posted by developer:
 
Not possible to reproduce the issue. Verified using the latest Connector/Net version (8.0.30)

Posted by developer:
 
Not possible to reproduce the issue. Verified using the latest Connector/Net version(8.0.30).