Bug #69656 Tables created with the n:m relationship tool have a blank created timestamp
Submitted: 3 Jul 2013 8:18 Modified: 25 Apr 2014 7:44
Reporter: Stian Andre Olsen Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:6.0.8 OS:Microsoft Windows (version 7)
Assigned to: CPU Architecture:Any
Tags: table blank missing created date timestamp
Triage: Needs Triage: D3 (Medium)

[3 Jul 2013 8:18] Stian Andre Olsen
In MySQL Workbench, when choosing the detailed view, tables are shown with their engine, created, modified and comments attributes.

Tables that are automatically created when using the n:m identifying relationship tool do not have a created timestamp.

Is it possible to alter the created timestamp?
Does it matter if the tables are missing the created timestamp?

How to repeat:
1. In MySQL Workbench, open an existing EER model or create a new one.
2. Create two tables table1 and table2.
3. Add a primary key to each of the two tables.
4. Add an EER diagram and drag table1 and table2 into the new diagram.
5. Choose the n:m identifying relationship tool, click table1 and then table2. This will create a new table that enable the many-to-many relationship.
6. Go back to the model view and choose the detail view for the MySQL Schema. Notice that table1 and table2 have a created timestamp but the table created by the n:m tool does not.

Suggested fix:
Fix the n:m relationship tool.
[3 Jul 2013 13:29] Miguel Solorzano
Thank you for the bug report. Please attach a screen-shot showing the issue reported or the project file test caae. Thanks.
[3 Jul 2013 13:43] Stian Andre Olsen
Screen shot from my own project showing some of the missing created time stamps

Attachment: Table view.png (image/png, text), 26.16 KiB.

[3 Jul 2013 13:44] Stian Andre Olsen
A test model with three tables. The table called table1_table2 is missing the created time stamp.

Attachment: Test.mwb (application/octet-stream, text), 7.21 KiB.

[3 Jul 2013 16:24] Miguel Solorzano
Thank you for the feedback.
[9 Jan 2014 22:41] Alfredo Kojima
Please try version 6.0.8
[10 Jan 2014 14:34] Stian Andre Olsen
I have just tested with MySQL Workbench 6.0.8 and both existing and new tables created with the n:m relationship tool are missing the created time stamp. As far as I can see, the bug remains.
[7 Feb 2014 21:00] Rafael Antonio Bedoy Torres
Posted by developer:
Fixed, checked using
[11 Feb 2014 2:24] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.1.2 release, and here's the changelog entry:

Tables created with the "n:m identifying relationship tool" were missing
the created timestamp.

Thank you for the bug report.
[25 Apr 2014 7:44] Stian Andre Olsen
I have just tested with version 6.1.4 and the n:m relationship tool now adds a created date. Nice!

However, the old tables created with the n:m relationship tool in a previous version of MySQL Workbench still have no created date. I guess it is impossible to get the correct creation date for these old tables. If so, I would prefer that the last modified date is added as the creation date, but I guess this is a matter of taste.

Thanks for fixing the n:m relationship tool! :-)