Acquisition search fails if the searched string contains extended ASCII characters

Bug #1843951 reported by Eva Cerninakova
16
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Evergreen
Won't Fix
Undecided
Unassigned

Bug Description

Acquisition search fails if the searched string contains extended ASCII characters.
E.g., if I perform the search in our system looking for an item whose title contains the string "kniha" (the Line item attribute title of work contains "kniha"), I get 21 titles, among them the title "Červená kniha".

However, If i perform the same query for "červená", the search fails silently ending with blank page (See the attachment).

The same silent error occurs if I search e.g., for the PO or invoice and the search string contains any extended ASCII character.

Revision history for this message
Eva Cerninakova (ece) wrote :
Changed in evergreen:
status: New → Confirmed
Revision history for this message
Galen Charlton (gmc) wrote :

The Angular rewrite of the acquisitions search interface (bug 1850547) does not have this problem: you can search for non-ASCII characters it bring up results without crashes.

This isn't perfect yet, however - the underlying database query does not do case folding for Czech correctly (at using typical default settings when creating an Evergreen database), so in your specfic example you'd have to search for "Červená" rather than "červená". That should probably be reported as a separate bug, though, as the reason why the search crashes outright in the Dojo interface has a different cause.

tags: added: acq-search
Revision history for this message
Eva Cerninakova (ece) wrote :

I recommend closing this bug as the issue has been solved in the Angular interface.
I have created new bug 1968196 for the database query issue described by Gallen.

Revision history for this message
Terran McCanna (tmccanna) wrote :

Thanks, Eva, I'll mark it Won't Fix

Changed in evergreen:
status: Confirmed → Won't Fix
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.