Bug #44123 Column types for base provider and isschemaprovider differ
Submitted: 7 Apr 2009 7:42 Modified: 17 Apr 2009 14:04
Reporter: Tonci Grgin Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Reggie Burnett CPU Architecture:Any

[7 Apr 2009 7:42] Tonci Grgin 
Description:
Comparing SchemaProvider.cs and ISSchemaProvider.cs it is visible they do not use same column types. Problem arises from fact that the base provider uses sql such as "show create table" (as it's used to support mysql 4.1 and lower) while isschemaprovider uses the schema information tables when they are available. Column types for the base class is int64 and the column types for the i_s one is unsigned.

How to repeat:
Check the sources.
[8 Apr 2009 20:36] 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/71680
[8 Apr 2009 20:36] Reggie Burnett 
fixed in 6.0.3
[17 Apr 2009 14:04] Tony Bedford 
Added an entry to the 6.0.3 changelog:

Column types for SchemaProvider and ISSchemaProvider did not match.

When the source code in SchemaProvider.cs and ISSchemaProvider.cs were compared it was apparent that they were not using the same column types. The base provider used SQL such as SHOW CREATE TABLE, while ISSchemaProvider used the schema information tables. Column types used by the base class were INT64 and the column types used by ISSchemaProvider were UNSIGNED.