Bug #44123 Column types for base provider and isschemaprovider differ

• Submitted: 7 Apr 2009 9:42
• Modified: 17 Apr 2009 16:04
• Reporter: Tonci Grgin
• Status: Closed
• Category: Connector/Net
• Severity: S3 (Non-critical)
• OS: Any
• Assigned to: Reggie Burnett
• Triage: D4 (Minor)

[7 Apr 2009 9: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 22: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 22:36] Reggie Burnett

fixed in 6.0.3

[17 Apr 2009 16: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.