MonetDB: default - In SQL, newline is just another character and...

[Sjoerd Mullender]

Changeset: 0e44674039ab for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0e44674039ab
Modified Files:
        monetdb5/modules/mal/pcre.c
Branch: default
Log Message:

In SQL, newline is just another character and should be matched in LIKE '_'.


diffs (30 lines):

diff --git a/monetdb5/modules/mal/pcre.c b/monetdb5/modules/mal/pcre.c
--- a/monetdb5/modules/mal/pcre.c
+++ b/monetdb5/modules/mal/pcre.c
@@ -319,7 +319,7 @@ static str
 pcre_likeselect(BAT **bnp, BAT *b, BAT *s, const char *pat, int caseignore, 
int anti)
 {
 #ifdef HAVE_LIBPCRE
-       int options = PCRE_UTF8 | PCRE_MULTILINE;
+       int options = PCRE_UTF8 | PCRE_MULTILINE | PCRE_DOTALL;
        pcre *re;
        pcre_extra *pe;
        const char *error;
@@ -1074,7 +1074,7 @@ PCREreplace_bat_wrap(bat *res, const bat
 str
 PCREmatch(bit *ret, const str *val, const str *pat)
 {
-       char *flags = "";
+       char *flags = "s";
        return pcre_match_with_flags(ret, *val, *pat, flags);
 }
 
@@ -1300,7 +1300,7 @@ BATPCRElike3(bat *ret, const bat *bid, c
 #ifdef HAVE_LIBPCRE
                        const char err[BUFSIZ], *err_p = err;
                        int errpos = 0;
-                       int options = PCRE_UTF8;
+                       int options = PCRE_UTF8 | PCRE_DOTALL;
                        pcre *re;
 #else
                        pcre re;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list