Re: Celko: help with an experiment

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