Bug #20667
host page implicit search searches on useless values
Description
e.g. searching for '10' will cause various searches that aren't needed, such as `("host_status"."status" >> 6 & 63) = 10 OR ("host_status"."status" >> 12 & 63) = 10 OR ("host_status"."status" >> 18 & 63) = 10 OR ("host_status"."status" >> 24 & 63) = 10`
Related issues
Associated revisions
History
#1
Updated by Tomer Brisker over 3 years ago
- Category set to Search
#2
Updated by The Foreman Bot over 3 years ago
- Status changed from New to Ready For Testing
- Assignee set to Tomer Brisker
- Pull request https://github.com/theforeman/foreman/pull/4768 added
#3
Updated by Tomer Brisker about 3 years ago
- Bugzilla link set to 1517255
#4
Updated by Marek Hulán about 3 years ago
- Legacy Backlogs Release (now unused) set to 296
#5
Updated by Anonymous about 3 years ago
- % Done changed from 0 to 100
- Status changed from Ready For Testing to Closed
Applied in changeset 3adfb7d1b0338bfa26232b99037a13f9bf4862e9.
#6
Updated by Tomer Brisker almost 3 years ago
- Related to Bug #22616: searching on host status fails with "'status' should be one of 'true, false', but the query was '0'" added
Fixes #20667 - Reduce implicit searching on host index (#4768)