MySQL Bugs: #87487: New Column disappear on Table Column List

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:	Windows (Windows 10)
Assigned to:		CPU Architecture:	Any

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

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.

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

Hello !,

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

Thanks,
Chiranjeevi.

Screenshot

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

Screenshot

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

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