Updated: 1/18/2022, 5:31:44 PM
Created: 1/18/2022, 5:31:44 PM
Last Updated By: dependabot[bot]
Read Time: 1 minute(s)
jQL: Issue with indexes and using wildcards with record keys
# 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.
# Current Release Behavior
All this change does is substitute [ and ] with ... if they are located at the start/end of the literal used for limiting.
Selections now work correctly when using wildcards with index selections.
Back to 5.7.1 Release Notes