Bug #9326 EDIT TABLE - Bad syntax for editing values.

• Submitted: 22 Mar 2005 5:34
• Modified: 28 Apr 2005 4:34
• Reporter: Deek Starr
• Status: No Feedback
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.1.5
• OS: Windows (XP-PRO)
• CPU Architecture: Any

[22 Mar 2005 5:34] Deek Starr

Description:

While looking trough the 'Edit Table' proporty tabs, i noticed an language option. I clicked it to view the options however didn't change the option. However now every time I 'Apply Changes' it adds the 'SET latin1 COLLATE latin1_swedish_ci' remark. 

A: How can i remove this? ( Setting langage to default does not remove this. )
B: The new syntax creats an error (See Example1 below).

Example1:
Current

ALTER TABLE `ict-store`.`employees` MODIFY COLUMN `Store_ID` INTEGER UNSIGNED CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

Correct

ALTER TABLE `ict-store`.`employees` MODIFY COLUMN `Store_ID` INTEGER UNSIGNED NOT NULL;

How to repeat:
Clicked Schema.
Clicked Edit Table.
Clicked 'Table Options' Tab.
Clicked 'Latin1'.
Clicked Apply.

Now i can't get it back to normal?

[22 Mar 2005 5:35] Deek Starr

While looking trough the 'Edit Table' property tabs, i noticed an language
option. I clicked it to view the options however didn't change the option.
However now every time I 'Apply Changes' it adds the 'SET latin1 COLLATE
latin1_swedish_ci' remark. 

A: How can I remove this? ( Setting language to default does not remove this. )
B: The new syntax creates an error (See Example1 below).

Example1:
Current

ALTER TABLE `ict-store`.`employees` MODIFY COLUMN `Store_ID` INTEGER UNSIGNED
CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

Correct

ALTER TABLE `ict-store`.`employees` MODIFY COLUMN `Store_ID` INTEGER UNSIGNED
NOT NULL;

How to repeat:
Clicked Schema.
Clicked Edit Table.
Clicked 'Table Options' Tab.
Clicked 'Latin1'.
Clicked Apply.

Now I can't get it back to normal?

[22 Mar 2005 11:18] MySQL Verification Team

I wasn't able to repeat with version 1.1.6. What version are
you using ?

[28 Mar 2005 4:34] Deek Starr

I'm using V1.1.5 for windows and MySQL 5.0.0-alpha.

Hope this helps.

[28 Apr 2005 23: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".