Re: MySQL and foreign-key support

[prev] [thread] [next] [lurker] [Date index for 2006/10/23]

From: David Cantrell
Subject: Re: MySQL and foreign-key support
Date: 19:08 on 23 Oct 2006
On Thu, Oct 19, 2006 at 07:31:02PM +0200, A. Pagaltzis wrote:
> * Aaron Crane <hateful@xxxxxxxxxx.xx.xx> [2006-10-19 14:20]:
> > MySQL still, after all these years, has a whole host of
> > arbitrary limitations (like the limits on key length, and the
> > inability to use TEXT columns in a foreign key, and the lack of
> > recursion in stored functions). And there are still important
> > features missing, whatever table engine you use (like CHECK
> > constraints, and deferred constraint checking).
> Not only those, but it will also still silently coerce data into
> compliance with constraints, like silently truncating values on
> INSERT and successfully performing the insertion instead of
> rejecting the query.

Of course, other databases also hatefully truncate data on INSERT too.
It's probably even required by some stupid standard.

-- 
David Cantrell | Hero of the Information Age

Do not be afraid of cooking, as your ingredients will know and misbehave
   -- Fergus Henderson
There's stuff above here

Generated at 16:01 on 02 Nov 2006 by mariachi 0.52