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".
--
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