Celko: help with an experiment

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 3 Jul 2002 12:05:20 -0700
Message-ID: <c0d87ec0.0207031105.996ef17_at_posting.google.com>

Please be so kind as to run this set of queries on any SQL products you have. They are short. Then send me your answers and the name and version of the SQL product you used.

I want to use this information in a article or my next book. I think there is a serious flaw in the Standards and want to investigate.

CREATE TABLE Foobar (I INTEGER NOT NULL);

INSERT INTO Foobar VALUES (1);

1. SELECT * FROM Foobar;

[ ] 0
[ ] 1
[ ] 99
[ ] NULL
[ ] Empty set
[ ] Warning
[ ] Fatal error
[ ] Other

2) SELECT MAX(i) FROM Foobar;

[ ] 0
[ ] 1
[ ] 99
[ ] NULL
[ ] Empty set
[ ] Warning
[ ] Fatal error
[ ] Other

3) SELECT * FROM Foobar WHERE 1 = 0;

[ ] 0
[ ] 1
[ ] 99
[ ] NULL
[ ] Empty set
[ ] Warning
[ ] Fatal error
[ ] Other

4) SELECT MAX(i) FROM Foobar WHERE 1 = 0;

[ ] 0
[ ] 1
[ ] 99
[ ] NULL
[ ] Empty set
[ ] Warning
[ ] Fatal error
[ ] Other

5) SELECT CASE WHEN 1 = 1

               THEN 99
               ELSE COUNT(*) END AS x
     FROM Foobar

    WHERE 1 = 0;
[ ] 0
[ ] 1
[ ] 99
[ ] NULL
[ ] Empty set
[ ] Warning
[ ] Fatal error
[ ] Other

6) SELECT CASE WHEN 1 = 0

               THEN 99
               ELSE COUNT(*) END AS x
     FROM Foobar

    WHERE 1 = 0;
[ ] 0
[ ] 1
[ ] 99
[ ] NULL
[ ] Empty set
[ ] Warning
[ ] Fatal error
[ ] Other

 --CELKO-- Received on Wed Jul 03 2002 - 21:05:20 CEST