Bug #27730 "Preview data" for DataTable shows incorrect values for AI columns
Submitted: 10 Apr 2007 10:30 Modified: 5 Dec 2013 20:47
Reporter: Tonci Grgin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Visual Studio Plugin Severity:S4 (Feature request)
Version:1.1.2 Alpha OS:Windows (XPPro SP2)
Assigned to: Fernando Gonzalez.Sanchez CPU Architecture:Any

[10 Apr 2007 10:30] Tonci Grgin 
Description:
  "Preview data" for DataTable shows incorrect values, actually -1* AI column value, for AI columns. This is probably due to known limitations in NET fw regarding AI fields but looks stupid anyway:
-1	-1231321
-2	1234567890abcdefšđčć.-
-3	testing
-4	27211
-5	27211-2
-6	sel,jfslefg
-7	makwer2fg
-8	wtrewt
-9	iopiopi
-10	preutperoutperut
-11	brbrbrrbrb

How to repeat:
CREATE TABLE `a` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

In Dataset designer add DataTable based on "SELECT * FROM a" query. Right click on DataTable, choose "Preview data" all negative values. Drag and drop table a from Server explorer, right click and choose "Preview data", correct values are shown.

 - MySQL server 5.0.38BK on WinXP Pro SP2 localhost
 - c/NET 5.0.6, Plugin 1.1.2 Alpha
 - NET fw 2.0

Suggested fix:
-
[5 Dec 2013 20:46] Fernando Gonzalez.Sanchez 
This was fixed in source, no longer reproducible.

Tested with
VS2010, Connector/NET 6.8.1, MySql for Visual Studio 1.1.1, .NET 4 Client Profile
VS2010, Connector/NET 6.8.1, MySql for Visual Studio 1.1.1, .NET 2
VS2012, Connector/NET 6.8.1, MySql for Visual Studio 1.1.1, .NET 4.5

All configurations with Windows 8 x64.
[5 Dec 2013 20:47] Fernando Gonzalez.Sanchez 
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/