Re: Examples of SQL anomalies?

From: Brian Selzer <brian_at_selzer-software.com>
Date: Thu, 26 Jun 2008 08:06:35 -0400
Message-ID: <CDL8k.6691$cW3.4376_at_nlpi064.nbdc.sbc.com>


"Artemus Ward" <artemus.ward_at_no.viagra.thanks> wrote in message news:g3vlk2$6nf$1_at_aioe.org...
> Before I waste a big chunk of next week, does anyone know of any docs on
> the web that attempt to gather together examples of anomolous behaviour in
> standard SQL? I am thinking particularly of things like inconsistent
> treatment of nulls. I've got a couple of (to me) very obvious examples
> but there must be many more.
>
> Failing that, can anyone suggest good Google search terms that might
> return a manageable number of hits? Nothing I've tried has been very
> useful.
>
> Arty
>

Well, the first thing that comes to mind is that SQL tables are not sets of rows, but bags of rows. Received on Thu Jun 26 2008 - 14:06:35 CEST

Original text of this message