Welcome to jBASE's new documentation site! Many answers to your questions can be found by searching the Knowledgebase or viewing the jBASE Documentation. We also have a Google Group for peer discussion about jBASE. If you are unable to find the information you are looking for, jBASE Support will be glad to assist in resolving your technical problems. Enjoy and please provide comments and feedback .

How can we help you?

PN5_60797

Description

jQL: Issue with indexes and using wildcards with record keys (CW2532) 


Previous Release Behavior

The actual problem was mixing LIKE and [] pattern matching. 

[]  is PICK
... is PRIME

Internally we use the same code as MATCHES with indexing, because this had only been coded to only support ... queries, gave the impression they were failing, 

The code was running and doing what it meant to but no matches would ever be found. 

OK      SELECT FILE WITH ID LIKE 2...
FAIL    SELECT FILE WITH ID EQ "2]"

This is because the index is looking for a right ignore string match and the trailing wild card had not been trimmed. 

Was this article helpful?