MySQL Bugs: #26569: Comment for field > 255 characters --> Server Messages; Warning unknow error

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:	Windows (XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	qc

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

w1

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

Correct error message

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

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.

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.

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.

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