Update of /cvsroot/monetdb/sql/src/server
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv18507/src/server
Modified Files:
rel_select.mx sql_parser.mx
Log Message:
fixed bug in like/ilike handling
Index: rel_select.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/rel_select.mx,v
retrieving revision 1.166
retrieving revision 1.167
diff -u -d -r1.166 -r1.167
--- rel_select.mx 10 Jan 2010 15:33:34 -0000 1.166
+++ rel_select.mx 10 Jan 2010 20:33:31 -0000 1.167
@@ -1847,7 +1847,7 @@
} else if (compare_op[0] == 'i') {
type = cmp_ilike;
} else if (compare_op[0] == 'n') {
- if (strcmp(compare_op, "not_like")) {
+ if (strcmp(compare_op, "not_like") == 0) {
type = cmp_notlike;
} else {
type = cmp_notilike;
Index: sql_parser.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/sql_parser.mx,v
retrieving revision 1.329
retrieving revision 1.330
diff -u -d -r1.329 -r1.330
--- sql_parser.mx 10 Jan 2010 15:33:35 -0000 1.329
+++ sql_parser.mx 10 Jan 2010 20:33:40 -0000 1.330
@@ -3199,7 +3199,7 @@
{ dlist *l = L();
append_symbol(l, $1);
append_symbol(l, $4);
- append_int(l, FALSE); /* case insensitive */
+ append_int(l, FALSE); /* case sensitive */
$$ = _symbol_create_list( SQL_NOT_LIKE, l ); }
| pred_exp NOT ILIKE like_exp
{ dlist *l = L();
@@ -3211,7 +3211,7 @@
{ dlist *l = L();
append_symbol(l, $1);
append_symbol(l, $3);
- append_int(l, FALSE); /* case insensitive */
+ append_int(l, FALSE); /* case sensitive */
$$ = _symbol_create_list( SQL_LIKE, l ); }
| pred_exp ILIKE like_exp
{ dlist *l = L();
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
