Bug #4520 time fields overflow using bytefx .net mysql driver
Submitted: 12 Jul 2004 16:47 Modified: 12 Jul 2004 17:05
Reporter: Jorge Bastos Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S1 (Critical)
Version:0.76 OS:Any (any)
Assigned to: Reggie Burnett CPU Architecture:Any

[12 Jul 2004 16:47] Jorge Bastos
Description:
Well, asuming that the time type columns accept a value of range '-838:59:59' to '838:59:59' when using the bytefx .net driver for mysql with vb.net (or other language) the driver just overflows when retrieving the value of the time column, at this time i have the value '98:28:00' in that time column, i think that when he has a value smaller than '24:00:00' it doesn't throw any error, not sure about that but not important, it should not overflow with the value '98:28:00'.

Below i'll past the output from the vb IDE.

MySql error: TimeSpan overflowed because the duration is too long.
An unhandled exception of type 'System.OverflowException' occurred in bytefx.mysqlclient.dll

Additional information: TimeSpan overflowed because the duration is too long.

The IDE also points the error to the myrd.read (dim myrd as mysqldatareader) command, it may help you find the bug.

Thanks,

Jorge Bastos

How to repeat:
nothing to declare

Suggested fix:
nothing to declare
[12 Jul 2004 17:05] Reggie Burnett
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html