View Issue Details

IDProjectCategoryView StatusLast Update
0001142Database Workbench v5MySQL Modulepublic2015-01-22 13:24
ReporterSandy Ganz Assigned ToMartijn Tonies  
PriorityhighSeveritymajorReproducibilityhave not tried
Status closedResolutionfixed 
PlatformWindows 7OSWindows 7OS VersionWindows 7
Product Version5.0.6 
Fixed in Version5.0.8 
Summary0001142: Adding Fields to an existing tables fails if position of field moved before saving
DescriptionIf 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 ReproduceTake 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 InformationError Output -

#42S22Unknown column 'img_test_deleteme' in 'images'
while executing:
  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),
TagsNo tags attached.


Martijn Tonies

2015-01-14 16:54

administrator   ~0000329

Hello Sandy,

Moving an existing field, without adding fields, does that work?

Sandy Ganz

2015-01-14 20:05

reporter   ~0000331

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.

Issue History

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