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: