Re: Celko: help with an experiment

Alphora Dataphor DAE v1.0:

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 [ ] Empty set [ ] Warning [ ] Fatal error
[X] Other: -2147483648 [Minimum Representable "Integer" value]

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

These are all correct as far as the relational model is concerned.

Yes, there are several "serious flaw[s] in the Standards" as pointed out by C. J. Date on numerous occasions. For example, the paper: "Empty Bags and Identity Crises" originally published in Database Programming and Design 6, no. 4 (April 1993)

--
--
Nathan Allan
SPAM_nathan_NOT_at_alphora.com

--
Nathan Allan
SPAM_nathan_NOT_at_alphora.com

Posted via dBforums
http://dbforums.com