Bug #4520 time fields overflow using bytefx .net mysql driver
Submitted: 12 Jul 2004 18:47 Modified: 12 Jul 2004 19:05
Reporter: jorge bastos
Status: Closed
Category:Connector/Net Severity:S1 (Critical)
Version:0.76 OS:Any (any)
Assigned to: Reggie Burnett Target Version:

[12 Jul 2004 18: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 19: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