Update of /cvsroot/monetdb/sql/src/server
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv29292/src/server
Modified Files:
Tag: Feb2010
bin_optimizer.mx
Log Message:
kdiff for deletes is only needed once per table. So on (projection)joins
these aren't needed. This used to work but again because of st_alias
this broke.
Index: bin_optimizer.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/bin_optimizer.mx,v
retrieving revision 1.25.2.1
retrieving revision 1.25.2.2
diff -u -d -r1.25.2.1 -r1.25.2.2
--- bin_optimizer.mx 30 Jan 2010 09:18:21 -0000 1.25.2.1
+++ bin_optimizer.mx 30 Jan 2010 11:26:22 -0000 1.25.2.2
@@ -448,6 +448,15 @@
s->op2.stval = stmt_dup(old->op1.stval);
stmt_destroy(old);
}
+ /* same as above but now with alias in between */
+ if (isEqJoin(s) &&
+ s->op2.stval->type == st_alias &&
+ s->op1.stval->t == s->op2.stval->op1.stval->h &&
+ s->op2.stval->op1.stval->type == st_diff){
+ stmt *old = s->op2.stval;
+ s->op2.stval = stmt_dup(old->op1.stval->op1.stval);
+ stmt_destroy(old);
+ }
s->optimized = 3;
return stmt_dup(s);
}
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
