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@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
