Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv13637/src/test/Tests
Modified Files:
Tag: SQL_2-16
rank.stable.out
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: rank.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/Attic/rank.stable.out,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- rank.stable.out 31 Mar 2007 17:21:36 -0000 1.1.2.1
+++ rank.stable.out 31 Mar 2007 20:34:04 -0000 1.1.2.2
@@ -23,150 +23,294 @@
% sys. # table_name
% foo # name
-% oid # type
+% int # type
% 2 # length
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
+[ 0 ]
+[ 1 ]
+[ 2 ]
+[ 3 ]
+[ 4 ]
+[ 5 ]
+[ 6 ]
+[ 7 ]
+[ 8 ]
+[ 9 ]
+[ 10 ]
+[ 11 ]
+[ 12 ]
+[ 13 ]
+[ 14 ]
+[ 15 ]
+[ 16 ]
+[ 17 ]
+[ 18 ]
+[ 19 ]
+[ 20 ]
+[ 21 ]
+[ 22 ]
+[ 23 ]
+[ 24 ]
+[ 25 ]
+[ 26 ]
+[ 27 ]
+[ 28 ]
+[ 29 ]
+[ 30 ]
+[ 31 ]
% sys.tables, sys.tables # table_name
% foo, schema_id # name
-% oid, int # type
+% int, int # type
% 2, 4 # length
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
+[ 0, 4585 ]
+[ 1, 4585 ]
+[ 2, 4585 ]
+[ 3, 4585 ]
+[ 4, 4585 ]
+[ 5, 4585 ]
+[ 6, 4585 ]
+[ 7, 4585 ]
+[ 8, 4585 ]
+[ 9, 4585 ]
+[ 10, 4585 ]
+[ 11, 4585 ]
+[ 12, 4585 ]
+[ 0, 4684 ]
+[ 1, 4684 ]
+[ 2, 4684 ]
+[ 3, 4684 ]
+[ 4, 4684 ]
+[ 5, 4684 ]
+[ 13, 4585 ]
+[ 14, 4585 ]
+[ 15, 4585 ]
+[ 16, 4585 ]
+[ 17, 4585 ]
+[ 18, 4585 ]
+[ 19, 4585 ]
+[ 6, 4684 ]
+[ 20, 4585 ]
+[ 21, 4585 ]
+[ 22, 4585 ]
+[ 23, 4585 ]
+[ 24, 4585 ]
% sys.tables, sys.tables # table_name
% foo, schema_id # name
-% oid, int # type
+% int, int # type
% 2, 4 # length
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
+[ 0, 4585 ]
+[ 1, 4585 ]
+[ 2, 4585 ]
+[ 3, 4585 ]
+[ 4, 4585 ]
+[ 5, 4585 ]
+[ 6, 4585 ]
+[ 7, 4585 ]
+[ 8, 4585 ]
+[ 9, 4585 ]
+[ 10, 4585 ]
+[ 11, 4585 ]
+[ 12, 4585 ]
+[ 0, 4684 ]
+[ 1, 4684 ]
+[ 2, 4684 ]
+[ 3, 4684 ]
+[ 4, 4684 ]
+[ 5, 4684 ]
+[ 13, 4585 ]
+[ 14, 4585 ]
+[ 15, 4585 ]
+[ 16, 4585 ]
+[ 17, 4585 ]
+[ 18, 4585 ]
+[ 19, 4585 ]
+[ 6, 4684 ]
+[ 20, 4585 ]
+[ 21, 4585 ]
+[ 22, 4585 ]
+[ 23, 4585 ]
+[ 24, 4585 ]
% ., sys.tables # table_name
% foo, schema_id # name
-% oid, int # type
+% int, int # type
% 2, 4 # length
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4676 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
-[ [EMAIL PROTECTED], 4577 ]
+[ 0, 4585 ]
+[ 1, 4585 ]
+[ 2, 4585 ]
+[ 3, 4585 ]
+[ 4, 4585 ]
+[ 5, 4585 ]
+[ 6, 4585 ]
+[ 7, 4585 ]
+[ 8, 4585 ]
+[ 9, 4585 ]
+[ 10, 4585 ]
+[ 11, 4585 ]
+[ 12, 4585 ]
+[ 13, 4585 ]
+[ 14, 4585 ]
+[ 15, 4585 ]
+[ 16, 4585 ]
+[ 17, 4585 ]
+[ 18, 4585 ]
+[ 19, 4585 ]
+[ 20, 4585 ]
+[ 21, 4585 ]
+[ 22, 4585 ]
+[ 23, 4585 ]
+[ 24, 4585 ]
+[ 25, 4684 ]
+[ 26, 4684 ]
+[ 27, 4684 ]
+[ 28, 4684 ]
+[ 29, 4684 ]
+[ 30, 4684 ]
+[ 31, 4684 ]
+% sys. # table_name
+% foo # name
+% int # type
+% 2 # length
+[ 0 ]
+[ 1 ]
+[ 2 ]
+[ 3 ]
+[ 4 ]
+[ 5 ]
+[ 6 ]
+[ 7 ]
+[ 8 ]
+[ 9 ]
+[ 10 ]
+[ 11 ]
+[ 12 ]
+[ 13 ]
+[ 14 ]
+[ 15 ]
+[ 16 ]
+[ 17 ]
+[ 18 ]
+[ 19 ]
+[ 20 ]
+[ 21 ]
+[ 22 ]
+[ 23 ]
+[ 24 ]
+[ 25 ]
+[ 26 ]
+[ 27 ]
+[ 28 ]
+[ 29 ]
+[ 30 ]
+[ 31 ]
+% sys.tables, sys.tables # table_name
+% foo, schema_id # name
+% int, int # type
+% 2, 4 # length
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 13, 4684 ]
+[ 13, 4684 ]
+[ 13, 4684 ]
+[ 13, 4684 ]
+[ 13, 4684 ]
+[ 13, 4684 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 13, 4684 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+% sys.tables, sys.tables # table_name
+% foo, schema_id # name
+% int, int # type
+% 2, 4 # length
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 13, 4684 ]
+[ 13, 4684 ]
+[ 13, 4684 ]
+[ 13, 4684 ]
+[ 13, 4684 ]
+[ 13, 4684 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 13, 4684 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+% ., sys.tables # table_name
+% foo, schema_id # name
+% int, int # type
+% 2, 4 # length
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 0, 4585 ]
+[ 16, 4684 ]
+[ 16, 4684 ]
+[ 16, 4684 ]
+[ 16, 4684 ]
+[ 16, 4684 ]
+[ 16, 4684 ]
+[ 16, 4684 ]
-# 19:18:12 >
-# 19:18:12 > Done.
-# 19:18:12 >
+# 22:17:03 >
+# 22:17:03 > Done.
+# 22:17:03 >
-------------------------------------------------------------------------
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
