Re: Examples of SQL anomalies?

From: Gene Wirchenko <genew_at_ocis.net>
Date: Thu, 26 Jun 2008 15:01:49 -0700
Message-ID: <584864hn8lrkuu42a4vn97eaeu8orjerjc@4ax.com>


"Artemus Ward" <artemus.ward_at_no.viagra.thanks> wrote:

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

     Let me add another item.

     Joins will often give trouble with ambiguity of names. Never mind that I am joining on the two columns having the same value. If they have the same name, I have to prefix them with the table name.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.
Received on Thu Jun 26 2008 - 17:01:49 CDT

Original text of this message