Re: Celko: help with an experiment

From: Saurabh Bhatnagar <Saurabh.Bhatnagar_at_ca.com>
Date: 12 Jul 2002 18:18:46 -0700
Message-ID: <6dad5e97.0207121718.292ccfc7@posting.google.com>

On Ingres II 2.6/0201 (int.w32/00) -
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
[ ] NULL
[x] 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 Fri Jul 12 2002 - 20:18:46 CDT