Summary: | patron name search does not handle punctuated names | ||
---|---|---|---|
Product: | Koha | Reporter: | D Ruth Holloway <ruth> |
Component: | Circulation | Assignee: | Guillaume Hatt <guillaume> |
Status: | CLOSED FIXED | QA Contact: | Bugs List <koha-bugs> |
Severity: | normal | ||
Priority: | P5 - low | CC: | chris, guillaume, jwagner, nengard |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
GIT URL: | Change sponsored?: | --- | |
Patch complexity: | --- | Documentation contact: | |
Documentation submission: | Text to go in the release notes: | ||
Version(s) released in: | Circulation function: | ||
Bug Depends on: | |||
Bug Blocks: | 6253 | ||
Attachments: |
Patch as sent to koha-patches
Patch minus a typo |
Description
Chris Cormack
2010-05-21 01:26:01 UTC
Currently the system is successfully returning results for the example here which was failing: A search for "steuben" will return patrons named "Smith-Steuben". However, the system also shows the less desirable behavior described: a search for "van" will return "Sullivan." I'm tempted to mark this bug fixed since a punctuated name can be searched for successfully. Or should the scope of the bug be changed so that we're talking specifically about the refined LIKE search described above? This patch *works*, but it's a pact with the Devil. Once you get a large number of patrons in the database, it's astonishingly inefficient, and thus slows down searches for patrons in an unacceptable way. Does that mean we should not even test this patch but find a better way to do it? Pushed, please test |