Bug #82523 MySQL Connector fails when we use DataTime.MaxValue in .NET
Submitted: 10 Aug 2016 8:33 Modified: 10 Aug 2016 12:56
Reporter: Gagan Tyagi Email Updates:
Status: Verified Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.9.9 OS:Any
Assigned to: CPU Architecture:Any

[10 Aug 2016 8:33] Gagan Tyagi
Description:
Suppose we are connecting MySQL DataBase and we pass MaxValue of DateTime i.e(12/31/9999 11:59:59 PM) then MySQL Connector 6.9.9 Fails It throws the exception DateTime OverFlow Exception.

All Software fails when They Pass MAX Value of Date Time IN SP's.

How to repeat:
Calling the Stored Procedure with Input Parameter of type DATE and in that parameter pass the value of DateTime.MaxValue from C# code.

Suggested fix:
We can use DateTime.MaxValue.Date for this
[10 Aug 2016 12:35] Chiranjeevi Battula
Hello Gagan Tyagi,

Thank you for the bug report.
Verified this behavior on Visual Studio 2013(C#.Net) and Connector/NET 6.9.9 version.

Thanks,
Chiranjeevi.
[10 Aug 2016 12:36] Chiranjeevi Battula
Screenshot

Attachment: 82523.JPG (image/jpeg, text), 253.28 KiB.

[10 Aug 2016 12:56] Gagan Tyagi
Hi Chiranjeevi
Thanks for the fast response.

Thanks
Gagan