Bug #26569 Comment for field > 255 characters --> Server Messages; Warning unknow error
Submitted: 22 Feb 2007 14:47 Modified: 30 Apr 2007 12:04
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:Microsoft Windows (XP)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: qc

[22 Feb 2007 14:47] Heinz Schweitzer
Description:
Comment for field longer then 255 characters --> Server Messages; Warning unknown error

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:
Prerequisit
	Have a table with a  field.
	

Start English or German MySQL Administrator 1.2.9
Open Catalogs
Select from Catalogs a database like 'mysql'

In the right pane activate the 'Schema Tables' Tab
Select a table like 'columns_priv'

In the table editor select the  field 'host'.
For this field add a comment that is longer then 255 characters.
Say 'Apply Changes' and confirm execution of SQL command.

--> you will get a window like in screen shot w1 saying
	Server Messages; Warning unknown error
[22 Feb 2007 14:47] Heinz Schweitzer
w1

Attachment: ScreenHunter_001.jpg (image/pjpeg, text), 160.64 KiB.

[24 Feb 2007 0:22] Miguel Solorzano
Correct error message

Attachment: longcomment.PNG (image/png, text), 36.06 KiB.

[24 Feb 2007 0:25] Miguel Solorzano
Thank you for the bug report. I got the correct message 'Too long comment
...' please see picture I have attached. Something I missed, a special
character you have used in the string comment?. Thanks in advance.
[24 Feb 2007 14:37] Heinz Schweitzer
Strange !

On the system I am currently working, I do not get an error message, not even
if  I enter comment 300 characters long. It just truncates the
comment down to 255 characters saves it, and that's it.
[1 Mar 2007 16:29] Miguel Solorzano
Thank you for the feedback.
"It just truncates the comment down to 255 characters saves it, and that's it."

Indeed I also experienced that.
[30 Apr 2007 12:04] 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

PS: The edit control does no longer accept more than 255 characters