Red Hat Bugzilla – Bug 883850
Hosts from another data center displayed when clicked on "Hosts" in tree view for cluster names with a single difference.
Last modified: 2016-02-10 14:07:35 EST
+++ This bug was initially created as a clone of Bug #874660 +++
Description of problem:
I have 2 clusters in separate data centers named as "RHEL-H_Cluster" and "RHEL-H-Cluster" (observe the difference that one has a "-" and the other has a "_"), however, from the tree view when I click on the "Hosts" of "RHEL-H_Cluster" I see hosts from "RHEL-H-Cluster" as well.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Create a DataCenter1 and create a cluster named "RHEL-H_Cluster"
2. Add hosts to "RHEL-H_Cluster"
3. Create a DataCenter2 and create a cluster named "RHEL-H-Cluster"
4. Add hosts to "RHEL-H-Cluster"
5. In tree view, navigate to DataCenter1 | Clusters | RHEL-H_Cluster | Hosts.
6. Observe the hosts list on the right hand side.
Hosts from DataCenter2 are displayed as well.
Hosts from another datacenter should not be displayed.
--- Additional comment from Gowrishankar Rajaiyan on 2012-11-08 10:37:42 EST ---
Created attachment 640887 [details]
Screenshot of hosts from different datacenter getting displayed
--- Additional comment from Gowrishankar Rajaiyan on 2012-11-08 10:39:33 EST ---
Created attachment 640889 [details]
--- Additional comment from Simon Grinberg on 2012-11-08 10:53:24 EST ---
Moving to backend since it's probably a search issue.
Need to check if this is a global issue where the search ignores these characters when matching search, or just does not distinguish '-' and '_'
--- Additional comment from Itamar Heim on 2012-11-09 00:50:51 EST ---
i'm pretty sure _ is a single character wildcard (like *).
sounds like we need either:
1. a parameter for search to not do a 'like', rather an equals ('=') in a search.
2. escape the _ when calling search from a tree.
i can only assume/hope we block '*' in entity names...
--- Additional comment from Gowrishankar Rajaiyan on 2012-11-09 01:07:42 EST ---
Created attachment 641269 [details]
Screenshot of VMs from tree view.
Additional info: See the same behaviour from the VMs node in tree view as well. VMs from another cluster in a different datacenter displayed.
--- Additional comment from Eli Mesika on 2012-11-11 21:39:04 EST ---
Actually the _ in Postgres is treated as ? in regular expressions when using the LIKE operator
engine=# create table test (a varchar(20));
engine=# insert into test values ('123-456');
INSERT 0 1
engine=# insert into test values ('123_456');
INSERT 0 1
engine=# insert into test values ('123X456');
INSERT 0 1
engine=# select * from test ;
engine=# select * from test where a ilike '123_456';
Solution should be , replacing all '_' with '\_'
engine=# select * from test where a ilike '123\_456';
--- Additional comment from Eli Mesika on 2012-11-12 17:57:42 EST ---
--- Additional comment from Eli Mesika on 2012-11-13 04:23:48 EST ---
fixed in commit: d3de5c3
Created attachment 685985 [details]
tree screenshots (archive)
The tree is not OK. Please attached screenshots.
On bug scrubbing for 3.1.4 qe pm and devel decided to CLOSE WONTFIX , this is not interesting enough and no customer ticket is involved.