Update of /cvsroot/monetdb/sql/src/backends/monet5
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv16585/src/backends/monet5
Modified Files:
sql_gencode.mx
Log Message:
propagated changes of Saturday Jan 30 2010 - Sunday Jan 31 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/01/30 - nielsnes: src/backends/monet5/sql_gencode.mx,1.352.2.2
the select statements didn't get pushed through the diffs and unions anymore.
Reason we added lots of 'st_alias'es around statements during the development
of the relational version. These st_aliases are now handled correctly fixing
the push down.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/01/30 - nielsnes: src/backends/monet5/sql_gencode.mx,1.352.2.3
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: sql_gencode.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet5/sql_gencode.mx,v
retrieving revision 1.353
retrieving revision 1.354
diff -u -d -r1.353 -r1.354
--- sql_gencode.mx 26 Jan 2010 13:25:25 -0000 1.353
+++ sql_gencode.mx 31 Jan 2010 12:44:36 -0000 1.354
@@ -1117,6 +1117,7 @@
int r = _dumpstmt(sql, mb, s->op2.stval);
char *jt = "join";
+ assert(l >= 0 && r >= 0);
if (s->type == st_outerjoin) {
jt = "outerjoin";
}
@@ -2201,9 +2202,11 @@
return;
} else {
stmt *opt;
+
opt = rel2bin(m, s);
stmt_destroy(s);
- s = opt;
+ s = bin_optimizer(m, opt);
+ stmt_destroy(opt);
}
assert(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
