[MonetDB-users] pcre exception with LIKE inside CASE
Hi, I can successfully run the following query: select "field1", "field2" from testlike where field2 like '%hel%' However, I cannot run this one: select "field1", "field2", (case when ("field2" like '%hel%') then cast("field1" as double) else cast("field1" as bigint) end) as dd from testlike I get this exception: !MALException:pcre_match:not available as required version of libpcre was not found by configure. (This is on Feb SP2 2009 compiled on Windows from CVS) -- View this message in context: http://www.nabble.com/pcre-exception-with-LIKE-inside-CASE-tp23694479p236944... Sent from the monetdb-users mailing list archive at Nabble.com.
Hi, On 24-05-2009 07:51:18 -0700, Alex Bo. wrote:
I can successfully run the following query: select "field1", "field2" from testlike where field2 like '%hel%'
However, I cannot run this one: select "field1", "field2", (case when ("field2" like '%hel%') then cast("field1" as double) else cast("field1" as bigint) end) as dd from testlike
I get this exception: !MALException:pcre_match:not available as required version of libpcre was not found by configure.
Thanks, this is a known issue.
(This is on Feb SP2 2009 compiled on Windows from CVS)
We fixed this for the next release, which should come soon.
participants (2)
-
Alex Bo. -
Fabian Groffen