Update of /cvsroot/monetdb/sql/src/server
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv28618/src/server
Modified Files:
rel_bin.mx
Log Message:
propagated changes of Sunday Nov 22 2009 - Saturday Nov 28 2009
from the Nov2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/11/22 - nielsnes: src/server/rel_bin.mx,1.93.2.2
implemented 2 new stmts (joinN and selectN)
needed for the bugs related to like-joins.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: rel_bin.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/rel_bin.mx,v
retrieving revision 1.99
retrieving revision 1.100
diff -u -d -r1.99 -r1.100
--- rel_bin.mx 22 Nov 2009 16:14:08 -0000 1.99
+++ rel_bin.mx 28 Nov 2009 19:56:56 -0000 1.100
@@ -567,6 +567,18 @@
}
return lstmt;
}
+ if (left && right && re->card > CARD_ATOM &&
!is_select) {
+ /* create l and r, gen operator func */
+ char *like = (e->flag == cmp_like || e->flag
== cmp_notlike)?"like":"ilike";
+ int anti = (e->flag == cmp_notlike || e->flag
== cmp_notilike);
+ sql_subtype *s = sql_bind_localtype("str");
+ sql_subfunc *f =
sql_bind_func3(sql->session->schema, like, s, s, s);
+
+ stmt *j =
stmt_joinN(stmt_list(append(create_stmt_list(),l)),
stmt_list(append(append(create_stmt_list(),r),r2)), f);
+ if (is_anti(e) || anti)
+ j->flag |= ANTI;
+ return j;
+ }
return stmt_likeselect(l, r, r2, (comp_type)e->flag);
}
if (left && right && re->card > CARD_ATOM && !is_select) {
------------------------------------------------------------------------------
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
