Update of /cvsroot/monetdb/sql/src/backends/monet4
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv13637/src/backends/monet4
Modified Files:
Tag: SQL_2-16
sql_server.mx
Log Message:
We implemented RANK as ROW_NUMBER which isn't correct afcourse
So now added ROW_NUMBER and a new implementation for RANK.
Index: sql_server.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet4/sql_server.mx,v
retrieving revision 1.157.2.5
retrieving revision 1.157.2.6
diff -u -d -r1.157.2.5 -r1.157.2.6
--- sql_server.mx 31 Mar 2007 17:25:36 -0000 1.157.2.5
+++ sql_server.mx 31 Mar 2007 20:34:02 -0000 1.157.2.6
@@ -1417,7 +1417,22 @@
proc [identity](bat[oid,any::1] b) : bat[oid,oid] { return mirror(b); }
proc {mark_grp}(BAT[oid,any::1] b, any::2 a, BAT[oid,oid] g) : BAT[oid,oid] {
- return mark_grp(b,g,[EMAIL PROTECTED]);
+ return [int](mark_grp(b,g,[EMAIL PROTECTED]));
+}
+proc mark_grp(BAT[oid,any::1] b) : BAT[oid,oid] {
+ return [int](mark(b,[EMAIL PROTECTED]));
+}
+proc {rank_grp}(BAT[oid,any::1] b, BAT[oid,oid] gp, BAT[oid,oid] gpe) :
BAT[oid,oid] {
+ var g := CTderive(gp,b);
+ var m := g.map();
+ var e := [int](g.extend().mirror());
+ return join(m, e);
+}
+proc rank_grp(BAT[oid,any::1] b) : BAT[oid,int] {
+ var g := CTgroup(b);
+ var m := g.map();
+ var e := [int](g.extend().mirror());
+ return join(m, e);
}
tzone_local(TIMEZONE("GMT"));
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
