Update of /cvsroot/monetdb/sql/src/test/BugTracker-2010/Tests
In directory
sfp-cvsdas-4.v30.ch3.sourceforge.com:/tmp/cvs-serv8724/src/test/BugTracker-2010/Tests
Added Files:
rank-over-crash.SF-2926454.sql
Log Message:
propagated changes of Friday Apr 16 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/04/16 - sjoerd:
src/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.sql,1.1.2.1
Test for bug 2926454.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: rank-over-crash.SF-2926454.sql ---
-- preparation
create table score_table (
s_name varchar(20),
subject varchar(10),
score int
);
insert into score_table values('foo','english',70);
insert into score_table values('foo','history',50);
insert into score_table values('foo','math',60);
insert into score_table values('bar','english',45);
insert into score_table values('bar','history',75);
-- this causes an assertion failure:
select
s_name,
sum(score) as totalscore,
rank() over (order by sum(score) desc) -- cannot use alias 'totalscore' here
from score_table
group by s_name;
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
