View Issue Details

IDProjectCategoryView StatusLast Update
0001492Database Workbench v5MySQL Modulepublic2017-08-03 14:17
ReporterDoychin Bondzhev Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version5.3.0 
Fixed in Version5.3.2 
Summary0001492: Incorrect alter statement when changing table structure
DescriptionAlter statements use the order of the change. That does not work always.
Steps To ReproduceTake an existing table TABLE1 with following fields:

ID, REMOTE_ID, FIELD3

Now open this table to make change in it
1. Remove REMOTE_ID
2. Add FIELD4 and FIELD5 after FIELD3.
3. Change FIELD3 to FIELD3_

this will generate alter statement that looks like this:

ALTER TABLE TABLE1
  DROP `REMOTE_ID`,
  ADD FIELD4 Bit AFTER FIELD4,
  ADD FIELD5 Integer AFTER FIELD4 ,
  CHANGE FIELD3 FIELD3_ NVarChar(255);

The right order is to change first FIELD3 to FIELD3_ and then to add FIELD4 after FIELD3_
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-04-25 22:59 Doychin Bondzhev New Issue
2017-05-03 12:23 Martijn Tonies Assigned To => Martijn Tonies
2017-05-03 12:23 Martijn Tonies Status new => acknowledged
2017-06-20 11:35 Martijn Tonies Status acknowledged => resolved
2017-06-20 11:35 Martijn Tonies Fixed in Version => 5.3.2
2017-06-20 11:35 Martijn Tonies Resolution open => fixed
2017-08-03 14:17 Martijn Tonies Status resolved => closed