Re: Celko: help with an experiment

From: Guillermo Labatte <labatteg_at_yahoo.com>
Date: Thu, 04 Jul 2002 08:52:20 -0300
Message-ID: <3D2436F4.8000806_at_yahoo.com>

Informix 5.10 on AIX 4.3.2.0

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

  [ ] 99

  [ ] NULL

  [ ] Empty set

  [ ] Warning

[X] 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

[X] Fatal error
[ ] Other
Received on Thu Jul 04 2002 - 13:52:20 CEST