Re: Celko: help with an experiment

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

ThinkSQL www.thinksql.co.uk - an RDBMS engine that one can get with delphi...

W2000 Pro.

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

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

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

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

> 5) SELECT CASE WHEN 1 = 1
> THEN 99
> ELSE COUNT(*) END AS x
> FROM Foobar
> WHERE 1 = 0;
> [X ] 99

> 6) SELECT CASE WHEN 1 = 0
> THEN 99
> ELSE COUNT(*) END AS x
> FROM Foobar
> WHERE 1 = 0;
 
> [X ] 0

Paul...

> --CELKO--
Received on Sat Jul 06 2002 - 19:01:22 CDT