Bug #57504 Table definition not updated with some modifications

• Submitted: 17 Oct 2010 16:10
• Modified: 29 Oct 2010 14:02
• Reporter: Tanguy Gilmont
• Status: Can't repeat
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 5.2.28
• OS: Windows (7)
• CPU Architecture: Any

[17 Oct 2010 16:10] Tanguy Gilmont

Description:
When some flags are changed in columns, no change is detected and the database is not updated.

How to repeat:
Create a simple table with a column 'id', as INT(11), and PK, NN, AI flags.

Click on Apply to create the table.

Alter the table, add the unique flag (UQ), click on apply.

[17 Oct 2010 16:28] Tanguy Gilmont

Removing or renaming indices is also ignored sometimes, forcing the user to proceed to an SQL dump / manual edit / SQL import.

[17 Oct 2010 17:25] Valeriy Kravchuk

Adding UQ flag for column that is PK, NN and AI works for me (ALTER TABLE that adds new UNIQUE index is generated) in 5.2.29 connected to 5.1.51 server version. Although I'd call adding such an index redundant.

Anyway, please, check if 5.2.29 solves the problem for you and, if it is not, please, provide the exact CREATE TABLE statement and server version used.

[28 Oct 2010 8:20] Vadim Sadovsky

In 5.2.29 bug closed, but "Index Comment" don't have an effect on "SQL Statement(s)" (and not apply).

[29 Oct 2010 14:02] Valeriy Kravchuk

Not repeatable with 5.2.29. 

Please, create new bug report for index comment problem.