Update of /cvsroot/monetdb/sql/src/common
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15984/src/common

Modified Files:
        sql_types.mx 
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 sql_types.mx
Index: sql_types.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/common/sql_types.mx,v
retrieving revision 1.117
retrieving revision 1.118
diff -u -d -r1.117 -r1.118
--- sql_types.mx        22 Oct 2008 10:42:21 -0000      1.117
+++ sql_types.mx        28 Oct 2008 20:05:04 -0000      1.118
@@ -1304,6 +1304,9 @@
        *t = NULL;
 
        sql_create_aggr("not_unique", "sql", "not_unique", OID, BIT);
+       /* well to be precise it does reduce and map */
+       sql_create_func("not_uniques", "sql", "not_uniques", WRD, NULL, OID, 
SCALE_NONE);
+       sql_create_func("not_uniques", "sql", "not_uniques", OID, NULL, OID, 
SCALE_NONE);
 
        /* functions needed for all types */
        sql_create_func("hash", "calc", "hash", ANY, NULL, WRD, SCALE_FIX);


-------------------------------------------------------------------------
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

Reply via email to