Bug #87487 New Column disappear on Table Column List
Submitted: 21 Aug 2017 7:51 Modified: 24 Aug 2017 8:56
Reporter: Thomas Lee Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:6.3.9 OS:Microsoft Windows (Windows 10)
Assigned to: CPU Architecture:Any

[21 Aug 2017 7:51] Thomas Lee
Description:
After I use Table Designer to add extra columns,  I can't see these new columns.

How to repeat:
After I use Table Designer to add extra columns, they are 
Data_TimeStamp  TimeStamp(3)
FileName  varchar(50)

I can "Apply" successfully and from Table Inspector because I see "Column Count: 7".
But when I use "Alter Table..." , I can't see these new columns on the Table Column List.

Thanks
[21 Aug 2017 12:33] Chiranjeevi Battula
Hello !,

Thank you for the feedback.
I could not repeat the issue at our end using with MySQL workbench 6.3.9 versions.
Could you please provide repeatable test case (exact steps, create table statement, screenshot etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[22 Aug 2017 0:47] Thomas Lee
Hi Chiranjeevi,
Thank you for supporting me in this case.

The following paragraph is my steps to create my table 

I used the Table Designer on WorkBench 6.3.9 to create the table
at first time, my table has 4 fields such as
- LoggingID  varchar(50)
- MachineID  varchar(50)
- Content  MEDIUMTEXT
- LoggingTime  TimeStamp(3)

after that, I add field "Success" (int) after "LoggingTime"

next, I modified the table, and added fields 
Data_TimeStamp TimeStamp(3) after LoggingTime 
, FileName  varchar(500) after  Data_TimeStamp
and move "Success" as the last field.

Could you see if you can duplicate my problem?
If not, I will re-create the table again to see if it can be repeated.

by the way, here are the URL of screenshot of my table
https://drive.google.com/open?id=0B_8UsMSAdbJXZ014SlNtUWlqWkE

https://drive.google.com/open?id=0B_8UsMSAdbJXZWVBdFhEdXVSNlE

Thanks,
Thomas
[22 Aug 2017 9:20] Chiranjeevi Battula
Hello !,

Thank you for the feedback.
Verified this behavior on MySQL Workbench in 6.3.9 version.

Thanks,
Chiranjeevi.
[22 Aug 2017 9:21] Chiranjeevi Battula
Screenshot

Attachment: 87487.JPG (image/jpeg, text), 137.09 KiB.

[22 Aug 2017 9:21] Chiranjeevi Battula
Screenshot

Attachment: 87487_1.JPG (image/jpeg, text), 70.30 KiB.

[24 Aug 2017 8:56] Thomas Lee
Hi Chiranjeevi,

I'm sorry, I'm not sure about your comment.

You could duplicate my problem, am I right?

Do I need to provide any further information?

Best Regards,
Thomas