Re: Examples of SQL anomalies?

From: -CELKO- <jcelko212_at_earthlink.net>
Date: Fri, 27 Jun 2008 08:20:51 -0700 (PDT)
Message-ID: <5ec6b5e8-5ed9-40e8-8b71-12b5037e6940@m44g2000hsc.googlegroups.com>


>> This critique is still accurate <<

No, some things have changed with the addition of table and row constructors using (VALUES (), (), ..) AS <table name>, row comparisons, the UNION, INTERSECT and EXCEPT, etc.

What is driving me nuts is allowing an alias in UPDATE and MERGE clauses. The model for an alias has been that a working table is effectively created with the alias (correlation) name and it disappears at the end of the statement.

The fact that SUM({}) IS NULL (undefined) and SUM(a) + SUM(b) <> SUM(a +b) is not a problem, if you have enough math to understand that summation (big sigma) is not addition (+) when you deal with sets. Received on Fri Jun 27 2008 - 10:20:51 CDT

Original text of this message