Roland Bouman wrote:
> This is most likely not a bug, because to reference explicitly specifies this behaviour.
> see:
http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html
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
etc...
(but don't count on me to do this, because it's a bug ;-)
--
felix
Please use
BBCode to format your messages in this forum.