On Thu, 2005-10-06 at 12:23, Jim C. Nasby wrote:
> On Thu, Oct 06, 2005 at 10:10:14AM -0500, Scott Marlowe wrote:
> > But what really bugs me is that some things that ARE bugs simply aren't
> > getting fixed and probably won't. Specifically, while mysql understands
> > fk references made at a table level, it simply ignores, without error,
> > warning, or notice, fk references made in a column. arg... Very
> > frustrating. If they just didn't support that syntax it would be much
> > less bothersome, since I'd try it, get an error, and try the other
> > syntax. Instead, I spent an afternoon trying to figure out why it
> > wasn't doing ANYTHING when I declared an FK reference at column level.
> >
> > Things like that are, sadly, kinda rampant in MySQL.
>
> Are you aware of the MySQL Gotchas website (just google it)? Any time
> you see MySQL being stupid about something you should probably check
> there first to see if it's a "feature".
Oh yeah, very aware. What's amazed me is how often I find something
that's majorly wrong that isn't in that list. For instance, this
particular problem isn't on the gotcha page, although lots of other
constraint issues are. Sadly, after talking to the author of the innodb
table handler, I get the feeling this one isn't going to change.