[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 |