Bug #25907 DataType Column of DataTypes collection does'nt contain the correct CLR Datatype
Submitted: 29 Jan 2007 9:33 Modified: 31 Jan 2007 16:15
Reporter: Sönke Schau Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:5.0.3 OS:Windows (Windows)
Assigned to: CPU Architecture:Any

[29 Jan 2007 9:33] Sönke Schau
Description:
The DataType Column of the DataTypes collection returned by the GetSchema call does not contain the correct CLR Datatype for the following MySql Datatypes:

"BLOB", "TINYBLOB", "MEDIUMBLOB", "LONGBLOB"
Type is "Byte" but should be "System.Byte[]"

"BIT"
Type is "UInt64" but should be "System.UInt64"

"DATE", "DATETIME", "TIMESTAMP"
Type is "DateTime" but should be "System.DateTime"

How to repeat:
DataTable dtdt = DbConnection.GetSchema( "DataTypes", new string[] { } );

Suggested fix:
Correct the Datatype Strings in the SetDSInfo function of the relevant Datatypes
[29 Jan 2007 11:43] Tonci Grgin
Thank you for your problem report. Providing that Bug#25906 is fixed, verified as described with attached test case on latest SVN sources.
[29 Jan 2007 11:44] Tonci Grgin
Test case

Attachment: Program.cs (text/plain), 1.40 KiB.

[30 Jan 2007 22:32] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/19050
[30 Jan 2007 22:32] Reggie Burnett
Fixed in 5.0.4
[31 Jan 2007 16:15] MC Brown
A note has been added to the 5.0.4 changelog.