Update of /cvsroot/monetdb/sql/src/backends/monet5
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv18234/backends/monet5
Modified Files:
sql_gencode.mx
Log Message:
Add the ILIKE operator to SQL for Stefan de Konink
U sql_gencode.mx
Index: sql_gencode.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet5/sql_gencode.mx,v
retrieving revision 1.330
retrieving revision 1.331
diff -u -d -r1.330 -r1.331
--- sql_gencode.mx 25 Jul 2009 22:08:37 -0000 1.330
+++ sql_gencode.mx 1 Aug 2009 14:47:29 -0000 1.331
@@ -708,10 +708,18 @@
op = "like";
mod = strRef;
break;
+ case cmp_ilike:
+ op = "ilike";
+ mod = strRef;
+ break;
case cmp_notlike:
op = "notlike";
mod = strRef;
break;
+ case cmp_notilike:
+ op = "notilike";
+ mod = strRef;
+ break;
default:
showException(SQL,"sql","Unknown
operator");
}
@@ -781,19 +789,25 @@
"thetaselect" : "thetauselect";
switch (s->flag) {
- case cmp_like:{
+ case cmp_like:
+ case cmp_ilike:
+ {
int e = _dumpstmt(sql, mb,
s->op3.stval);
- q = newStmt1(mb, pcreRef,
"like_uselect");
+ q = newStmt1(mb, pcreRef,
+ (s->flag == cmp_like ?
"like_uselect" : "ilike_uselect"));
q = pushArgument(mb, q, l);
q = pushArgument(mb, q, r);
q = pushArgument(mb, q, e);
break;
}
- case cmp_notlike:{
+ case cmp_notlike:
+ case cmp_notilike:
+ {
int e = _dumpstmt(sql, mb,
s->op3.stval);
int k;
- q = newStmt1(mb, pcreRef,
"like_uselect");
+ q = newStmt1(mb, pcreRef,
+ (s->flag == cmp_like ?
"like_uselect" : "ilike_uselect"));
q = pushArgument(mb, q, l);
q = pushArgument(mb, q, r);
q = pushArgument(mb, q, e);
------------------------------------------------------------------------------
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
