REGEX character search broken

[Ruslan Zasukhin]

On 4/22/05 3:57 PM, "jda" <jda at his.com> wrote:

>> 
>>> 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...

Ah, you use SQL. Sorry then.

Ok, then add request that IndexByWords we should not use for Like/RegEx
optimization...I have see this problem, but forget to make it.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]