MySQL Bugs: #4520: time fields overflow using bytefx .net mysql driver

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
Category:	Connector/Net	Severity:	S1 (Critical)
Version:	0.76	OS:	Any (any)
Assigned to:	Reggie Burnett	Target Version:

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

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