MySQL Forums
Forum List  »  General

Re: About many to many relationships
Posted by: Felix Geerinckx
Date: October 10, 2005 02:02PM

Roland Bouman wrote:

> This is most likely not a bug, because to reference explicitly specifies this behaviour.
> see:

Even when it is listed as a feature, I consider it a bug.
As you say, no other RDBMS allows. So using this 'feature' could lead to a porting nightmare.

It would be interesting to model a simple many-to-many relationship (e.g. users <-> user groups) and see what anomalies you will encounter when:

making a user member of a group
removing a member (who is member of several other groups) from a group
changing the username of a user

(but don't count on me to do this, because it's a bug ;-)

Please use BBCode to format your messages in this forum.

Options: ReplyQuote

Written By
Re: About many to many relationships
October 10, 2005 02:02PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.