Re: Celko: help with an experiment
Date: Sat, 06 Jul 2002 22:58:28 GMT
Message-ID: <3d277394.76548430_at_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
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 Sun Jul 07 2002 - 00:58:28 CEST