Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv14014/src/test/BugTracker-2009/Tests
Added Files:
caselessthen.sql
Log Message:
propagated changes of Thursday Feb 12 2009
from the Feb2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/02/12 - mlkersten: src/test/BugTracker-2009/Tests/caselessthen.sql,1.1.2.1
Another pair of bugs resolved. The optimizers did not properly react to
a type-error (and roll back).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: caselessthen.sql ---
create table tcase(i int);
insert into tcase values(10);
insert into tcase values(11);
insert into tcase values(12);
insert into tcase values(13);
select x
, case when x<=12 then 1 else 0 end as log
from (
select 10 as x
union
select 11 as x
union
select 12 as x
union
select 13 as x
) sub
;
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
