Match anywhere in word by default: How is it supposed to work?

[cnewtonne]

I have a info item containing this text ...

"A constant that indicates that the hierarchies of the dimension are consistent with a star schema organization."

I search for "star schema" (including the quotes)

When I enable this new search option, UR does not find the info item. When disabled, it finds it.

First image, shows UR returning 0 items, whereas the second (option disabled), it finds 69 items.

Is this how this options supposed to work?

Thanks

[kinook]

Remove the double quotes.

[kinook]

With double quotes, it's supposed to search on *star schema*, and without double quotes, it searches *star* *schema*, but I don't think FTS really supports it. You may need to use non-FTS mode (Tools | Compact & Repair). Either way, it's a non-indexed search so it can be slow, and I wouldn't advise using it.