On 10/7/05, Jim C. Nasby <jnasby@xxxxxxxxxxxxx> wrote: > 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: (...) > > > 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. The author writes: all additions, corrections etc. most welcome. I haven't had a chance to update the site much recently, but I'm slowly going through the list to update it for MySQL 5. Ian Barwick ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings