Bug #36394
closedPassing invalid value to infrasturcture_facet search key leads to PG::InvalidTextRepresentation error
Description
Description of problem:
Host search can error out on infrasturcture_facet related queries
Version-Release number of selected component (if applicable):
Satellite 6.11 snap 14
How reproducible:
always
Steps to Reproduce:
1. in satellite UI, go to the hosts page
2. in the search field put "infrastructure_facet.foreman=test" or "infrastructure_facet.smart_proxy_id=test"
Actual results:
Error screen with:
Oops, we're sorry but something went wrong PG::InvalidTextRepresentation: ERROR: invalid input syntax for type boolean: "test" LINE 1: ...acets_infrastructure_facets"."foreman_instance" = 'test')) O... ^
(same happens when searching through hammer CLI)
Expected results:
no error, host page with no results (as it is when passing wrong values to other search keys"
Additional info:
Updated by The Foreman Bot over 1 year ago
- Status changed from New to Ready For Testing
- Pull request https://github.com/theforeman/foreman/pull/9706 added
Updated by Adam Ruzicka over 1 year ago
- Status changed from Ready For Testing to Closed
Applied in changeset foreman|85e60a9c136662c05462647d1bd86fe6b5df0740.
Updated by Ewoud Kohl van Wijngaarden over 1 year ago
- Triaged changed from No to Yes