Re: Celko: help with an experiment

Sibyl v5.7:

SQL>CREATE TABLE Foobar (I INTEGER NOT NULL);

Grudgingly created.  

SQL> INSERT INTO Foobar VALUES (1);

Added the thingy.

SQL> SELECT * FROM Foobar;

I

SQL> SELECT MAX(i) FROM Foobar;

MAX(I)

SQL> SELECT * FROM Foobar WHERE 1 = 0;

Sibyl-01289: Take some math in local community college to learn that 1 is not equal to 0  

SQL> SELECT MAX(i) FROM Foobar WHERE 1 = 0;

Sibyl-01297: Why do you still believe that 1 = 0 ?

SQL> SELECT CASE WHEN 1 = 1

               THEN 99
                ELSE COUNT(*) END AS x
      FROM Foobar
     WHERE 1 = 0;

Sibyl-01293: Tired of this "1 = 0". Ninety Nine, if you insist.

SQL> SELECT CASE WHEN 1 = 0

                THEN 99
                ELSE COUNT(*) END AS x
      FROM Foobar
     WHERE 1 = 0;

Sibyl-01291: Stop trolling with this "1 = 0"! Giving up: go count yorself. Received on Sat Jul 06 2002 - 21:48:36 CEST