Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv29216/src/test/BugTracker-2009/Tests
Added Files:
IS_NULL_in_CASE.sql
Log Message:
propagated changes of Wednesday Feb 04 2009
from the Feb2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/02/04 - stmane: src/test/BugTracker-2009/Tests/IS_NULL_in_CASE.sql,1.1.2.1
added test for
[ 2523442 ] IS NULL handled wrong in searched CASE
https://sourceforge.net/tracker/index.php?func=detail&aid=2523442&group_id=56967&atid=482468
fails as reported
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: IS_NULL_in_CASE.sql ---
CREATE TABLE "sometable" (
"somecol" INTEGER
)
;
INSERT INTO "sometable" VALUES ( 0);
INSERT INTO "sometable" VALUES ( 1);
INSERT INTO sometable VALUES (NULL);
SELECT somecol
, CASE
WHEN somecol < 6 THEN 'small'
WHEN somecol = 6 THEN 'six'
WHEN somecol > 6 AND somecol < 9 THEN '78'
WHEN somecol IS NULL THEN 'NULL FOUND'
ELSE 'big'
END AS "NewColumnName"
FROM sometable
;
SELECT somecol
, CASE
WHEN somecol IS NULL THEN 'NULL FOUND'
WHEN somecol < 6 THEN 'small'
WHEN somecol = 6 THEN 'six'
WHEN somecol > 6 AND somecol < 9 THEN '78'
ELSE 'big'
END AS "NewColumnName"
FROM sometable
;
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
