| 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: | |
| Category: | Connector / NET | Severity: | S3 (Non-critical) |
| Version: | 5.0.3 | OS: | Windows (Windows) |
| Assigned to: | CPU Architecture: | Any | |
[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.

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