Bug 832978

Summary:	Wild card search query on strings including latin-1 characters does not give expected results
Product:	Red Hat Satellite	Reporter:	Sachin Ghai <sghai>
Component:	WebUI	Assignee:	Justin Sherrill <jsherril>
Status:	CLOSED WORKSFORME	QA Contact:	Katello QA List <katello-qa-list>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	6.0.1	CC:	bbuckingham, bkearney, ckannan, cwelton, lzap, mmccune, omaciel, sghai
Target Milestone:	Unspecified	Keywords:	TestBlocker, Triaged
Target Release:	Unused
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2014-06-03 13:37:48 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Sachin Ghai 2012-06-18 10:06:19 UTC

Description of problem:
Wildcard character search is not working with latin-1/spanish characters.
for e.g.
when we create org with name say: test and best; we can get both name
by search string like: name:?est

However, if I create org with spanish: niños and siños. then search
returns nothing with name:?iños

There are few other possible ways I tried:

si os ==> doesn't return anything in result ( space is between si and os)
si?os ==> returns siños
?iños ==> doesn't return anything in result
?i?os ==> returns both niños and siños
 
If I replace 'ñ' with wild card character '?', search behaves
correctly

Version-Release number of selected component (if applicable):
katello-cli-common-0.1.111-1.el6_2.noarch
katello-0.1.317-1.el6_2.noarch
katello-cli-0.1.111-1.el6_2.noarch
pulp-1.0.4-1.el6.noarch
elasticsearch-0.18.4-11.el6.noarch

How reproducible:
always

Steps to Reproduce:
1. Create org with name niños and siños
2. now perform search query like: name:?iños
3.
  
Actual results:
Serach query (name:?iños) doesn't return anything in result, however if I replace 'ñ' with wild card character '?', search behaves
correctly

Expected results:
Serach query (name:?iños) should return  niños and siños in result as per above example.

Or Wild card characters should work on latin-1 strings as with normal US language strings.


Additional info:

Comment 2 Mike McCune 2013-08-16 18:06:46 UTC

getting rid of 6.0.0 version since that doesn't exist

Comment 5 Justin Sherrill 2014-06-02 22:07:20 UTC

I am not able to reproduce this currently.  Organizations have been moved to foreman and thus use scoped search, however with 'host collections':

Created two: niños and siños.

Performed the following searches:


name:?iños  ==> Returned both

si os ==> doesn't return anything in result 

This shouldn't return anything.  You can try si*  or *os  to return what you would expect.

si?os ==> returns siños as expected
?iños ==> returns both 
?i?os ==> returns both


So this all seems to be working as expected.

Comment 6 Sachin Ghai 2014-06-03 06:56:31 UTC

@Justin: The bug was originally filed against org search. And looks like now I can not use wildcard characters while performing org search. Is it because of scoped search ? If that's the case then I'll close this bz.

Also, with 'host collections' the search using above latin-1 chars works perfectly.

Comment 7 Bryan Kearney 2014-06-03 12:50:05 UTC

spoke with og.. not a blocker.

Comment 9 Justin Sherrill 2014-06-03 13:23:44 UTC

@Sachin,  yes, organizations (and all entities within foreman) use scoped search.

I think you can accomplish similar to what you want with:

name ~ ACME

That would search for anything with ACME.

Feel free to close !

Comment 10 Sachin Ghai 2014-06-03 13:37:48 UTC

thanks Justin, I created two orgs(niños and siños) and search for ~iños and search returns both niños and siños.

So with new UI(in sat6 beta snap7 compose2), the search query gives expected results as per bz description. So closing this bz.

Comment 11 Sachin Ghai 2015-04-20 11:05:10 UTC

Clearing need_info flag