Update of /cvsroot/monetdb/sql/src/test/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv23123/src/test/Tests
Modified Files:
rank.stable.out
Log Message:
added another column in the catalog for function side effect administration
Functions which have side effects (such as rand and next_value (sequences)),
are now called once per row, even if the function doesn't have arguments.
The last case expects functions/procs to be available with one argument
which isn't used (needed for the multiplex call).
order by needs selection columns (ie no relaxed semantics if there are
group by's)
this fixes bugs
[ 1723863 ] SQL Query Crashes Server - CRITICAL
[ 1723791 ] rand() is not executed for every row
Index: rank.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/rank.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- rank.stable.out 26 Apr 2007 14:35:10 -0000 1.4
+++ rank.stable.out 23 May 2007 22:06:02 -0000 1.5
@@ -61,110 +61,110 @@
% foo, schema_id # name
% int, int # type
% 2, 3 # length
-[ 0, 844 ]
-[ 1, 844 ]
-[ 2, 844 ]
-[ 3, 844 ]
-[ 4, 844 ]
-[ 5, 844 ]
-[ 6, 844 ]
-[ 7, 844 ]
-[ 8, 844 ]
-[ 9, 844 ]
-[ 10, 844 ]
-[ 11, 844 ]
-[ 12, 844 ]
-[ 0, 944 ]
-[ 1, 944 ]
-[ 2, 944 ]
-[ 3, 944 ]
-[ 4, 944 ]
-[ 5, 944 ]
-[ 13, 844 ]
-[ 14, 844 ]
-[ 15, 844 ]
-[ 16, 844 ]
-[ 17, 844 ]
-[ 18, 844 ]
-[ 19, 844 ]
-[ 6, 944 ]
-[ 20, 844 ]
-[ 21, 844 ]
-[ 22, 844 ]
-[ 23, 844 ]
-[ 24, 844 ]
+[ 0, 846 ]
+[ 1, 846 ]
+[ 2, 846 ]
+[ 3, 846 ]
+[ 4, 846 ]
+[ 5, 846 ]
+[ 6, 846 ]
+[ 7, 846 ]
+[ 8, 846 ]
+[ 9, 846 ]
+[ 10, 846 ]
+[ 11, 846 ]
+[ 12, 846 ]
+[ 0, 947 ]
+[ 1, 947 ]
+[ 2, 947 ]
+[ 3, 947 ]
+[ 4, 947 ]
+[ 5, 947 ]
+[ 13, 846 ]
+[ 14, 846 ]
+[ 15, 846 ]
+[ 16, 846 ]
+[ 17, 846 ]
+[ 18, 846 ]
+[ 19, 846 ]
+[ 6, 947 ]
+[ 20, 846 ]
+[ 21, 846 ]
+[ 22, 846 ]
+[ 23, 846 ]
+[ 24, 846 ]
% sys.tables, sys.tables # table_name
% foo, schema_id # name
% int, int # type
% 2, 3 # length
-[ 0, 844 ]
-[ 1, 844 ]
-[ 2, 844 ]
-[ 3, 844 ]
-[ 4, 844 ]
-[ 5, 844 ]
-[ 6, 844 ]
-[ 7, 844 ]
-[ 8, 844 ]
-[ 9, 844 ]
-[ 10, 844 ]
-[ 11, 844 ]
-[ 12, 844 ]
-[ 0, 944 ]
-[ 1, 944 ]
-[ 2, 944 ]
-[ 3, 944 ]
-[ 4, 944 ]
-[ 5, 944 ]
-[ 13, 844 ]
-[ 14, 844 ]
-[ 15, 844 ]
-[ 16, 844 ]
-[ 17, 844 ]
-[ 18, 844 ]
-[ 19, 844 ]
-[ 6, 944 ]
-[ 20, 844 ]
-[ 21, 844 ]
-[ 22, 844 ]
-[ 23, 844 ]
-[ 24, 844 ]
+[ 0, 846 ]
+[ 1, 846 ]
+[ 2, 846 ]
+[ 3, 846 ]
+[ 4, 846 ]
+[ 5, 846 ]
+[ 6, 846 ]
+[ 7, 846 ]
+[ 8, 846 ]
+[ 9, 846 ]
+[ 10, 846 ]
+[ 11, 846 ]
+[ 12, 846 ]
+[ 0, 947 ]
+[ 1, 947 ]
+[ 2, 947 ]
+[ 3, 947 ]
+[ 4, 947 ]
+[ 5, 947 ]
+[ 13, 846 ]
+[ 14, 846 ]
+[ 15, 846 ]
+[ 16, 846 ]
+[ 17, 846 ]
+[ 18, 846 ]
+[ 19, 846 ]
+[ 6, 947 ]
+[ 20, 846 ]
+[ 21, 846 ]
+[ 22, 846 ]
+[ 23, 846 ]
+[ 24, 846 ]
% ., sys.tables # table_name
% foo, schema_id # name
% int, int # type
% 2, 3 # length
-[ 0, 844 ]
-[ 1, 844 ]
-[ 2, 844 ]
-[ 3, 844 ]
-[ 4, 844 ]
-[ 5, 844 ]
-[ 6, 844 ]
-[ 7, 844 ]
-[ 8, 844 ]
-[ 9, 844 ]
-[ 10, 844 ]
-[ 11, 844 ]
-[ 12, 844 ]
-[ 13, 844 ]
-[ 14, 844 ]
-[ 15, 844 ]
-[ 16, 844 ]
-[ 17, 844 ]
-[ 18, 844 ]
-[ 19, 844 ]
-[ 20, 844 ]
-[ 21, 844 ]
-[ 22, 844 ]
-[ 23, 844 ]
-[ 24, 844 ]
-[ 25, 944 ]
-[ 26, 944 ]
-[ 27, 944 ]
-[ 28, 944 ]
-[ 29, 944 ]
-[ 30, 944 ]
-[ 31, 944 ]
+[ 0, 846 ]
+[ 1, 846 ]
+[ 2, 846 ]
+[ 3, 846 ]
+[ 4, 846 ]
+[ 5, 846 ]
+[ 6, 846 ]
+[ 7, 846 ]
+[ 8, 846 ]
+[ 9, 846 ]
+[ 10, 846 ]
+[ 11, 846 ]
+[ 12, 846 ]
+[ 13, 846 ]
+[ 14, 846 ]
+[ 15, 846 ]
+[ 16, 846 ]
+[ 17, 846 ]
+[ 18, 846 ]
+[ 19, 846 ]
+[ 20, 846 ]
+[ 21, 846 ]
+[ 22, 846 ]
+[ 23, 846 ]
+[ 24, 846 ]
+[ 25, 947 ]
+[ 26, 947 ]
+[ 27, 947 ]
+[ 28, 947 ]
+[ 29, 947 ]
+[ 30, 947 ]
+[ 31, 947 ]
% sys. # table_name
% foo # name
% int # type
@@ -205,110 +205,110 @@
% foo, schema_id # name
% int, int # type
% 2, 3 # length
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 13, 944 ]
-[ 13, 944 ]
-[ 13, 944 ]
-[ 13, 944 ]
-[ 13, 944 ]
-[ 13, 944 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 13, 944 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 13, 947 ]
+[ 13, 947 ]
+[ 13, 947 ]
+[ 13, 947 ]
+[ 13, 947 ]
+[ 13, 947 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 13, 947 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
% sys.tables, sys.tables # table_name
% foo, schema_id # name
% int, int # type
% 2, 3 # length
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 13, 944 ]
-[ 13, 944 ]
-[ 13, 944 ]
-[ 13, 944 ]
-[ 13, 944 ]
-[ 13, 944 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 13, 944 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 13, 947 ]
+[ 13, 947 ]
+[ 13, 947 ]
+[ 13, 947 ]
+[ 13, 947 ]
+[ 13, 947 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 13, 947 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
% ., sys.tables # table_name
% foo, schema_id # name
% int, int # type
% 2, 3 # length
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 0, 844 ]
-[ 16, 944 ]
-[ 16, 944 ]
-[ 16, 944 ]
-[ 16, 944 ]
-[ 16, 944 ]
-[ 16, 944 ]
-[ 16, 944 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 0, 846 ]
+[ 16, 947 ]
+[ 16, 947 ]
+[ 16, 947 ]
+[ 16, 947 ]
+[ 16, 947 ]
+[ 16, 947 ]
+[ 16, 947 ]
# 22:17:03 >
# 22:17:03 > Done.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
