[FOLIO-419] CQL2PgJSON: replace LIKE '%s%' by a word boundary regex match Created: 19/Dec/16  Updated: 12/Nov/18  Resolved: 24/Aug/17

Status: Closed
Project: FOLIO
Components: None
Affects versions: None
Fix versions: None

Type: Bug Priority: P3
Reporter: Julian Ladisch Assignee: Julian Ladisch
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Sprint:

 Description   
The current search uses LIKE '%s%'.
When searching for "on" this also finds "Long".
It should only find "Long" when searching for "*on*".

This can be fixed by using a regexp that matches at the begin and end of a word boundary: https://www.postgresql.org/docs/9.6/static/functions-matching.html



 Comments   
Comment by Julian Ladisch [ 24/Aug/17 ]

Implemented by https://github.com/folio-org/cql2pgjson-java/commit/c6638f5dfa95653dce06f7df860e9c65f4abb89a

Generated at Thu Feb 08 23:05:38 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.