0001492: Incorrect alter statement when changing table structure

ID	Project	Category	View Status	Date Submitted	Last Update

0001492	Database Workbench v5	MySQL Module	public	2017-04-25 22:59	2017-08-03 14:17

Reporter	Doychin Bondzhev	Assigned To	Martijn Tonies
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	5.3.0
Fixed in Version	5.3.2

Summary	0001492: Incorrect alter statement when changing table structure
Description	Alter statements use the order of the change. That does not work always.
Steps To Reproduce	Take 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_
Tags	No tags attached.

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