Re: MySQL and foreign-key support

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

From: Philip Newton
Subject: Re: MySQL and foreign-key support
Date: 19:16 on 23 Oct 2006
On 10/23/06, David Cantrell <david@xxxxxxxx.xxx.xx> wrote:
> On Thu, Oct 19, 2006 at 07:31:02PM +0200, A. Pagaltzis wrote:
> > 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.

And let's not even get started with databases who won't let you insert
empty strings into VARCHAR columns, turning them into NULL instead.

Somebody has grossly misunderstood what "NULL" means, methinks.
-- 
Philip Newton <philip.newton@xxxxx.xxx>
There's stuff above here

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