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

Reply via email to