Details
-
Bug
-
Status: Closed (View Workflow)
-
P2
-
Resolution: Done
-
None
-
None
-
-
Core: F - Sprint 65
-
Core: Platform
Description
Preconditions:
- I created following titles (for test purpose): Inventory instance record in FOLIO Snapshot to have resource title: Arctic A to Z (2019), and resource title: (accidental atheist)
Steps to reproduce:
Login to FOLIO Snapshot go to Inventory:
- search for: Arctic A to Z (2019) in search term: All (title, contributor, identifier)
- search for: Arctic A to Z (2019) in search term: Title
- search for: (accidental atheist) in search term: All (title, contributor, identifier)
- search for: (accidental atheist) in search term: Title
Expected result:
Each of the performed search would bring up 1 hit
Actual result:
Search on titles with parenthesis works fine in search term Title, but fails in search term: All (title, contributor, identifier)
ERROR: in module @folio/inventory, operation GET on resource 'records' failed, saying: ErrorMessage(fields=Map(Line -> 208, File -> regexp.c, SQLSTATE -> 2201B, Routine -> RE_compile_and_cache, V -> ERROR, Message -> invalid regular expression: parentheses () not balanced, Severity -> ERROR))
- - - - - - - - - - - - - - - - - - -
Since FOLIO requires that I enter an exact match, but the exact value in this case produces an error, I see no way of actually finding this instance by ISBN.
Having parenthesis in ISBN fields is not at all uncommon. The same goes for subject headings.
CW: lisams - when you search on ISBN numbers you'd like to have an exact match on the digits in the ISBN, and then the possibility to truncate. When you perform following search: 978-0-226-23584-4* in the Identifier/ISBN field, you get 1 hit:
TestRail: Results
Attachments
Issue Links
- defines
-
UXPROD-1836 Priority fixes and enhancements for inventory search
-
- Closed
-
- is blocked by
-
MODINVSTOR-285 upgrade to RMB 26 and resolve related issues
-
- Closed
-
-
MODINVSTOR-293 CQL identifiers=")" fails with "invalid regular expression: parentheses () not balanced" SQL Injection
-
- Closed
-
- relates to
-
RMB-396 mask ) ] } in regexp to prevent SQL injection
-
- Closed
-
-
UIIN-594 Title search: Apostrophe/Right Single Quotation Mark (U+2019) not found
-
- Closed
-
-
MODORDERS-262 PO with a POL whose productID has a paren, copied/edited from Instance cannot be saved
-
- Closed
-
-
UIIN-589 Mask double quotes and backslash (searching by quote or backslash generates error)
-
- Closed
-