Update of /cvsroot/monetdb/sql/src/backends/monet5
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv30838/src/backends/monet5
Modified Files:
Tag: Aug2009
sql_gencode.mx
Log Message:
solved bug in handling not (i)like
allow '*' in selection with other (constant) column expressions
U sql_gencode.mx
Index: sql_gencode.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet5/sql_gencode.mx,v
retrieving revision 1.332
retrieving revision 1.332.2.1
diff -u -d -r1.332 -r1.332.2.1
--- sql_gencode.mx 2 Aug 2009 19:56:39 -0000 1.332
+++ sql_gencode.mx 3 Aug 2009 18:25:23 -0000 1.332.2.1
@@ -679,6 +679,7 @@
case st_uselect:
case st_select: {
+ bit need_not = FALSE;
int l = _dumpstmt(sql, mb, s->op1.stval);
int r = _dumpstmt(sql, mb, s->op2.stval);
@@ -716,11 +717,13 @@
mod = strRef;
break;
case cmp_notlike:
- op = "notlike";
+ need_not = TRUE;
+ op = "like";
mod = strRef;
break;
case cmp_notilike:
- op = "notilike";
+ need_not = TRUE;
+ op = "ilike";
mod = strRef;
break;
default:
@@ -768,7 +771,7 @@
q = newStmt2(mb, algebraRef, uselectRef);
q = pushArgument(mb, q, k);
- q = pushBit(mb, q, TRUE);
+ q = pushBit(mb, q, !need_not);
k = getDestVar(q);
q = newStmt2(mb, batRef, reverseRef );
@@ -1937,11 +1940,6 @@
}
}
-...@-
-ROBERTO PATCH
- newStmt(mb,sqlRef,putName("emptyset",8));
-...@c
-
backend_dumpstmt(be, mb, s);
Toptimize = GDKusec();
m->Tparse = Toptimize - m->Tparse;
------------------------------------------------------------------------------
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
