Bug #7030 ALTER SQL error in Adminsitrator
Submitted: 6 Dec 2004 5:39 Modified: 10 Oct 2005 13:24
Reporter: Fred Dinkler Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.0.17 OS:Windows (WinXP)
Assigned to: Mike Lischke CPU Architecture:Any

[6 Dec 2004 5:39] Fred Dinkler 
Description:
Edit table definition (Tble Editor), on  Table Options, change Charset and Collation both to 'efault'.  Click "Apply Changes", note that the displayed SQL is defective.

Executing returns SQL error 1064.

How to repeat:
Edit an existing table definition (Table Editor)
Click tab "Table Options" change Charset and Collation both to 'default' or some other valueif already Default.
Click "Apply Changes", 
Note that the displayed SQL is defective. The word 'COLLATE' is clipped to 'OLLATE'
Click Execute. Error 1064 is displayed.
[6 Dec 2004 5:40] Fred Dinkler 
Screen shot of Table Editor generated ALTER SQLwith COLLATE defect.

Attachment: Adminstrator.SQLerror.jpg (image/pjpeg, text), 73.10 KiB.
[6 Dec 2004 12:51] MySQL Verification Team 
Thank you for the bug report.
[15 Dec 2004 12:38] Michael G. Zinner 
Thanks for reporting. Could you check if this is still the case with the current 1.0.17 release? Thanks a lot.
[15 Dec 2004 13:39] Fred Dinkler 
Yes, this defect exists in 1.0.17 as well. See attached file for screen shot.
[15 Dec 2004 13:40] Fred Dinkler 
Screen shot of Admin ALTER TABLE SQL from 1.0.17

Attachment: MySQL.Admin.bug.jpg (image/pjpeg, text), 22.50 KiB.
[2 Jan 2005 16:30] MySQL Verification Team 
Still presents on 1.0.18.
[10 Oct 2005 13:24] Mike Lischke 
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/