MySQL Bugs: #18803: n:m relationship tool is not functional

Bug #18803	n:m relationship tool is not functional
Submitted:	5 Apr 2006 13:40	Modified:	2 May 2006 16:56
Reporter:	Klaus Bensch	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench Preview	Severity:	S2 (Serious)
Version:	1.0.5	OS:	Windows (WinXP-SP2)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Using the n:m relationship tool only creates a 1:n relation.

How to repeat:
Create two tables with primary keys.
Use the n:m tool to connect the tables.

Suggested fix:
Workaround
Insert a new table which will become the n:m table.
Don't edit then:m table at this point.
Add two 1:n relations from the source tables to the n:m table.
Now it is possible to change the name of the table and the foreign keys to primary keys.

Thanks for your bug report