Bug #46100 unhandled exception: SystemArgumentException
Submitted: 9 Jul 22:46 Modified: 4 Aug 12:43
Reporter: Charles Santee
Status: Closed
Category:Connector/Net Severity:S3 (Non-critical)
Version:6.04 OS:Microsoft Windows
Assigned to: Reggie Burnett Target Version:
Tags: creating tables using VS2008
Triage: D2 (Serious)

[9 Jul 22:46] Charles Santee 
Description:
The following exception occurred in the DataGridView

SystemArgumentException: DataGridViewComboBoxCell value is npot valid

To replace this default dialog please yhandle the DataError Event.

After the error message all previously entered varchar's are changed to bit(10).

Also cannot name save the table because I use an autoincrement id column
and there doesn't seem to be any way to make it a primary key.

How to repeat:
Connect to a mysql database in the server exployer. Right click to bring up the menue
that lets you create a new table. Start entering column names and select varchar(10) as
the data type. Then change varchar(10) to varchar(20) [or pick a number], you many have
to do two or three columns.

Also there does not appear to be anyway to assign a primary key to the database.
[10 Jul 12:36] Tonci Grgin 
Oh wow! Thanks for this report Charles.

Verified as described on W2K8SEx64 using c/NET 6.0.4 with .NET FW 3.5 and remote MySQL
server 5.1.31 on OpenSolaris box.

How-To:
  - Open VS2008
  - Open connection from server explorer
  - "Create New Table"
  - Add field ID, type = serial
  - Add field of type VARCHAR, leave default (10)
  - Add field of type VARCHAR and change default (10) to, let's say, (20)
All sorts of errors will pop up when hoovering with mouse over "Data Type" and the first
VARCHAR(10) field defined will change to "bit(10)" even though "Column Properties" will
still show "varchar(10)".

After changing back BIT(10) to VARCHAR(10) for first defined VARCHAR column, the second
one changes to BIT(10)...
[10 Jul 12:37] Tonci Grgin 
SShot of problem.

Attachment: Bug46100.jpg (image/jpeg, text), 45.89 KiB.
[31 Jul 22:11] 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/79799

733 Reggie Burnett	2009-07-31
      - fixed bug where editing a table and giving a size based type that is different
than
        the default (i.e. varchar(20)) would cause other columns that have the default
        to fail (bug #46100)
[31 Jul 22:17] Reggie Burnett 
fixed in 6.0.5 and 6.1.1
[4 Aug 12:43] Tony Bedford 
An entry was added to the 6.0.5 and the 6.1.1 changelogs:

When populating a MySQL database table in Visual Studio using the Table Editor, if a
VARCHAR(10) column was changed to a VARCHAR(20) column an exception was generated:

SystemArgumentException: DataGridViewComboBoxCell value is not valid.
To replace this default dialog please handle the DataError Event.