REGEX character search broken

jda jda at his.com
Fri Apr 22 08:57:24 CDT 2005


>
>  > I use REGEX to search for character strings in my db (fields are
>>  indexedbyword). This is broken in 2.0.3. The following search worked
>>  before:
>>
>>  select id,hit from thereferences where (keywords REGEX '(?i)*') order by id
>>
>>  I think it fails because now REGEX uses indexes. Can we get the old
>>  behavior back? Speed is not important if you can't do the search.
>
>Well, I think FindRegEx() have second parameter, where you can say:
>     NOT to use index
>

I don't understand. I'm using astraight SQL query (see above). Never 
heard of FindRegEx(). The new behavior in 2.0.3 breaks code that has 
worked for years with Valentina...

Jon


More information about the Valentina-beta mailing list