View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001142 | Database Workbench v5 | MySQL Module | public | 2015-01-13 20:37 | 2015-01-22 13:24 |
Reporter | Sandy Ganz | Assigned To | Martijn Tonies | ||
Priority | high | Severity | major | Reproducibility | have not tried |
Status | closed | Resolution | fixed | ||
Platform | Windows 7 | OS | Windows 7 | OS Version | Windows 7 |
Product Version | 5.0.6 | ||||
Fixed in Version | 5.0.8 | ||||
Summary | 0001142: Adding Fields to an existing tables fails if position of field moved before saving | ||||
Description | If I have an existing table and add a new field to the table in the editor it will work OK if the field is left at the bottom where the default is added. However if I add a new field, then move the field UP to where I want it then click the alter db button it comes up with an error. | ||||
Steps To Reproduce | Take an existing MySQL innodb table, add a new field to it, move the field UP in the list of fields, Save changes (alter table). Error below. No error IF the field is left at the bottom position. | ||||
Additional Information | Error Output - #42S22Unknown column 'img_test_deleteme' in 'images' while executing: ALTER TABLE images CHANGE img_path img_path VarChar(255) AFTER img_test_deleteme, CHANGE img_type img_type Integer(8) NOT NULL DEFAULT 0 AFTER img_path, CHANGE img_desc img_desc VarChar(255) AFTER img_type, CHANGE img_update img_update Timestamp AFTER img_desc, ADD img_test_deleteme Integer(8), ENGINE=InnoDB | ||||
Tags | No tags attached. | ||||
|
Hello Sandy, Moving an existing field, without adding fields, does that work? |
|
Yes, that seems to work. The process that I do now is just add the field (shows up at the bottom of the list) then alter table. Good. Then I just move the field up where I want it and again alter table, all good. So part 2 is just moving a field around and I think that is OK. |
Date Modified | Username | Field | Change |
---|---|---|---|
2015-01-13 20:37 | Sandy Ganz | New Issue | |
2015-01-14 16:54 | Martijn Tonies | Note Added: 0000329 | |
2015-01-14 16:54 | Martijn Tonies | Assigned To | => Martijn Tonies |
2015-01-14 16:54 | Martijn Tonies | Status | new => feedback |
2015-01-14 20:05 | Sandy Ganz | Note Added: 0000331 | |
2015-01-14 20:05 | Sandy Ganz | Status | feedback => assigned |
2015-01-20 09:26 | Martijn Tonies | Status | assigned => resolved |
2015-01-20 09:26 | Martijn Tonies | Fixed in Version | => 5.0.8 |
2015-01-20 09:26 | Martijn Tonies | Resolution | open => fixed |
2015-01-22 13:24 | Martijn Tonies | Status | resolved => closed |