Re: Celko: help with an experiment

From: Tobin Harris <comedyharris_at_hotmail.com>
Date: Thu, 4 Jul 2002 15:25:45 +0100
Message-ID: <ag1ltg$i62vr$1_at_ID-135366.news.dfncis.de>


Here are the results from MS SQL Server 2000 running on Windows 2000 Server.

In short form: ( 1, 1, Empty Set, Null, 99, 0 )

Tobin

 CREATE TABLE Foobar (I INTEGER NOT NULL);

INSERT INTO Foobar VALUES (1);

  1. SELECT * FROM Foobar;

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

2) SELECT MAX(i) FROM Foobar;

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

3) SELECT * FROM Foobar WHERE 1 = 0;

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

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

[ ] 0
[ ] 1
[ ] 99
[X] 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
[X] 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;
[X] 0
[ ] 1
[ ] 99
[ ] NULL
[ ] Empty set

 [ ] Warning
[ ] Fatal error
[ ] Other
Received on Thu Jul 04 2002 - 16:25:45 CEST

Original text of this message