Path: news.easynews.com!easynews!zeus.visi.com!news-out.visi.com!hermes.visi.com!newsfeed.news2me.com!west.cox.net!cox.net!news-hub.cableinet.net!blueyonder!btnet-peer!btnet!diablo.theplanet.net!news.indigo.ie!not-for-mail From: paul@not.a.chance.eircom.net (Paulie) Newsgroups: comp.databases.theory Subject: Re: Celko: help with an experiment Message-ID: <3d277394.76548430@news1.eircom.net> References: X-Newsreader: Forte Free Agent 1.21/32.243 Lines: 82 Date: Sat, 06 Jul 2002 22:58:28 GMT NNTP-Posting-Host: 159.134.177.31 X-Complaints-To: abuse@eircom.net X-Trace: news.indigo.ie 1025996408 159.134.177.31 (Sun, 07 Jul 2002 00:00:08 BST) NNTP-Posting-Date: Sun, 07 Jul 2002 00:00:08 BST Organization: Eircom.Net http://www.eircom.net Xref: easynews comp.databases.theory:21650 X-Received-Date: Sat, 06 Jul 2002 15:57:25 MST (news.easynews.com) 71062.1056@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--