Update of /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15984/src/benchmarks/tpch/Tests
Modified Files:
01-22.stable.out.Algebra 02.stable.out.Algebra
17.stable.out.Algebra
Log Message:
added support for sql/xml namespaces
fixed bug in algebra version for handling exist/not exists in exists/not exists
with correlation
added optimizer steps for algebra version to rewrite semi/anti joins followed
by joins on the same (referenced) relation into a single semijoin
push selects through semi/anti joins
approved tests
U 02.stable.out.Algebra
Index: 02.stable.out.Algebra
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/02.stable.out.Algebra,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- 02.stable.out.Algebra 23 Jun 2008 21:32:16 -0000 1.1
+++ 02.stable.out.Algebra 28 Oct 2008 20:05:04 -0000 1.2
@@ -36,7 +36,7 @@
% rewrite, count # name
% clob, int # type
% 7, 2 # length
-[ "joinidx", 11 ]
+[ "joinidx", 9 ]
# 09:17:12 >
# 09:17:12 > Done.
U 17.stable.out.Algebra
Index: 17.stable.out.Algebra
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/17.stable.out.Algebra,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- 17.stable.out.Algebra 23 Jun 2008 21:32:17 -0000 1.1
+++ 17.stable.out.Algebra 28 Oct 2008 20:05:04 -0000 1.2
@@ -33,7 +33,7 @@
% rewrite, count # name
% clob, int # type
% 7, 1 # length
-[ "joinidx", 2 ]
+[ "joinidx", 0 ]
# 09:17:19 >
# 09:17:19 > Done.
U 01-22.stable.out.Algebra
Index: 01-22.stable.out.Algebra
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/01-22.stable.out.Algebra,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- 01-22.stable.out.Algebra 23 Jun 2008 21:32:15 -0000 1.1
+++ 01-22.stable.out.Algebra 28 Oct 2008 20:05:04 -0000 1.2
@@ -59,7 +59,7 @@
% rewrite, count # name
% clob, int # type
% 7, 2 # length
-[ "joinidx", 11 ]
+[ "joinidx", 9 ]
# 11:48:05 >
# 11:48:05 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781
@@ -1182,7 +1182,7 @@
% rewrite, count # name
% clob, int # type
% 7, 1 # length
-[ "joinidx", 2 ]
+[ "joinidx", 0 ]
# 11:48:06 >
# 11:48:06 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
