Update of /cvsroot/monetdb/sql/src/test/BugTracker-2010/Tests
In directory
sfp-cvsdas-4.v30.ch3.sourceforge.com:/tmp/cvs-serv5626/sql/src/test/BugTracker-2010/Tests
Modified Files:
Tag: Feb2010
All
Added Files:
Tag: Feb2010
rank-over-crash.SF-2926454.sql
rank-over-crash.SF-2926454.stable.err
rank-over-crash.SF-2926454.stable.out
Log Message:
Test for bug 2926454.
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2010/Tests/All,v
retrieving revision 1.1.2.8
retrieving revision 1.1.2.9
diff -u -d -r1.1.2.8 -r1.1.2.9
--- All 15 Apr 2010 14:16:30 -0000 1.1.2.8
+++ All 16 Apr 2010 14:45:22 -0000 1.1.2.9
@@ -4,3 +4,4 @@
offset_limited_32bit.SF-2950579
correlated_update_type_mismatch.SF-2947841
heap_combine_crash.SF-2947763
+rank-over-crash.SF-2926454
--- NEW FILE: rank-over-crash.SF-2926454.stable.err ---
When the bug is fixed, output can be provided.
--- 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;
--- NEW FILE: rank-over-crash.SF-2926454.stable.out ---
When the bug is fixed, output can be provided.
------------------------------------------------------------------------------
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
