Update of /cvsroot/monetdb/sql/src/benchmarks/arno/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv31468/src/benchmarks/arno/Tests
Modified Files:
check0a.stable.out check1a.stable.out
Log Message:
cleanup some more pre-remap.optimzer code
approved some output of tests
bumped the SQL_VERSION (ie the catalog got changed by romulo)
Index: check0a.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/arno/Tests/check0a.stable.out,v
retrieving revision 1.83
retrieving revision 1.84
diff -u -d -r1.83 -r1.84
--- check0a.stable.out 1 Apr 2007 22:08:56 -0000 1.83
+++ check0a.stable.out 17 Apr 2007 12:27:06 -0000 1.84
@@ -93,6 +93,7 @@
[ [EMAIL PROTECTED], "oid", "int", 0 ]
[ [EMAIL PROTECTED], "oid", "int", 0 ]
[ [EMAIL PROTECTED], "oid", "int", 0 ]
+[ [EMAIL PROTECTED], "oid", "int", 0 ]
[ [EMAIL PROTECTED], "oid", "lng", 0 ]
[ [EMAIL PROTECTED], "oid", "lng", 0 ]
[ [EMAIL PROTECTED], "oid", "lng", 0 ]
@@ -159,8 +160,6 @@
[ [EMAIL PROTECTED], "void", "int", 0 ]
[ [EMAIL PROTECTED], "void", "int", 0 ]
[ [EMAIL PROTECTED], "void", "int", 0 ]
-[ [EMAIL PROTECTED], "void", "int", 0 ]
-[ [EMAIL PROTECTED], "void", "int", 0 ]
[ [EMAIL PROTECTED], "void", "lng", 0 ]
[ [EMAIL PROTECTED], "void", "lng", 0 ]
[ [EMAIL PROTECTED], "void", "lng", 0 ]
@@ -189,7 +188,6 @@
[ [EMAIL PROTECTED], "void", "sht", 0 ]
[ [EMAIL PROTECTED], "void", "sht", 0 ]
[ [EMAIL PROTECTED], "void", "sht", 0 ]
-[ [EMAIL PROTECTED], "void", "sht", 0 ]
[ [EMAIL PROTECTED], "void", "str", 0 ]
[ [EMAIL PROTECTED], "void", "str", 0 ]
[ [EMAIL PROTECTED], "void", "str", 0 ]
@@ -227,57 +225,61 @@
[ [EMAIL PROTECTED], "void", "int", 3 ]
[ [EMAIL PROTECTED], "void", "int", 3 ]
[ [EMAIL PROTECTED], "void", "int", 3 ]
-[ [EMAIL PROTECTED], "void", "str", 3 ]
-[ [EMAIL PROTECTED], "void", "str", 3 ]
-[ [EMAIL PROTECTED], "void", "str", 3 ]
-[ [EMAIL PROTECTED], "void", "int", 6 ]
-[ [EMAIL PROTECTED], "void", "int", 6 ]
-[ [EMAIL PROTECTED], "void", "int", 6 ]
-[ [EMAIL PROTECTED], "void", "str", 6 ]
-[ [EMAIL PROTECTED], "void", "int", 14 ]
-[ [EMAIL PROTECTED], "void", "int", 14 ]
-[ [EMAIL PROTECTED], "void", "int", 14 ]
-[ [EMAIL PROTECTED], "void", "int", 14 ]
-[ [EMAIL PROTECTED], "void", "int", 14 ]
-[ [EMAIL PROTECTED], "void", "int", 22 ]
-[ [EMAIL PROTECTED], "void", "int", 22 ]
-[ [EMAIL PROTECTED], "void", "int", 22 ]
-[ [EMAIL PROTECTED], "void", "int", 22 ]
-[ [EMAIL PROTECTED], "void", "int", 22 ]
-[ [EMAIL PROTECTED], "void", "int", 22 ]
-[ [EMAIL PROTECTED], "void", "str", 22 ]
-[ [EMAIL PROTECTED], "void", "str", 22 ]
-[ [EMAIL PROTECTED], "void", "bit", 32 ]
-[ [EMAIL PROTECTED], "void", "int", 32 ]
-[ [EMAIL PROTECTED], "void", "int", 32 ]
-[ [EMAIL PROTECTED], "void", "sht", 32 ]
-[ [EMAIL PROTECTED], "void", "sht", 32 ]
-[ [EMAIL PROTECTED], "void", "str", 32 ]
-[ [EMAIL PROTECTED], "void", "str", 32 ]
-[ [EMAIL PROTECTED], "void", "bit", 182 ]
-[ [EMAIL PROTECTED], "void", "int", 182 ]
-[ [EMAIL PROTECTED], "void", "int", 182 ]
-[ [EMAIL PROTECTED], "void", "int", 182 ]
-[ [EMAIL PROTECTED], "void", "int", 182 ]
-[ [EMAIL PROTECTED], "void", "int", 182 ]
-[ [EMAIL PROTECTED], "void", "str", 182 ]
-[ [EMAIL PROTECTED], "void", "str", 182 ]
-[ [EMAIL PROTECTED], "void", "str", 182 ]
-[ [EMAIL PROTECTED], "int", "str", 332 ]
-[ [EMAIL PROTECTED], "void", "bit", 1222 ]
-[ [EMAIL PROTECTED], "void", "bit", 1222 ]
-[ [EMAIL PROTECTED], "void", "int", 1222 ]
-[ [EMAIL PROTECTED], "void", "int", 1222 ]
-[ [EMAIL PROTECTED], "void", "str", 1222 ]
-[ [EMAIL PROTECTED], "void", "str", 1222 ]
-[ [EMAIL PROTECTED], "void", "str", 1222 ]
-[ [EMAIL PROTECTED], "void", "int", 3345 ]
-[ [EMAIL PROTECTED], "void", "int", 3345 ]
-[ [EMAIL PROTECTED], "void", "int", 3345 ]
-[ [EMAIL PROTECTED], "void", "int", 3345 ]
-[ [EMAIL PROTECTED], "void", "int", 3345 ]
-[ [EMAIL PROTECTED], "void", "str", 3345 ]
-[ [EMAIL PROTECTED], "void", "str", 3345 ]
+[ [EMAIL PROTECTED], "void", "int", 3 ]
+[ [EMAIL PROTECTED], "void", "int", 3 ]
+[ [EMAIL PROTECTED], "void", "int", 3 ]
+[ [EMAIL PROTECTED], "void", "sht", 3 ]
+[ [EMAIL PROTECTED], "void", "str", 3 ]
+[ [EMAIL PROTECTED], "void", "str", 3 ]
+[ [EMAIL PROTECTED], "void", "str", 3 ]
+[ [EMAIL PROTECTED], "void", "int", 6 ]
+[ [EMAIL PROTECTED], "void", "int", 6 ]
+[ [EMAIL PROTECTED], "void", "int", 6 ]
+[ [EMAIL PROTECTED], "void", "str", 6 ]
+[ [EMAIL PROTECTED], "void", "int", 14 ]
+[ [EMAIL PROTECTED], "void", "int", 14 ]
+[ [EMAIL PROTECTED], "void", "int", 14 ]
+[ [EMAIL PROTECTED], "void", "int", 14 ]
+[ [EMAIL PROTECTED], "void", "int", 14 ]
+[ [EMAIL PROTECTED], "void", "int", 22 ]
+[ [EMAIL PROTECTED], "void", "int", 22 ]
+[ [EMAIL PROTECTED], "void", "int", 22 ]
+[ [EMAIL PROTECTED], "void", "int", 22 ]
+[ [EMAIL PROTECTED], "void", "int", 22 ]
+[ [EMAIL PROTECTED], "void", "int", 22 ]
+[ [EMAIL PROTECTED], "void", "str", 22 ]
+[ [EMAIL PROTECTED], "void", "str", 22 ]
+[ [EMAIL PROTECTED], "void", "bit", 32 ]
+[ [EMAIL PROTECTED], "void", "int", 32 ]
+[ [EMAIL PROTECTED], "void", "int", 32 ]
+[ [EMAIL PROTECTED], "void", "sht", 32 ]
+[ [EMAIL PROTECTED], "void", "sht", 32 ]
+[ [EMAIL PROTECTED], "void", "str", 32 ]
+[ [EMAIL PROTECTED], "void", "str", 32 ]
+[ [EMAIL PROTECTED], "void", "bit", 184 ]
+[ [EMAIL PROTECTED], "void", "int", 184 ]
+[ [EMAIL PROTECTED], "void", "int", 184 ]
+[ [EMAIL PROTECTED], "void", "int", 184 ]
+[ [EMAIL PROTECTED], "void", "int", 184 ]
+[ [EMAIL PROTECTED], "void", "int", 184 ]
+[ [EMAIL PROTECTED], "void", "str", 184 ]
+[ [EMAIL PROTECTED], "void", "str", 184 ]
+[ [EMAIL PROTECTED], "void", "str", 184 ]
+[ [EMAIL PROTECTED], "int", "str", 336 ]
+[ [EMAIL PROTECTED], "void", "bit", 1222 ]
+[ [EMAIL PROTECTED], "void", "bit", 1222 ]
+[ [EMAIL PROTECTED], "void", "int", 1222 ]
+[ [EMAIL PROTECTED], "void", "int", 1222 ]
+[ [EMAIL PROTECTED], "void", "str", 1222 ]
+[ [EMAIL PROTECTED], "void", "str", 1222 ]
+[ [EMAIL PROTECTED], "void", "str", 1222 ]
+[ [EMAIL PROTECTED], "void", "int", 3345 ]
+[ [EMAIL PROTECTED], "void", "int", 3345 ]
+[ [EMAIL PROTECTED], "void", "int", 3345 ]
+[ [EMAIL PROTECTED], "void", "int", 3345 ]
+[ [EMAIL PROTECTED], "void", "int", 3345 ]
+[ [EMAIL PROTECTED], "void", "str", 3345 ]
+[ [EMAIL PROTECTED], "void", "str", 3345 ]
quit();
# 10:00:03 >
Index: check1a.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/arno/Tests/check1a.stable.out,v
retrieving revision 1.83
retrieving revision 1.84
diff -u -d -r1.83 -r1.84
--- check1a.stable.out 1 Apr 2007 22:08:56 -0000 1.83
+++ check1a.stable.out 17 Apr 2007 12:27:06 -0000 1.84
@@ -93,6 +93,7 @@
[ [EMAIL PROTECTED], "oid", "int", 0 ]
[ [EMAIL PROTECTED], "oid", "int", 0 ]
[ [EMAIL PROTECTED], "oid", "int", 0 ]
+[ [EMAIL PROTECTED], "oid", "int", 0 ]
[ [EMAIL PROTECTED], "oid", "lng", 0 ]
[ [EMAIL PROTECTED], "oid", "lng", 0 ]
[ [EMAIL PROTECTED], "oid", "lng", 0 ]
@@ -152,8 +153,6 @@
[ [EMAIL PROTECTED], "void", "int", 0 ]
[ [EMAIL PROTECTED], "void", "int", 0 ]
[ [EMAIL PROTECTED], "void", "int", 0 ]
-[ [EMAIL PROTECTED], "void", "int", 0 ]
-[ [EMAIL PROTECTED], "void", "int", 0 ]
[ [EMAIL PROTECTED], "void", "lng", 0 ]
[ [EMAIL PROTECTED], "void", "lng", 0 ]
[ [EMAIL PROTECTED], "void", "lng", 0 ]
@@ -182,7 +181,6 @@
[ [EMAIL PROTECTED], "void", "sht", 0 ]
[ [EMAIL PROTECTED], "void", "sht", 0 ]
[ [EMAIL PROTECTED], "void", "sht", 0 ]
-[ [EMAIL PROTECTED], "void", "sht", 0 ]
[ [EMAIL PROTECTED], "void", "str", 0 ]
[ [EMAIL PROTECTED], "void", "str", 0 ]
[ [EMAIL PROTECTED], "void", "str", 0 ]
@@ -213,71 +211,75 @@
[ [EMAIL PROTECTED], "void", "int", 3 ]
[ [EMAIL PROTECTED], "void", "int", 3 ]
[ [EMAIL PROTECTED], "void", "int", 3 ]
-[ [EMAIL PROTECTED], "void", "str", 3 ]
-[ [EMAIL PROTECTED], "void", "str", 3 ]
-[ [EMAIL PROTECTED], "void", "str", 3 ]
-[ [EMAIL PROTECTED], "void", "int", 6 ]
-[ [EMAIL PROTECTED], "void", "int", 6 ]
-[ [EMAIL PROTECTED], "void", "int", 6 ]
-[ [EMAIL PROTECTED], "void", "str", 6 ]
-[ [EMAIL PROTECTED], "void", "int", 14 ]
-[ [EMAIL PROTECTED], "void", "int", 14 ]
-[ [EMAIL PROTECTED], "void", "int", 14 ]
-[ [EMAIL PROTECTED], "void", "int", 14 ]
-[ [EMAIL PROTECTED], "void", "int", 14 ]
-[ [EMAIL PROTECTED], "void", "int", 22 ]
-[ [EMAIL PROTECTED], "void", "int", 22 ]
-[ [EMAIL PROTECTED], "void", "int", 22 ]
-[ [EMAIL PROTECTED], "void", "int", 22 ]
-[ [EMAIL PROTECTED], "void", "int", 22 ]
-[ [EMAIL PROTECTED], "void", "int", 22 ]
-[ [EMAIL PROTECTED], "void", "str", 22 ]
-[ [EMAIL PROTECTED], "void", "str", 22 ]
-[ [EMAIL PROTECTED], "void", "bit", 32 ]
-[ [EMAIL PROTECTED], "void", "int", 32 ]
-[ [EMAIL PROTECTED], "void", "int", 32 ]
-[ [EMAIL PROTECTED], "void", "sht", 32 ]
-[ [EMAIL PROTECTED], "void", "sht", 32 ]
-[ [EMAIL PROTECTED], "void", "str", 32 ]
-[ [EMAIL PROTECTED], "void", "str", 32 ]
-[ [EMAIL PROTECTED], "void", "bit", 182 ]
-[ [EMAIL PROTECTED], "void", "int", 182 ]
-[ [EMAIL PROTECTED], "void", "int", 182 ]
-[ [EMAIL PROTECTED], "void", "int", 182 ]
-[ [EMAIL PROTECTED], "void", "int", 182 ]
-[ [EMAIL PROTECTED], "void", "int", 182 ]
-[ [EMAIL PROTECTED], "void", "str", 182 ]
-[ [EMAIL PROTECTED], "void", "str", 182 ]
-[ [EMAIL PROTECTED], "void", "str", 182 ]
-[ [EMAIL PROTECTED], "void", "int", 188 ]
-[ [EMAIL PROTECTED], "void", "int", 188 ]
-[ [EMAIL PROTECTED], "void", "int", 188 ]
-[ [EMAIL PROTECTED], "void", "str", 188 ]
-[ [EMAIL PROTECTED], "int", "str", 332 ]
-[ [EMAIL PROTECTED], "void", "bit", 1222 ]
-[ [EMAIL PROTECTED], "void", "bit", 1222 ]
-[ [EMAIL PROTECTED], "void", "int", 1222 ]
-[ [EMAIL PROTECTED], "void", "int", 1222 ]
-[ [EMAIL PROTECTED], "void", "str", 1222 ]
-[ [EMAIL PROTECTED], "void", "str", 1222 ]
-[ [EMAIL PROTECTED], "void", "str", 1222 ]
-[ [EMAIL PROTECTED], "void", "int", 3345 ]
-[ [EMAIL PROTECTED], "void", "int", 3345 ]
-[ [EMAIL PROTECTED], "void", "int", 3345 ]
-[ [EMAIL PROTECTED], "void", "int", 3345 ]
-[ [EMAIL PROTECTED], "void", "int", 3345 ]
-[ [EMAIL PROTECTED], "void", "str", 3345 ]
-[ [EMAIL PROTECTED], "void", "str", 3345 ]
-[ [EMAIL PROTECTED], "void", "int", 4893 ]
-[ [EMAIL PROTECTED], "void", "int", 4893 ]
-[ [EMAIL PROTECTED], "void", "str", 4893 ]
-[ [EMAIL PROTECTED], "void", "str", 4893 ]
-[ [EMAIL PROTECTED], "void", "str", 4893 ]
-[ [EMAIL PROTECTED], "void", "int", 5243 ]
-[ [EMAIL PROTECTED], "void", "int", 5243 ]
-[ [EMAIL PROTECTED], "void", "str", 5243 ]
-[ [EMAIL PROTECTED], "void", "str", 5243 ]
-[ [EMAIL PROTECTED], "void", "str", 5243 ]
+[ [EMAIL PROTECTED], "void", "int", 3 ]
+[ [EMAIL PROTECTED], "void", "int", 3 ]
+[ [EMAIL PROTECTED], "void", "int", 3 ]
+[ [EMAIL PROTECTED], "void", "sht", 3 ]
+[ [EMAIL PROTECTED], "void", "str", 3 ]
+[ [EMAIL PROTECTED], "void", "str", 3 ]
+[ [EMAIL PROTECTED], "void", "str", 3 ]
+[ [EMAIL PROTECTED], "void", "int", 6 ]
+[ [EMAIL PROTECTED], "void", "int", 6 ]
+[ [EMAIL PROTECTED], "void", "int", 6 ]
+[ [EMAIL PROTECTED], "void", "str", 6 ]
+[ [EMAIL PROTECTED], "void", "int", 14 ]
+[ [EMAIL PROTECTED], "void", "int", 14 ]
+[ [EMAIL PROTECTED], "void", "int", 14 ]
+[ [EMAIL PROTECTED], "void", "int", 14 ]
+[ [EMAIL PROTECTED], "void", "int", 14 ]
+[ [EMAIL PROTECTED], "void", "int", 22 ]
+[ [EMAIL PROTECTED], "void", "int", 22 ]
+[ [EMAIL PROTECTED], "void", "int", 22 ]
+[ [EMAIL PROTECTED], "void", "int", 22 ]
+[ [EMAIL PROTECTED], "void", "int", 22 ]
+[ [EMAIL PROTECTED], "void", "int", 22 ]
+[ [EMAIL PROTECTED], "void", "str", 22 ]
+[ [EMAIL PROTECTED], "void", "str", 22 ]
+[ [EMAIL PROTECTED], "void", "bit", 32 ]
+[ [EMAIL PROTECTED], "void", "int", 32 ]
+[ [EMAIL PROTECTED], "void", "int", 32 ]
+[ [EMAIL PROTECTED], "void", "sht", 32 ]
+[ [EMAIL PROTECTED], "void", "sht", 32 ]
+[ [EMAIL PROTECTED], "void", "str", 32 ]
+[ [EMAIL PROTECTED], "void", "str", 32 ]
+[ [EMAIL PROTECTED], "void", "bit", 184 ]
+[ [EMAIL PROTECTED], "void", "int", 184 ]
+[ [EMAIL PROTECTED], "void", "int", 184 ]
+[ [EMAIL PROTECTED], "void", "int", 184 ]
+[ [EMAIL PROTECTED], "void", "int", 184 ]
+[ [EMAIL PROTECTED], "void", "int", 184 ]
+[ [EMAIL PROTECTED], "void", "str", 184 ]
+[ [EMAIL PROTECTED], "void", "str", 184 ]
+[ [EMAIL PROTECTED], "void", "str", 184 ]
+[ [EMAIL PROTECTED], "void", "int", 188 ]
+[ [EMAIL PROTECTED], "void", "int", 188 ]
+[ [EMAIL PROTECTED], "void", "int", 188 ]
+[ [EMAIL PROTECTED], "void", "str", 188 ]
+[ [EMAIL PROTECTED], "int", "str", 336 ]
+[ [EMAIL PROTECTED], "void", "bit", 1222 ]
+[ [EMAIL PROTECTED], "void", "bit", 1222 ]
+[ [EMAIL PROTECTED], "void", "int", 1222 ]
+[ [EMAIL PROTECTED], "void", "int", 1222 ]
+[ [EMAIL PROTECTED], "void", "str", 1222 ]
+[ [EMAIL PROTECTED], "void", "str", 1222 ]
+[ [EMAIL PROTECTED], "void", "str", 1222 ]
+[ [EMAIL PROTECTED], "void", "int", 3345 ]
+[ [EMAIL PROTECTED], "void", "int", 3345 ]
+[ [EMAIL PROTECTED], "void", "int", 3345 ]
+[ [EMAIL PROTECTED], "void", "int", 3345 ]
+[ [EMAIL PROTECTED], "void", "int", 3345 ]
+[ [EMAIL PROTECTED], "void", "str", 3345 ]
+[ [EMAIL PROTECTED], "void", "str", 3345 ]
+[ [EMAIL PROTECTED], "void", "int", 4893 ]
+[ [EMAIL PROTECTED], "void", "int", 4893 ]
+[ [EMAIL PROTECTED], "void", "str", 4893 ]
+[ [EMAIL PROTECTED], "void", "str", 4893 ]
+[ [EMAIL PROTECTED], "void", "str", 4893 ]
+[ [EMAIL PROTECTED], "void", "int", 5243 ]
+[ [EMAIL PROTECTED], "void", "int", 5243 ]
+[ [EMAIL PROTECTED], "void", "str", 5243 ]
+[ [EMAIL PROTECTED], "void", "str", 5243 ]
+[ [EMAIL PROTECTED], "void", "str", 5243 ]
quit();
# 10:01:19 >
-------------------------------------------------------------------------
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