Re: [MonetDB-users] pcre exception with LIKE inside CASE

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.