Bug #82523 MySQL Connector fails when we use DataTime.MaxValue in .NET

• Submitted: 10 Aug 2016 8:33
• Modified: 10 Aug 17:23
• Reporter: Gagan Tyagi
• Status: Closed
• Category: Connector / NET
• Severity: S2 (Serious)
• Version: 6.9.9
• OS: Any
• 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

[10 Aug 17:23] Daniel Valdez

Fix already implemented. Please use our latest release, Connector/NET 8.0.30.