Bug #22283 Catalogs, Table Actions, Table Editor, Create Table, Script Generator, Error

• Submitted: 12 Sep 2006 20:21
• Modified: 22 Nov 2006 9:03
• Reporter: kimbro gray
• Status: No Feedback
• Category: MySQL Administrator
• Severity: S3 (Non-critical)
• Version: MySQL 5.0.22, Admin r3
• OS: MacOS (MAC OSX 10.4.7, Darwin 8.7.0)
• CPU Architecture: Any
• Tags: Script Generator Error

[12 Sep 2006 20:21] kimbro gray

Description:
Using the newest release of MySQL Administrator, a tool which I greatly appreciate, from the "catalogs" page, pop up menu "table actions" option "create table" brings up the table editor. If you add several columns, use the first one as a primary key, then then next columns select data type "varchar", and then click "create" the program generates an SQL command which it asks you to verify before executing. Without modifying the script, select "execute" and an error regarding the syntax of the script occurs. Table type is default "MyISAM". No other changes to the column structure have been made other than checking the checkbox for "primary key" on the first column, and changing the names of the next three columns and as well as their data type to "varchar". Hope this helps.

How to repeat:
see above.

Suggested fix:
I guess examine code for script generation regarding comptibility with selected table. 
Do I get a IPOD? :D

[22 Oct 2006 9:03] Valeriy Kravchuk

Thank you for a problem report. Please, try to repeat with a newer version, 1.2.4 rc (from r4), and inform about the results. Please, send the exact error message (at least, a screenshot with it) in case of similar problem.

[23 Nov 2006 0:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".