Update of /cvsroot/monetdb/sql/src/test/Tests
In directory
sfp-cvsdas-4.v30.ch3.sourceforge.com:/tmp/cvs-serv4419/src/test/Tests
Modified Files:
rank.stable.out
Log Message:
propagated changes of Sunday Apr 25 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/04/25 - nielsnes: src/test/Tests/rank.stable.out,1.24.2.1
passing error's from tablet via mvc structure into sql layer
approving related tests
added test for problem overflow error not reported on client (only dumped
on server)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: rank.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/rank.stable.out,v
retrieving revision 1.24
retrieving revision 1.25
diff -u -d -r1.24 -r1.25
--- rank.stable.out 15 Nov 2009 23:00:39 -0000 1.24
+++ rank.stable.out 25 Apr 2010 20:59:58 -0000 1.25
@@ -34,7 +34,25 @@
% sys. # table_name
% foo # name
% int # type
-% 2 # length
+% 1 # length
+[ 1 ]
+[ 2 ]
+[ 3 ]
+[ 4 ]
+[ 5 ]
+[ 6 ]
+[ 1 ]
+[ 2 ]
+[ 3 ]
+[ 4 ]
+[ 5 ]
+[ 6 ]
+[ 1 ]
+[ 2 ]
+[ 3 ]
+[ 4 ]
+[ 5 ]
+[ 6 ]
[ 1 ]
[ 2 ]
[ 3 ]
@@ -44,24 +62,7 @@
[ 7 ]
[ 8 ]
[ 9 ]
-[ 10 ]
-[ 11 ]
-[ 12 ]
-[ 13 ]
-[ 14 ]
-[ 15 ]
-[ 16 ]
-[ 17 ]
-[ 18 ]
-[ 19 ]
-[ 20 ]
-[ 21 ]
-[ 22 ]
-[ 23 ]
-[ 24 ]
-[ 25 ]
-[ 26 ]
-[ 27 ]
+#select ROW_NUMBER() over (PARTITION BY id) as foo, id from ranktest;
% ., sys.ranktest # table_name
% foo, id # name
% int, int # type
@@ -158,7 +159,25 @@
% sys. # table_name
% foo # name
% int # type
-% 2 # length
+% 1 # length
+[ 1 ]
+[ 2 ]
+[ 3 ]
+[ 4 ]
+[ 5 ]
+[ 6 ]
+[ 1 ]
+[ 2 ]
+[ 3 ]
+[ 4 ]
+[ 5 ]
+[ 6 ]
+[ 1 ]
+[ 2 ]
+[ 3 ]
+[ 4 ]
+[ 5 ]
+[ 6 ]
[ 1 ]
[ 2 ]
[ 3 ]
@@ -168,24 +187,7 @@
[ 7 ]
[ 8 ]
[ 9 ]
-[ 10 ]
-[ 11 ]
-[ 12 ]
-[ 13 ]
-[ 14 ]
-[ 15 ]
-[ 16 ]
-[ 17 ]
-[ 18 ]
-[ 19 ]
-[ 20 ]
-[ 21 ]
-[ 22 ]
-[ 23 ]
-[ 24 ]
-[ 25 ]
-[ 26 ]
-[ 27 ]
+#select RANK() over (PARTITION BY id) as foo, id from ranktest;
% ., sys.ranktest # table_name
% foo, id # name
% int, int # type
@@ -282,34 +284,35 @@
% sys., sys.ranktest, sys.ranktest # table_name
% foo, id, k # name
% int, int, clob # type
-% 2, 4, 8 # length
+% 1, 4, 8 # length
[ 1, 1061, "varchar" ]
[ 2, 1061, "int" ]
[ 3, 1061, "varchar" ]
[ 4, 1061, "varchar" ]
[ 5, 1061, "int" ]
[ 6, 1061, "int" ]
-[ 7, 1061, "varchar" ]
-[ 8, 1061, "varchar" ]
-[ 9, 1061, "boolean" ]
-[ 10, 1061, "boolean" ]
-[ 11, 1061, "int" ]
-[ 12, 1061, "varchar" ]
-[ 13, 1061, "char" ]
-[ 14, 1062, "int" ]
-[ 15, 1062, "char" ]
-[ 16, 1062, "char" ]
-[ 17, 1062, "int" ]
-[ 18, 1062, "smallint" ]
-[ 19, 1062, "boolean" ]
-[ 20, 1062, "smallint" ]
-[ 21, 1061, "int" ]
-[ 22, 1061, "varchar" ]
-[ 23, 1061, "int" ]
-[ 24, 1061, "varchar" ]
-[ 25, 1061, "int" ]
-[ 26, 1061, "int" ]
-[ 27, 1061, "smallint" ]
+[ 1, 1061, "varchar" ]
+[ 2, 1061, "varchar" ]
+[ 3, 1061, "boolean" ]
+[ 4, 1061, "boolean" ]
+[ 5, 1061, "int" ]
+[ 6, 1061, "varchar" ]
+[ 1, 1061, "char" ]
+[ 2, 1062, "int" ]
+[ 3, 1062, "char" ]
+[ 4, 1062, "char" ]
+[ 5, 1062, "int" ]
+[ 6, 1062, "smallint" ]
+[ 1, 1062, "boolean" ]
+[ 2, 1062, "smallint" ]
+[ 3, 1061, "int" ]
+[ 4, 1061, "varchar" ]
+[ 5, 1061, "int" ]
+[ 6, 1061, "varchar" ]
+[ 7, 1061, "int" ]
+[ 8, 1061, "int" ]
+[ 9, 1061, "smallint" ]
+#select RANK() over (PARTITION BY id) as foo, id, k from ranktest;
% ., sys.ranktest, sys.ranktest # table_name
% foo, id, k # name
% int, int, clob # type
@@ -407,80 +410,89 @@
% foo, id, k # name
% int, int, clob # type
% 2, 4, 8 # length
-[ 1, 1061, "varchar" ]
-[ 2, 1061, "int" ]
-[ 3, 1061, "varchar" ]
-[ 4, 1061, "varchar" ]
-[ 5, 1061, "int" ]
-[ 6, 1061, "int" ]
-[ 7, 1061, "varchar" ]
-[ 8, 1061, "varchar" ]
-[ 9, 1061, "boolean" ]
[ 10, 1061, "boolean" ]
-[ 11, 1061, "int" ]
-[ 12, 1061, "varchar" ]
+[ 19, 1062, "boolean" ]
+[ 9, 1061, "boolean" ]
+[ 16, 1062, "char" ]
[ 13, 1061, "char" ]
-[ 14, 1062, "int" ]
[ 15, 1062, "char" ]
-[ 16, 1062, "char" ]
+[ 6, 1061, "int" ]
+[ 21, 1061, "int" ]
+[ 25, 1061, "int" ]
+[ 26, 1061, "int" ]
+[ 11, 1061, "int" ]
+[ 2, 1061, "int" ]
[ 17, 1062, "int" ]
+[ 14, 1062, "int" ]
+[ 5, 1061, "int" ]
+[ 23, 1061, "int" ]
+[ 27, 1061, "smallint" ]
[ 18, 1062, "smallint" ]
-[ 19, 1062, "boolean" ]
[ 20, 1062, "smallint" ]
-[ 21, 1061, "int" ]
+[ 12, 1061, "varchar" ]
+[ 8, 1061, "varchar" ]
[ 22, 1061, "varchar" ]
-[ 23, 1061, "int" ]
+[ 7, 1061, "varchar" ]
[ 24, 1061, "varchar" ]
-[ 25, 1061, "int" ]
-[ 26, 1061, "int" ]
-[ 27, 1061, "smallint" ]
+[ 4, 1061, "varchar" ]
+[ 3, 1061, "varchar" ]
+[ 1, 1061, "varchar" ]
+#select DENSE_RANK() over (PARTITION BY id) as foo, id, k from ranktest order
by k;
% ., sys.ranktest, sys.ranktest # table_name
% foo, id, k # name
% int, int, clob # type
% 1, 4, 8 # length
-[ 1, 1061, "varchar" ]
-[ 1, 1061, "int" ]
-[ 1, 1061, "varchar" ]
-[ 1, 1061, "varchar" ]
-[ 1, 1061, "int" ]
-[ 1, 1061, "int" ]
-[ 1, 1061, "varchar" ]
-[ 1, 1061, "varchar" ]
[ 1, 1061, "boolean" ]
+[ 1, 1062, "boolean" ]
[ 1, 1061, "boolean" ]
-[ 1, 1061, "int" ]
-[ 1, 1061, "varchar" ]
+[ 1, 1062, "char" ]
[ 1, 1061, "char" ]
+[ 1, 1062, "char" ]
+[ 1, 1061, "int" ]
+[ 1, 1061, "int" ]
[ 1, 1061, "int" ]
-[ 1, 1061, "varchar" ]
[ 1, 1061, "int" ]
-[ 1, 1061, "varchar" ]
[ 1, 1061, "int" ]
[ 1, 1061, "int" ]
-[ 1, 1061, "smallint" ]
[ 1, 1062, "int" ]
-[ 1, 1062, "char" ]
-[ 1, 1062, "char" ]
[ 1, 1062, "int" ]
+[ 1, 1061, "int" ]
+[ 1, 1061, "int" ]
+[ 1, 1061, "smallint" ]
[ 1, 1062, "smallint" ]
-[ 1, 1062, "boolean" ]
[ 1, 1062, "smallint" ]
+[ 1, 1061, "varchar" ]
+[ 1, 1061, "varchar" ]
+[ 1, 1061, "varchar" ]
+[ 1, 1061, "varchar" ]
+[ 1, 1061, "varchar" ]
+[ 1, 1061, "varchar" ]
+[ 1, 1061, "varchar" ]
+[ 1, 1061, "varchar" ]
+#select DENSE_RANK() over (PARTITION BY id ORDER BY id, k) as foo, id, k from
ranktest order by k;
% ., sys.ranktest, sys.ranktest # table_name
% foo, id, k # name
% int, int, clob # type
% 1, 4, 8 # length
[ 1, 1061, "boolean" ]
+[ 1, 1062, "boolean" ]
[ 1, 1061, "boolean" ]
+[ 2, 1062, "char" ]
[ 2, 1061, "char" ]
+[ 2, 1062, "char" ]
[ 3, 1061, "int" ]
[ 3, 1061, "int" ]
[ 3, 1061, "int" ]
[ 3, 1061, "int" ]
[ 3, 1061, "int" ]
[ 3, 1061, "int" ]
+[ 3, 1062, "int" ]
+[ 3, 1062, "int" ]
[ 3, 1061, "int" ]
[ 3, 1061, "int" ]
[ 4, 1061, "smallint" ]
+[ 4, 1062, "smallint" ]
+[ 4, 1062, "smallint" ]
[ 5, 1061, "varchar" ]
[ 5, 1061, "varchar" ]
[ 5, 1061, "varchar" ]
@@ -489,29 +501,30 @@
[ 5, 1061, "varchar" ]
[ 5, 1061, "varchar" ]
[ 5, 1061, "varchar" ]
-[ 1, 1062, "boolean" ]
-[ 2, 1062, "char" ]
-[ 2, 1062, "char" ]
-[ 3, 1062, "int" ]
-[ 3, 1062, "int" ]
-[ 4, 1062, "smallint" ]
-[ 4, 1062, "smallint" ]
+#select DENSE_RANK() over (ORDER BY id, k) as foo, id, k from ranktest order
by k;
% ., sys.ranktest, sys.ranktest # table_name
% foo, id, k # name
% int, int, clob # type
% 1, 4, 8 # length
[ 1, 1061, "boolean" ]
+[ 6, 1062, "boolean" ]
[ 1, 1061, "boolean" ]
+[ 7, 1062, "char" ]
[ 2, 1061, "char" ]
+[ 7, 1062, "char" ]
[ 3, 1061, "int" ]
[ 3, 1061, "int" ]
[ 3, 1061, "int" ]
[ 3, 1061, "int" ]
[ 3, 1061, "int" ]
[ 3, 1061, "int" ]
+[ 8, 1062, "int" ]
+[ 8, 1062, "int" ]
[ 3, 1061, "int" ]
[ 3, 1061, "int" ]
[ 4, 1061, "smallint" ]
+[ 9, 1062, "smallint" ]
+[ 9, 1062, "smallint" ]
[ 5, 1061, "varchar" ]
[ 5, 1061, "varchar" ]
[ 5, 1061, "varchar" ]
@@ -520,13 +533,6 @@
[ 5, 1061, "varchar" ]
[ 5, 1061, "varchar" ]
[ 5, 1061, "varchar" ]
-[ 6, 1062, "boolean" ]
-[ 7, 1062, "char" ]
-[ 7, 1062, "char" ]
-[ 8, 1062, "int" ]
-[ 8, 1062, "int" ]
-[ 9, 1062, "smallint" ]
-[ 9, 1062, "smallint" ]
# 20:30:44 >
# 20:30:44 > Done.
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
