Bug 874660
| Summary: | Hosts from another data center displayed when clicked on "Hosts" in tree view for cluster names with a single difference. | |||
|---|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Gowrishankar Rajaiyan <grajaiya> | |
| Component: | ovirt-engine | Assignee: | Eli Mesika <emesika> | |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Jiri Belka <jbelka> | |
| Severity: | unspecified | Docs Contact: | ||
| Priority: | unspecified | |||
| Version: | unspecified | CC: | bazulay, cpelland, dyasny, ecohen, iheim, lpeer, Rhev-m-bugs, sgrinber, yeylon, ykaul, yzaslavs | |
| Target Milestone: | --- | Keywords: | ZStream | |
| Target Release: | 3.2.0 | |||
| Hardware: | Unspecified | |||
| OS: | Unspecified | |||
| Whiteboard: | infra | |||
| Fixed In Version: | sf6 | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 883850 (view as bug list) | Environment: | ||
| Last Closed: | Type: | Bug | ||
| Regression: | --- | Mount Type: | --- | |
| Documentation: | --- | CRM: | ||
| Verified Versions: | Category: | --- | ||
| oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | ||
| Cloudforms Team: | --- | Target Upstream Version: | ||
| Embargoed: | ||||
| Bug Depends On: | ||||
| Bug Blocks: | 883850, 915537 | |||
| Attachments: | ||||
|
Description
Gowrishankar Rajaiyan
2012-11-08 15:36:18 UTC
Created attachment 640887 [details]
Screenshot of hosts from different datacenter getting displayed
Created attachment 640889 [details]
Engine log
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 '_' 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...
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.
Attaching screenshot.
Actually the _ in Postgres is treated as ? in regular expressions when using the LIKE operator
engine=# create table test (a varchar(20));
CREATE TABLE
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 ;
a
---------
123-456
123_456
123X456
(3 rows)
engine=# select * from test where a ilike '123_456';
a
---------
123-456
123_456
123X456
Solution should be , replacing all '_' with '\_'
engine=# select * from test where a ilike '123\_456';
a
---------
123_456
fixed in commit: d3de5c3 Not fully OK, please check for my comments and screenshots in zstream clone - https://bugzilla.redhat.com/show_bug.cgi?id=883850#c3. Same issues in 3.2.x. Created attachment 688169 [details]
Pics showing that the reported scenario in the bug is OK now
Created attachment 688997 [details]
tree
I can reproduce it even I tried to clean Firefox cache.
fixed in commit : a28f219 ok, sf6. 3.2 has been released 3.2 has been released 3.2 has been released 3.2 has been released 3.2 has been released |