Re: Celko: help with an experiment
Date: 12 Jul 2002 18:18:46 -0700
Message-ID: <6dad5e97.0207121718.292ccfc7_at_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
5) SELECT CASE WHEN 1 = 1
[ ] 1
[ ] 99
[ ] NULL
[x] Empty set
[ ] Warning
[ ] Fatal error
[ ] Other
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 Sat Jul 13 2002 - 03:18:46 CEST