Search Works Beginning with Punctuation

sroth · Post by **sroth** » Wed Oct 29, 2014 11:10 am

I would like to find words beginning with punctuation such as
?uestlove
*NSYNC

I when searching on LIKEP *NSYNC, I get this error:
Query `*NSYNC' would require linear dictionary search: Index expression(s) match non-prefix substring of term `*nsync'

I also tried ecaping the * with \*, same error.

Do I need to add a specific index expression to handle this?

Post by **Kai** » Wed Oct 29, 2014 11:46 am

If your Webinator version has it, set Allow Leading Wildcards to Y under All Walk Settings. This will allow leading-wildcard searches such as `*nsync'. These searches are normally disabled, because they require a linear dictionary search: this can be slower than a normal (binary-dictionary) index search, though it is not as slow as a full linear search.

sroth · Post by **sroth** » Wed Oct 29, 2014 11:51 am

Thanks, I'm not using vortex script. Is there and equivalent apicp setting? Do I need this set when creating the index or just when running the query?

sroth · Post by **sroth** » Wed Oct 29, 2014 11:54 am

Sorry, typo. I meant to say I am using vortex script not webinator.

sroth · Post by **sroth** » Wed Oct 29, 2014 12:12 pm

I'm now setting these for the query, but still get the same error.






'prefixes less than 2 characters (*NSYNC)' not allowed in query

Post by **Kai** » Wed Oct 29, 2014 12:51 pm

Make sure you set any APICP settings via <apicp> where possible, instead of <sql "set ...">, as the latter may not propagate properly all the time. E.g. qminprelen is settable via <apicp>, whereas wildsingle is not, so they should be set thusly:

<sql "set wildsingle=1"></sql>
<apicp qminprelen 0>

sroth · Post by **sroth** » Wed Oct 29, 2014 12:56 pm

using <apicp qminprelen 0> fixed it. Thanks.