On Thu, Oct 06, 2005 at 01:46:29PM -0500, Scott Marlowe wrote:
> 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.
Please submit any missing items to the author. If he refuses them send
them to me and I'll start an addendum.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461