Bug #26631 Access Violation when field name length >= 280 characters
Submitted: 26 Feb 2007 11:44 Modified: 30 Apr 2007 9:55
Reporter: Heinz Schweitzer (Gold Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.9 OS:Windows (XP)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: qc

[26 Feb 2007 11:44] Heinz Schweitzer
Description:
Access Violation when field name length >= 280 characters

NOTE:
If the field name is very very long MA just closes on you
no error dialog nothing.

German MySQL Administrator 1.2.9

MySQL Server Information
--------------------------------------------------------------------------------
Connected to MySQL Server Instance
  Username:                root
  Hostname:                localhost
  Port:                    3306
--------------------------------------------------------------------------------
Server Information
  MySQL Version:           MySQL 5.0.27-community-nt via TCP/IP
  Network Name:            localhost
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
Client Information
  Version:                 MySQL Client Version 5.1.11
  Network Name:            xxxxxxxxxxx
  IP:                      xxxxxxxxxxx
  Operating System:        Windows XP
  Hardware:                2x Intel(R) Core(TM)2 CPU         T7200  @ 2.00GHz, 2.0 GB RAM

How to repeat:
Start  Administrator 1.2.9
Select  'Catalogs'
In the pane below select and open schema 'mysql'

In the right pane activate the 'Schema Tables' tab
in there select the table 'db' and say 'Edit'

Table Editor pops up
In there select the first field 'host' and activate
the 'Column Details' tab below.
In there set the field name to a length of 280  characters or above.
Say 'Apply Changes' ---> Access Violation 
see screen shot f1
[26 Feb 2007 11:45] Heinz Schweitzer
f1

Attachment: ScreenHunter_002.jpg (image/jpeg, text), 220.64 KiB.

[26 Feb 2007 12:38] MySQL Verification Team
Thank you for the bug report. Verified as described.
[12 Mar 2007 15:24] Mike Lischke
I cannot reproduce this problem. I get:

Fehler, währen die Abfrage ausgeführt wurde.

ALTER TABLE `mysql`.`db` MODIFY COLUMN `Host` CHAR(280) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 MODIFY COLUMN `Delete_priv` ENUM('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AUTO_INCREMENT;

MySQL Fehlernummer1074
Column length too big for column 'Host' (max = 255); use BLOB or TEXT instead

... and nothing bad happens. Please try with the latest build and let me know.
[12 Mar 2007 15:53] Heinz Schweitzer
I tried with 1.2.10 and have the same result with a field name
length of 280 characters :-(
[12 Mar 2007 15:57] Heinz Schweitzer
NOTE:

I am talking about the length of the field name itself NOT the column length.
[30 Apr 2007 9:55] Mike Lischke
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html