Bug 15268

Summary: Patron search differs between 'Check out' search and 'Patron' search on two-word surnames like 'St. Claire'
Product: Koha Reporter: Barton Chittenden <barton>
Component: CirculationAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: edischer, gmcharlt, kyle.m.hall
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Barton Chittenden 2015-11-30 19:21:31 UTC
Given Patrons with the following names:

SURNAME    , FIRSTNAME

ST CLAIRE  , JAKE
ST. AUBIN  , SHELLEY P
ST. CLAIRE , AUSTIN B   
ST. CLAIRE , BRADLEY
ST. CLAIRE , CHYENNA M  
ST. CLAIRE , CODY R.    
ST. CLAIRE , HENRY
ST. CLAIRE , SKYANN M.  
ST. JOHN   , CHRISTA
ST. JOHN   , EMERSON D
STEINBERG  , CLAIRE

The patron search and checkout search behave differently:

Searching for

  st. claire

Patron search returns

ST. CLAIRE , AUSTIN B   
ST. CLAIRE , BRADLEY
ST. CLAIRE , CHYENNA M  
ST. CLAIRE , CODY R.    
ST. CLAIRE , HENRY
ST. CLAIRE , SKYANN M.  

check-out search returns nothing.

---

Searching for

  st claire

Patron search returns results for both ST CLAIRE and ST. CLAIRE:

ST CLAIRE  , JAKE
ST. CLAIRE , AUSTIN B   
ST. CLAIRE , BRADLEY
ST. CLAIRE , CHYENNA M  
ST. CLAIRE , CODY R.    
ST. CLAIRE , HENRY
ST. CLAIRE , SKYANN M.  

check-out search returns STEINBERG   , CLAIRE

---

Searching for

  st.

Both searches return

ST. AUBIN  , SHELLEY P
ST. CLAIRE , AUSTIN B   
ST. CLAIRE , BRADLEY
ST. CLAIRE , CHYENNA M  
ST. CLAIRE , CODY R.    
ST. CLAIRE , HENRY
ST. CLAIRE , SKYANN M.  
ST. JOHN   , CHRISTA
ST. JOHN   , EMERSON D

This may be related to Bug 7397 - Patron search from Checkout tab does 'contains' instead of 'starts_with' search.
Comment 1 Owen Leonard 2016-08-18 16:36:05 UTC
This appears to be fixed in master. Barton could you re-test?
Comment 2 Barton Chittenden 2016-08-18 18:15:13 UTC
This was caused by the "Starts With" vs. "Contains" user search -- Bug 15930. That bug is closed, and I'm marking this one as a duplicate.

*** This bug has been marked as a duplicate of bug 15930 ***