Bug #67677 unsign int type error when add a new query in typed dataset
Submitted: 22 Nov 2012 7:56 Modified: 15 Feb 2013 3:00
Reporter: billy cat Email Updates:
Status: Duplicate Impact on me:
Category:Connector / NET Severity:S3 (Non-critical)
Version:6.6.4 OS:Windows (XP 3)
Assigned to: Assigned Account CPU Architecture:Any

[22 Nov 2012 7:56] billy cat
while using the MySQL Connector/Net to create the Typed Dataset from mysql, type uint may be error.

columns in mysql table defined with unsigned-integer, will be defined with uint(System.UInt32). When create the Typed Dataset, it will be mapped to uint, that's right.

but, if a new query, which get a column with unsigned-integer is be add to a exist data-adapter, the unsigned-integer column is seems to be mapped to int(System.Int32). 

How to repeat:
1. Create a Typed Dataset with MySQL Connector/Net 6.6.4 from a mysql database with a table that has a column defined unsigned-integer, it will create a DataAdapter like to the table.

2. Go to the "designer view" of the Typed Dataset.

3. Choose that DataAdapter, and add a new query(insert or update) to the dataadapter.

4. Just finish create the new query, and it seems that the unsigned-integer column will be mapped to int(System.Int32)

ps, this bug seem to be seen while adding a new query. Query created by the Typed Dataset itself can be correctly mapped the unsigned-integer to the uint(System.UInt32)
[15 Feb 2013 3:00] Fernando Gonzalez.Sanchez
This is a duplicated of bug http://bugs.mysql.com/bug.php?id=67282