Update of /cvsroot/monetdb/sql/src/server
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv507/src/server
Modified Files:
Tag: Aug2009
rel_bin.mx sql_rel2bin.mx
Log Message:
fix performance problem with foreign key checking (hash computation)
fixed crash in updates
U sql_rel2bin.mx
Index: sql_rel2bin.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/sql_rel2bin.mx,v
retrieving revision 1.137.2.1
retrieving revision 1.137.2.2
diff -u -d -r1.137.2.1 -r1.137.2.2
--- sql_rel2bin.mx 3 Aug 2009 18:25:23 -0000 1.137.2.1
+++ sql_rel2bin.mx 18 Aug 2009 05:59:03 -0000 1.137.2.2
@@ -629,7 +629,7 @@
{
sql_subtype *it, *wrd;
stmt *h = NULL;
- stmt *bits = stmt_atom_int(1 + ((sizeof(wrd)*8)-1)/(list_length(l)));
+ stmt *bits = stmt_atom_int(1 + ((sizeof(wrd)*8)-1)/(list_length(l)+1));
node *icn;
it = sql_bind_localtype("int");
@@ -665,7 +665,7 @@
node *m;
sql_subtype *it, *wrd;
stmt *h = NULL;
- stmt *bits = stmt_atom_int(1 + ((sizeof(wrd)*8)-1)/(list_length(l)));
+ stmt *bits = stmt_atom_int(1 + ((sizeof(wrd)*8)-1)/(list_length(l)+1));
stmt *o = NULL;
it = sql_bind_localtype("int");
U rel_bin.mx
Index: rel_bin.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/rel_bin.mx,v
retrieving revision 1.87.2.2
retrieving revision 1.87.2.3
diff -u -d -r1.87.2.2 -r1.87.2.3
--- rel_bin.mx 16 Aug 2009 14:22:25 -0000 1.87.2.2
+++ rel_bin.mx 18 Aug 2009 05:59:03 -0000 1.87.2.3
@@ -1478,7 +1478,7 @@
sql_subtype *it = sql_bind_localtype("int");
sql_subtype *wrd = sql_bind_localtype("wrd");
stmt *h = NULL;
- stmt *bits = stmt_atom_int(1 +
((sizeof(wrd)*8)-1)/(list_length(i->columns)));
+ stmt *bits = stmt_atom_int(1 +
((sizeof(wrd)*8)-1)/(list_length(i->columns)+1));
sql_exp *e = en->data;
sql_exp *l = e->l;
stmt *idx = bin_find_column(sub, l->l, i->base.name);
@@ -2052,7 +2052,7 @@
{
node *m;
sql_subtype *it, *wrd;
- int bits = 1 + ((sizeof(wrd)*8)-1)/(list_length(i->columns));
+ int bits = 1 + ((sizeof(wrd)*8)-1)/(list_length(i->columns)+1);
stmt *h = NULL, *o = NULL;
if (list_length(i->columns) <= 1)
@@ -2820,7 +2820,7 @@
/* calculate new value */
node *m;
sql_subtype *it, *wrd;
- int bits = 1 + ((sizeof(wrd)*8)-1)/(list_length(i->columns));
+ int bits = 1 + ((sizeof(wrd)*8)-1)/(list_length(i->columns)+1);
stmt *h = NULL, *ts, *o = NULL;
if (list_length(i->columns) <= 1)
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
