MySQL Bugs: #23046: Wierd error dialogs when changing varchar(45) to varchar(1234567890)

Bug #23046	Wierd error dialogs when changing varchar(45) to varchar(1234567890)
Submitted:	6 Oct 2006 11:34	Modified:	13 Nov 2006 9:08
Reporter:	Heinz Schweitzer (Gold Quality Contributor)	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.4 RC	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any

Description:
Wierd error dialogs when changing varchar(45) to varchar(1234567890)

MySQL Administrator 1.2.4 RC
MySQL-Server-Information
--------------------------------------------------------------------------------
Mit MySQL-Serverinstanz verbunden
  Benutzername:            root
  Hostname:                localhost
  Port:                    3306
--------------------------------------------------------------------------------
Serverinformation
  MySQL-Version:           MySQL 5.0.24a-community-nt via TCP/IP
  Netzwerkname:            localhost
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
Clientinformation
  Version:                 MySQL Client Version 5.0.11
  Netzwerkname:            xxxxxxxxxxx
  IP:                      xxxxxxxxxxx
  Betriebssystem:          Windows XP
  Hardware:                Intel(R) Pentium(R) M processor 1600MHz, 512 MB RAM

How to repeat:
Prerequisites:
==============
Have a schema like 'btest' you can fool around with.
In there have a table with a varchar field like you see in screen shot v4

=======
Open MySQL Administrator 1.2.4 RC 

Select Catalogs-->btest

In the right pane activate the schema tables tab
Select table like 'b1' and say edit

In the MySQL Table Editor change filed 'b' from varchar(45) to varchar(1234567890)
and say 'Applay Changes'
In the next dialog confirm with 'execute' like in screen shot v4

Can not fetch table ... error will pop up like in screen shot v5
Say 'ok' in the error dialog.

In the MySQL Table Editor say 'Applay Changes' again
Confirm table edit pops up again like in screen shot v5

Say execute and error dialog will pop up like in screen shot v6

????

In the end this will change the field from VARCHAR to LONGTEXT

v4

Attachment: shot_4.jpg (image/jpeg, text), 128.42 KiB.

v5

Attachment: shot_5.jpg (image/jpeg, text), 127.00 KiB.

v6

Attachment: shot_6.jpg (image/jpeg, text), 139.24 KiB.

v7

Attachment: shot_7.jpg (image/jpeg, text), 134.46 KiB.

NOTE: The conform table edit dialog does also not
react to ctrl-a --> see bug 23042

Thank you for the bug report. The proper error message should be like below:

mysql> alter table tb2 modify col1 varchar(1234567890);
ERROR 1074 (42000): Column length too big for column 'col1' (max = 65535); use BLOB or TEXT instead

Thank you for the bug report. I was unable to repeat with latest version,
could you please update and test again. Thanks in advance.