Re: Celko: help with an experiment

DB2 7.2.3

CREATE TABLE Foobar (I INTEGER NOT NULL) DB20000I The SQL command completed successfully.

INSERT INTO Foobar VALUES (1)
DB20000I The SQL command completed successfully.

SELECT * FROM Foobar

I

          1

  1 record(s) selected.

SELECT MAX(i) FROM Foobar

1

          1

  1 record(s) selected.

SELECT * FROM Foobar WHERE 1 = 0

I

   record(s) selected.

SELECT MAX(i) FROM Foobar WHERE 1 = 0

1

          -

  1 record(s) selected.

SELECT CASE WHEN 1 = 1 THEN 99 ELSE COUNT(*) END AS x FROM Foobar WHERE 1 = 0 X

         99

  1 record(s) selected.

SELECT CASE WHEN 1 = 0 THEN 99 ELSE COUNT(*) END AS x FROM Foobar WHERE 1 = 0 X

  1 record(s) selected.

--
Posted via http://dbforums.com