Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv28088/src/test/BugTracker-2009/Tests
Added Files:
LE_vs_GE_in_CASE.SF-2562264.sql
Log Message:
propagated changes of Tuesday Feb 03 2009 - Wednesday Feb 04 2009
from the Feb2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/02/03 - stmane:
src/test/BugTracker-2009/Tests/LE_vs_GE_in_CASE.SF-2562264.sql,1.1.2.1
added test for
[ 2562264 ] <= (LE) in CASE interpreted as >= (GE)
https://sourceforge.net/tracker/index.php?func=detail&aid=2562264&group_id=56967&atid=482468
With all three releases, Jun2008, Nov2008 & Feb2009,
"<=" seems to be incorrectly interpreted as ">=",
while "<", "=", ">=", ">" seem to work fine with all releases
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: LE_vs_GE_in_CASE.SF-2562264.sql ---
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
;
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
;
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
;
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
;
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
;
------------------------------------------------------------------------------
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
