Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv22578/src/test/BugTracker-2009/Tests
Added Files:
case_evaluates_all_branches.SF-2893484.sql
Log Message:
propagated changes of Wednesday Nov 11 2009 - Thursday Nov 12 2009
from the Nov2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/11/11 - nielsnes:
src/test/BugTracker-2009/Tests/case_evaluates_all_branches.SF-2893484.sql,1.1.2.1
add test for bug 2893484
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: case_evaluates_all_branches.SF-2893484.sql ---
create table stats_2009_week_31 (
payout_units_cpc int,
payout_cpc int
);
insert into stats_2009_week_31 values (0,1),
(0,2),
(0,0),
(0,0),
(0,0);
SELECT CASE SUM(payout_units_cpc) WHEN 0 THEN 0 ELSE 1 END AS avg_cost_cpc FROM
stats_2009_week_31;
SELECT CASE SUM(payout_units_cpc) WHEN 0 THEN 0 ELSE cast(SUM(payout_units_cpc
* payout_cpc) as numeric(12,4)) / SUM(payout_units_cpc) END AS avg_cost_cpc
FROM stats_2009_week_31;
drop table stats_2009_week_31;
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
