Bug #43776 Mysql Workbench Many-to-Many Table

• Submitted: 21 Mar 2009 6:24
• Modified: 6 Apr 2009 15:09
• Reporter: Henry Chan
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.1.9
• OS: Any
• Assigned to: Alfredo Kojima
• CPU Architecture: Any

[21 Mar 2009 6:24] Henry Chan

Description:
The generated Mysql Workbench Many-to-Many Table
is of Engine Type: Server Default
When generated it should be InnoDB.

This may a BIG difference when I was running Reverse Engineering with Hibernate (Java)

How to repeat:
Create 2 tables
and then use the GUI to create a n:m relationship to generate a new table.
This new table is of Engine type: "Server Default"

Suggested fix:
set the type type to InnoDB

[22 Mar 2009 15:13] MySQL Verification Team

Thank you for the bug report.

[30 Mar 2009 19:59] Johannes Taxacher

this is fixed. fix will be in 5.1.10

[6 Apr 2009 15:09] Tony Bedford

An entry was added to the 5.1.10 changelog:

The Many-to-Many Table generated by Workbench was of engine type Server Default. It should have been of type InnoDB.