Re: Celko: help with an experiment

From: Paulie <paul_at_not.a.chance.eircom.net>
Date: Sat, 06 Jul 2002 22:58:28 GMT
Message-ID: <3d277394.76548430@news1.eircom.net>

71062.1056_at_compuserve.com (--CELKO--) wrote:

I am using Firebird (a derivative of Interbase Open Source - see www.ibphoenix.com for details...

I am using release 1 - Wi-V6.794 Firebird 1.0

> CREATE TABLE Foobar (I INTEGER NOT NULL);
> INSERT INTO Foobar VALUES (1);

> 1) SELECT * FROM Foobar;
> [X ] 1
 

> 2) SELECT MAX(i) FROM Foobar;
> [X ] 1

> 3) SELECT * FROM Foobar WHERE 1 = 0;
> [X ] NULL

> 4) SELECT MAX(i) FROM Foobar WHERE 1 = 0;
> [X ] NULL

> 5) SELECT CASE WHEN 1 = 1
[X]Other

• see message ----------------

ISC ERROR CODE:335544569 ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 13
WHEN Statement: SELECT CASE WHEN 1 = 1

        THEN 99
        ELSE COUNT(*) END AS x

   FROM Foobar
   WHERE 1 = 0

---

 

> 6) SELECT CASE WHEN 1 = 0

> [X ] Other

• see message------------------------ ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 13
WHEN Statement: SELECT CASE WHEN 1 = 0

        THEN 99
        ELSE COUNT(*) END AS x

   FROM Foobar
   WHERE 1 = 0

---

Hope this is of use to you.

Paul...  

> --CELKO--
Received on Sat Jul 06 2002 - 17:58:28 CDT