Project

General

Profile

Bug #20667

host page implicit search searches on useless values

Added by Tomer Brisker over 3 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Tomer Brisker
Category:
Search
Target version:
1.17.0
Difficulty:
Triaged:
Bugzilla link:
1517255
Pull request:
https://github.com/theforeman/foreman/pull/4768
Fixed in Releases:
Found in Releases:

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

Related to Foreman - Bug #22616: searching on host status fails with "'status' should be one of 'true, false', but the query was '0'"Closed2018-02-19

Associated revisions

Revision 3adfb7d1 (diff)
Added by Tomer Brisker about 3 years ago

Fixes #20667 - Reduce implicit searching on host index (#4768)

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

#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

Also available in: Atom PDF