Open Users App start page on folio-testing.
Enter *foo into the search slot and press enter or click on Search.
Expected result: searches for strings that contain foo.
Actual result: Error popup with this message:
The wording of the error message has slightly changed since this issue has been reported. Current wording (May 2020):
It was decided on https://issues.folio.org/browse/CQLPG-71 and https://issues.folio.org/browse/CQLPG-58 that the front-end must do special handing on the id field. This includes not sending a left truncation query on the id field. See documentation: https://github.com/folio-org/cql2pgjson-java#id
For all other fields the b-tree indexes "index" and "uniqueIndex" and the full text index "fullTextIndex" only support right truncation. See https://github.com/folio-org/mod-users/blob/master/src/main/resources/templates/db_scripts/schema.json which indexes exist. Consider to completely disallow all left truncation and all in-word truncation like foo*bar and only allow right truncation for all fields. This will ensure short response times.