Update of /cvsroot/monetdb/sql/src/test
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv29277/src/test
Modified Files:
rank.sql
Log Message:
approved output after
1) added new dense_rank test
2) fixes too row_number (start at 1 now)
3) fixes to algebra version
4) output now requires io.stdout()
Index: rank.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/rank.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- rank.sql 1 Apr 2007 22:08:58 -0000 1.2
+++ rank.sql 25 Feb 2008 22:28:00 -0000 1.3
@@ -7,3 +7,13 @@
select RANK() over (PARTITION BY schema_id) as foo, schema_id from tables;
select RANK() over (PARTITION BY schema_id ORDER BY schema_id) as foo,
schema_id from tables;
select RANK() over (ORDER BY schema_id) as foo, schema_id from tables;
+
+select RANK() over () as foo, name, "type" from columns;
+select RANK() over (PARTITION BY name) as foo, name, "type" from columns;
+select RANK() over (PARTITION BY name ORDER BY name, "type") as foo, name,
"type" from columns;
+select RANK() over (ORDER BY name, "type") as foo, name, "type" from columns;
+
+select DENSE_RANK() over () as foo, name, "type" from columns;
+select DENSE_RANK() over (PARTITION BY name) as foo, name, "type" from columns;
+select DENSE_RANK() over (PARTITION BY name ORDER BY name, "type") as foo,
name, "type" from columns;
+select DENSE_RANK() over (ORDER BY name, "type") as foo, name, "type" from
columns;
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
